RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA675331 · 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
2443889 2443889 PRJNA675331_P_NODE_7142_length_363_cov_1.327586_g6970_i0 PRJNA675331 7142 363 1.327586 4.81913718 Cetobacterium 180162 Bacteria Bacteria 660 0   NTclustered gi|2865368125|gb|CP122294.1| 188913 g6970 i0 99.449 509.980716253444 363 2 100 0 1 363 279120 278758 Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence blastn 185123 660 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
3198693 3198693 PRJNA675331_P_NODE_3383_length_508_cov_2.255172_g3213_i0 PRJNA675331 3383 508 2.255172 11.45627376 Cetobacterium somerae 188913 Bacteria Bacteria 904 0   NTclustered gi|2201062197|gb|CP092519.1| 188913 g3213 i0 98.819 515.931102362205 508 5 100 1 1 508 48888 49394 Cetobacterium somerae strain CS2105-BJ chromosome, complete genome blastn 262093 904 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
12127081 12127081 PRJNA675331_P_NODE_24130_length_241_cov_0.916667_g23958_i0 PRJNA675331 24130 241 0.916667 2.20916747 Cetobacterium somerae 188913 Bacteria Bacteria 412 8.64e-111   NTclustered gi|2666488225|gb|CP143319.1| 188913 g23958 i0 97.51 99.6514522821577 241 6 100 0 1 241 1904210 1904450 Cetobacterium somerae strain ceto chromosome, complete genome blastn 24016 412 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
17746397 17746397 PRJNA675331_P_NODE_5334_length_414_cov_2.425220_g5162_i0 PRJNA675331 5334 414 2.42522 10.0404108 Cetobacterium 180162 Bacteria Bacteria 732 0   NTclustered gi|2865368125|gb|CP122294.1| 188913 g5162 i0 98.551 487.971014492754 414 6 100 0 1 414 279749 279336 Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence blastn 202020 732 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
19020246 19020246 PRJNA675331_P_NODE_10335_length_310_cov_19.316456_g10163_i0 PRJNA675331 10335 310 19.316456 59.8810136 root 1 Root_unresolved Root_unresolved 503 6.65e-138   NTclustered gi|169792031|gb|EU419208.1| 860 g10163 i0 97.945 113.048387096774 292 3 93 1 12 300 447 738 Fusobacterium periodonticum isolate 3-1-7B 16S ribosomal RNA gene, partial sequence blastn 35045 508 0.990157480314961 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
23600579 23600579 PRJNA675331_P_NODE_22659_length_243_cov_0.905882_g22487_i0 PRJNA675331 22659 243 0.905882 2.20129326 Cetobacterium somerae 188913 Bacteria Bacteria 316 7.03e-82   NTclustered gi|2201062197|gb|CP092519.1| 188913 g22487 i0 90.123 5.91358024691358 243 24 100 0 1 243 130853 131095 Cetobacterium somerae strain CS2105-BJ chromosome, complete genome blastn 1437 316 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
24120472 24120472 PRJNA675331_P_NODE_18619_length_250_cov_0.870056_g18447_i0 PRJNA675331 18619 250 0.870056 2.17514 Cetobacterium 180162 Bacteria Bacteria 401 1.9499999999999994e-107   NTclustered gi|2666488225|gb|CP143319.1| 188913 g18447 i0 95.6 20.124 250 11 100 0 1 250 1904617 1904866 Cetobacterium somerae strain ceto chromosome, complete genome blastn 5031 401 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae

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