RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJEB58983", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 11 ✖

tax_clade 1

  • Sar · 11 ✖

bioproject 1

  • PRJEB58983 · 11 ✖

tax_kingdom 0

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
124835 124835 PRJEB58983_P_NODE_22701_length_276_cov_1.167488_g22286_i0 PRJEB58983 22701 276 1.167488 3.22226688 Verrucomonas longifila 629764 SAR_Eukaryotes SAR_Eukaryotes 111 4.13e-20   NTclustered gi|290760489|gb|GQ144692.1| 629764 g22286 i0 85.088 25.1268115942029 114 11 41 6 165 276 1245 1354 Cercozoa sp. CC-2009f large subunit ribosomal RNA gene, partial sequence blastn 6935 111 1 Eukaryota Sar   Cercozoa Thecofilosea Ventricleftida   Verrucomonas Verrucomonas longifila
3950723 3950723 PRJEB58983_P_NODE_12184_length_361_cov_1.427083_g11769_i0 PRJEB58983 12184 361 1.427083 5.15176963 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 128 2.1799999999999997e-35   NR ADK26622.1 323453 g11769 i0 93.4 0.506925207756233 61 4 50.7 0 3 185 70 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 183 128 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
6503277 6503277 PRJEB58983_P_NODE_31566_length_244_cov_0.912281_g31151_i0 PRJEB58983 31566 244 0.912281 2.22596564 Bodomorpha sp. HFCC 92 458884 SAR_Eukaryotes SAR_Eukaryotes 451 1.86e-122   NTclustered gi|197723521|gb|EF681900.2| 458884 g31151 i0 100 80.3565573770492 244 0 100 0 1 244 255 12 Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence blastn 19607 451 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha sp. HFCC 92
13745501 13745501 PRJEB58983_P_NODE_1511_length_1034_cov_3.782518_g1206_i0 PRJEB58983 1511 1034 3.782518 39.11123612 Cercozoa sp. DMV 1342330 SAR_Eukaryotes SAR_Eukaryotes 387 2.6099999999999998e-129   NR BAN37425.1 1342330 g1206 i0 70.9 3.68762088974855 254 74 73.7 0 7 768 188 441 BAN37425.1 elongation factor 1-alpha [Cercozoa sp. DMV] diamond 3813 387 1 Eukaryota Sar   Cercozoa         Cercozoa sp. DMV
14153504 14153504 PRJEB58983_P_NODE_33852_length_232_cov_6.905660_g33437_i0 PRJEB58983 33852 232 6.90566 16.0211312 Cercomonas sp. 1979794 SAR_Eukaryotes SAR_Eukaryotes 182 2.54e-41   NTclustered gi|2651357801|gb|PP174314.1| 1979794 g33437 i0 81.579 83.0086206896552 228 35 97 7 4 229 4029 3807 Cercomonas sp. isolate P5 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 19258 182 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp.
15427233 15427233 PRJEB58983_P_NODE_21273_length_283_cov_1.461905_g20858_i0 PRJEB58983 21273 283 1.461905 4.13719115 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 175 1.83e-52   NR ADK26624.1 323453 g20858 i0 89.4 0.996466431095406 94 10 99.6 0 2 283 67 160 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 282 175 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
19250295 19250295 PRJEB58983_P_NODE_16176_length_318_cov_4.261224_g15761_i0 PRJEB58983 16176 318 4.261224 13.55069232 Mesofila sp. ATCC PRA-54 439948 SAR_Eukaryotes SAR_Eukaryotes 257 5.8800000000000006e-64   NTclustered gi|160337400|gb|EF455798.1| 439948 g15761 i0 84.151 79.1037735849057 265 42 83 0 1 265 728 464 Dimorpha sp. ATCC PRA-54 clone 2 actin gene, partial cds blastn 25155 257 1 Eukaryota Sar   Cercozoa     Mesofilidae Mesofila Mesofila sp. ATCC PRA-54
21801515 21801515 PRJEB58983_P_NODE_18258_length_302_cov_1.017467_g17843_i0 PRJEB58983 18258 302 1.017467 3.07275034 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 520 6.409999999999999e-143   NTclustered gi|1402550476|gb|MH488762.1| 2231160 g17843 i0 97.682 7.57284768211921 302 7 100 0 1 302 205 506 Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 2287 520 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
21801862 21801862 PRJEB58983_P_NODE_34398_length_229_cov_2.282051_g33983_i0 PRJEB58983 34398 229 2.282051 5.22589679 Phytocercomonas venanatans 2065209 SAR_Eukaryotes SAR_Eukaryotes 158 4.21e-34   NTclustered gi|1315527750|gb|MF034900.1| 2065209 g33983 i0 79.565 1.98689956331878 230 39 97 6 1 223 9467 9695 Phytocercomonas venanatans 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 455 158 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Phytocercomonas Phytocercomonas venanatans
23076648 23076648 PRJEB58983_P_NODE_10939_length_379_cov_52.565359_g10524_i0 PRJEB58983 10939 379 52.565359 199.22271061 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 344 5.32e-90   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g10524 i0 85.174 48.2823218997361 344 41 89 10 41 379 4039 3701 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 18299 344 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
27886424 27886424 PRJEB58983_P_NODE_27185_length_255_cov_3.274725_g26770_i0 PRJEB58983 27185 255 3.274725 8.35054875 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 140 8.46e-41   NR ADK47156.1 323453 g26770 i0 94.3 0.823529411764706 70 4 82.4 0 210 1 1 70 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 210 140 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74

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);;