RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

bioproject 1

  • PRJNA315399 · 5 ✖

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
5488769 5488769 PRJNA315399_S_NODE_36445_length_234_cov_7.893401_g36244_i0 PRJNA315399 36445 234 7.893401 18.47055834 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 172 1.54e-38   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g36244 i0 88.356 38.3547008547009 146 14 62 2 1 145 2549 2406 Rosculus vulgaris isolate CCA sequence blastn 8975 172 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
16369714 16369714 PRJNA315399_S_NODE_8833_length_363_cov_23.917178_g8632_i0 PRJNA315399 8833 363 23.917178 86.81935614 Imbricatea 1736114 SAR_Eukaryotes SAR_Eukaryotes 582 9.869999999999999e-162   NTclustered gi|2493707699|dbj|LC764482.1| 45107 g8632 i0 96.591 97.0468319559229 352 10 97 2 13 363 19 369 Heteromita globosa LAP3-2017 gene for 18S rRNA, partial sequence blastn 35228 582 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
20786288 20786288 PRJNA315399_S_NODE_189357_length_152_cov_1.486957_g189156_i0 PRJNA315399 189357 152 1.486957 2.26017464 uncultured Cercozoa 175275 SAR_Eukaryotes SAR_Eukaryotes 193 7.02e-45   NTclustered gi|1002343672|gb|KU738550.1| 175275 g189156 i0 97.345 15.3355263157895 113 3 74 0 23 135 179 291 Uncultured Cercozoa clone cow/sheep_dung13 18S ribosomal RNA gene, partial sequence blastn 2331 193 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
22743538 22743538 PRJNA315399_S_NODE_166818_length_156_cov_12.420168_g166617_i0 PRJNA315399 166818 156 12.420168 19.37546208 Kraken 1862315 SAR_Eukaryotes SAR_Eukaryotes 237 3.31e-58   NTclustered gi|1185382122|gb|KY975569.1| 1979793 g166617 i0 100 86.4166666666667 128 0 82 0 1 128 128 1 Kraken sp. isolate Otu001178 small subunit ribosomal RNA gene, partial sequence blastn 13481 237 1 Eukaryota Sar   Cercozoa       Kraken Kraken sp.
31971005 31971005 PRJNA315399_S_NODE_61838_length_203_cov_1.572289_g61637_i0 PRJNA315399 61838 203 1.572289 3.19174667 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 90.9 1.87e-22   NR MES1911722.1 1215613 g61637 i0 73.1 0.768472906403941 52 14 76.8 0 201 46 1 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 90.9 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);;