RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA493234" and tax_phylum = "Fusobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fusobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493234 · 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
5557713 5557713 PRJNA493234_S_NODE_11465_length_298_cov_2.284444_g11372_i0 PRJNA493234 11465 298 2.284444 6.80764312 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 429 1.1e-115   NTclustered gi|922689899|gb|CP012410.1| 712357 g11372 i0 92.642 133.798657718121 299 20 100 2 1 298 51727 52024 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 39872 429 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
12578451 12578451 PRJNA493234_S_NODE_21390_length_239_cov_2.295181_g21297_i0 PRJNA493234 21390 239 2.295181 5.48548259 Fusobacterium 848 Bacteria Bacteria 442 1.0899999999999994e-119   NTclustered gi|1370537877|gb|CP028108.1| 860 g21297 i0 100 99.6820083682008 239 0 100 0 1 239 2369775 2369537 Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome blastn 23824 442 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
14482854 14482854 PRJNA493234_S_NODE_14192_length_277_cov_3.431373_g14099_i0 PRJNA493234 14192 277 3.431373 9.50490321 Leptotrichia sp. HMT-225 3058373 Bacteria Bacteria 507 4.53e-139   NTclustered gi|2557559843|gb|CP130323.1| 3058373 g14099 i0 99.639 511.187725631769 277 1 100 0 1 277 198047 197771 Leptotrichia sp. HMT-225 chromosome, complete genome blastn 141599 507 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. HMT-225
24680424 24680424 PRJNA493234_S_NODE_21420_length_238_cov_3.593939_g21327_i0 PRJNA493234 21420 238 3.593939 8.55357482 Leptotrichia sp. oral taxon 498 712368 Bacteria Bacteria 440 3.899999999999999e-119   NTclustered gi|1227268105|gb|CP016753.1| 712368 g21327 i0 100 130.819327731092 238 0 100 0 1 238 594065 593828 Leptotrichia sp. oral taxon 498, complete genome blastn 31135 440 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 498

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