RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA330616" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA330616 · 5 ✖

analysis 1

  • blastn · 5 ✖
Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
2940537 2940537 PRJNA330616_P_NODE_7523_length_303_cov_1.968504_g7114_i0 PRJNA330616 7523 303 1.968504 5.96456712 Obelia longissima 32570 Cnidaria other_Eukaryota 309 1.5200000000000002e-79   NTclustered gi|62825455|gb|AY789864.1| 32570 g7114 i0 85.382 91.5280528052805 301 40 99 4 4 302 56 354 Obelia longissima voucher 656AN calmodulin gene, partial cds blastn 27733 309 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Obeliidae Obelia Obelia longissima
13822885 13822885 PRJNA330616_P_NODE_3571_length_457_cov_28.306373_g3164_i0 PRJNA330616 3571 457 28.306373 129.36012461 Opisthokonta 33154 Cnidaria other_Eukaryota 135 4.28e-27   NTclustered gi|2862235116|gb|PQ647263.1| 880218 g3164 i0 90.385 23.1203501094092 104 9 23 1 19 121 6909 6806 Cephea cephea isolate AGC18069 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 10566 135 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Cepheidae Cephea Cephea cephea
18920912 18920912 PRJNA330616_P_NODE_3555_length_458_cov_47.014670_g3149_i0 PRJNA330616 3555 458 47.01467 215.3271886 Opisthokonta 33154 Cnidaria other_Eukaryota 135 4.2900000000000005e-27   NTclustered gi|2862235116|gb|PQ647263.1| 880218 g3149 i0 90.385 22.9519650655022 104 9 22 1 19 121 6909 6806 Cephea cephea isolate AGC18069 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 10512 135 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Cepheidae Cephea Cephea cephea
22066003 22066003 PRJNA330616_P_NODE_15298_length_213_cov_2.213415_g14889_i0 PRJNA330616 15298 213 2.213415 4.71457395 Nematostella vectensis 45351 Cnidaria other_Eukaryota 108 3.94e-19   NTclustered gi|2257899224|ref|XM_001632976.3| 45351 g14889 i0 81.538 52.9953051643192 130 24 61 0 84 213 887 758 PREDICTED: Nematostella vectensis 60S ribosomal protein L8 (LOC5512708), mRNA blastn 11288 108 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
22746309 22746309 PRJNA330616_P_NODE_29578_length_163_cov_1.649123_g29169_i0 PRJNA330616 29578 163 1.649123 2.68807049 Obelia 32569 Cnidaria other_Eukaryota 200 4.589999999999999e-47   NTclustered gi|62825455|gb|AY789864.1| 32570 g29169 i0 88.889 93.5153374233129 162 18 99 0 2 163 225 64 Obelia longissima voucher 656AN calmodulin gene, partial cds blastn 15243 200 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Obeliidae Obelia Obelia longissima

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;