contig_metadata
12 rows where bioproject = "PRJNA867519", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25074199 | 25074199 | PRJNA867519_P_NODE_24060_length_257_cov_1.673913_g23906_i0 | PRJNA867519 | 24060 | 257 | 1.673913 | 4.30195641 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 105 | 1.09e-24 | NR | MDP6533201.1 | 2026760 | g23906 | i0 | 64 | 3.88715953307393 | 86 | 27 | 99.2 | 2 | 2 | 256 | 67 | 149 | MDP6533201.1 M20 family metallopeptidase [Fidelibacterota bacterium] | diamond | 999 | 105 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 26833737 | 26833737 | PRJNA867519_P_NODE_6981_length_415_cov_2.058480_g6827_i0 | PRJNA867519 | 6981 | 415 | 2.05848 | 8.542692 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 58.2 | 1.03e-6 | NR | MCH7819564.1 | 2026760 | g6827 | i0 | 38.1 | 0.701204819277108 | 97 | 56 | 70.1 | 3 | 122 | 412 | 468 | 560 | MCH7819564.1 PAS domain S-box protein [Fidelibacterota bacterium] | diamond | 291 | 58.2 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 27560478 | 27560478 | PRJNA867519_P_NODE_10144_length_356_cov_2.159011_g9990_i0 | PRJNA867519 | 10144 | 356 | 2.159011 | 7.68607916 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 127 | 2.56e-32 | NR | MDP7028008.1 | 2026760 | g9990 | i0 | 50 | 1.93820224719101 | 112 | 55 | 94.4 | 1 | 355 | 20 | 56 | 166 | MDP7028008.1 M14 family zinc carboxypeptidase [Fidelibacterota bacterium] | diamond | 690 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 27844642 | 27844642 | PRJNA867519_P_NODE_10564_length_351_cov_1.384892_g10410_i0 | PRJNA867519 | 10564 | 351 | 1.384892 | 4.86097092 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 95.1 | 1.9e-20 | NR | MCH7613494.1 | 2026760 | g10410 | i0 | 44 | 3.94017094017094 | 116 | 59 | 98.3 | 4 | 350 | 6 | 56 | 166 | MCH7613494.1 phytase [Fidelibacterota bacterium] | diamond | 1383 | 95.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28223583 | 28223583 | PRJNA867519_P_NODE_346_length_1371_cov_5.325116_g266_i0 | PRJNA867519 | 346 | 1371 | 5.325116 | 73.00734036 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 329 | 7.48e-102 | NR | MDP6685262.1 | 2026760 | g266 | i0 | 45.6 | 7.04157549234136 | 406 | 190 | 84.2 | 13 | 1298 | 144 | 29 | 424 | MDP6685262.1 trypsin-like peptidase domain-containing protein [Fidelibacterota bacterium] | diamond | 9654 | 329 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29865586 | 29865586 | PRJNA867519_P_NODE_23591_length_260_cov_1.016043_g23437_i0 | PRJNA867519 | 23591 | 260 | 1.016043 | 2.6417118 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 66.6 | 1.76e-10 | NR | HIN19706.1 | 2026760 | g23437 | i0 | 48.1 | 5.46923076923077 | 79 | 39 | 88.8 | 2 | 3 | 233 | 369 | 447 | HIN19706.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 1422 | 66.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30086654 | 30086654 | PRJNA867519_P_NODE_22072_length_266_cov_1.595855_g21918_i0 | PRJNA867519 | 22072 | 266 | 1.595855 | 4.2449743 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 81.6 | 9.67e-16 | NR | MCF7805930.1 | 2026760 | g21918 | i0 | 55.8 | 0.868421052631579 | 77 | 32 | 86.8 | 1 | 1 | 231 | 229 | 303 | MCF7805930.1 DUF2235 domain-containing protein [Fidelibacterota bacterium] | diamond | 231 | 81.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30181474 | 30181474 | PRJNA867519_P_NODE_34372_length_228_cov_2.632258_g34218_i0 | PRJNA867519 | 34372 | 228 | 2.632258 | 6.00154824 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 71.6 | 1.48e-12 | NR | MEE9189295.1 | 2026760 | g34218 | i0 | 44.9 | 0.907894736842105 | 69 | 38 | 90.8 | 0 | 228 | 22 | 263 | 331 | MEE9189295.1 inositol 2-dehydrogenase [Fidelibacterota bacterium] | diamond | 207 | 71.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30221135 | 30221135 | PRJNA867519_P_NODE_6532_length_428_cov_1.878873_g6378_i0 | PRJNA867519 | 6532 | 428 | 1.878873 | 8.04157644 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 102 | 3.39e-22 | NR | MBL7059838.1 | 2026760 | g6378 | i0 | 43.4 | 5.72663551401869 | 129 | 72 | 90.4 | 1 | 34 | 420 | 387 | 514 | MBL7059838.1 amidase [Fidelibacterota bacterium] | diamond | 2451 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30560417 | 30560417 | PRJNA867519_P_NODE_15433_length_300_cov_2.801762_g15279_i0 | PRJNA867519 | 15433 | 300 | 2.801762 | 8.405286 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 58.5 | 4.34e-9 | NR | MBC8197104.1 | 2026760 | g15279 | i0 | 52.8 | 0.53 | 53 | 24 | 52 | 1 | 75 | 230 | 3 | 55 | MBC8197104.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 159 | 58.5 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30876631 | 30876631 | PRJNA867519_P_NODE_27894_length_248_cov_0.880000_g27740_i0 | PRJNA867519 | 27894 | 248 | 0.88 | 2.1824 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 112 | 1.62e-28 | NR | NQV30439.1 | 2026760 | g27740 | i0 | 68.3 | 1.98387096774194 | 82 | 26 | 99.2 | 0 | 247 | 2 | 108 | 189 | NQV30439.1 SDR family NAD(P)-dependent oxidoreductase [Fidelibacterota bacterium] | diamond | 492 | 112 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32836234 | 32836234 | PRJNA867519_P_NODE_10400_length_353_cov_1.264286_g10246_i0 | PRJNA867519 | 10400 | 353 | 1.264286 | 4.46292958 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 58.2 | 5.39e-7 | NR | MBH26207.1 | 2026760 | g10246 | i0 | 42.9 | 1.60623229461756 | 63 | 34 | 52.7 | 2 | 45 | 230 | 750 | 811 | MBH26207.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 567 | 58.2 | 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);;