contig_metadata
15 rows where bioproject = "PRJNA379145" and tax_phylum = "Fidelibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11277222 | 11277222 | PRJNA379145_P_NODE_4009_length_1465_cov_27.683659_g3498_i0 | PRJNA379145 | 4009 | 1465 | 27.683659 | 405.56560435 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 350 | 1.1999999999999997e-108 | NR | MBL7053026.1 | 2026760 | g3498 | i0 | 46.1 | 5.5146757679180904 | 393 | 195 | 79.9 | 5 | 1192 | 23 | 69 | 447 | MBL7053026.1 succinylglutamate desuccinylase/aspartoacylase family protein [Fidelibacterota bacterium] | diamond | 8079 | 350 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 27801616 | 27801616 | PRJNA379145_P_NODE_33224_length_373_cov_1.779412_g31083_i0 | PRJNA379145 | 33224 | 373 | 1.779412 | 6.63720676 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 50.4 | 1.2e-5 | NR | MBC21920.1 | 2026760 | g31083 | i0 | 42.6 | 0.434316353887399 | 54 | 29 | 43.4 | 1 | 343 | 182 | 2 | 53 | MBC21920.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 162 | 50.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28117125 | 28117125 | PRJNA379145_P_NODE_4665_length_1375_cov_173.546945_g4085_i0 | PRJNA379145 | 4665 | 1375 | 173.546945 | 2386.27049375 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 326 | 1.4499999999999995e-99 | NR | MBC8197595.1 | 2026760 | g4085 | i0 | 41.5 | 8.27127272727273 | 434 | 231 | 90.5 | 11 | 98 | 1342 | 3 | 432 | MBC8197595.1 trypsin-like peptidase domain-containing protein [Fidelibacterota bacterium] | diamond | 11373 | 326 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28544945 | 28544945 | PRJNA379145_P_NODE_3607_length_1520_cov_6.527909_g3132_i0 | PRJNA379145 | 3607 | 1520 | 6.527909 | 99.2242168 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 429 | 6.219999999999998e-143 | NR | MEC7981332.1 | 2026760 | g3132 | i0 | 50.5 | 17.1078947368421 | 426 | 198 | 83.3 | 5 | 111 | 1376 | 45 | 461 | MEC7981332.1 M28 family metallopeptidase [Fidelibacterota bacterium] | diamond | 26004 | 429 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29222539 | 29222539 | PRJNA379145_P_NODE_55149_length_208_cov_1.714286_g52995_i0 | PRJNA379145 | 55149 | 208 | 1.714286 | 3.56571488 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 42.4 | 0.0304 | NR | HIB58228.1 | 2026760 | g52995 | i0 | 52.6 | 1.09615384615385 | 38 | 18 | 54.8 | 0 | 169 | 56 | 75 | 112 | HIB58228.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 228 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29443085 | 29443085 | PRJNA379145_P_NODE_39110_length_311_cov_1.730216_g36959_i0 | PRJNA379145 | 39110 | 311 | 1.730216 | 5.38097176 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 48.9 | 4.83e-4 | NR | MEA3391950.1 | 2026760 | g36959 | i0 | 37.5 | 1.38906752411576 | 72 | 43 | 69.5 | 2 | 92 | 307 | 102 | 171 | MEA3391950.1 bifunctional methionine sulfoxide reductase B/A protein [Fidelibacterota bacterium] | diamond | 432 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30232864 | 30232864 | PRJNA379145_P_NODE_1032_length_2364_cov_12.607465_g857_i1 | PRJNA379145 | 1032 | 2364 | 12.607465 | 298.0404726 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 108 | 9.06e-20 | NR | MFL3013266.1 | 2026760 | g857 | i1 | 27.6 | 0.515228426395939 | 406 | 255 | 49.1 | 20 | 586 | 1746 | 1361 | 1746 | MFL3013266.1 LamG-like jellyroll fold domain-containing protein [Fidelibacterota bacterium] | diamond | 1218 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30391388 | 30391388 | PRJNA379145_P_NODE_40893_length_295_cov_3.408397_g38742_i0 | PRJNA379145 | 40893 | 295 | 3.408397 | 10.05477115 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 42 | 0.0113 | NR | MCJ7801247.1 | 2026760 | g38742 | i0 | 57.1 | 0.355932203389831 | 35 | 13 | 33.6 | 1 | 250 | 152 | 2 | 36 | MCJ7801247.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 105 | 42 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31197444 | 31197444 | PRJNA379145_P_NODE_73295_length_152_cov_1.504202_g71140_i0 | PRJNA379145 | 73295 | 152 | 1.504202 | 2.28638704 | Bacteria | 2 | Bacteria | Bacteria | 39.7 | 0.0354 | NR | MDP7608240.1 | 2026760 | g71140 | i0 | 33.3 | 1.93421052631579 | 48 | 31 | 94.7 | 1 | 1 | 144 | 26 | 72 | MDP7608240.1 glutathione S-transferase C-terminal domain-containing protein [Fidelibacterota bacterium] | diamond | 294 | 39.7 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31370751 | 31370751 | PRJNA379145_P_NODE_33056_length_375_cov_2.187135_g30915_i0 | PRJNA379145 | 33056 | 375 | 2.187135 | 8.20175625 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 57 | 1.73e-6 | NR | MBH26207.1 | 2026760 | g30915 | i0 | 48.2 | 1.344 | 56 | 27 | 44 | 2 | 370 | 206 | 757 | 811 | MBH26207.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 504 | 57 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31514384 | 31514384 | PRJNA379145_P_NODE_21936_length_553_cov_2.369231_g19999_i0 | PRJNA379145 | 21936 | 553 | 2.369231 | 13.10184743 | root | 1 | Root_unresolved | Root_unresolved | 47.4 | 0.0137 | NR | MBF89262.1 | 2026760 | g19999 | i0 | 31 | 1.4376130198915 | 116 | 65 | 62.9 | 2 | 60 | 407 | 10 | 110 | MBF89262.1 DNA recombination protein RmuC [Fidelibacterota bacterium] | diamond | 795 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32224776 | 32224776 | PRJNA379145_P_NODE_38958_length_312_cov_2.903226_g36807_i0 | PRJNA379145 | 38958 | 312 | 2.903226 | 9.05806512 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 42.4 | 0.00949 | NR | MCJ7801247.1 | 2026760 | g36807 | i0 | 57.1 | 0.336538461538462 | 35 | 13 | 31.7 | 1 | 267 | 169 | 2 | 36 | MCJ7801247.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 105 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32509670 | 32509670 | PRJNA379145_P_NODE_1019_length_2379_cov_10.310315_g857_i0 | PRJNA379145 | 1019 | 2379 | 10.310315 | 245.28239385 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 108 | 7e-20 | NR | MFL3013266.1 | 2026760 | g857 | i0 | 27.6 | 0.511979823455233 | 406 | 255 | 48.8 | 20 | 1794 | 634 | 1361 | 1746 | MFL3013266.1 LamG-like jellyroll fold domain-containing protein [Fidelibacterota bacterium] | diamond | 1218 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32761610 | 32761610 | PRJNA379145_P_NODE_49880_length_234_cov_1.925373_g47726_i0 | PRJNA379145 | 49880 | 234 | 1.925373 | 4.50537282 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 70.1 | 6.97e-12 | NR | UCH10371.1 | 2026760 | g47726 | i0 | 45.8 | 1.74358974358974 | 72 | 35 | 89.7 | 2 | 215 | 6 | 308 | 377 | UCH10371.1 MAG: alkaline phosphatase family protein [Fidelibacterota bacterium] | diamond | 408 | 70.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32856024 | 32856024 | PRJNA379145_P_NODE_60480_length_187_cov_1.636364_g58326_i0 | PRJNA379145 | 60480 | 187 | 1.636364 | 3.06000068 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 73.6 | 1.02e-13 | NR | MCJ7802071.1 | 2026760 | g58326 | i0 | 52.4 | 1.01069518716578 | 63 | 29 | 99.5 | 1 | 2 | 187 | 174 | 236 | MCJ7802071.1 lipase family protein [Fidelibacterota bacterium] | diamond | 189 | 73.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota 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);;