RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA541476 · 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
509068 509068 PRJNA541476_P_NODE_35181_length_246_cov_0.895954_g34975_i0 PRJNA541476 35181 246 0.895954 2.20404684 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 427 3.16e-115   NTclustered gi|1276718681|gb|CP024704.1| 2663009 g34975 i0 97.967 92.7357723577236 246 5 100 0 1 246 982138 982383 Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome blastn 22813 427 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
509363 509363 PRJNA541476_P_NODE_9641_length_367_cov_1.129252_g9435_i0 PRJNA541476 9641 367 1.129252 4.14435484 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 678 0   NTclustered gi|1276705688|gb|CP024698.1| 2663009 g9435 i0 100 476.610354223433 367 0 100 0 1 367 508570 508936 Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome blastn 174916 678 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
5612317 5612317 PRJNA541476_P_NODE_17605_length_293_cov_2.209091_g17399_i0 PRJNA541476 17605 293 2.209091 6.47263663 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 542 1.32e-149   NTclustered gi|1276705688|gb|CP024698.1| 2663009 g17399 i0 100 456.184300341297 293 0 100 0 1 293 736575 736867 Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome blastn 133662 542 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
10713221 10713221 PRJNA541476_P_NODE_37569_length_244_cov_0.906433_g37363_i0 PRJNA541476 37569 244 0.906433 2.21169652 Leptotrichia hongkongensis 554406 Bacteria Bacteria 451 1.86e-122   NTclustered gi|1708587163|dbj|AP019846.1| 554406 g37363 i0 100 11.7090163934426 244 0 100 0 1 244 310091 309848 Leptotrichia hongkongensis JMUB5056 DNA, complete genome blastn 2857 451 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hongkongensis
15146628 15146628 PRJNA541476_P_NODE_5912_length_466_cov_1.819338_g5710_i0 PRJNA541476 5912 466 1.819338 8.47811508 Fusobacterium 848 Bacteria Bacteria 861 0   NTclustered gi|1370537877|gb|CP028108.1| 860 g5710 i0 100 480.302575107296 466 0 100 0 1 466 462599 463064 Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome blastn 223821 861 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);;