RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA603943 · 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
4404222 4404222 PRJNA603943_P_NODE_15944_length_418_cov_1.211594_g15752_i0 PRJNA603943 15944 418 1.211594 5.06446292 Fusobacterium hwasookii 1583098 Bacteria Bacteria 773 0   NTclustered gi|1890959825|gb|CP060112.1| 1583098 g15752 i0 100 485.153110047847 418 0 100 0 1 418 544946 545363 Fusobacterium hwasookii strain KCOM 1249 chromosome, complete genome blastn 202794 773 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium hwasookii
10782183 10782183 PRJNA603943_P_NODE_63589_length_245_cov_0.895349_g63397_i0 PRJNA603943 63589 245 0.895349 2.19360505 Leptotrichia sp. oral taxon 221 712362 Bacteria Bacteria 414 2.45e-111   NTclustered gi|2028889048|gb|CP072378.1| 712362 g63397 i0 97.143 1 245 7 100 0 1 245 250296 250052 Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome blastn 245 414 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 221
15171336 15171336 PRJNA603943_P_NODE_33752_length_314_cov_1.526971_g33560_i0 PRJNA603943 33752 314 1.526971 4.79468894 Fusobacterium 848 Bacteria Bacteria 575 1.4099999999999994e-159   NTclustered gi|1370537877|gb|CP028108.1| 860 g33560 i0 99.682 488.015923566879 314 1 100 0 1 314 463041 462728 Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome blastn 153237 580 0.991379310344828 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
20269725 20269725 PRJNA603943_P_NODE_5556_length_645_cov_1.480769_g5372_i0 PRJNA603943 5556 645 1.480769 9.55096005 Fusobacterium 848 Bacteria Bacteria 1192 0   NTclustered gi|2706069597|gb|CP077108.1| 76857 g5372 i0 100 486.415503875969 645 0 100 0 1 645 1185919 1185275 Fusobacterium polymorphum strain KCOM1281 chromosome, complete genome blastn 313738 1192 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum

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