RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA788929" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 10 ✖

bioproject 1

  • PRJNA788929 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
10973144 10973144 PRJNA788929_P_NODE_1589_length_1665_cov_31.069095_g1383_i0 PRJNA788929 1589 1665 31.069095 517.30043175 Cetobacterium sp. NK 2071632 Bacteria Bacteria 694 1.1099999999999995e-247   NR WP_256689639.1 2993530 g1383 i0 92.2 0.718918918918919 399 31 71.9 0 138 1334 1 399 WP_256689639.1 sodium/glutamate symporter [Cetobacterium sp. NK01] diamond 1197 694 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. NK01
12248759 12248759 PRJNA788929_P_NODE_21250_length_353_cov_23.064286_g20590_i0 PRJNA788929 21250 353 23.064286 81.41692958 Cetobacterium sp. 8H 2759681 Bacteria Bacteria 132 3.25e-36   NR WP_185875338.1 2759681 g20590 i0 79.5 0.662889518413598 78 16 66.3 0 330 97 134 211 WP_185875338.1 carbonic anhydrase [Cetobacterium sp. 8H] diamond 234 132 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. 8H
13523398 13523398 PRJNA788929_P_NODE_4951_length_898_cov_39.276364_g4379_i0 PRJNA788929 4951 898 39.276364 352.70174872 Cetobacterium somerae 188913 Bacteria Bacteria 514 2.96e-181   NR WP_023051507.1 188913 g4379 i0 90.6 0.962138084632517 288 27 96.2 0 875 12 101 388 WP_023051507.1 cysteine desulfurase family protein [Cetobacterium somerae] diamond 864 514 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
27275002 27275002 PRJNA788929_P_NODE_34183_length_267_cov_1.479381_g33522_i0 PRJNA788929 34183 267 1.479381 3.94994727 Fusobacterium necrophorum 859 Bacteria Bacteria 40.8 0.0476   NR WP_005964152.1 859 g33522 i0 44.9 0.550561797752809 49 21 51.7 2 128 265 1 46 WP_005964152.1 DUF3100 domain-containing protein [Fusobacterium necrophorum] diamond 147 40.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium necrophorum
27654126 27654126 PRJNA788929_P_NODE_14864_length_438_cov_7.879452_g14205_i0 PRJNA788929 14864 438 7.879452 34.51199976 Cetobacterium sp. ZWU 2071632 Bacteria Bacteria 246 5.21e-79   NR WP_047382431.1 1340502 g14205 i0 100 0.876712328767123 128 0 87.7 0 55 438 1 128 WP_047382431.1 hypothetical protein [Cetobacterium sp. ZWU0022] diamond 384 246 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZWU0022
27748962 27748962 PRJNA788929_P_NODE_46504_length_220_cov_13.034014_g45843_i0 PRJNA788929 46504 220 13.034014 28.6748308 Leptotrichia wadei 157687 Bacteria Bacteria 85.1 5.3e-20   NR WP_021747207.1 157687 g45843 i0 100 0.531818181818182 39 0 53.2 0 102 218 1 39 WP_021747207.1 type II toxin-antitoxin system HicA family toxin [Leptotrichia wadei] diamond 117 85.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
28664401 28664401 PRJNA788929_P_NODE_15507_length_426_cov_28.033994_g14848_i0 PRJNA788929 15507 426 28.033994 119.42481444 Cetobacterium sp. 2071632 Bacteria Bacteria 245 1.2799999999999998e-73   NR WP_332484866.1 2071632 g14848 i0 96.9 0.901408450704225 128 4 90.1 0 26 409 128 255 WP_332484866.1 MobA/MobL family protein [Cetobacterium sp.] diamond 384 245 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp.
29264030 29264030 PRJNA788929_P_NODE_16389_length_412_cov_34.412979_g15730_i0 PRJNA788929 16389 412 34.412979 141.78147348 unclassified Cetobacterium 2630983 Bacteria Bacteria 232 4.85e-74   NR WP_047384647.1 2630983 g15730 i0 99.2 1.79126213592233 123 1 89.6 0 390 22 171 293 WP_047384647.1 MULTISPECIES: phosphate ABC transporter permease subunit PstC [unclassified Cetobacterium] diamond 738 232 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  
31570888 31570888 PRJNA788929_P_NODE_44316_length_232_cov_11.452830_g43655_i0 PRJNA788929 44316 232 11.45283 26.5705656 unclassified Cetobacterium 2630983 Bacteria Bacteria 129 2.75e-35   NR WP_047384075.1 2630983 g43655 i0 100 0.84051724137931 65 0 84.1 0 208 14 185 249 WP_047384075.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium] diamond 195 129 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  
31855283 31855283 PRJNA788929_P_NODE_34437_length_265_cov_17.546875_g33776_i0 PRJNA788929 34437 265 17.546875 46.49921875 Cetobacterium sp. ZOR 2071632 Bacteria Bacteria 162 3.9599999999999996e-47   NR WP_047393926.1 1339239 g33776 i0 100 0.905660377358491 80 0 90.6 0 24 263 203 282 WP_047393926.1 glycosyltransferase family 9 protein [Cetobacterium sp. ZOR0034] diamond 240 162 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZOR0034

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