RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA529924" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA529924 · 4 ✖

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
1778562 1778562 PRJNA529924_P_NODE_4522_length_173_cov_1.777778_g4348_i0 PRJNA529924 4522 173 1.777778 3.07555594 Globisporangium splendens 82926 SAR_Eukaryotes SAR_Eukaryotes 231 1.7399999999999998e-56   NTclustered gi|1103652769|gb|AF085345.2| 82926 g4348 i0 90.751 98.2080924855491 173 16 100 0 1 173 469 297 Pythium splendens actin mRNA, complete cds blastn 16990 231 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium splendens
5607025 5607025 PRJNA529924_P_NODE_3545_length_214_cov_2.372973_g3371_i0 PRJNA529924 3545 214 2.372973 5.07816222 Cercomonas sp. ATCC 50317 45111 SAR_Eukaryotes SAR_Eukaryotes 220 4.88e-53   NTclustered gi|15216722|gb|AF363535.1| 45111 g3371 i0 85.99 89.9953271028037 207 27 96 2 9 214 53 258 Cercomonas sp. ATCC 50317 actin-2 (act2) gene, partial cds blastn 19259 220 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. ATCC 50317
9431555 9431555 PRJNA529924_P_NODE_4788_length_160_cov_3.572519_g4614_i0 PRJNA529924 4788 160 3.5725189999999998 5.7160304 Achlya bisexualis 4766 SAR_Eukaryotes SAR_Eukaryotes 167 4.5399999999999995e-37   NTclustered gi|2289|emb|X59936.1| 4766 g4614 i0 86.452 84.65 155 18 95 3 7 158 1 155 A.bisexualis gene for actin blastn 13544 167 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya bisexualis
18354665 18354665 PRJNA529924_P_NODE_4415_length_177_cov_3.547297_g4241_i0 PRJNA529924 4415 177 3.547297 6.27871569 Oxytricha granulifera 5947 SAR_Eukaryotes SAR_Eukaryotes 174 3.06e-39   NTclustered gi|21215206|gb|AF510205.1| 5947 g4241 i0 91.935 42.361581920904 124 10 70 0 2 125 282 159 Oxytricha granulifera beta-tubulin gene, complete cds blastn 7498 174 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha granulifera

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