RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA495917", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA495917 · 6 ✖

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
6855113 6855113 PRJNA495917_S_NODE_1546_length_384_cov_17.584527_g1352_i0 PRJNA495917 1546 384 17.584527 67.52458368 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 350 1.1600000000000001e-91   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g1352 i0 85.112 43.5755208333333 356 38 91 11 36 384 4039 3692 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 16733 350 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
8130624 8130624 PRJNA495917_S_NODE_5247_length_220_cov_12.210811_g5053_i0 PRJNA495917 5247 220 12.210811 26.8637842 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 285 1.7599999999999998e-72   NTclustered gi|238617605|gb|FJ973380.1| 45107 g5053 i0 89.912 37.8227272727273 228 14 99 4 1 219 1654 1881 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 8321 285 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
10681096 10681096 PRJNA495917_S_NODE_13409_length_159_cov_17.145161_g13215_i0 PRJNA495917 13409 159 17.145161 27.26080599 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 289 9.22e-74   NTclustered gi|238617605|gb|FJ973380.1| 45107 g13215 i0 99.371 100.786163522013 159 1 100 0 1 159 1187 1029 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 16025 289 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
13231457 13231457 PRJNA495917_S_NODE_9351_length_178_cov_10.083916_g9157_i0 PRJNA495917 9351 178 10.083916 17.94937048 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 327 2.23e-85   NTclustered gi|68271541|gb|DQ086722.1| 45107 g9157 i0 100 100.544943820225 177 0 99 0 1 177 343 519 Heteromita globosa isolate HETEGLOB large subunit ribosomal RNA gene, partial sequence blastn 17897 327 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
17054848 17054848 PRJNA495917_S_NODE_2034_length_341_cov_18.209150_g1840_i0 PRJNA495917 2034 341 18.20915 62.0932015 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 569 7.199999999999998e-158   NTclustered gi|238617605|gb|FJ973380.1| 45107 g1840 i0 96.774 99.2492668621701 341 11 100 0 1 341 1637 1297 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 33844 569 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
24059769 24059769 PRJNA495917_S_NODE_1459_length_393_cov_12.136872_g1265_i0 PRJNA495917 1459 393 12.136872 47.69790696 Heteromita 45106 SAR_Eukaryotes SAR_Eukaryotes 710 0   NTclustered gi|46393899|gb|AY496043.1| 45107 g1265 i0 99.237 100.045801526718 393 3 100 0 1 393 813 421 Heteromita globosa strain SCCAP H251 small subunit ribosomal RNA gene, partial sequence blastn 39318 715 0.993006993006993 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa

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