RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1034995", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA1034995 · 5 ✖

analysis 1

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
168444 168444 PRJNA1034995_S_NODE_30281_length_267_cov_15.491071_g30125_i0 PRJNA1034995 30281 267 15.491071 41.36115957 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 425 1.25e-114   NTclustered gi|238617605|gb|FJ973380.1| 45107 g30125 i0 98.354 89.5505617977528 243 3 91 1 26 267 1343 1585 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 23910 425 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
9096072 9096072 PRJNA1034995_S_NODE_37928_length_216_cov_3.959538_g37772_i0 PRJNA1034995 37928 216 3.959538 8.55260208 uncultured Cercozoa 175275 SAR_Eukaryotes SAR_Eukaryotes 333 6.079999999999999e-87   NTclustered gi|219524772|gb|EU709135.1| 175275 g37772 i0 97.462 91.2731481481482 197 2 91 2 1 196 287 93 Uncultured cercozoan isolate HetChi17 18S ribosomal RNA gene, partial sequence blastn 19715 333 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
15471394 15471394 PRJNA1034995_S_NODE_43393_length_189_cov_2.835616_g43237_i0 PRJNA1034995 43393 189 2.835616 5.35931424 Homocognata cf. vulgaris 2231174 SAR_Eukaryotes SAR_Eukaryotes 350 5.14e-92   NTclustered gi|1402550492|gb|MH488778.1| 2231174 g43237 i0 100 98.3227513227513 189 0 100 0 1 189 2735 2547 Homocognata cf. vulgaris isolate CGS2A sequence blastn 18583 350 1 Eukaryota Sar   Cercozoa       Homocognata Homocognata cf. vulgaris
23960033 23960033 PRJNA1034995_S_NODE_36999_length_221_cov_11.460674_g36843_i0 PRJNA1034995 36999 221 11.460674 25.32808954 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 357 3.71e-94   NTclustered gi|65306224|gb|AY965867.1| 328349 g36843 i0 99.49 88.4615384615385 196 1 89 0 26 221 1435 1630 Soil flagellate AND24 18S ribosomal RNA gene, partial sequence blastn 19550 357 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae   soil flagellate AND24
25233864 25233864 PRJNA1034995_S_NODE_18600_length_409_cov_25.603825_g18445_i0 PRJNA1034995 18600 409 25.603825 104.71964425 Bodomorpha 188949 SAR_Eukaryotes SAR_Eukaryotes 745 0   NTclustered gi|33309639|gb|AF411276.1| 188950 g18445 i0 99.511 100.440097799511 409 2 100 0 1 409 620 1028 Bodomorpha minima 18S ribosomal RNA gene, complete sequence blastn 41080 745 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima

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