RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1092581" 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

  • PRJNA1092581 · 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
195783 195783 PRJNA1092581_P_NODE_111461_length_237_cov_9.731707_g110928_i0 PRJNA1092581 111461 237 9.731707 23.06414559 Placocista sp. CC-Grouse Mountain 741089 SAR_Eukaryotes SAR_Eukaryotes 97.1 9.69e-16   NTclustered gi|290760485|gb|GQ144688.1| 741089 g110928 i0 82.301 13.42194092827 113 18 47 2 51 162 1708 1597 Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence blastn 3181 97.1 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Placocista Placocista sp. CC-Grouse Mountain
6120985 6120985 PRJNA1092581_P_NODE_116285_length_229_cov_7.858974_g115752_i0 PRJNA1092581 116285 229 7.858974 17.99705046 Paracercomonas 372085 SAR_Eukaryotes SAR_Eukaryotes 398 2.2799999999999994e-106   NTclustered gi|166083761|gb|EF024284.1| 404737 g115752 i0 99.099 96.3187772925764 222 1 97 1 8 229 1666 1446 Cercomonadidae environmental sample clone Elev_18S_681 18S ribosomal RNA gene, partial sequence blastn 22057 398 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae   uncultured cercomonad
6573786 6573786 PRJNA1092581_P_NODE_11846_length_793_cov_35.961111_g11380_i0 PRJNA1092581 11846 793 35.961111 285.17161023 Guttulinopsis rogosa 2231170 SAR_Eukaryotes SAR_Eukaryotes 1417 0   NTclustered gi|1402550485|gb|MH488771.1| 2231170 g11380 i0 100 18.6948297604035 767 0 97 0 21 787 4 770 Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 14825 1417 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Guttulinopsis Guttulinopsis rogosa
12950161 12950161 PRJNA1092581_P_NODE_2551_length_1383_cov_59.569466_g2353_i0 PRJNA1092581 2551 1383 59.569466 823.84571478 Guttulinopsis rogosa 2231170 SAR_Eukaryotes SAR_Eukaryotes 2416 0   NTclustered gi|1402550485|gb|MH488771.1| 2231170 g2353 i0 98.678 31.9942154736081 1362 12 98 4 24 1383 720 2077 Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 44248 2416 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Guttulinopsis Guttulinopsis rogosa

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