contig_metadata
24 rows where bioproject = "PRJNA719595" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3260810 | 3260810 | PRJNA719595_P_NODE_9183_length_243_cov_0.917647_g9148_i0 | PRJNA719595 | 9183 | 243 | 0.917647 | 2.22988221 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 164 | 1.0099999999999999e-46 | NR | HEY9420521.1 | 2651171 | g9148 | i0 | 96.3 | 2.95061728395062 | 80 | 3 | 98.8 | 0 | 241 | 2 | 203 | 282 | HEY9420521.1 molybdopterin cofactor-binding domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 717 | 164 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 4537846 | 4537846 | PRJNA719595_P_NODE_6524_length_253_cov_0.866667_g6489_i0 | PRJNA719595 | 6524 | 253 | 0.866667 | 2.19266751 | Bacteria | 2 | Bacteria | Bacteria | 171 | 2.0599999999999995e-47 | NR | MCC7243071.1 | 1978231 | g6489 | i0 | 90.4 | 21.7944664031621 | 83 | 8 | 98.4 | 0 | 5 | 253 | 17 | 99 | MCC7243071.1 leucine--tRNA ligase [Acidobacteriota bacterium] | diamond | 5514 | 172 | 0.994186046511628 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 4537874 | 4537874 | PRJNA719595_P_NODE_7804_length_248_cov_0.891429_g7769_i0 | PRJNA719595 | 7804 | 248 | 0.891429 | 2.21074392 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 149 | 3.51e-42 | NR | HZH92031.1 | 2283092 | g7769 | i0 | 90.2 | 0.991935483870968 | 82 | 8 | 99.2 | 0 | 1 | 246 | 55 | 136 | HZH92031.1 ABC transporter permease [Pyrinomonadaceae bacterium] | diamond | 246 | 149 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 24144929 | 24144929 | PRJNA719595_P_NODE_4679_length_294_cov_1.022624_g4644_i0 | PRJNA719595 | 4679 | 294 | 1.022624 | 3.00651456 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 117 | 5.729999999999999e-28 | NR | HSK79934.1 | 2651171 | g4644 | i0 | 57.1 | 9.01020408163265 | 98 | 42 | 100 | 0 | 294 | 1 | 927 | 1024 | HSK79934.1 amino acid adenylation domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 2649 | 117 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 26904402 | 26904402 | PRJNA719595_P_NODE_6861_length_252_cov_0.871508_g6826_i0 | PRJNA719595 | 6861 | 252 | 0.871508 | 2.19620016 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 144 | 3.82e-39 | NR | MDX2154290.1 | 2212468 | g6826 | i0 | 81.7 | 3.9047619047619 | 82 | 15 | 97.6 | 0 | 250 | 5 | 285 | 366 | MDX2154290.1 glycosyltransferase [Bryobacteraceae bacterium] | diamond | 984 | 145 | 0.993103448275862 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 27399850 | 27399850 | PRJNA719595_P_NODE_8623_length_245_cov_0.906977_g8588_i0 | PRJNA719595 | 8623 | 245 | 0.906977 | 2.22209365 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 42.7 | 0.0352 | NR | HEX4310408.1 | 2052142 | g8588 | i0 | 41.4 | 0.857142857142857 | 70 | 34 | 84.5 | 2 | 219 | 13 | 138 | 201 | HEX4310408.1 ABC transporter permease [Acidobacteriaceae bacterium] | diamond | 210 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 27442038 | 27442038 | PRJNA719595_P_NODE_7123_length_251_cov_0.876404_g7088_i0 | PRJNA719595 | 7123 | 251 | 0.876404 | 2.19977404 | Bacteria | 2 | Bacteria | Bacteria | 150 | 6.659999999999999e-40 | NR | MCA1623910.1 | 1978231 | g7088 | i0 | 92.8 | 1.9840637450199201 | 83 | 6 | 99.2 | 0 | 1 | 249 | 646 | 728 | MCA1623910.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 498 | 150 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29209998 | 29209998 | PRJNA719595_P_NODE_8529_length_246_cov_0.901734_g8494_i0 | PRJNA719595 | 8529 | 246 | 0.901734 | 2.21826564 | Bacteria | 2 | Bacteria | Bacteria | 156 | 2.57e-45 | NR | MCA1631309.1 | 1978231 | g8494 | i0 | 96.3 | 76.0609756097561 | 81 | 3 | 98.8 | 0 | 2 | 244 | 137 | 217 | MCA1631309.1 signal recognition particle-docking protein FtsY [Acidobacteriota bacterium] | diamond | 18711 | 157 | 0.993630573248408 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29609545 | 29609545 | PRJNA719595_P_NODE_9090_length_243_cov_0.917647_g9055_i0 | PRJNA719595 | 9090 | 243 | 0.917647 | 2.22988221 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 57 | 3.31e-7 | NR | MBD0326210.1 | 2283092 | g9055 | i0 | 84.4 | 1.18518518518519 | 32 | 5 | 39.5 | 0 | 242 | 147 | 357 | 388 | MBD0326210.1 threonine synthase [Pyrinomonadaceae bacterium] | diamond | 288 | 57 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30178333 | 30178333 | PRJNA719595_P_NODE_8132_length_247_cov_0.896552_g8097_i0 | PRJNA719595 | 8132 | 247 | 0.896552 | 2.21448344 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 153 | 2.470000000000001e-44 | NR | HEX7175471.1 | 2283092 | g8097 | i0 | 90.2 | 0.995951417004049 | 82 | 8 | 99.6 | 0 | 246 | 1 | 114 | 195 | HEX7175471.1 arginine deiminase family protein [Pyrinomonadaceae bacterium] | diamond | 246 | 153 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30400044 | 30400044 | PRJNA719595_P_NODE_7353_length_250_cov_0.881356_g7318_i0 | PRJNA719595 | 7353 | 250 | 0.881356 | 2.20339 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 116 | 2.05e-28 | NR | HWT03022.1 | 2283092 | g7318 | i0 | 70 | 0.96 | 80 | 24 | 96 | 0 | 2 | 241 | 192 | 271 | HWT03022.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 240 | 116 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30431614 | 30431614 | PRJNA719595_P_NODE_6433_length_253_cov_0.866667_g6398_i0 | PRJNA719595 | 6433 | 253 | 0.866667 | 2.19266751 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 146 | 4.49e-40 | NR | MDQ2746489.1 | 1978231 | g6398 | i0 | 84.5 | 2.98814229249012 | 84 | 13 | 99.6 | 0 | 253 | 2 | 61 | 144 | MDQ2746489.1 HD domain-containing protein [Acidobacteriota bacterium] | diamond | 756 | 146 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30431616 | 30431616 | PRJNA719595_P_NODE_7373_length_250_cov_0.881356_g7338_i0 | PRJNA719595 | 7373 | 250 | 0.881356 | 2.20339 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 126 | 6.549999999999999e-32 | NR | HEV2915134.1 | 2283092 | g7338 | i0 | 74.7 | 2.988 | 83 | 21 | 99.6 | 0 | 2 | 250 | 332 | 414 | HEV2915134.1 ATP-binding cassette domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 747 | 126 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30620669 | 30620669 | PRJNA719595_P_NODE_8173_length_247_cov_0.896552_g8138_i0 | PRJNA719595 | 8173 | 247 | 0.896552 | 2.21448344 | Terracidiphilus sp. | 1964191 | Bacteria | Bacteria | 145 | 4.92e-39 | NR | HEX8812537.1 | 1964191 | g8138 | i0 | 80.2 | 0.983805668016194 | 81 | 16 | 98.4 | 0 | 4 | 246 | 167 | 247 | HEX8812537.1 hypothetical protein [Terracidiphilus sp.] | diamond | 243 | 145 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 30620671 | 30620671 | PRJNA719595_P_NODE_9213_length_243_cov_0.917647_g9178_i0 | PRJNA719595 | 9213 | 243 | 0.917647 | 2.22988221 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 154 | 2.2e-43 | NR | HYO79772.1 | 2212468 | g9178 | i0 | 92.5 | 0.987654320987654 | 80 | 6 | 98.8 | 0 | 241 | 2 | 288 | 367 | HYO79772.1 ATP-binding protein [Bryobacteraceae bacterium] | diamond | 240 | 154 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30652174 | 30652174 | PRJNA719595_P_NODE_9473_length_242_cov_0.923077_g9438_i0 | PRJNA719595 | 9473 | 242 | 0.923077 | 2.23384634 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 109 | 2.02e-26 | NR | HYU80745.1 | 2910147 | g9438 | i0 | 68.4 | 1.95867768595041 | 79 | 25 | 97.9 | 0 | 6 | 242 | 168 | 246 | HYU80745.1 serine hydrolase domain-containing protein [Vicinamibacterales bacterium] | diamond | 474 | 109 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 30842019 | 30842019 | PRJNA719595_P_NODE_8354_length_246_cov_0.901734_g8319_i0 | PRJNA719595 | 8354 | 246 | 0.901734 | 2.21826564 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 112 | 2.75e-28 | NR | MEX1128915.1 | 2910147 | g8319 | i0 | 63.8 | 0.975609756097561 | 80 | 29 | 97.6 | 0 | 246 | 7 | 100 | 179 | MEX1128915.1 SCO family protein [Vicinamibacterales bacterium] | diamond | 240 | 112 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 31421350 | 31421350 | PRJNA719595_P_NODE_7316_length_250_cov_0.881356_g7281_i0 | PRJNA719595 | 7316 | 250 | 0.881356 | 2.20339 | Bacteria | 2 | Bacteria | Bacteria | 128 | 2.58e-34 | NR | MBW8826653.1 | 1978231 | g7281 | i0 | 75.9 | 1.992 | 83 | 20 | 99.6 | 0 | 1 | 249 | 173 | 255 | MBW8826653.1 tetratricopeptide repeat protein [Acidobacteriota bacterium] | diamond | 498 | 128 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31569276 | 31569276 | PRJNA719595_P_NODE_6556_length_253_cov_0.866667_g6521_i0 | PRJNA719595 | 6556 | 253 | 0.866667 | 2.19266751 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 55.8 | 9.51e-7 | NR | MEX2299861.1 | 2026791 | g6521 | i0 | 80.8 | 0.308300395256917 | 26 | 5 | 30.8 | 0 | 3 | 80 | 352 | 377 | MEX2299861.1 metallophosphoesterase [Bryobacterales bacterium] | diamond | 78 | 55.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 32328651 | 32328651 | PRJNA719595_P_NODE_7099_length_251_cov_0.876404_g7064_i0 | PRJNA719595 | 7099 | 251 | 0.876404 | 2.19977404 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 123 | 1.92e-33 | NR | MBA2304462.1 | 1978231 | g7064 | i0 | 72.3 | 0.99203187250996006 | 83 | 23 | 99.2 | 0 | 2 | 250 | 12 | 94 | MBA2304462.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 249 | 123 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32360221 | 32360221 | PRJNA719595_P_NODE_6879_length_252_cov_0.871508_g6844_i0 | PRJNA719595 | 6879 | 252 | 0.871508 | 2.19620016 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 55.1 | 4.34e-8 | NR | HSY47206.1 | 2651171 | g6844 | i0 | 53.7 | 0.488095238095238 | 41 | 19 | 48.8 | 0 | 193 | 71 | 3 | 43 | HSY47206.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 123 | 55.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 32644032 | 32644032 | PRJNA719595_P_NODE_9140_length_243_cov_0.917647_g9105_i0 | PRJNA719595 | 9140 | 243 | 0.917647 | 2.22988221 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 71.2 | 1.72e-12 | NR | MCC6992530.1 | 1978231 | g9105 | i0 | 54 | 0.777777777777778 | 63 | 29 | 77.8 | 0 | 242 | 54 | 226 | 288 | MCC6992530.1 CpsD/CapB family tyrosine-protein kinase [Acidobacteriota bacterium] | diamond | 189 | 71.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32833221 | 32833221 | PRJNA719595_P_NODE_6240_length_256_cov_1.327869_g6205_i0 | PRJNA719595 | 6240 | 256 | 1.327869 | 3.39934464 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 42.7 | 0.0436 | NR | HXY51432.1 | 2282142 | g6205 | i0 | 53.1 | 0.375 | 32 | 15 | 37.5 | 0 | 88 | 183 | 228 | 259 | HXY51432.1 cellulose synthase family protein [Terriglobales bacterium] | diamond | 96 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 32864700 | 32864700 | PRJNA719595_P_NODE_6480_length_253_cov_0.866667_g6445_i0 | PRJNA719595 | 6480 | 253 | 0.866667 | 2.19266751 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 165 | 2.7399999999999997e-47 | NR | HEY0656973.1 | 2283092 | g6445 | i0 | 91.6 | 3.93675889328063 | 83 | 7 | 98.4 | 0 | 3 | 251 | 181 | 263 | HEY0656973.1 M28 family metallopeptidase [Pyrinomonadaceae bacterium] | diamond | 996 | 165 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae 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);;