RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB39269" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 6 ✖

bioproject 1

  • PRJEB39269 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
2264525 2264525 PRJEB39269_P_NODE_16082_length_350_cov_1.443730_g15677_i0 PRJEB39269 16082 350 1.44373 5.053055 Fusobacterium 848 Bacteria Bacteria 630 3.3399999999999984e-176   NTclustered gi|2444100754|gb|CP117525.1| 851 g15677 i0 99.143 489.937142857143 350 3 100 0 1 350 85231 84882 Fusobacterium nucleatum strain FNV chromosome, complete genome blastn 171478 636 0.990566037735849 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
6092328 6092328 PRJEB39269_P_NODE_24265_length_284_cov_1.048980_g23860_i0 PRJEB39269 24265 284 1.04898 2.9791032 Cetobacterium 180162 Bacteria Bacteria 446 1.03e-120   NTclustered gi|2865368125|gb|CP122294.1| 188913 g23860 i0 94.792 493.003521126761 288 11 100 4 1 284 279754 279467 Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence blastn 140013 446 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
8642409 8642409 PRJEB39269_P_NODE_54027_length_187_cov_1.641892_g53622_i0 PRJEB39269 54027 187 1.641892 3.07033804 Leptotrichia 32067 Bacteria Bacteria 346 6.56e-91   NTclustered gi|470484715|ref|NR_076664.1| 40542 g53622 i0 100 476.229946524064 187 0 100 0 1 187 695 881 Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence blastn 89055 346 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia buccalis
13742706 13742706 PRJEB39269_P_NODE_57791_length_181_cov_1.978873_g57386_i0 PRJEB39269 57791 181 1.978873 3.58176013 Fusobacterium 848 Bacteria Bacteria 335 1.36e-87   NTclustered gi|2704983719|gb|CP077132.1| 851 g57386 i0 100 494 181 0 100 0 1 181 93595 93775 Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome blastn 89414 335 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
16633902 16633902 PRJEB39269_P_NODE_42074_length_212_cov_1.092486_g41669_i0 PRJEB39269 42074 212 1.092486 2.31607032 Leptotrichia wadei 157687 Bacteria Bacteria 381 2.0899999999999994e-101   NTclustered gi|1708582457|dbj|AP019841.1| 157687 g41669 i0 99.057 168.594339622642 212 2 100 0 1 212 221477 221688 Leptotrichia wadei JMUB3936 DNA, complete genome blastn 35742 381 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
20115809 20115809 PRJEB39269_P_NODE_91056_length_150_cov_1.846847_g90651_i0 PRJEB39269 91056 150 1.846847 2.7702705 Leptotrichia 32067 Bacteria Bacteria 278 1.85e-70   NTclustered gi|631253196|ref|NR_114394.1| 40542 g90651 i0 100 107.993333333333 150 0 100 0 1 150 865 716 Leptotrichia buccalis strain C-1013-b 16S ribosomal RNA, partial sequence blastn 16199 278 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia buccalis

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