RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA752572" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA752572 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
9657059 9657059 PRJNA752572_P_NODE_167888_length_206_cov_1.865497_g167381_i0 PRJNA752572 167888 206 1.865497 3.84292382 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 359 9.47e-95   NTclustered gi|88792583|gb|DQ386164.1| 372086 g167381 i0 98.058 171.383495145631 206 4 100 0 1 206 2707 2502 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 35305 359 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
19855645 19855645 PRJNA752572_P_NODE_126996_length_238_cov_1.812808_g126489_i0 PRJNA752572 126996 238 1.812808 4.31448304 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 429 8.45e-116   NTclustered gi|88792583|gb|DQ386164.1| 372086 g126489 i0 99.16 95.7941176470588 238 2 100 0 1 238 1704 1941 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 22799 429 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
21131127 21131127 PRJNA752572_P_NODE_102797_length_266_cov_2.290043_g102290_i0 PRJNA752572 102797 266 2.290043 6.09151438 Cercomonas sp. HFCC549 458874 SAR_Eukaryotes SAR_Eukaryotes 475 1.2199999999999997e-129   NTclustered gi|161015714|gb|EF681948.1| 458874 g102290 i0 98.872 17.218045112782 266 3 100 0 1 266 321 586 Cercomonas sp. HFCC549 28S ribosomal RNA gene, partial sequence blastn 4580 475 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. HFCC549

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