contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA565584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3106843 | 3106843 | PRJNA565584_P_NODE_192843_length_246_cov_0.890173_g191691_i0 | PRJNA565584 | 192843 | 246 | 0.890173 | 2.18982558 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 166 | 2.0999999999999998e-47 | NR | WP_047383178.1 | 1340502 | g191691 | i0 | 100 | 0.98780487804878 | 81 | 0 | 98.8 | 0 | 245 | 3 | 157 | 237 | WP_047383178.1 amidohydrolase [Cetobacterium sp. ZWU0022] | diamond | 243 | 166 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 4383184 | 4383184 | PRJNA565584_P_NODE_174424_length_250_cov_0.870056_g173272_i0 | PRJNA565584 | 174424 | 250 | 0.870056 | 2.17514 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 163 | 1.81e-47 | NR | WP_294093991.1 | 527638 | g173272 | i0 | 97.6 | 3.936 | 82 | 2 | 98.4 | 0 | 2 | 247 | 98 | 179 | WP_294093991.1 electron transfer flavoprotein subunit alpha/FixB family protein [uncultured Cetobacterium sp.] | diamond | 984 | 163 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 4385345 | 4385345 | PRJNA565584_P_NODE_90484_length_312_cov_1.610879_g89332_i0 | PRJNA565584 | 90484 | 312 | 1.610879 | 5.02594248 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 211 | 8.24e-64 | NR | WP_047382423.1 | 2630983 | g89332 | i0 | 100 | 0.990384615384615 | 103 | 0 | 99 | 0 | 310 | 2 | 85 | 187 | WP_047382423.1 MULTISPECIES: glutathione ABC transporter substrate-binding protein [unclassified Cetobacterium] | diamond | 309 | 211 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 5659520 | 5659520 | PRJNA565584_P_NODE_177845_length_249_cov_0.875000_g176693_i0 | PRJNA565584 | 177845 | 249 | 0.875 | 2.17875 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 166 | 4.29e-49 | NR | WP_047380571.1 | 2630983 | g176693 | i0 | 100 | 1 | 83 | 0 | 100 | 0 | 249 | 1 | 100 | 182 | WP_047380571.1 MULTISPECIES: bifunctional methylenetetrahydrofolate dehydrogenase/methenyltetrahydrofolate cyclohydrolase FolD [unclassified Cetobacterium] | diamond | 249 | 166 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 12036109 | 12036109 | PRJNA565584_P_NODE_45410_length_443_cov_1.586486_g44259_i0 | PRJNA565584 | 45410 | 443 | 1.586486 | 7.02813298 | Cetobacterium | 180162 | Bacteria | Bacteria | 281 | 3.17e-93 | NR | MEG1365337.1 | 2071632 | g44259 | i0 | 96.6 | 1.99097065462754 | 147 | 5 | 99.5 | 0 | 2 | 442 | 8 | 154 | MEG1365337.1 ABC transporter ATP-binding protein [Cetobacterium sp.] | diamond | 882 | 283 | 0.992932862190813 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. | ||
| 22812625 | 22812625 | PRJNA565584_P_NODE_76718_length_339_cov_1.736842_g75567_i0 | PRJNA565584 | 76718 | 339 | 1.736842 | 5.88789438 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 224 | 1.09e-70 | NR | WP_047382551.1 | 2630983 | g75567 | i0 | 99.1 | 1 | 113 | 1 | 100 | 0 | 1 | 339 | 34 | 146 | WP_047382551.1 MULTISPECIES: 3-deoxy-7-phosphoheptulonate synthase [unclassified Cetobacterium] | diamond | 339 | 224 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 26952621 | 26952621 | PRJNA565584_P_NODE_139002_length_269_cov_2.178571_g137850_i0 | PRJNA565584 | 139002 | 269 | 2.178571 | 5.86035599 | Fusobacterium sp. | 68766 | Bacteria | Bacteria | 48.9 | 3.5e-4 | NR | WP_330061876.1 | 68766 | g137850 | i0 | 57.6 | 0.368029739776952 | 33 | 14 | 36.8 | 0 | 252 | 154 | 631 | 663 | WP_330061876.1 SEL1-like repeat protein [Fusobacterium sp.] | diamond | 99 | 48.9 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium sp. | ||
| 27680021 | 27680021 | PRJNA565584_P_NODE_71364_length_352_cov_1.093190_g70213_i0 | PRJNA565584 | 71364 | 352 | 1.09319 | 3.8480288 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 240 | 1.1900000000000001e-77 | NR | WP_294095125.1 | 527638 | g70213 | i0 | 100 | 0.997159090909091 | 117 | 0 | 99.7 | 0 | 351 | 1 | 58 | 174 | WP_294095125.1 Rpn family recombination-promoting nuclease/putative transposase [uncultured Cetobacterium sp.] | diamond | 351 | 240 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 28198296 | 28198296 | PRJNA565584_P_NODE_144706_length_266_cov_0.943005_g143554_i0 | PRJNA565584 | 144706 | 266 | 0.943005 | 2.5083933 | Bacteria | 2 | Bacteria | Bacteria | 48.9 | 2.62e-4 | NR | WP_026737426.1 | 157692 | g143554 | i0 | 31.4 | 1.80451127819549 | 86 | 52 | 97 | 2 | 7 | 264 | 155 | 233 | WP_026737426.1 gamma-glutamyl-gamma-aminobutyrate hydrolase family protein [Pseudoleptotrichia goodfellowii] | diamond | 480 | 49.3 | 0.991886409736308 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Pseudoleptotrichia | Pseudoleptotrichia goodfellowii | ||
| 28974297 | 28974297 | PRJNA565584_P_NODE_186088_length_247_cov_0.885057_g184936_i0 | PRJNA565584 | 186088 | 247 | 0.885057 | 2.18609079 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 157 | 2.37e-46 | NR | WP_047382053.1 | 2630983 | g184936 | i0 | 100 | 0.898785425101215 | 74 | 0 | 89.9 | 0 | 2 | 223 | 140 | 213 | WP_047382053.1 MULTISPECIES: flavodoxin family protein [unclassified Cetobacterium] | diamond | 222 | 157 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 29037516 | 29037516 | PRJNA565584_P_NODE_147268_length_264_cov_1.450262_g146116_i0 | PRJNA565584 | 147268 | 264 | 1.450262 | 3.82869168 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 134 | 2.06e-34 | NR | WP_294094599.1 | 527638 | g146116 | i0 | 91.8 | 0.965909090909091 | 85 | 7 | 96.6 | 0 | 256 | 2 | 1 | 85 | WP_294094599.1 ribonuclease J [uncultured Cetobacterium sp.] | diamond | 255 | 134 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 29163833 | 29163833 | PRJNA565584_P_NODE_158789_length_256_cov_2.245902_g157637_i0 | PRJNA565584 | 158789 | 256 | 2.245902 | 5.74950912 | Propionigenium maris | 45622 | Bacteria | Bacteria | 167 | 2.01e-47 | NR | WP_281833469.1 | 45622 | g157637 | i0 | 98.8 | 0.99609375 | 85 | 1 | 99.6 | 0 | 2 | 256 | 181 | 265 | WP_281833469.1 sodium-dependent transporter [Propionigenium maris] | diamond | 255 | 167 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Propionigenium | Propionigenium maris | ||
| 29921551 | 29921551 | PRJNA565584_P_NODE_117391_length_283_cov_1.980952_g116239_i0 | PRJNA565584 | 117391 | 283 | 1.980952 | 5.60609416 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 171 | 6e-51 | NR | WP_052191600.1 | 1340502 | g116239 | i0 | 92.6 | 0.996466431095406 | 94 | 7 | 99.6 | 0 | 2 | 283 | 28 | 121 | WP_052191600.1 RluA family pseudouridine synthase [Cetobacterium sp. ZWU0022] | diamond | 282 | 171 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 30016298 | 30016298 | PRJNA565584_P_NODE_180011_length_248_cov_2.291429_g178859_i0 | PRJNA565584 | 180011 | 248 | 2.291429 | 5.68274392 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 160 | 1.97e-43 | NR | WP_047384907.1 | 1340502 | g178859 | i0 | 100 | 0.991935483870968 | 82 | 0 | 99.2 | 0 | 247 | 2 | 662 | 743 | WP_047384907.1 hypothetical protein [Cetobacterium sp. ZWU0022] | diamond | 246 | 160 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 30142155 | 30142155 | PRJNA565584_P_NODE_133632_length_273_cov_1.460000_g132480_i0 | PRJNA565584 | 133632 | 273 | 1.46 | 3.9858 | Cetobacterium sp. ZOR | 2071632 | Bacteria | Bacteria | 176 | 4.91e-52 | NR | WP_047393843.1 | 1339239 | g132480 | i0 | 100 | 0.989010989010989 | 90 | 0 | 98.9 | 0 | 2 | 271 | 223 | 312 | WP_047393843.1 SEC-C metal-binding domain-containing protein [Cetobacterium sp. ZOR0034] | diamond | 270 | 176 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZOR0034 | ||
| 30156013 | 30156013 | PRJNA565584_P_NODE_60852_length_381_cov_1.129870_g59701_i0 | PRJNA565584 | 60852 | 381 | 1.12987 | 4.3048047 | Cetobacterium | 180162 | Bacteria | Bacteria | 45.4 | 0.0197 | NR | WP_291941244.1 | 2071632 | g59701 | i0 | 42.3 | 1.11811023622047 | 52 | 29 | 40.2 | 1 | 174 | 22 | 864 | 915 | WP_291941244.1 autotransporter outer membrane beta-barrel domain-containing protein [Cetobacterium sp.] | diamond | 426 | 45.8 | 0.991266375545852 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. | ||
| 30395717 | 30395717 | PRJNA565584_P_NODE_138673_length_270_cov_0.893401_g137521_i0 | PRJNA565584 | 138673 | 270 | 0.893401 | 2.4121827 | Cetobacterium sp. ZOR | 2071632 | Bacteria | Bacteria | 177 | 4.11e-53 | NR | WP_047394886.1 | 1339239 | g137521 | i0 | 100 | 0.988888888888889 | 89 | 0 | 98.9 | 0 | 3 | 269 | 12 | 100 | WP_047394886.1 AAA family ATPase, partial [Cetobacterium sp. ZOR0034] | diamond | 267 | 177 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZOR0034 | ||
| 30774676 | 30774676 | PRJNA565584_P_NODE_222514_length_226_cov_2.176471_g221362_i0 | PRJNA565584 | 222514 | 226 | 2.176471 | 4.91882446 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 48.5 | 2.68e-4 | NR | WP_047383591.1 | 1340502 | g221362 | i0 | 44.4 | 1.18141592920354 | 45 | 25 | 59.7 | 0 | 91 | 225 | 4 | 48 | WP_047383591.1 glycosyltransferase [Cetobacterium sp. ZWU0022] | diamond | 267 | 48.5 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 31184902 | 31184902 | PRJNA565584_P_NODE_138075_length_270_cov_1.558376_g136923_i0 | PRJNA565584 | 138075 | 270 | 1.558376 | 4.2076152 | Cetobacterium | 180162 | Bacteria | Bacteria | 115 | 5.53e-32 | NR | WP_291941138.1 | 180162 | g136923 | i0 | 90.2 | 0.566666666666667 | 51 | 5 | 56.7 | 0 | 155 | 3 | 1 | 51 | WP_291941138.1 MULTISPECIES: rubredoxin [Cetobacterium] | diamond | 153 | 115 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 31280023 | 31280023 | PRJNA565584_P_NODE_205695_length_243_cov_0.905882_g204543_i0 | PRJNA565584 | 205695 | 243 | 0.905882 | 2.20129326 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 163 | 3.75e-46 | NR | WP_047384609.1 | 1340502 | g204543 | i0 | 100 | 1 | 81 | 0 | 100 | 0 | 243 | 1 | 249 | 329 | WP_047384609.1 UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--2,6-diaminopimelate ligase [Cetobacterium sp. ZWU0022] | diamond | 243 | 163 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 31483791 | 31483791 | PRJNA565584_P_NODE_208976_length_242_cov_0.911243_g207824_i0 | PRJNA565584 | 208976 | 242 | 0.911243 | 2.20520806 | Cetobacterium | 180162 | Bacteria | Bacteria | 150 | 1.89e-40 | NR | WP_297406435.1 | 527638 | g207824 | i0 | 100 | 1.98347107438017 | 80 | 0 | 99.2 | 0 | 240 | 1 | 243 | 322 | WP_297406435.1 GTPase HflX [uncultured Cetobacterium sp.] | diamond | 480 | 150 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 31785937 | 31785937 | PRJNA565584_P_NODE_157557_length_257_cov_1.673913_g156405_i0 | PRJNA565584 | 157557 | 257 | 1.673913 | 4.30195641 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 137 | 2.88e-40 | NR | WP_294095922.1 | 527638 | g156405 | i0 | 97.4 | 0.88715953307393 | 76 | 2 | 88.7 | 0 | 228 | 1 | 1 | 76 | WP_294095922.1 hypothetical protein [uncultured Cetobacterium sp.] | diamond | 228 | 137 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 32229287 | 32229287 | PRJNA565584_P_NODE_171538_length_250_cov_1.435028_g170386_i0 | PRJNA565584 | 171538 | 250 | 1.435028 | 3.58757 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 156 | 6.7599999999999985e-47 | NR | WP_047382959.1 | 1340502 | g170386 | i0 | 95.2 | 0.996 | 83 | 4 | 99.6 | 0 | 249 | 1 | 51 | 133 | WP_047382959.1 Dps family protein [Cetobacterium sp. ZWU0022] | diamond | 249 | 156 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 32514098 | 32514098 | PRJNA565584_P_NODE_119879_length_282_cov_1.191388_g118727_i0 | PRJNA565584 | 119879 | 282 | 1.191388 | 3.35971416 | Cetobacterium sp. NK | 2071632 | Bacteria | Bacteria | 179 | 2.02e-56 | NR | WP_256690022.1 | 2993530 | g118727 | i0 | 89.2 | 0.98936170212766 | 93 | 10 | 98.9 | 0 | 280 | 2 | 13 | 105 | WP_256690022.1 cell division protein SepF [Cetobacterium sp. NK01] | diamond | 279 | 179 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. NK01 |
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);;