contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJDB4470" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7359086 | 7359086 | PRJDB4470_P_NODE_71546_length_217_cov_1.154762_g70391_i0 | PRJDB4470 | 71546 | 217 | 1.154762 | 2.50583354 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 115 | 5.190000000000001e-29 | NR | MCL6509819.1 | 2052143 | g70391 | i0 | 75 | 1.99078341013825 | 72 | 18 | 99.5 | 0 | 216 | 1 | 136 | 207 | MCL6509819.1 P-type conjugative transfer ATPase TrbB [Anaerolineae bacterium] | diamond | 432 | 115 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 26779325 | 26779325 | PRJDB4470_P_NODE_118421_length_163_cov_0.912281_g117266_i0 | PRJDB4470 | 118421 | 163 | 0.912281 | 1.48701803 | Caldilineae bacterium | 2420332 | Bacteria | Bacteria | 46.6 | 2.42e-4 | NR | RME56806.1 | 2420332 | g117266 | i0 | 51.3 | 0.717791411042945 | 39 | 18 | 69.9 | 1 | 49 | 162 | 36 | 74 | RME56806.1 MAG: hypothetical protein D6790_14205 [Caldilineae bacterium] | diamond | 117 | 46.6 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineae bacterium | |||||
| 27089861 | 27089861 | PRJDB4470_P_NODE_106802_length_166_cov_1.307692_g105647_i0 | PRJDB4470 | 106802 | 166 | 1.307692 | 2.17076872 | Bacteria | 2 | Bacteria | Bacteria | 59.3 | 1.33e-8 | NR | MBA2755258.1 | 2448782 | g105647 | i0 | 64.4 | 4.01204819277108 | 45 | 16 | 81.3 | 0 | 161 | 27 | 221 | 265 | MBA2755258.1 undecaprenyl-diphosphate phosphatase [Chloroflexia bacterium] | diamond | 666 | 59.7 | 0.993299832495812 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 27406037 | 27406037 | PRJDB4470_P_NODE_101643_length_168_cov_2.546218_g100488_i0 | PRJDB4470 | 101643 | 168 | 2.546218 | 4.27764624 | Bacteria | 2 | Bacteria | Bacteria | 97.8 | 5.16e-24 | NR | HZC78526.1 | 2306968 | g100488 | i0 | 75 | 2 | 56 | 14 | 100 | 0 | 1 | 168 | 98 | 153 | HZC78526.1 RNA polymerase sigma factor [Ktedonobacterales bacterium] | diamond | 336 | 97.8 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacterales bacterium | ||||
| 27506643 | 27506643 | PRJDB4470_P_NODE_110843_length_165_cov_0.896552_g109688_i0 | PRJDB4470 | 110843 | 165 | 0.896552 | 1.4793108 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 90.5 | 1.94e-19 | NR | MDF2735700.1 | 2026724 | g109688 | i0 | 83 | 3.96363636363636 | 53 | 9 | 96.4 | 0 | 165 | 7 | 177 | 229 | MDF2735700.1 argS [Chloroflexota bacterium] | diamond | 654 | 90.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27538110 | 27538110 | PRJDB4470_P_NODE_111784_length_165_cov_0.879310_g110629_i0 | PRJDB4470 | 111784 | 165 | 0.87931 | 1.4508615 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 49.3 | 6.44e-5 | NR | NJD27155.1 | 2026724 | g110629 | i0 | 61.4 | 1.6 | 44 | 17 | 80 | 0 | 34 | 165 | 3 | 46 | NJD27155.1 HAMP domain-containing histidine kinase [Chloroflexota bacterium] | diamond | 264 | 49.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27664504 | 27664504 | PRJDB4470_P_NODE_109144_length_166_cov_0.871795_g107989_i0 | PRJDB4470 | 109144 | 166 | 0.871795 | 1.4471797 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 95.1 | 3.14e-21 | NR | MEM7535667.1 | 2026724 | g107989 | i0 | 84.9 | 1.91566265060241 | 53 | 8 | 95.8 | 0 | 3 | 161 | 74 | 126 | MEM7535667.1 preprotein translocase subunit SecY [Chloroflexota bacterium] | diamond | 318 | 95.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27948514 | 27948514 | PRJDB4470_P_NODE_66465_length_230_cov_1.127072_g65310_i0 | PRJDB4470 | 66465 | 230 | 1.127072 | 2.5922656 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 55.1 | 1.37e-6 | NR | MFN8465799.1 | 2614250 | g65310 | i0 | 61.7 | 0.61304347826087 | 47 | 18 | 61.3 | 0 | 214 | 74 | 376 | 422 | MFN8465799.1 gephyrin-like molybdotransferase Glp [Caldilineaceae bacterium] | diamond | 141 | 55.1 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 28453862 | 28453862 | PRJDB4470_P_NODE_92846_length_179_cov_1.176923_g91691_i0 | PRJDB4470 | 92846 | 179 | 1.176923 | 2.10669217 | Ktedonobacteraceae bacterium | 2740538 | Bacteria | Bacteria | 47 | 2.52e-4 | NR | HVB75907.1 | 2740538 | g91691 | i0 | 48 | 0.837988826815642 | 50 | 24 | 80.4 | 1 | 179 | 36 | 61 | 110 | HVB75907.1 allene oxide cyclase family protein [Ktedonobacteraceae bacterium] | diamond | 150 | 47 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium | |||
| 28548599 | 28548599 | PRJDB4470_P_NODE_111067_length_165_cov_0.896552_g109912_i0 | PRJDB4470 | 111067 | 165 | 0.896552 | 1.4793108 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 61.6 | 9.66e-10 | NR | MCL6509849.1 | 2052143 | g109912 | i0 | 60 | 0.909090909090909 | 50 | 19 | 89.1 | 1 | 5 | 151 | 153 | 202 | MCL6509849.1 hypothetical protein [Anaerolineae bacterium] | diamond | 150 | 61.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29337817 | 29337817 | PRJDB4470_P_NODE_93369_length_178_cov_1.558140_g92214_i0 | PRJDB4470 | 93369 | 178 | 1.55814 | 2.7734892 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 66.6 | 2.79e-11 | NR | HXH66383.1 | 2952938 | g92214 | i0 | 57.9 | 1.8876404494382 | 57 | 24 | 96.1 | 0 | 172 | 2 | 1 | 57 | HXH66383.1 molybdopterin-dependent oxidoreductase [Candidatus Limnocylindrales bacterium] | diamond | 336 | 66.6 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 29489561 | 29489561 | PRJDB4470_P_NODE_34550_length_381_cov_35.132530_g33400_i0 | PRJDB4470 | 34550 | 381 | 35.13253 | 133.8549393 | Bacillati | 1783272 | Bacteria | Bacteria | 46.6 | 5.87e-4 | NR | HCG01734.1 | 2026724 | g33400 | i0 | 78.6 | 0.496062992125984 | 28 | 6 | 22 | 0 | 266 | 183 | 6 | 33 | HCG01734.1 CsbD family protein [Chloroflexota bacterium] | diamond | 189 | 46.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29558674 | 29558674 | PRJDB4470_P_NODE_96190_length_174_cov_1.632000_g95035_i0 | PRJDB4470 | 96190 | 174 | 1.632 | 2.83968 | Chloroflexales bacterium | 2725990 | Bacteria | Bacteria | 49.3 | 1.6e-5 | NR | MEI8165616.1 | 2725990 | g95035 | i0 | 52.9 | 0.879310344827586 | 51 | 24 | 87.9 | 0 | 2 | 154 | 11 | 61 | MEI8165616.1 DUF4844 domain-containing protein [Chloroflexales bacterium] | diamond | 153 | 49.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexales bacterium | ||||
| 30285632 | 30285632 | PRJDB4470_P_NODE_106952_length_166_cov_1.085470_g105797_i0 | PRJDB4470 | 106952 | 166 | 1.08547 | 1.8018802 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 103 | 1.07e-27 | NR | MCW1969365.1 | 2052143 | g105797 | i0 | 96.1 | 0.921686746987952 | 51 | 2 | 92.2 | 0 | 154 | 2 | 1 | 51 | MCW1969365.1 Fe-S cluster assembly protein IscX [Anaerolineae bacterium] | diamond | 153 | 103 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30348955 | 30348955 | PRJDB4470_P_NODE_116572_length_164_cov_0.878261_g115417_i0 | PRJDB4470 | 116572 | 164 | 0.878261 | 1.44034804 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 71.2 | 9.33e-15 | NR | HLQ32529.1 | 2026724 | g115417 | i0 | 62.3 | 4.84756097560976 | 53 | 20 | 97 | 0 | 164 | 6 | 13 | 65 | HLQ32529.1 rhodanese-like domain-containing protein [Chloroflexota bacterium] | diamond | 795 | 71.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31043856 | 31043856 | PRJDB4470_P_NODE_118155_length_163_cov_1.052632_g117000_i0 | PRJDB4470 | 118155 | 163 | 1.052632 | 1.71579016 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 69.3 | 3.57e-13 | NR | MEZ4515128.1 | 2026724 | g117000 | i0 | 60 | 2.00613496932515 | 55 | 21 | 99.4 | 1 | 1 | 162 | 6 | 60 | MEZ4515128.1 coactosin family protein [Chloroflexota bacterium] | diamond | 327 | 69.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31075239 | 31075239 | PRJDB4470_P_NODE_94575_length_176_cov_2.362205_g93420_i0 | PRJDB4470 | 94575 | 176 | 2.362205 | 4.1574808 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 57 | 1.34e-7 | NR | MCA9830234.1 | 2026734 | g93420 | i0 | 52.2 | 0.784090909090909 | 46 | 22 | 78.4 | 0 | 171 | 34 | 40 | 85 | MCA9830234.1 toprim domain-containing protein [Dehalococcoidia bacterium] | diamond | 138 | 57 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 32467170 | 32467170 | PRJDB4470_P_NODE_124859_length_162_cov_0.893805_g123704_i0 | PRJDB4470 | 124859 | 162 | 0.893805 | 1.4479641 | Anaerolinea sp. | 1872519 | Bacteria | Bacteria | 73.2 | 8.22e-15 | NR | MBE2200499.1 | 1872519 | g123704 | i0 | 66.7 | 1 | 54 | 17 | 100 | 1 | 1 | 162 | 40 | 92 | MBE2200499.1 hypothetical protein [Anaerolinea sp.] | diamond | 162 | 73.2 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolinea | Anaerolinea sp. |
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);;