RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA613025", 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 · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA613025 · 6 ✖

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
4419535 4419535 PRJNA613025_S_NODE_31664_length_164_cov_2.330435_g31510_i0 PRJNA613025 31664 164 2.330435 3.8219134 Gymnophrys sp. ATCC 50923 646463 SAR_Eukaryotes SAR_Eukaryotes 124 2.86e-24   NTclustered gi|238617604|gb|FJ973379.1| 646463 g31510 i0 81.176 27.9085365853659 170 19 98 11 3 163 2156 2321 Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence blastn 4577 124 1 Eukaryota Sar   Cercozoa       Gymnophrys Gymnophrys sp. ATCC 50923
10795685 10795685 PRJNA613025_S_NODE_10369_length_383_cov_1.691617_g10216_i0 PRJNA613025 10369 383 1.691617 6.47889311 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 217 1.22e-51   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g10216 i0 92.208 34.331592689295 154 10 40 2 64 216 3696 3848 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 13149 217 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
18443747 18443747 PRJNA613025_S_NODE_19655_length_223_cov_1.172414_g19501_i0 PRJNA613025 19655 223 1.172414 2.61448322 uncultured Cercozoa 175275 SAR_Eukaryotes SAR_Eukaryotes 324 3.8e-84   NTclustered gi|1270185585|gb|MG266086.1| 175275 g19501 i0 92.825 100.605381165919 223 16 100 0 1 223 577 355 Uncultured Cercozoa clone MossITSLSU68 large subunit ribosomal RNA gene, partial sequence blastn 22435 324 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
19718520 19718520 PRJNA613025_S_NODE_32356_length_163_cov_1.456140_g32202_i0 PRJNA613025 32356 163 1.45614 2.3735082 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 139 1.01e-28   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g32202 i0 88.235 33.7914110429448 119 11 73 3 45 163 3875 3760 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 5508 139 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
20275257 20275257 PRJNA613025_S_NODE_23856_length_194_cov_2.813793_g23702_i0 PRJNA613025 23856 194 2.813793 5.45875842 Thaumatomastigidae 45098 SAR_Eukaryotes SAR_Eukaryotes 200 5.649999999999999e-47   NTclustered gi|238617604|gb|FJ973379.1| 646463 g23702 i0 94.574 64.4690721649485 129 7 66 0 63 191 1747 1875 Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence blastn 12507 200 1 Eukaryota Sar   Cercozoa       Gymnophrys Gymnophrys sp. ATCC 50923
32179914 32179914 PRJNA613025_S_NODE_29358_length_169_cov_2.075000_g29204_i0 PRJNA613025 29358 169 2.075 3.50675 Cladocopium 2486696 SAR_Eukaryotes SAR_Eukaryotes 86.7 1.93e-18   NR MES1916625.1 1215613 g29204 i0 74.5 35.112426035503 55 14 97.6 0 3 167 6 60 MES1916625.1 hypothetical protein [Cercozoa sp. M6MM] diamond 5934 86.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM

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