RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA397733 · 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
412091 412091 PRJNA397733_S_NODE_9241_length_198_cov_3.597633_g9153_i0 PRJNA397733 9241 198 3.597633 7.12331334 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 366 5.4e-97   NTclustered gi|1276705688|gb|CP024698.1| 2663009 g9153 i0 100 476.636363636364 198 0 100 0 1 198 967600 967797 Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome blastn 94374 366 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
10007989 10007989 PRJNA397733_S_NODE_15688_length_155_cov_3.420635_g15600_i0 PRJNA397733 15688 155 3.420635 5.30198425 Fusobacterium 848 Bacteria Bacteria 287 3.21e-73   NTclustered gi|2704983719|gb|CP077132.1| 851 g15600 i0 100 490 155 0 100 0 1 155 94094 93940 Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome blastn 75950 287 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
12558623 12558623 PRJNA397733_S_NODE_14990_length_158_cov_27.658915_g14902_i0 PRJNA397733 14990 158 27.658915 43.7010857 Fusobacterium 848 Bacteria Bacteria 292 7.07e-75   NTclustered gi|2704983719|gb|CP077132.1| 851 g14902 i0 100 495.993670886076 158 0 100 0 1 158 93730 93573 Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome blastn 78367 292 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
21481593 21481593 PRJNA397733_S_NODE_12217_length_174_cov_2.386207_g12129_i0 PRJNA397733 12217 174 2.386207 4.15200018 Fusobacterium 848 Bacteria Bacteria 305 1.02e-78   NTclustered gi|1370537877|gb|CP028108.1| 860 g12129 i0 98.276 465.034482758621 174 3 100 0 1 174 462668 462495 Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome blastn 80916 305 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
21481596 21481596 PRJNA397733_S_NODE_3977_length_307_cov_2.687050_g3889_i0 PRJNA397733 3977 307 2.68705 8.2492435 Fusobacterium 848 Bacteria Bacteria 551 2.319999999999999e-152   NTclustered gi|586941090|dbj|AB910749.1| 860 g3889 i0 99.023 291.28013029316 307 3 100 0 1 307 4 310 Fusobacterium periodonticum gene for 16S ribosomal RNA, partial sequence blastn 89423 551 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);;