RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA312899", 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

  • PRJNA312899 · 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
2930092 2930092 PRJNA312899_P_NODE_36183_length_300_cov_27.653386_g35741_i0 PRJNA312899 36183 300 27.653386 82.960158 uncultured Cercozoa 175275 SAR_Eukaryotes SAR_Eukaryotes 468 2.34e-127   NTclustered gi|1270185585|gb|MG266086.1| 175275 g35741 i0 94.966 99.5533333333333 298 15 99 0 1 298 622 325 Uncultured Cercozoa clone MossITSLSU68 large subunit ribosomal RNA gene, partial sequence blastn 29866 468 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
5483000 5483000 PRJNA312899_P_NODE_41245_length_277_cov_4.732456_g40803_i0 PRJNA312899 41245 277 4.732456 13.10890312 uncultured Cercozoa 175275 SAR_Eukaryotes SAR_Eukaryotes 483 7.63e-132   NTclustered gi|1270185585|gb|MG266086.1| 175275 g40803 i0 98.188 99.5234657039711 276 5 99 0 1 276 586 311 Uncultured Cercozoa clone MossITSLSU68 large subunit ribosomal RNA gene, partial sequence blastn 27568 483 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
5483465 5483465 PRJNA312899_P_NODE_67565_length_199_cov_2.040000_g67123_i0 PRJNA312899 67565 199 2.04 4.0596 Cercozoa sp. 900 1215612 SAR_Eukaryotes SAR_Eukaryotes 351 1.52e-92   NTclustered gi|399764281|gb|JQ271792.1| 1215612 g67123 i0 98.507 70.0603015075377 201 0 99 1 2 199 236 36 Cercozoa sp. 900 18S ribosomal RNA gene, partial sequence blastn 13942 351 1 Eukaryota Sar   Cercozoa         Cercozoa sp. 900
15682468 15682468 PRJNA312899_P_NODE_54633_length_232_cov_7.759563_g54191_i0 PRJNA312899 54633 232 7.759563 18.00218616 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 429 8.2e-116   NTclustered gi|1402550473|gb|MH488759.1| 2231160 g54191 i0 100 5.27155172413793 232 0 100 0 1 232 337 568 Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 1223 429 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
16956722 16956722 PRJNA312899_P_NODE_29614_length_339_cov_10.186207_g29172_i0 PRJNA312899 29614 339 10.186207 34.53124173 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 610 4.21e-170   NTclustered gi|1402550473|gb|MH488759.1| 2231160 g29172 i0 99.407 22.4395280235988 337 1 99 1 1 337 1356 1021 Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 7607 610 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
21466605 21466605 PRJNA312899_P_NODE_62617_length_211_cov_5.037037_g62175_i0 PRJNA312899 62617 211 5.037037 10.62814807 Cercomonadidae 45108 SAR_Eukaryotes SAR_Eukaryotes 128 2.99e-25   NTclustered gi|88792584|gb|DQ386165.1| 372078 g62175 i0 82.278 116.137440758294 158 19 91 7 5 161 1719 1570 Cercomonas sp. C59 28S ribosomal RNA gene, partial sequence blastn 24505 128 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. C59

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