RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1245487" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 5 ✖

bioproject 1

  • PRJNA1245487 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
8004415 8004415 PRJNA1245487_P_NODE_20147_length_249_cov_0.886364_g19809_i0 PRJNA1245487 20147 249 0.886364 2.20704636 Fusobacterium hwasookii 1583098 Bacteria Bacteria 444 3.18e-120   NTclustered gi|1890959825|gb|CP060112.1| 1583098 g19809 i0 98.795 93.0963855421687 249 3 100 0 1 249 2170273 2170025 Fusobacterium hwasookii strain KCOM 1249 chromosome, complete genome blastn 23181 444 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium hwasookii
12530004 12530004 PRJNA1245487_P_NODE_19690_length_251_cov_0.876404_g19352_i0 PRJNA1245487 19690 251 0.876404 2.19977404 Bacteria 2 Bacteria Bacteria 462 8.869999999999999e-126   NTclustered gi|285798270|gb|GU408252.1| 851 g19352 i0 100 202.888446215139 250 0 99 0 2 251 1 250 Fusobacterium nucleatum clone OEN015 16S ribosomal RNA gene, partial sequence blastn 50925 464 0.995689655172414 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
15078751 15078751 PRJNA1245487_P_NODE_10312_length_370_cov_3.555556_g9974_i0 PRJNA1245487 10312 370 3.555556 13.1555572 Fusobacterium 848 Bacteria Bacteria 675 0   NTclustered gi|1370537877|gb|CP028108.1| 860 g9974 i0 99.728 487.364864864865 368 1 99 0 3 370 462498 462131 Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome blastn 180325 680 0.992647058823529 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
15654145 15654145 PRJNA1245487_P_NODE_21753_length_243_cov_0.917647_g21415_i0 PRJNA1245487 21753 243 0.917647 2.22988221 Leptotrichia hofstadii 157688 Bacteria Bacteria 433 6.69e-117   NTclustered gi|1708566027|dbj|AP019823.1| 157688 g21415 i0 98.765 1 243 3 100 0 1 243 2448597 2448355 Leptotrichia hofstadii JCM16775 DNA, complete genome blastn 243 433 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hofstadii
23303492 23303492 PRJNA1245487_P_NODE_19479_length_251_cov_2.337079_g19141_i0 PRJNA1245487 19479 251 2.337079 5.86606829 Fusobacterium animalis 76859 Bacteria Bacteria 464 2.47e-126   NTclustered gi|2706444732|gb|CP084069.1| 76859 g19141 i0 100 442.784860557769 251 0 100 0 1 251 464239 464489 Fusobacterium animalis strain SB062 chromosome, complete genome blastn 111139 464 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium animalis

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