RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB14803" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 7 ✖

bioproject 1

  • PRJEB14803 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
21478 21478 PRJEB14803_P_NODE_27541_length_209_cov_1.396552_g27075_i0 PRJEB14803 27541 209 1.396552 2.91879368 Leptotrichia hongkongensis 554406 Bacteria Bacteria 331 2.1e-86   NTclustered gi|1708587163|dbj|AP019846.1| 554406 g27075 i0 95.631 506.578947368421 206 9 99 0 4 209 70708 70913 Leptotrichia hongkongensis JMUB5056 DNA, complete genome blastn 105875 331 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hongkongensis
1295577 1295577 PRJEB14803_P_NODE_15622_length_305_cov_1.740741_g15156_i0 PRJEB14803 15622 305 1.740741 5.30926005 Leptotrichia hongkongensis 554406 Bacteria Bacteria 549 8.27e-152   NTclustered gi|1708587163|dbj|AP019846.1| 554406 g15156 i0 99.34 143.314754098361 303 2 99 0 3 305 1995467 1995165 Leptotrichia hongkongensis JMUB5056 DNA, complete genome blastn 43711 549 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hongkongensis
2261104 2261104 PRJEB14803_P_NODE_3982_length_704_cov_129.714499_g506_i3 PRJEB14803 3982 704 129.714499 913.19007296 Cetobacterium 180162 Bacteria Bacteria 872 0   NTclustered gi|2865368125|gb|CP122294.1| 188913 g506 i3 89.231 528.563920454545 715 54 100 21 1 704 278611 279313 Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence blastn 372109 872 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
11499535 11499535 PRJEB14803_P_NODE_38870_length_168_cov_2.045113_g38404_i0 PRJEB14803 38870 168 2.045113 3.43578984 Leptotrichia hongkongensis 554406 Bacteria Bacteria 311 2.11e-80   NTclustered gi|1708587163|dbj|AP019846.1| 554406 g38404 i0 100 372.619047619048 168 0 100 0 1 168 1622740 1622907 Leptotrichia hongkongensis JMUB5056 DNA, complete genome blastn 62600 311 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hongkongensis
14049507 14049507 PRJEB14803_P_NODE_16732_length_291_cov_2.031250_g16266_i0 PRJEB14803 16732 291 2.03125 5.9109375 Leptotrichia hongkongensis 554406 Bacteria Bacteria 538 1.6999999999999994e-148   NTclustered gi|1708587163|dbj|AP019846.1| 554406 g16266 i0 100 445.745704467354 291 0 100 0 1 291 71659 71369 Leptotrichia hongkongensis JMUB5056 DNA, complete genome blastn 129712 538 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hongkongensis
16598360 16598360 PRJEB14803_P_NODE_46514_length_152_cov_1.025641_g46048_i0 PRJEB14803 46514 152 1.025641 1.55897432 Leptotrichia hongkongensis 554406 Bacteria Bacteria 281 1.46e-71   NTclustered gi|1708587163|dbj|AP019846.1| 554406 g46048 i0 100 412.835526315789 152 0 100 0 1 152 72351 72200 Leptotrichia hongkongensis JMUB5056 DNA, complete genome blastn 62751 281 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hongkongensis
24247221 24247221 PRJEB14803_P_NODE_20060_length_258_cov_20.116592_g19594_i0 PRJEB14803 20060 258 20.116592 51.90080736 Leptotrichia hongkongensis 554406 Bacteria Bacteria 464 2.5499999999999994e-126   NTclustered gi|1708587163|dbj|AP019846.1| 554406 g19594 i0 99.222 487.701550387597 257 2 99 0 1 257 1622024 1622280 Leptotrichia hongkongensis JMUB5056 DNA, complete genome blastn 125827 464 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hongkongensis

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