contig_metadata
18 rows where bioproject = "PRJNA1214993", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 330280 | 330280 | PRJNA1214993_P_NODE_20621_length_251_cov_0.876404_g20435_i0 | PRJNA1214993 | 20621 | 251 | 0.876404 | 2.19977404 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 111 | 1.4700000000000002e-27 | NR | MBL7664112.1 | 2081706 | g20435 | i0 | 60.2 | 1.9840637450199201 | 83 | 33 | 99.2 | 0 | 249 | 1 | 194 | 276 | MBL7664112.1 ribose-phosphate pyrophosphokinase [Bacteriovoracaceae bacterium] | diamond | 498 | 111 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 10534264 | 10534264 | PRJNA1214993_P_NODE_7449_length_395_cov_1.860248_g7263_i0 | PRJNA1214993 | 7449 | 395 | 1.860248 | 7.3479796 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 117 | 1.9099999999999997e-30 | NR | MCB0370127.1 | 2053517 | g7263 | i0 | 89.4 | 0.50126582278481 | 66 | 7 | 50.1 | 0 | 198 | 395 | 72 | 137 | MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium] | diamond | 198 | 117 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 11808932 | 11808932 | PRJNA1214993_P_NODE_15910_length_280_cov_1.130435_g15724_i0 | PRJNA1214993 | 15910 | 280 | 1.130435 | 3.165218 | Pseudobdellovibrio exovorus | 453816 | Bacteria | Bacteria | 340 | 4.919999999999999e-89 | NTclustered | gi|469929247|gb|CP003537.1| | 1184267 | g15724 | i0 | 89.362 | 74.8357142857143 | 282 | 15 | 100 | 10 | 1 | 280 | 751599 | 751867 | Bdellovibrio exovorus JSS, complete genome | blastn | 20954 | 340 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 14359325 | 14359325 | PRJNA1214993_P_NODE_19192_length_255_cov_2.313187_g19006_i0 | PRJNA1214993 | 19192 | 255 | 2.313187 | 5.89862685 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 122 | 2.43e-33 | NR | MCB0370127.1 | 2053517 | g19006 | i0 | 90.3 | 0.729411764705882 | 62 | 6 | 72.9 | 0 | 70 | 255 | 33 | 94 | MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium] | diamond | 186 | 122 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 23997489 | 23997489 | PRJNA1214993_P_NODE_15719_length_281_cov_1.500000_g15533_i0 | PRJNA1214993 | 15719 | 281 | 1.5 | 4.215 | Bacteriovorax | 146784 | Bacteria | Bacteria | 520 | 5.909999999999999e-143 | NTclustered | gi|34604519|gb|AY294222.1| | 242936 | g15533 | i0 | 100 | 94.1957295373665 | 281 | 0 | 100 | 0 | 1 | 281 | 306 | 26 | Bacteriovorax sp. EPC3 16S ribosomal RNA gene, partial sequence | blastn | 26469 | 520 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax sp. EPC3 | ||
| 27452116 | 27452116 | PRJNA1214993_P_NODE_6623_length_418_cov_2.113043_g6438_i0 | PRJNA1214993 | 6623 | 418 | 2.113043 | 8.83251974 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 187 | 7.710000000000001e-58 | NR | MCB0368045.1 | 2053517 | g6438 | i0 | 68.1 | 2.92822966507177 | 138 | 44 | 99 | 0 | 418 | 5 | 34 | 171 | MCB0368045.1 EF-hand domain-containing protein [Bdellovibrionales bacterium] | diamond | 1224 | 187 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27736388 | 27736388 | PRJNA1214993_P_NODE_26784_length_223_cov_4.986667_g26598_i0 | PRJNA1214993 | 26784 | 223 | 4.986667 | 11.12026741 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 92 | 1.86e-22 | NR | MCB0369232.1 | 2053517 | g26598 | i0 | 55.7 | 0.94170403587444 | 70 | 28 | 90.1 | 1 | 20 | 220 | 1 | 70 | MCB0369232.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 210 | 92 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27957099 | 27957099 | PRJNA1214993_P_NODE_16845_length_273_cov_1.155000_g16659_i0 | PRJNA1214993 | 16845 | 273 | 1.155 | 3.15315 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 84.7 | 4.82e-19 | NR | MCB0369368.1 | 2053517 | g16659 | i0 | 61.3 | 0.681318681318681 | 62 | 24 | 68.1 | 0 | 191 | 6 | 2 | 63 | MCB0369368.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 186 | 84.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28588716 | 28588716 | PRJNA1214993_P_NODE_11307_length_327_cov_1.842520_g11121_i0 | PRJNA1214993 | 11307 | 327 | 1.84252 | 6.0250404 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 68.6 | 8.74e-13 | NR | MCB0370563.1 | 2053517 | g11121 | i0 | 50.8 | 0.596330275229358 | 65 | 32 | 59.6 | 0 | 318 | 124 | 3 | 67 | MCB0370563.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 195 | 68.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28651697 | 28651697 | PRJNA1214993_P_NODE_23327_length_246_cov_2.109827_g23141_i0 | PRJNA1214993 | 23327 | 246 | 2.109827 | 5.19017442 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 61.6 | 6.53e-10 | NR | MCB0370850.1 | 2053517 | g23141 | i0 | 41.6 | 0.939024390243902 | 77 | 41 | 89 | 1 | 223 | 5 | 7 | 83 | MCB0370850.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 231 | 61.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28702190 | 28702190 | PRJNA1214993_P_NODE_2767_length_633_cov_2.142857_g2589_i0 | PRJNA1214993 | 2767 | 633 | 2.142857 | 13.56428481 | Bacteria | 2 | Bacteria | Bacteria | 47.4 | 0.0288 | NR | MBD65172.1 | 2026745 | g2589 | i0 | 32.8 | 1.45023696682464 | 177 | 84 | 79.6 | 7 | 568 | 65 | 953 | 1103 | MBD65172.1 hypothetical protein [Halobacteriovoraceae bacterium] | diamond | 918 | 47.8 | 0.99163179916318 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovoraceae bacterium | |||
| 29030805 | 29030805 | PRJNA1214993_P_NODE_3728_length_550_cov_1.213836_g3545_i0 | PRJNA1214993 | 3728 | 550 | 1.213836 | 6.676098 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 58.2 | 3.62e-6 | NR | MBC7690966.1 | 2599941 | g3545 | i0 | 37.6 | 0.507272727272727 | 93 | 55 | 50.7 | 1 | 4 | 282 | 1296 | 1385 | MBC7690966.1 choice-of-anchor D domain-containing protein [Oligoflexia bacterium] | diamond | 279 | 58.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 29977825 | 29977825 | PRJNA1214993_P_NODE_22931_length_247_cov_0.896552_g22745_i0 | PRJNA1214993 | 22931 | 247 | 0.896552 | 2.21448344 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 136 | 8.92e-40 | NR | MCB0369089.1 | 2053517 | g22745 | i0 | 76.5 | 0.983805668016194 | 81 | 19 | 98.4 | 0 | 245 | 3 | 18 | 98 | MCB0369089.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 243 | 136 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30135499 | 30135499 | PRJNA1214993_P_NODE_17072_length_271_cov_1.338384_g16886_i0 | PRJNA1214993 | 17072 | 271 | 1.338384 | 3.62702064 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 150 | 2.61e-45 | NR | MCB0370427.1 | 2053517 | g16886 | i0 | 77.8 | 0.996309963099631 | 90 | 20 | 99.6 | 0 | 2 | 271 | 2 | 91 | MCB0370427.1 co-chaperone GroES [Bdellovibrionales bacterium] | diamond | 270 | 150 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30989060 | 30989060 | PRJNA1214993_P_NODE_20874_length_251_cov_0.865169_g20688_i0 | PRJNA1214993 | 20874 | 251 | 0.865169 | 2.17157419 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 68.6 | 1.47e-12 | NR | MCB0370244.1 | 2053517 | g20688 | i0 | 41 | 0.932270916334661 | 78 | 46 | 93.2 | 0 | 248 | 15 | 28 | 105 | MCB0370244.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 234 | 68.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31494925 | 31494925 | PRJNA1214993_P_NODE_7436_length_395_cov_3.621118_g7250_i0 | PRJNA1214993 | 7436 | 395 | 3.621118 | 14.3034161 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 194 | 1.6599999999999998e-60 | NR | MCB0369154.1 | 2053517 | g7250 | i0 | 71.3 | 0.979746835443038 | 129 | 37 | 98 | 0 | 391 | 5 | 1 | 129 | MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium] | diamond | 387 | 194 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32601928 | 32601928 | PRJNA1214993_P_NODE_4840_length_485_cov_1.740291_g4655_i0 | PRJNA1214993 | 4840 | 485 | 1.740291 | 8.44041135 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 167 | 8.6e-50 | NR | MCB0369646.1 | 2053517 | g4655 | i0 | 66.7 | 0.779381443298969 | 126 | 42 | 77.9 | 0 | 392 | 15 | 46 | 171 | MCB0369646.1 50S ribosomal protein L22 [Bdellovibrionales bacterium] | diamond | 378 | 167 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32885120 | 32885120 | PRJNA1214993_P_NODE_11440_length_325_cov_2.492063_g11254_i0 | PRJNA1214993 | 11440 | 325 | 2.492063 | 8.09920475 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 188 | 1.6199999999999995e-55 | NR | MCB0368368.1 | 2053517 | g11254 | i0 | 80.6 | 0.996923076923077 | 108 | 21 | 99.7 | 0 | 2 | 325 | 36 | 143 | MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 324 | 188 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium |
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);;