contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA942359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7301095 | 7301095 | PRJNA942359_P_NODE_18846_length_244_cov_0.912281_g18731_i0 | PRJNA942359 | 18846 | 244 | 0.912281 | 2.22596564 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 158 | 2.99e-43 | NR | HEX2513560.1 | 2026724 | g18731 | i0 | 95.1 | 0.995901639344262 | 81 | 4 | 99.6 | 0 | 243 | 1 | 380 | 460 | HEX2513560.1 ABC transporter ATP-binding protein [Chloroflexota bacterium] | diamond | 243 | 158 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 9850908 | 9850908 | PRJNA942359_P_NODE_14568_length_251_cov_0.876404_g14453_i0 | PRJNA942359 | 14568 | 251 | 0.876404 | 2.19977404 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 172 | 1.2e-50 | NR | MCK6566192.1 | 2073117 | g14453 | i0 | 97.6 | 0.99203187250996006 | 83 | 2 | 99.2 | 0 | 249 | 1 | 284 | 366 | MCK6566192.1 endolytic transglycosylase MltG [Anaerolineales bacterium] | diamond | 249 | 172 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 22599913 | 22599913 | PRJNA942359_P_NODE_13378_length_253_cov_0.866667_g13263_i0 | PRJNA942359 | 13378 | 253 | 0.866667 | 2.19266751 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 128 | 8.53e-34 | NR | MER3406439.1 | 2026724 | g13263 | i0 | 68.3 | 0.972332015810277 | 82 | 26 | 97.2 | 0 | 2 | 247 | 152 | 233 | MER3406439.1 molybdopterin-binding oxidoreductase [Chloroflexota bacterium] | diamond | 246 | 128 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 24210405 | 24210405 | PRJNA942359_P_NODE_16919_length_247_cov_0.896552_g16804_i0 | PRJNA942359 | 16919 | 247 | 0.896552 | 2.21448344 | Bacillati | 1783272 | Bacteria | Bacteria | 144 | 1.62e-38 | NR | MCI0645254.1 | 2026724 | g16804 | i0 | 88.9 | 10.821862348178101 | 81 | 9 | 98.4 | 0 | 245 | 3 | 375 | 455 | MCI0645254.1 ABC transporter ATP-binding protein/permease [Chloroflexota bacterium] | diamond | 2673 | 145 | 0.993103448275862 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27119789 | 27119789 | PRJNA942359_P_NODE_13122_length_253_cov_0.866667_g13007_i0 | PRJNA942359 | 13122 | 253 | 0.866667 | 2.19266751 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 147 | 5.07e-41 | NR | HSK66068.1 | 2073117 | g13007 | i0 | 88 | 10.8260869565217 | 83 | 10 | 98.4 | 0 | 253 | 5 | 17 | 99 | HSK66068.1 adenosine deaminase [Anaerolineales bacterium] | diamond | 2739 | 147 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 27530800 | 27530800 | PRJNA942359_P_NODE_18463_length_245_cov_0.906977_g18348_i0 | PRJNA942359 | 18463 | 245 | 0.906977 | 2.22209365 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 144 | 4.28e-42 | NR | MCC7130685.1 | 2052143 | g18348 | i0 | 83.8 | 0.979591836734694 | 80 | 13 | 98 | 0 | 3 | 242 | 77 | 156 | MCC7130685.1 dehydratase [Anaerolineae bacterium] | diamond | 240 | 144 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28036104 | 28036104 | PRJNA942359_P_NODE_17725_length_246_cov_0.901734_g17610_i0 | PRJNA942359 | 17725 | 246 | 0.901734 | 2.21826564 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 127 | 2.06e-32 | NR | MCC7165053.1 | 2052143 | g17610 | i0 | 100 | 0.731707317073171 | 60 | 0 | 73.2 | 0 | 65 | 244 | 1 | 60 | MCC7165053.1 hypothetical protein [Anaerolineae bacterium] | diamond | 180 | 127 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28478085 | 28478085 | PRJNA942359_P_NODE_16326_length_248_cov_0.891429_g16211_i0 | PRJNA942359 | 16326 | 248 | 0.891429 | 2.21074392 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 92.8 | 9.74e-20 | NR | MBC7264510.1 | 2026724 | g16211 | i0 | 56.2 | 0.883064516129032 | 73 | 32 | 88.3 | 0 | 7 | 225 | 1504 | 1576 | MBC7264510.1 hypothetical protein [Chloroflexota bacterium] | diamond | 219 | 92.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28509659 | 28509659 | PRJNA942359_P_NODE_9267_length_288_cov_1.362791_g9152_i0 | PRJNA942359 | 9267 | 288 | 1.362791 | 3.92483808 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 72.8 | 1.27e-12 | NR | NWG18473.1 | 2026724 | g9152 | i0 | 80 | 0.833333333333333 | 40 | 8 | 41.7 | 0 | 288 | 169 | 306 | 345 | NWG18473.1 GDP-mannose 4,6-dehydratase [Chloroflexota bacterium] | diamond | 240 | 72.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28604354 | 28604354 | PRJNA942359_P_NODE_18627_length_244_cov_0.912281_g18512_i0 | PRJNA942359 | 18627 | 244 | 0.912281 | 2.22596564 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 117 | 1.67e-28 | NR | MBE7554056.1 | 2073117 | g18512 | i0 | 78.5 | 0.971311475409836 | 79 | 17 | 97.1 | 0 | 242 | 6 | 409 | 487 | MBE7554056.1 ATP-binding cassette domain-containing protein [Anaerolineales bacterium] | diamond | 237 | 117 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28919900 | 28919900 | PRJNA942359_P_NODE_13888_length_252_cov_0.871508_g13773_i0 | PRJNA942359 | 13888 | 252 | 0.871508 | 2.19620016 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 171 | 3.619999999999999e-48 | NR | HET7704332.1 | 2952938 | g13773 | i0 | 100 | 1 | 84 | 0 | 100 | 0 | 252 | 1 | 513 | 596 | HET7704332.1 PA domain-containing protein [Candidatus Limnocylindrales bacterium] | diamond | 252 | 171 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 29267171 | 29267171 | PRJNA942359_P_NODE_15829_length_249_cov_0.886364_g15714_i0 | PRJNA942359 | 15829 | 249 | 0.886364 | 2.20704636 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 155 | 4.3299999999999996e-43 | NR | MDP9365206.1 | 2026724 | g15714 | i0 | 90.4 | 1 | 83 | 8 | 100 | 0 | 1 | 249 | 392 | 474 | MDP9365206.1 chlorohydrolase family protein [Chloroflexota bacterium] | diamond | 249 | 155 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29298993 | 29298993 | PRJNA942359_P_NODE_13809_length_252_cov_0.871508_g13694_i0 | PRJNA942359 | 13809 | 252 | 0.871508 | 2.19620016 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 78.2 | 5.87e-16 | NR | HET9083880.1 | 2952938 | g13694 | i0 | 66.1 | 2.10714285714286 | 59 | 19 | 70.2 | 1 | 75 | 251 | 1 | 58 | HET9083880.1 F0F1 ATP synthase subunit A [Candidatus Limnocylindrales bacterium] | diamond | 531 | 78.2 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 29400490 | 29400490 | PRJNA942359_P_NODE_18269_length_245_cov_0.906977_g18154_i0 | PRJNA942359 | 18269 | 245 | 0.906977 | 2.22209365 | Chloroflexota | 200795 | Bacteria | Bacteria | 47.4 | 8.52e-4 | NR | HEX9922308.1 | 2052143 | g18154 | i0 | 65.6 | 0.795918367346939 | 32 | 11 | 39.2 | 0 | 244 | 149 | 327 | 358 | HEX9922308.1 Gfo/Idh/MocA family oxidoreductase [Anaerolineae bacterium] | diamond | 195 | 47.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29993769 | 29993769 | PRJNA942359_P_NODE_17571_length_246_cov_0.901734_g17456_i0 | PRJNA942359 | 17571 | 246 | 0.901734 | 2.21826564 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 75.1 | 1.52e-13 | NR | UCD40817.1 | 2026724 | g17456 | i0 | 79.5 | 0.536585365853659 | 44 | 9 | 53.7 | 0 | 113 | 244 | 7 | 50 | UCD40817.1 MAG: helix-turn-helix domain-containing protein, partial [Chloroflexota bacterium] | diamond | 132 | 75.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30878300 | 30878300 | PRJNA942359_P_NODE_14914_length_250_cov_0.881356_g14799_i0 | PRJNA942359 | 14914 | 250 | 0.881356 | 2.20339 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 122 | 6.56e-31 | NR | MCL4860970.1 | 2614250 | g14799 | i0 | 69.5 | 2.952 | 82 | 25 | 98.4 | 0 | 3 | 248 | 122 | 203 | MCL4860970.1 MFS transporter [Caldilineaceae bacterium] | diamond | 738 | 122 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 31454281 | 31454281 | PRJNA942359_P_NODE_17076_length_247_cov_0.896552_g16961_i0 | PRJNA942359 | 17076 | 247 | 0.896552 | 2.21448344 | PVC group | 1783257 | Bacteria | Bacteria | 52.8 | 9.81e-6 | NR | MBI3160559.1 | 2026724 | g16961 | i0 | 41.9 | 3.30364372469636 | 62 | 36 | 75.3 | 0 | 190 | 5 | 136 | 197 | MBI3160559.1 hypothetical protein [Chloroflexota bacterium] | diamond | 816 | 52.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31731846 | 31731846 | PRJNA942359_P_NODE_13057_length_253_cov_0.866667_g12942_i0 | PRJNA942359 | 13057 | 253 | 0.866667 | 2.19266751 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 130 | 1.54e-33 | NR | MBC7875527.1 | 2073117 | g12942 | i0 | 78.3 | 1.96837944664032 | 83 | 17 | 98.4 | 1 | 3 | 251 | 354 | 435 | MBC7875527.1 hypothetical protein [Anaerolineales bacterium] | diamond | 498 | 130 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 31921775 | 31921775 | PRJNA942359_P_NODE_12977_length_253_cov_0.866667_g12862_i0 | PRJNA942359 | 12977 | 253 | 0.866667 | 2.19266751 | Roseiflexaceae bacterium | 2762507 | Bacteria | Bacteria | 152 | 1.01e-41 | NR | MDZ4719714.1 | 2762507 | g12862 | i0 | 89.2 | 1.96837944664032 | 83 | 9 | 98.4 | 0 | 3 | 251 | 286 | 368 | MDZ4719714.1 sugar ABC transporter ATP-binding protein [Roseiflexaceae bacterium] | diamond | 498 | 152 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 32459807 | 32459807 | PRJNA942359_P_NODE_13039_length_253_cov_0.866667_g12924_i0 | PRJNA942359 | 13039 | 253 | 0.866667 | 2.19266751 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 151 | 1.1099999999999999e-43 | NR | MCH8281813.1 | 2026724 | g12924 | i0 | 78.3 | 1.96837944664032 | 83 | 18 | 98.4 | 0 | 249 | 1 | 1 | 83 | MCH8281813.1 iron-containing redox enzyme family protein [Chloroflexota bacterium] | diamond | 498 | 151 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32586353 | 32586353 | PRJNA942359_P_NODE_17599_length_246_cov_0.901734_g17484_i0 | PRJNA942359 | 17599 | 246 | 0.901734 | 2.21826564 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 99.4 | 1.86e-22 | NR | HEY0603028.1 | 2720503 | g17484 | i0 | 66.7 | 0.98780487804878 | 81 | 27 | 98.8 | 0 | 2 | 244 | 46 | 126 | HEY0603028.1 transposase [Herpetosiphonaceae bacterium] | diamond | 243 | 99.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 32844809 | 32844809 | PRJNA942359_P_NODE_13480_length_252_cov_1.430168_g13365_i0 | PRJNA942359 | 13480 | 252 | 1.430168 | 3.60402336 | Bacteria | 2 | Bacteria | Bacteria | 58.2 | 2.91e-8 | NR | MCI0399046.1 | 2026724 | g13365 | i0 | 78.1 | 1.16666666666667 | 32 | 7 | 38.1 | 0 | 155 | 250 | 1 | 32 | MCI0399046.1 cold shock domain-containing protein [Chloroflexota bacterium] | diamond | 294 | 58.2 | 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);;