contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1013345" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19283727 | 19283727 | PRJNA1013345_P_NODE_11676_length_194_cov_2.666667_g11546_i0 | PRJNA1013345 | 11676 | 194 | 2.666667 | 5.17333398 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 125 | 2.17e-32 | NR | MEX1022268.1 | 2026734 | g11546 | i0 | 93.8 | 3.01546391752577 | 65 | 2 | 97.4 | 1 | 2 | 190 | 327 | 391 | MEX1022268.1 cysteine desulfurase [Dehalococcoidia bacterium] | diamond | 585 | 125 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 22679293 | 22679293 | PRJNA1013345_P_NODE_18618_length_174_cov_2.409449_g18488_i0 | PRJNA1013345 | 18618 | 174 | 2.409449 | 4.19244126 | Bacteria | 2 | Bacteria | Bacteria | 127 | 2.0899999999999997e-35 | NR | MBA3449709.1 | 2448782 | g18488 | i0 | 94.8 | 24 | 58 | 3 | 100 | 0 | 174 | 1 | 88 | 145 | MBA3449709.1 phenylalanine--tRNA ligase subunit alpha [Chloroflexia bacterium] | diamond | 4176 | 128 | 0.9921875 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 26749566 | 26749566 | PRJNA1013345_P_NODE_24701_length_164_cov_0.871795_g24571_i0 | PRJNA1013345 | 24701 | 164 | 0.871795 | 1.4297438 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 79.7 | 1.17e-15 | NR | HYI22202.1 | 2952938 | g24571 | i0 | 78.4 | 0.932926829268293 | 51 | 11 | 93.3 | 0 | 154 | 2 | 366 | 416 | HYI22202.1 DNA internalization-related competence protein ComEC/Rec2 [Candidatus Limnocylindrales bacterium] | diamond | 153 | 79.7 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 26845226 | 26845226 | PRJNA1013345_P_NODE_13561_length_186_cov_1.143885_g13431_i0 | PRJNA1013345 | 13561 | 186 | 1.143885 | 2.1276261 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 58.9 | 2.64e-8 | NR | HEY4684734.1 | 2026734 | g13431 | i0 | 61.5 | 1.67741935483871 | 52 | 13 | 83.9 | 1 | 30 | 185 | 170 | 214 | HEY4684734.1 PHP domain-containing protein [Dehalococcoidia bacterium] | diamond | 312 | 58.9 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 26845227 | 26845227 | PRJNA1013345_P_NODE_21161_length_169_cov_1.418033_g21031_i0 | PRJNA1013345 | 21161 | 169 | 1.418033 | 2.39647577 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 93.6 | 7.12e-22 | NR | HXH20850.1 | 2026734 | g21031 | i0 | 76.4 | 3.90532544378698 | 55 | 13 | 97.6 | 0 | 167 | 3 | 4 | 58 | HXH20850.1 TrkA family potassium uptake protein [Dehalococcoidia bacterium] | diamond | 660 | 93.6 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 26939798 | 26939798 | PRJNA1013345_P_NODE_13422_length_186_cov_1.467626_g13292_i0 | PRJNA1013345 | 13422 | 186 | 1.467626 | 2.72978436 | Ktedonosporobacter rubrisoli | 2509675 | Bacteria | Bacteria | 42.4 | 0.0229 | NR | WP_165422824.1 | 2509675 | g13292 | i0 | 39.3 | 0.903225806451613 | 56 | 33 | 90.3 | 1 | 9 | 176 | 40 | 94 | WP_165422824.1 CPBP family intramembrane glutamic endopeptidase [Ktedonosporobacter rubrisoli] | diamond | 168 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonosporobacteraceae | Ktedonosporobacter | Ktedonosporobacter rubrisoli | ||
| 27603784 | 27603784 | PRJNA1013345_P_NODE_17924_length_176_cov_1.581395_g17794_i0 | PRJNA1013345 | 17924 | 176 | 1.581395 | 2.7832552 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 110 | 1.7500000000000002e-26 | NR | HEV8402523.1 | 2952938 | g17794 | i0 | 86.2 | 7.85795454545455 | 58 | 8 | 98.9 | 0 | 3 | 176 | 211 | 268 | HEV8402523.1 MDR family MFS transporter [Candidatus Limnocylindrales bacterium] | diamond | 1383 | 110 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 28077084 | 28077084 | PRJNA1013345_P_NODE_31045_length_158_cov_0.918919_g30915_i0 | PRJNA1013345 | 31045 | 158 | 0.918919 | 1.45189202 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 89.7 | 1.78e-19 | NR | HEX2193820.1 | 3047546 | g30915 | i0 | 80.8 | 0.987341772151899 | 52 | 10 | 98.7 | 0 | 156 | 1 | 51 | 102 | HEX2193820.1 ABC transporter permease [Candidatus Limnocylindria bacterium] | diamond | 156 | 89.7 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 28266404 | 28266404 | PRJNA1013345_P_NODE_16206_length_180_cov_1.060150_g16076_i0 | PRJNA1013345 | 16206 | 180 | 1.06015 | 1.90827 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 42.7 | 0.0156 | NR | HEY71228.1 | 2052143 | g16076 | i0 | 42.6 | 0.783333333333333 | 47 | 24 | 73.3 | 1 | 29 | 160 | 33 | 79 | HEY71228.1 4Fe-4S binding protein [Anaerolineae bacterium] | diamond | 141 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28392913 | 28392913 | PRJNA1013345_P_NODE_24946_length_163_cov_2.241379_g24816_i0 | PRJNA1013345 | 24946 | 163 | 2.241379 | 3.65344777 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 90.5 | 1.54e-19 | NR | MDQ3524265.1 | 2026724 | g24816 | i0 | 77.8 | 0.993865030674847 | 54 | 12 | 99.4 | 0 | 2 | 163 | 401 | 454 | MDQ3524265.1 FAD-binding oxidoreductase [Chloroflexota bacterium] | diamond | 162 | 90.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29024777 | 29024777 | PRJNA1013345_P_NODE_19708_length_172_cov_1.576000_g19578_i0 | PRJNA1013345 | 19708 | 172 | 1.576 | 2.71072 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 41.2 | 0.0423 | NR | MCC6176415.1 | 2026724 | g19578 | i0 | 47.2 | 0.924418604651163 | 53 | 25 | 92.4 | 1 | 10 | 168 | 42 | 91 | MCC6176415.1 hypothetical protein [Chloroflexota bacterium] | diamond | 159 | 41.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29782153 | 29782153 | PRJNA1013345_P_NODE_14491_length_183_cov_9.316176_g14361_i0 | PRJNA1013345 | 14491 | 183 | 9.316176 | 17.04860208 | uncultured Chloroflexota bacterium | 166587 | Bacteria | Bacteria | 41.6 | 0.0445 | NR | CAA9302627.1 | 166587 | g14361 | i0 | 41.9 | 0.704918032786885 | 43 | 22 | 70.5 | 1 | 7 | 135 | 304 | 343 | CAA9302627.1 MAG: hypothetical protein AVDCRST_MAG77-5794 [uncultured Chloroflexota bacterium] | diamond | 129 | 41.6 | 1 | Bacteria | Bacillati | Chloroflexota | uncultured Chloroflexota bacterium | ||||||
| 29877036 | 29877036 | PRJNA1013345_P_NODE_30551_length_158_cov_1.837838_g30421_i0 | PRJNA1013345 | 30551 | 158 | 1.837838 | 2.90378404 | Ardenticatenaceae bacterium | 2614247 | Bacteria | Bacteria | 80.5 | 5.74e-16 | NR | HEX8681913.1 | 2614247 | g30421 | i0 | 78.8 | 1.9746835443038 | 52 | 11 | 98.7 | 0 | 158 | 3 | 463 | 514 | HEX8681913.1 3-hydroxyacyl-CoA dehydrogenase/enoyl-CoA hydratase family protein [Ardenticatenaceae bacterium] | diamond | 312 | 80.5 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Ardenticatenales | Ardenticatenaceae | Ardenticatenaceae bacterium | |||
| 31362220 | 31362220 | PRJNA1013345_P_NODE_17056_length_178_cov_1.404580_g16926_i0 | PRJNA1013345 | 17056 | 178 | 1.40458 | 2.5001524 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 70.5 | 2.61e-12 | NR | HJP70109.1 | 3047546 | g16926 | i0 | 69.5 | 0.99438202247191 | 59 | 18 | 99.4 | 0 | 178 | 2 | 871 | 929 | HJP70109.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Limnocylindria bacterium] | diamond | 177 | 70.5 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 31362221 | 31362221 | PRJNA1013345_P_NODE_17456_length_177_cov_1.569231_g17326_i0 | PRJNA1013345 | 17456 | 177 | 1.569231 | 2.77753887 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 62.8 | 1.26e-9 | NR | HET9498448.1 | 3047546 | g17326 | i0 | 66.7 | 0.76271186440678 | 45 | 15 | 76.3 | 0 | 39 | 173 | 1 | 45 | HET9498448.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Limnocylindria bacterium] | diamond | 135 | 62.8 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 31386041 | 31386041 | PRJNA1013345_P_NODE_20436_length_170_cov_2.682927_g20306_i0 | PRJNA1013345 | 20436 | 170 | 2.682927 | 4.5609759 | Bacteria | 2 | Bacteria | Bacteria | 77 | 1.03e-14 | NR | MDP9356711.1 | 2026724 | g20306 | i0 | 80 | 1.58823529411765 | 45 | 9 | 79.4 | 0 | 137 | 3 | 1 | 45 | MDP9356711.1 adenosylhomocysteinase [Chloroflexota bacterium] | diamond | 270 | 77 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31646526 | 31646526 | PRJNA1013345_P_NODE_30117_length_159_cov_0.910714_g29987_i0 | PRJNA1013345 | 30117 | 159 | 0.910714 | 1.44803526 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 112 | 1.5600000000000002e-27 | NR | HET9852287.1 | 2952938 | g29987 | i0 | 96.2 | 1 | 53 | 2 | 100 | 0 | 1 | 159 | 135 | 187 | HET9852287.1 NAD(P)-binding domain-containing protein [Candidatus Limnocylindrales bacterium] | diamond | 159 | 112 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales 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);;