contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA515078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12589920 | 12589920 | PRJNA515078_P_NODE_32450_length_154_cov_1.461538_g32217_i0 | PRJNA515078 | 32450 | 154 | 1.461538 | 2.25076852 | FCB group | 1783270 | Bacteria | Bacteria | 84.3 | 2.43e-17 | NR | MDD5082062.1 | 2026733 | g32217 | i0 | 86.3 | 37.7532467532468 | 51 | 7 | 99.4 | 0 | 154 | 2 | 152 | 202 | MDD5082062.1 molecular chaperone DnaK [Dehalococcoidales bacterium] | diamond | 5814 | 85.1 | 0.990599294947121 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 22787973 | 22787973 | PRJNA515078_P_NODE_14258_length_233_cov_1.545918_g14025_i0 | PRJNA515078 | 14258 | 233 | 1.545918 | 3.60198894 | Ktedonobacterales bacterium | 2306968 | Bacteria | Bacteria | 93.6 | 2.8e-20 | NR | HEX6818152.1 | 2306968 | g14025 | i0 | 64.9 | 2.97424892703863 | 77 | 20 | 99.1 | 1 | 232 | 2 | 168 | 237 | HEX6818152.1 GTPase ObgE [Ktedonobacterales bacterium] | diamond | 693 | 93.6 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacterales bacterium | ||||
| 26950493 | 26950493 | PRJNA515078_P_NODE_9282_length_299_cov_2.076336_g9049_i0 | PRJNA515078 | 9282 | 299 | 2.076336 | 6.20824464 | Chloroflexaceae bacterium | 2562117 | Bacteria | Bacteria | 57.8 | 3.65e-7 | NR | NJP04782.1 | 2562117 | g9049 | i0 | 67.6 | 1.62541806020067 | 37 | 12 | 37.1 | 0 | 297 | 187 | 430 | 466 | NJP04782.1 deoxyribodipyrimidine photo-lyase [Chloroflexaceae bacterium] | diamond | 486 | 57.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexaceae bacterium | |||
| 27803857 | 27803857 | PRJNA515078_P_NODE_26024_length_170_cov_2.052632_g25791_i0 | PRJNA515078 | 26024 | 170 | 2.052632 | 3.4894744 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 52.4 | 3.34e-6 | NR | MBW7881338.1 | 2614250 | g25791 | i0 | 76.5 | 2.18823529411765 | 34 | 7 | 60 | 1 | 68 | 169 | 158 | 190 | MBW7881338.1 pyridoxal 5'-phosphate synthase glutaminase subunit PdxT [Caldilineaceae bacterium] | diamond | 372 | 52.4 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 28308986 | 28308986 | PRJNA515078_P_NODE_34346_length_150_cov_1.725664_g34113_i0 | PRJNA515078 | 34346 | 150 | 1.725664 | 2.588496 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 60.5 | 4.93e-9 | NR | MBG7609968.1 | 2052143 | g34113 | i0 | 65.3 | 3.92 | 49 | 17 | 98 | 0 | 3 | 149 | 207 | 255 | MBG7609968.1 hypothetical protein [Anaerolineae bacterium] | diamond | 588 | 60.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28545533 | 28545533 | PRJNA515078_P_NODE_14187_length_234_cov_1.187817_g13954_i0 | PRJNA515078 | 14187 | 234 | 1.187817 | 2.77949178 | PVC group | 1783257 | Bacteria | Bacteria | 53.9 | 3.98e-6 | NR | MFC1973516.1 | 2026724 | g13954 | i0 | 41.4 | 2.61538461538462 | 70 | 37 | 88.5 | 2 | 228 | 22 | 1076 | 1142 | MFC1973516.1 PKD domain-containing protein [Chloroflexota bacterium] | diamond | 612 | 54.3 | 0.992633517495396 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28640216 | 28640216 | PRJNA515078_P_NODE_25627_length_172_cov_1.118519_g25394_i0 | PRJNA515078 | 25627 | 172 | 1.118519 | 1.92385268 | Chloroflexota | 200795 | Bacteria | Bacteria | 50.8 | 1.05e-5 | NR | MFQ5617136.1 | 2073117 | g25394 | i0 | 51 | 3.48837209302326 | 49 | 24 | 85.5 | 0 | 155 | 9 | 25 | 73 | MFQ5617136.1 rhomboid family intramembrane serine protease [Anaerolineales bacterium] | diamond | 600 | 50.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28734781 | 28734781 | PRJNA515078_P_NODE_25707_length_171_cov_1.888060_g25474_i0 | PRJNA515078 | 25707 | 171 | 1.88806 | 3.2285826 | root | 1 | Root_unresolved | Root_unresolved | 57.4 | 8.17e-8 | NR | MFL2746032.1 | 2026734 | g25474 | i0 | 46.3 | 7.68421052631579 | 54 | 28 | 93 | 1 | 11 | 169 | 162 | 215 | MFL2746032.1 PQQ-dependent sugar dehydrogenase [Dehalococcoidia bacterium] | diamond | 1314 | 57.8 | 0.993079584775087 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 29319213 | 29319213 | PRJNA515078_P_NODE_21049_length_189_cov_1.335526_g20816_i0 | PRJNA515078 | 21049 | 189 | 1.335526 | 2.52414414 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 52.4 | 7.03e-6 | NR | MFO8035657.1 | 2073117 | g20816 | i0 | 35 | 4.85714285714286 | 60 | 39 | 95.2 | 0 | 184 | 5 | 272 | 331 | MFO8035657.1 serpin family protein [Anaerolineales bacterium] | diamond | 918 | 52.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 30171894 | 30171894 | PRJNA515078_P_NODE_29072_length_162_cov_1.040000_g28839_i0 | PRJNA515078 | 29072 | 162 | 1.04 | 1.6848 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 77.4 | 2.22e-16 | NR | MDO9333994.1 | 2026733 | g28839 | i0 | 90.9 | 0.814814814814815 | 44 | 3 | 79.6 | 1 | 1 | 129 | 92 | 135 | MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium] | diamond | 132 | 77.4 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 30566181 | 30566181 | PRJNA515078_P_NODE_22733_length_182_cov_1.344828_g22500_i0 | PRJNA515078 | 22733 | 182 | 1.344828 | 2.44758696 | Bacillati | 1783272 | Bacteria | Bacteria | 53.9 | 1.87e-6 | NR | WP_287906347.1 | 1904827 | g22500 | i0 | 45.8 | 11.8846153846154 | 59 | 32 | 97.3 | 0 | 4 | 180 | 335 | 393 | WP_287906347.1 RCC1 repeat-containing protein [Chloroflexus sp.] | diamond | 2163 | 54.3 | 0.992633517495396 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexus | Chloroflexus sp. | ||
| 30930263 | 30930263 | PRJNA515078_P_NODE_24014_length_177_cov_1.392857_g23781_i0 | PRJNA515078 | 24014 | 177 | 1.392857 | 2.46535689 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 43.5 | 0.00809 | NR | MFL5769623.1 | 2026724 | g23781 | i0 | 40.4 | 3.22033898305085 | 52 | 25 | 88.1 | 1 | 157 | 2 | 122 | 167 | MFL5769623.1 PQQ-dependent sugar dehydrogenase [Chloroflexota bacterium] | diamond | 570 | 43.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31088233 | 31088233 | PRJNA515078_P_NODE_31415_length_156_cov_1.966387_g31182_i0 | PRJNA515078 | 31415 | 156 | 1.966387 | 3.06756372 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 50.1 | 2.89e-5 | NR | MEA3309843.1 | 2026724 | g31182 | i0 | 44.7 | 4.61538461538461 | 47 | 26 | 90.4 | 0 | 2 | 142 | 251 | 297 | MEA3309843.1 serpin family protein [Chloroflexota bacterium] | diamond | 720 | 50.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31246238 | 31246238 | PRJNA515078_P_NODE_18695_length_201_cov_1.048780_g18462_i0 | PRJNA515078 | 18695 | 201 | 1.04878 | 2.1080478 | Candidatus Thermofonsia Clade 1 bacterium | 2364210 | Bacteria | Bacteria | 53.9 | 2.35e-6 | NR | PJF37383.1 | 2364210 | g18462 | i0 | 46.9 | 2.19402985074627 | 49 | 26 | 73.1 | 0 | 194 | 48 | 10 | 58 | PJF37383.1 MAG: acyl-CoA dehydrogenase [Candidatus Thermofonsia Clade 1 bacterium] | diamond | 441 | 53.9 | 1 | Bacteria | Candidatus Thermofonsia Clade 1 | Bacillati | Chloroflexota | Candidatus Thermofontia | Candidatus Thermofonsia Clade 1 bacterium | ||||
| 31309421 | 31309421 | PRJNA515078_P_NODE_14835_length_228_cov_1.303665_g14602_i0 | PRJNA515078 | 14835 | 228 | 1.303665 | 2.9723562 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 66.2 | 1.6e-10 | NR | HEX2910365.1 | 2448782 | g14602 | i0 | 51.9 | 5.77631578947368 | 54 | 26 | 71.1 | 0 | 223 | 62 | 1265 | 1318 | HEX2910365.1 6-bladed beta-propeller [Chloroflexia bacterium] | diamond | 1317 | 66.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 31657235 | 31657235 | PRJNA515078_P_NODE_14597_length_230_cov_1.378238_g14364_i0 | PRJNA515078 | 14597 | 230 | 1.378238 | 3.1699474 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42.4 | 0.0406 | NR | HLJ67436.1 | 2026724 | g14364 | i0 | 25 | 0.834782608695652 | 64 | 46 | 80.9 | 1 | 45 | 230 | 213 | 276 | HLJ67436.1 carbohydrate ABC transporter permease [Chloroflexota bacterium] | diamond | 192 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31720681 | 31720681 | PRJNA515078_P_NODE_15657_length_221_cov_1.570652_g15424_i0 | PRJNA515078 | 15657 | 221 | 1.570652 | 3.47114092 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 99.8 | 1.12e-24 | NR | MBL8094096.1 | 2073117 | g15424 | i0 | 66.1 | 3.40723981900452 | 62 | 21 | 84.2 | 0 | 6 | 191 | 88 | 149 | MBL8094096.1 nucleoside-diphosphate kinase [Anaerolineales bacterium] | diamond | 753 | 99.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 31878680 | 31878680 | PRJNA515078_P_NODE_25017_length_174_cov_1.029197_g24784_i0 | PRJNA515078 | 25017 | 174 | 1.029197 | 1.79080278 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 44.3 | 0.00441 | NR | MBE7556839.1 | 2073117 | g24784 | i0 | 52.2 | 1.74137931034483 | 46 | 22 | 79.3 | 0 | 28 | 165 | 1167 | 1212 | MBE7556839.1 PKD domain-containing protein [Anaerolineales bacterium] | diamond | 303 | 44.3 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32416858 | 32416858 | PRJNA515078_P_NODE_13959_length_236_cov_1.763819_g13726_i0 | PRJNA515078 | 13959 | 236 | 1.763819 | 4.16261284 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 43.9 | 0.0131 | NR | MYC30865.1 | 2026724 | g13726 | i0 | 32.4 | 0.864406779661017 | 68 | 46 | 86.4 | 0 | 5 | 208 | 38 | 105 | MYC30865.1 CoA transferase [Chloroflexota bacterium] | diamond | 204 | 43.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32621702 | 32621702 | PRJNA515078_P_NODE_26100_length_170_cov_1.466165_g25867_i0 | PRJNA515078 | 26100 | 170 | 1.466165 | 2.4924805 | Chloroflexus | 1107 | Bacteria | Bacteria | 55.1 | 6.18e-7 | NR | WP_299756274.1 | 214040 | g25867 | i0 | 56.3 | 1.69411764705882 | 48 | 21 | 84.7 | 0 | 23 | 166 | 48 | 95 | WP_299756274.1 SdrD B-like domain-containing protein, partial [uncultured Chloroflexus sp.] | diamond | 288 | 55.5 | 0.992792792792793 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexus | uncultured Chloroflexus sp. | ||
| 32700718 | 32700718 | PRJNA515078_P_NODE_9600_length_293_cov_1.828125_g9367_i0 | PRJNA515078 | 9600 | 293 | 1.828125 | 5.35640625 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 68.2 | 7.47e-11 | NR | MFQ5872256.1 | 2026734 | g9367 | i0 | 42.7 | 0.982935153583618 | 96 | 52 | 96.2 | 2 | 1 | 282 | 83 | 177 | MFQ5872256.1 GDP-mannose 4,6-dehydratase [Dehalococcoidia bacterium] | diamond | 288 | 68.2 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia 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);;