contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA1137393" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 284718 | 284718 | PRJNA1137393_P_NODE_40761_length_169_cov_0.866667_g40245_i0 | PRJNA1137393 | 40761 | 169 | 0.866667 | 1.46466723 | Bacteria | 2 | Bacteria | Bacteria | 97.8 | 4.47e-22 | NR | MBI5668569.1 | 2026724 | g40245 | i0 | 75 | 4.91715976331361 | 56 | 14 | 99.4 | 0 | 1 | 168 | 193 | 248 | MBI5668569.1 DUF1800 domain-containing protein [Chloroflexota bacterium] | diamond | 831 | 97.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 2835527 | 2835527 | PRJNA1137393_P_NODE_68723_length_163_cov_0.912281_g68207_i0 | PRJNA1137393 | 68723 | 163 | 0.912281 | 1.48701803 | Roseiflexaceae bacterium | 2762507 | Bacteria | Bacteria | 69.7 | 2.69e-12 | NR | HEU5103483.1 | 2762507 | g68207 | i0 | 67.9 | 1.95092024539877 | 53 | 17 | 97.5 | 0 | 3 | 161 | 152 | 204 | HEU5103483.1 AraC family transcriptional regulator [Roseiflexaceae bacterium] | diamond | 318 | 69.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 21961545 | 21961545 | PRJNA1137393_P_NODE_49258_length_167_cov_0.881356_g48742_i0 | PRJNA1137393 | 49258 | 167 | 0.881356 | 1.47186452 | Bacteria | 2 | Bacteria | Bacteria | 82.8 | 9.5e-17 | NR | MBA3687949.1 | 2026724 | g48742 | i0 | 83.6 | 2.96407185628743 | 55 | 9 | 98.8 | 0 | 1 | 165 | 376 | 430 | MBA3687949.1 phospholipid carrier-dependent glycosyltransferase [Chloroflexota bacterium] | diamond | 495 | 83.6 | 0.990430622009569 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26627208 | 26627208 | PRJNA1137393_P_NODE_70141_length_162_cov_0.920354_g69625_i0 | PRJNA1137393 | 70141 | 162 | 0.920354 | 1.49097348 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 81.6 | 2.25e-16 | NR | MEM7533421.1 | 2026724 | g69625 | i0 | 69.6 | 1.98148148148148 | 56 | 13 | 96.3 | 1 | 3 | 158 | 59 | 114 | MEM7533421.1 FAD-dependent oxidoreductase [Chloroflexota bacterium] | diamond | 321 | 81.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26880720 | 26880720 | PRJNA1137393_P_NODE_53081_length_166_cov_0.888889_g52565_i0 | PRJNA1137393 | 53081 | 166 | 0.888889 | 1.47555574 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 69.3 | 5.59e-12 | NR | MFL5778763.1 | 2026724 | g52565 | i0 | 70.4 | 0.975903614457831 | 54 | 16 | 97.6 | 0 | 163 | 2 | 853 | 906 | MFL5778763.1 AAA family ATPase [Chloroflexota bacterium] | diamond | 162 | 69.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27101906 | 27101906 | PRJNA1137393_P_NODE_68322_length_163_cov_0.912281_g67806_i0 | PRJNA1137393 | 68322 | 163 | 0.912281 | 1.48701803 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 103 | 9.6e-25 | NR | HKF86059.1 | 2952938 | g67806 | i0 | 92.6 | 0.993865030674847 | 54 | 4 | 99.4 | 0 | 1 | 162 | 308 | 361 | HKF86059.1 cell division FtsA domain-containing protein [Candidatus Limnocylindrales bacterium] | diamond | 162 | 103 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 27291696 | 27291696 | PRJNA1137393_P_NODE_62783_length_164_cov_0.904348_g62267_i0 | PRJNA1137393 | 62783 | 164 | 0.904348 | 1.48313072 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 54.7 | 7.7e-7 | NR | MCE1252931.1 | 2052143 | g62267 | i0 | 55.6 | 0.98780487804878 | 54 | 24 | 98.8 | 0 | 162 | 1 | 420 | 473 | MCE1252931.1 hypothetical protein [Anaerolineae bacterium] | diamond | 162 | 54.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28175643 | 28175643 | PRJNA1137393_P_NODE_73226_length_162_cov_0.920354_g72710_i0 | PRJNA1137393 | 73226 | 162 | 0.920354 | 1.49097348 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 80.5 | 5.77e-17 | NR | MEA2611352.1 | 2026724 | g72710 | i0 | 75.5 | 2.94444444444444 | 53 | 13 | 98.1 | 0 | 2 | 160 | 154 | 206 | MEA2611352.1 2-phospho-L-lactate/phosphoenolpyruvate guanylyltransferase [Chloroflexota bacterium] | diamond | 477 | 80.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28333652 | 28333652 | PRJNA1137393_P_NODE_31566_length_179_cov_1.330769_g31050_i0 | PRJNA1137393 | 31566 | 179 | 1.330769 | 2.38207651 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 109 | 3.67e-26 | NR | MEP7293101.1 | 2026724 | g31050 | i0 | 88.1 | 0.988826815642458 | 59 | 7 | 98.9 | 0 | 1 | 177 | 249 | 307 | MEP7293101.1 exonuclease domain-containing protein [Chloroflexota bacterium] | diamond | 177 | 109 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28365079 | 28365079 | PRJNA1137393_P_NODE_30566_length_180_cov_2.335878_g30050_i0 | PRJNA1137393 | 30566 | 180 | 2.335878 | 4.2045804 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 91.3 | 5.490000000000001e-21 | NR | MCQ3937196.1 | 2026724 | g30050 | i0 | 72.1 | 2.01666666666667 | 61 | 16 | 100 | 1 | 180 | 1 | 38 | 98 | MCQ3937196.1 metallophosphoesterase [Chloroflexota bacterium] | diamond | 363 | 91.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29123335 | 29123335 | PRJNA1137393_P_NODE_55049_length_166_cov_0.888889_g54533_i0 | PRJNA1137393 | 55049 | 166 | 0.888889 | 1.47555574 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 106 | 7.11e-26 | NR | MBI1794036.1 | 2026724 | g54533 | i0 | 92.6 | 0.975903614457831 | 54 | 4 | 97.6 | 0 | 164 | 3 | 230 | 283 | MBI1794036.1 rod shape-determining protein [Chloroflexota bacterium] | diamond | 162 | 106 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29407126 | 29407126 | PRJNA1137393_P_NODE_25449_length_189_cov_1.192857_g24933_i0 | PRJNA1137393 | 25449 | 189 | 1.192857 | 2.25449973 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 114 | 1.1e-27 | NR | MCC6456738.1 | 2614250 | g24933 | i0 | 76.2 | 1 | 63 | 15 | 100 | 0 | 189 | 1 | 17 | 79 | MCC6456738.1 AMP-binding protein [Caldilineaceae bacterium] | diamond | 189 | 114 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 29785982 | 29785982 | PRJNA1137393_P_NODE_57211_length_165_cov_0.896552_g56695_i0 | PRJNA1137393 | 57211 | 165 | 0.896552 | 1.4793108 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 47.4 | 2.5e-4 | NR | MFN2199128.1 | 2073117 | g56695 | i0 | 58.5 | 0.963636363636364 | 53 | 22 | 96.4 | 0 | 7 | 165 | 157 | 209 | MFN2199128.1 ankyrin repeat domain-containing protein [Anaerolineales bacterium] | diamond | 159 | 47.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 29912610 | 29912610 | PRJNA1137393_P_NODE_58871_length_165_cov_0.896552_g58355_i0 | PRJNA1137393 | 58871 | 165 | 0.896552 | 1.4793108 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 69.7 | 3.87e-13 | NR | HEY4188783.1 | 2952938 | g58355 | i0 | 56.6 | 2.89090909090909 | 53 | 23 | 96.4 | 0 | 161 | 3 | 68 | 120 | HEY4188783.1 nuclear transport factor 2 family protein [Candidatus Limnocylindrales bacterium] | diamond | 477 | 69.7 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 30291964 | 30291964 | PRJNA1137393_P_NODE_36432_length_172_cov_1.691057_g35916_i0 | PRJNA1137393 | 36432 | 172 | 1.691057 | 2.90861804 | Dictyobacter aurantiacus | 1936993 | Bacteria | Bacteria | 67.4 | 2.92e-11 | NR | WP_126601423.1 | 1936993 | g35916 | i0 | 46.4 | 0.976744186046512 | 56 | 30 | 97.7 | 0 | 5 | 172 | 866 | 921 | WP_126601423.1 DUF5724 domain-containing protein [Dictyobacter aurantiacus] | diamond | 168 | 67.4 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Dictyobacteraceae | Dictyobacter | Dictyobacter aurantiacus | ||
| 30355266 | 30355266 | PRJNA1137393_P_NODE_62412_length_164_cov_0.904348_g61896_i0 | PRJNA1137393 | 62412 | 164 | 0.904348 | 1.48313072 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 90.9 | 6.5900000000000005e-22 | NR | MEN9936062.1 | 2026724 | g61896 | i0 | 77.8 | 1.97560975609756 | 54 | 12 | 98.8 | 0 | 3 | 164 | 20 | 73 | MEN9936062.1 hypothetical protein [Chloroflexota bacterium] | diamond | 324 | 90.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30575652 | 30575652 | PRJNA1137393_P_NODE_60033_length_165_cov_0.896552_g59517_i0 | PRJNA1137393 | 60033 | 165 | 0.896552 | 1.4793108 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 62.8 | 1.08e-9 | NR | MDQ3689197.1 | 2026724 | g59517 | i0 | 59.3 | 2.90909090909091 | 54 | 22 | 98.2 | 0 | 164 | 3 | 264 | 317 | MDQ3689197.1 TRAP transporter substrate-binding protein DctP [Chloroflexota bacterium] | diamond | 480 | 62.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31239314 | 31239314 | PRJNA1137393_P_NODE_36295_length_172_cov_3.455285_g35779_i0 | PRJNA1137393 | 36295 | 172 | 3.455285 | 5.9430902 | Ktedonobacterales bacterium | 2306968 | Bacteria | Bacteria | 41.6 | 0.0269 | NR | HEU5198589.1 | 2306968 | g35779 | i0 | 46 | 0.872093023255814 | 50 | 22 | 83.7 | 2 | 22 | 165 | 15 | 61 | HEU5198589.1 SHOCT domain-containing protein [Ktedonobacterales bacterium] | diamond | 150 | 41.6 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacterales bacterium | ||||
| 31524240 | 31524240 | PRJNA1137393_P_NODE_61716_length_164_cov_0.904348_g61200_i0 | PRJNA1137393 | 61716 | 164 | 0.904348 | 1.48313072 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 78.2 | 1.23e-15 | NR | MFO7681010.1 | 2026724 | g61200 | i0 | 69.8 | 1.9390243902439 | 53 | 16 | 97 | 0 | 3 | 161 | 59 | 111 | MFO7681010.1 CPBP family intramembrane glutamic endopeptidase [Chloroflexota bacterium] | diamond | 318 | 78.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31587531 | 31587531 | PRJNA1137393_P_NODE_48716_length_167_cov_0.881356_g48200_i0 | PRJNA1137393 | 48716 | 167 | 0.881356 | 1.47186452 | Ktedonobacterales bacterium | 2306968 | Bacteria | Bacteria | 60.8 | 5.27e-9 | NR | HEU4785705.1 | 2306968 | g48200 | i0 | 67.4 | 1.63473053892216 | 46 | 15 | 82.6 | 0 | 166 | 29 | 331 | 376 | HEU4785705.1 helix-turn-helix domain-containing protein [Ktedonobacterales bacterium] | diamond | 273 | 60.8 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacterales bacterium | ||||
| 31713895 | 31713895 | PRJNA1137393_P_NODE_55057_length_166_cov_0.888889_g54541_i0 | PRJNA1137393 | 55057 | 166 | 0.888889 | 1.47555574 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 85.9 | 6.25e-18 | NR | HEY3333946.1 | 2952938 | g54541 | i0 | 88.9 | 1.95180722891566 | 54 | 6 | 97.6 | 0 | 3 | 164 | 103 | 156 | HEY3333946.1 MFS transporter [Candidatus Limnocylindrales bacterium] | diamond | 324 | 85.9 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 32252042 | 32252042 | PRJNA1137393_P_NODE_17598_length_211_cov_0.876543_g17082_i0 | PRJNA1137393 | 17598 | 211 | 0.876543 | 1.84950573 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42.7 | 0.0185 | NR | HDQ70825.1 | 2026724 | g17082 | i0 | 45.9 | 0.5260663507109 | 37 | 17 | 48.3 | 1 | 175 | 74 | 82 | 118 | HDQ70825.1 hypothetical protein [Chloroflexota bacterium] | diamond | 111 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32693974 | 32693974 | PRJNA1137393_P_NODE_46540_length_168_cov_0.873950_g46024_i0 | PRJNA1137393 | 46540 | 168 | 0.87395 | 1.468236 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 41.6 | 0.0342 | NR | MXX93750.1 | 2026724 | g46024 | i0 | 43.2 | 0.785714285714286 | 44 | 25 | 78.6 | 0 | 158 | 27 | 203 | 246 | MXX93750.1 hypothetical protein [Chloroflexota bacterium] | diamond | 132 | 41.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota 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);;