RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA270367" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA270367 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
1644879 1644879 PRJNA270367_P_NODE_30382_length_202_cov_1.183007_g30177_i0 PRJNA270367 30382 202 1.183007 2.38967414 Gymnophrys sp. ATCC 50923 646463 SAR_Eukaryotes SAR_Eukaryotes 357 3.3299999999999996e-94   NTclustered gi|302026148|gb|GQ377646.1| 646463 g30177 i0 98.995 103.673267326733 199 2 99 0 4 202 931 733 Gymnophrys sp. ATCC 50923 beta-tubulin (Btub) gene, partial cds blastn 20942 357 1 Eukaryota Sar   Cercozoa       Gymnophrys Gymnophrys sp. ATCC 50923
1644904 1644904 PRJNA270367_P_NODE_33902_length_188_cov_0.942446_g33697_i0 PRJNA270367 33902 188 0.942446 1.77179848 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 176 9.16e-40   NTclustered gi|238617666|gb|FJ973412.1| 188950 g33697 i0 87.582 14.7553191489362 153 17 81 2 13 164 1 152 Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds blastn 2774 176 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
5473421 5473421 PRJNA270367_P_NODE_31385_length_198_cov_1.040268_g31180_i0 PRJNA270367 31385 198 1.040268 2.05973064 Gymnophrys sp. ATCC 50923 646463 SAR_Eukaryotes SAR_Eukaryotes 359 9.03e-95   NTclustered gi|302026186|gb|GQ377653.1| 646463 g31180 i0 99.492 75.3080808080808 197 1 99 0 2 198 969 773 Gymnophrys sp. ATCC 50923 HSP90 gene, partial cds blastn 14911 359 1 Eukaryota Sar   Cercozoa       Gymnophrys Gymnophrys sp. ATCC 50923
18909688 18909688 PRJNA270367_P_NODE_39655_length_169_cov_0.866667_g39450_i0 PRJNA270367 39655 169 0.866667 1.46466723 Guttulinopsis 1144921 SAR_Eukaryotes SAR_Eukaryotes 259 7.75e-65   NTclustered gi|1402550487|gb|MH488773.1| 2231167 g39450 i0 99.301 46.2366863905325 143 1 85 0 27 169 1148 1006 Guttulinopsis sp. isolate STA small subunit ribosomal RNA gene, partial sequence blastn 7814 261 0.992337164750958 Eukaryota Sar   Cercozoa     Guttulinopsidae Guttulinopsis Guttulinopsis sp.

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