contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax_phylum = "Chloroflexota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26895635 | 26895635 | PRJNA784298_P_NODE_16641_length_304_cov_1.822511_g16440_i0 | PRJNA784298 | 16641 | 304 | 1.822511 | 5.54043344 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 112 | 2.29e-29 | NR | HEY1014436.1 | 2720503 | g16440 | i0 | 51 | 0.947368421052632 | 96 | 47 | 94.7 | 0 | 13 | 300 | 3 | 98 | HEY1014436.1 YiaA/YiaB family inner membrane protein [Herpetosiphonaceae bacterium] | diamond | 288 | 112 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 27685786 | 27685786 | PRJNA784298_P_NODE_1984_length_905_cov_3.185096_g1814_i0 | PRJNA784298 | 1984 | 905 | 3.185096 | 28.8251188 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 57.8 | 5.55e-6 | NR | HEY5983886.1 | 2073117 | g1814 | i0 | 45.5 | 0.434254143646409 | 66 | 34 | 21.2 | 1 | 195 | 4 | 3 | 68 | HEY5983886.1 DUF333 domain-containing protein [Anaerolineales bacterium] | diamond | 393 | 57.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28317021 | 28317021 | PRJNA784298_P_NODE_6926_length_481_cov_1.686275_g6725_i0 | PRJNA784298 | 6926 | 481 | 1.686275 | 8.11098275 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 70.9 | 5.39e-11 | NR | MFA7407642.1 | 2024896 | g6725 | i0 | 31.2 | 0.879417879417879 | 141 | 95 | 87.3 | 2 | 49 | 468 | 2 | 141 | MFA7407642.1 glycosyltransferase [Anaerolineaceae bacterium] | diamond | 423 | 70.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 28601224 | 28601224 | PRJNA784298_P_NODE_16947_length_301_cov_1.842105_g16746_i0 | PRJNA784298 | 16947 | 301 | 1.842105 | 5.54473605 | Anaerolineales bacterium HSG25 | 3055601 | Bacteria | Bacteria | 70.5 | 1.36e-11 | NR | MDM8531619.1 | 3055601 | g16746 | i0 | 42.9 | 0.767441860465116 | 77 | 44 | 76.7 | 0 | 69 | 299 | 88 | 164 | MDM8531619.1 hypothetical protein [Anaerolineales bacterium HSG25] | diamond | 231 | 70.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium HSG25 | ||||
| 28758924 | 28758924 | PRJNA784298_P_NODE_6107_length_512_cov_1.908884_g5907_i0 | PRJNA784298 | 6107 | 512 | 1.908884 | 9.77348608 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 65.1 | 9.02e-9 | NR | MDE3095945.1 | 2026724 | g5907 | i0 | 44.6 | 0.5390625 | 92 | 40 | 51 | 3 | 465 | 205 | 82 | 167 | MDE3095945.1 chromosome condensation regulator RCC1 [Chloroflexota bacterium] | diamond | 276 | 65.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29778566 | 29778566 | PRJNA784298_P_NODE_5731_length_529_cov_2.072368_g5532_i0 | PRJNA784298 | 5731 | 529 | 2.072368 | 10.96282672 | Bacteria | 2 | Bacteria | Bacteria | 146 | 3.8399999999999997e-38 | NR | MBM25467.1 | 2026724 | g5532 | i0 | 53.5 | 8.80151228733459 | 142 | 66 | 80.5 | 0 | 426 | 1 | 2 | 143 | MBM25467.1 dihydrolipoyl dehydrogenase [Chloroflexota bacterium] | diamond | 4656 | 147 | 0.993197278911565 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29958848 | 29958848 | PRJNA784298_P_NODE_4331_length_612_cov_3.270872_g4134_i0 | PRJNA784298 | 4331 | 612 | 3.270872 | 20.01773664 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 135 | 1.4e-35 | NR | MEA3309225.1 | 2026724 | g4134 | i0 | 63.1 | 0.504901960784314 | 103 | 35 | 49 | 2 | 612 | 313 | 134 | 236 | MEA3309225.1 hypothetical protein [Chloroflexota bacterium] | diamond | 309 | 135 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30211428 | 30211428 | PRJNA784298_P_NODE_19152_length_282_cov_6.574163_g18951_i0 | PRJNA784298 | 19152 | 282 | 6.574163 | 18.53913966 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 63.5 | 1.2e-9 | NR | HEX9615926.1 | 2073117 | g18951 | i0 | 42.9 | 0.74468085106383 | 70 | 40 | 74.5 | 0 | 258 | 49 | 4 | 73 | HEX9615926.1 hypothetical protein [Anaerolineales bacterium] | diamond | 210 | 63.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 30306914 | 30306914 | PRJNA784298_P_NODE_3532_length_679_cov_2.767327_g3339_i0 | PRJNA784298 | 3532 | 679 | 2.767327 | 18.79015033 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 82.4 | 5.35e-16 | NR | MBP7692612.1 | 2073117 | g3339 | i0 | 38.7 | 2.04565537555228 | 155 | 66 | 67.2 | 5 | 106 | 561 | 3 | 131 | MBP7692612.1 NUDIX domain-containing protein [Anaerolineales bacterium] | diamond | 1389 | 82.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 30338429 | 30338429 | PRJNA784298_P_NODE_13272_length_343_cov_1.133333_g13071_i0 | PRJNA784298 | 13272 | 343 | 1.133333 | 3.88733219 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 67.8 | 4.06e-11 | NR | NDJ34543.1 | 2026724 | g13071 | i0 | 48.5 | 3.59475218658892 | 68 | 35 | 59.5 | 0 | 2 | 205 | 134 | 201 | NDJ34543.1 hypothetical protein [Chloroflexota bacterium] | diamond | 1233 | 67.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30590696 | 30590696 | PRJNA784298_P_NODE_7873_length_449_cov_1.595745_g7672_i0 | PRJNA784298 | 7873 | 449 | 1.595745 | 7.16489505 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 45.4 | 0.00722 | NR | MCL4370469.1 | 2026724 | g7672 | i0 | 43.5 | 0.307349665924276 | 46 | 26 | 30.7 | 0 | 284 | 421 | 66 | 111 | MCL4370469.1 flagellar protein FlaG [Chloroflexota bacterium] | diamond | 138 | 45.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30970056 | 30970056 | PRJNA784298_P_NODE_4494_length_600_cov_2.111954_g4297_i0 | PRJNA784298 | 4494 | 600 | 2.111954 | 12.671724 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 120 | 9.52e-28 | NR | MFA5366580.1 | 2026734 | g4297 | i0 | 37.6 | 0.905 | 181 | 106 | 90.5 | 1 | 578 | 36 | 560 | 733 | MFA5366580.1 vWA domain-containing protein [Dehalococcoidia bacterium] | diamond | 543 | 120 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 32013494 | 32013494 | PRJNA784298_P_NODE_26678_length_241_cov_2.071429_g26477_i0 | PRJNA784298 | 26678 | 241 | 2.071429 | 4.99214389 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 59.3 | 1.3e-8 | NR | MFA7408284.1 | 2024896 | g26477 | i0 | 36.7 | 2.00414937759336 | 79 | 50 | 98.3 | 0 | 238 | 2 | 5 | 83 | MFA7408284.1 ATP-binding protein [Anaerolineaceae bacterium] | diamond | 483 | 59.3 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae 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);;