RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJEB12237" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 4 ✖

bioproject 1

  • PRJEB12237 · 4 ✖

analysis 1

  • blastn · 4 ✖

tax_clade 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
985640 985640 PRJEB12237_P_NODE_8661_length_185_cov_1.600000_g8465_i0 PRJEB12237 8661 185 1.6 2.96 Leptotrichia 32067 Bacteria Bacteria 342 8.369999999999999e-90   NTclustered gi|1227268105|gb|CP016753.1| 712368 g8465 i0 100 259.962162162162 185 0 100 0 1 185 592804 592988 Leptotrichia sp. oral taxon 498, complete genome blastn 48093 342 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 498
8638658 8638658 PRJEB12237_P_NODE_10807_length_161_cov_1.230159_g10611_i0 PRJEB12237 10807 161 1.230159 1.98055599 Leptotrichia 32067 Bacteria Bacteria 298 1.56e-76   NTclustered gi|1227268105|gb|CP016753.1| 712368 g10611 i0 100 376.776397515528 161 0 100 0 1 161 593761 593601 Leptotrichia sp. oral taxon 498, complete genome blastn 60661 298 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 498
10223483 10223483 PRJEB12237_P_NODE_8909_length_182_cov_1.251701_g8713_i0 PRJEB12237 8909 182 1.251701 2.27809582 Leptotrichia sp. oral taxon 221 712362 Bacteria Bacteria 331 1.7800000000000002e-86   NTclustered gi|2028889048|gb|CP072378.1| 712362 g8713 i0 99.451 400.659340659341 182 1 100 0 1 182 1713264 1713445 Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome blastn 72920 331 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 221
25211651 25211651 PRJEB12237_P_NODE_11740_length_153_cov_1.355932_g11544_i0 PRJEB12237 11740 153 1.355932 2.07457596 Fusobacterium 848 Bacteria Bacteria 279 5.28e-71   NTclustered gi|1370537877|gb|CP028108.1| 860 g11544 i0 100 469.771241830065 151 0 99 0 1 151 462460 462610 Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome blastn 71875 279 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum

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