contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA473201" and tax_kingdom = "Fusobacteriati"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10648244 | 10648244 | PRJNA473201_P_NODE_73609_length_247_cov_0.885057_g72867_i0 | PRJNA473201 | 73609 | 247 | 0.885057 | 2.18609079 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 165 | 2.4899999999999996e-47 | NR | WP_047381888.1 | 1340502 | g72867 | i0 | 98.8 | 0.983805668016194 | 81 | 1 | 98.4 | 0 | 245 | 3 | 81 | 161 | WP_047381888.1 ABC transporter substrate-binding protein [Cetobacterium sp. ZWU0022] | diamond | 243 | 165 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 20845068 | 20845068 | PRJNA473201_P_NODE_18257_length_465_cov_0.982143_g17515_i0 | PRJNA473201 | 18257 | 465 | 0.982143 | 4.56696495 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 308 | 7.519999999999998e-103 | NR | WP_047382551.1 | 2630983 | g17515 | i0 | 100 | 0.993548387096774 | 154 | 0 | 99.4 | 0 | 2 | 463 | 91 | 244 | WP_047382551.1 MULTISPECIES: 3-deoxy-7-phosphoheptulonate synthase [unclassified Cetobacterium] | diamond | 462 | 308 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 26823144 | 26823144 | PRJNA473201_P_NODE_71301_length_248_cov_1.257143_g70559_i0 | PRJNA473201 | 71301 | 248 | 1.257143 | 3.11771464 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 159 | 1.26e-43 | NR | WP_047384178.1 | 2630983 | g70559 | i0 | 97.6 | 0.991935483870968 | 82 | 2 | 99.2 | 0 | 248 | 3 | 409 | 490 | WP_047384178.1 MULTISPECIES: elongation factor G [unclassified Cetobacterium] | diamond | 246 | 159 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 27107587 | 27107587 | PRJNA473201_P_NODE_55882_length_277_cov_1.509804_g55140_i0 | PRJNA473201 | 55882 | 277 | 1.509804 | 4.18215708 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 180 | 3.7e-53 | NR | WP_294095619.1 | 527638 | g55140 | i0 | 100 | 0.985559566787004 | 91 | 0 | 98.6 | 0 | 3 | 275 | 102 | 192 | WP_294095619.1 ROK family protein [uncultured Cetobacterium sp.] | diamond | 273 | 180 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 27138995 | 27138995 | PRJNA473201_P_NODE_58462_length_270_cov_1.563452_g57720_i0 | PRJNA473201 | 58462 | 270 | 1.563452 | 4.2213204 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 134 | 1.35e-38 | NR | WP_047383608.1 | 2630983 | g57720 | i0 | 100 | 0.788888888888889 | 71 | 0 | 78.9 | 0 | 215 | 3 | 1 | 71 | WP_047383608.1 MULTISPECIES: desulfoferrodoxin family protein [unclassified Cetobacterium] | diamond | 213 | 134 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 29507625 | 29507625 | PRJNA473201_P_NODE_40710_length_314_cov_1.261411_g39968_i0 | PRJNA473201 | 40710 | 314 | 1.261411 | 3.96083054 | Cetobacterium sp. 8H | 2759681 | Bacteria | Bacteria | 120 | 5.7e-29 | NR | WP_304488674.1 | 2759681 | g39968 | i0 | 73.9 | 0.878980891719745 | 92 | 24 | 87.9 | 0 | 312 | 37 | 629 | 720 | WP_304488674.1 ATP-dependent zinc metalloprotease FtsH [Cetobacterium sp. 8H] | diamond | 276 | 120 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. 8H | ||
| 30250565 | 30250565 | PRJNA473201_P_NODE_84312_length_241_cov_1.773810_g83570_i0 | PRJNA473201 | 84312 | 241 | 1.77381 | 4.2748821 | Fusobacterium | 848 | Bacteria | Bacteria | 50.8 | 5.03e-5 | NR | WP_032834147.1 | 848 | g83570 | i0 | 52.9 | 1.9045643153527 | 51 | 20 | 58.5 | 2 | 239 | 99 | 1083 | 1133 | WP_032834147.1 MULTISPECIES: hypothetical protein [Fusobacterium] | diamond | 459 | 50.8 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | |||
| 30865987 | 30865987 | PRJNA473201_P_NODE_74834_length_246_cov_2.115607_g74092_i0 | PRJNA473201 | 74834 | 246 | 2.115607 | 5.20439322 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 170 | 6.94e-50 | NR | WP_294093214.1 | 527638 | g74092 | i0 | 98.8 | 0.98780487804878 | 81 | 1 | 98.8 | 0 | 244 | 2 | 205 | 285 | WP_294093214.1 alanine racemase [uncultured Cetobacterium sp.] | diamond | 243 | 170 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 31292996 | 31292996 | PRJNA473201_P_NODE_86075_length_241_cov_0.892857_g85333_i0 | PRJNA473201 | 86075 | 241 | 0.892857 | 2.15178537 | Cetobacterium | 180162 | Bacteria | Bacteria | 156 | 3.71e-45 | NR | MEG0514211.1 | 2071632 | g85333 | i0 | 95 | 1.99170124481328 | 80 | 4 | 99.6 | 0 | 240 | 1 | 100 | 179 | MEG0514211.1 signal recognition particle receptor subunit alpha [Cetobacterium sp.] | diamond | 480 | 157 | 0.993630573248408 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. | ||
| 32495359 | 32495359 | PRJNA473201_P_NODE_70439_length_249_cov_0.875000_g69697_i0 | PRJNA473201 | 70439 | 249 | 0.875 | 2.17875 | Cetobacterium | 180162 | Bacteria | Bacteria | 48.9 | 1.47e-4 | NR | WP_294096023.1 | 527638 | g69697 | i0 | 95.5 | 0.530120481927711 | 22 | 1 | 26.5 | 0 | 2 | 67 | 167 | 188 | WP_294096023.1 RNA-guided endonuclease InsQ/TnpB family protein, partial [uncultured Cetobacterium sp.] | diamond | 132 | 48.9 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 32794075 | 32794075 | PRJNA473201_P_NODE_30000_length_361_cov_1.034722_g29258_i0 | PRJNA473201 | 30000 | 361 | 1.034722 | 3.73534642 | Cetobacterium somerae | 188913 | Bacteria | Bacteria | 142 | 1.82e-36 | NR | WP_281700265.1 | 188913 | g29258 | i0 | 74.2 | 0.997229916897507 | 120 | 31 | 99.7 | 0 | 361 | 2 | 4 | 123 | WP_281700265.1 ATP-dependent zinc metalloprotease FtsH [Cetobacterium somerae] | diamond | 360 | 142 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae |
Advanced export
JSON shape: default, array, newline-delimited
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);;