contig_metadata
23 rows where bioproject = "PRJEB2925", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1300364 | 1300364 | PRJEB2925_P_NODE_16422_length_242_cov_2.125604_g15144_i0 | PRJEB2925 | 16422 | 242 | 2.125604 | 5.14396168 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 111 | 1.14e-28 | NR | MBA2518035.1 | 2448782 | g15144 | i0 | 65.8 | 0.979338842975207 | 79 | 27 | 97.9 | 0 | 2 | 238 | 60 | 138 | MBA2518035.1 TetR/AcrR family transcriptional regulator [Chloroflexia bacterium] | diamond | 237 | 111 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 5128467 | 5128467 | PRJEB2925_P_NODE_15545_length_254_cov_1.232877_g14267_i0 | PRJEB2925 | 15545 | 254 | 1.232877 | 3.13150758 | Litorilinea aerophila | 1204385 | Bacteria | Bacteria | 327 | 3.42e-85 | NTclustered | gi|393193706|gb|JQ733906.1| | 1204385 | g14267 | i0 | 90.119 | 117.803149606299 | 253 | 23 | 99 | 2 | 3 | 254 | 3725 | 3474 | Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence | blastn | 29922 | 327 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Litorilinea | Litorilinea aerophila | ||
| 9916244 | 9916244 | PRJEB2925_P_NODE_14188_length_272_cov_2.400844_g12910_i0 | PRJEB2925 | 14188 | 272 | 2.400844 | 6.53029568 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 159 | 1.0699999999999999e-43 | NR | MDP9375399.1 | 2026724 | g12910 | i0 | 90 | 1.98529411764706 | 90 | 9 | 99.3 | 0 | 270 | 1 | 303 | 392 | MDP9375399.1 FAD-dependent oxidoreductase [Chloroflexota bacterium] | diamond | 540 | 159 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 12779652 | 12779652 | PRJEB2925_P_NODE_15771_length_251_cov_1.296296_g14493_i0 | PRJEB2925 | 15771 | 251 | 1.296296 | 3.25370296 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 161 | 1.46e-44 | NR | MDP9370997.1 | 2026724 | g14493 | i0 | 96.3 | 3.93227091633466 | 81 | 3 | 96.8 | 0 | 247 | 5 | 393 | 473 | MDP9370997.1 threonine--tRNA ligase [Chloroflexota bacterium] | diamond | 987 | 161 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 16290748 | 16290748 | PRJEB2925_P_NODE_15133_length_259_cov_4.223214_g13855_i0 | PRJEB2925 | 15133 | 259 | 4.223214 | 10.93812426 | Bacillati | 1783272 | Bacteria | Bacteria | 106 | 1.79e-18 | NTclustered | gi|470481958|ref|NR_076505.1| | 357808 | g13855 | i0 | 86.735 | 183.803088803089 | 98 | 9 | 37 | 4 | 51 | 146 | 249 | 154 | Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence | blastn | 47605 | 106 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexus | Roseiflexus sp. RS-1 | ||
| 16602893 | 16602893 | PRJEB2925_P_NODE_15334_length_257_cov_1.441441_g14056_i0 | PRJEB2925 | 15334 | 257 | 1.441441 | 3.70450337 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 72 | 6.71e-13 | NR | MBV8085423.1 | 2026724 | g14056 | i0 | 73.9 | 0.536964980544747 | 46 | 12 | 53.7 | 0 | 118 | 255 | 1 | 46 | MBV8085423.1 CehA/McbA family metallohydrolase [Chloroflexota bacterium] | diamond | 138 | 72 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 20426804 | 20426804 | PRJEB2925_P_NODE_16337_length_243_cov_3.264423_g15059_i0 | PRJEB2925 | 16337 | 243 | 3.264423 | 7.93254789 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 104 | 5.96e-18 | NTclustered | gi|2874254132|emb|OY970217.1| | 1672391 | g15059 | i0 | 91.026 | 7.77366255144033 | 78 | 6 | 32 | 1 | 1 | 78 | 3523522 | 3523598 | MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1 | blastn | 1889 | 104 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 22978026 | 22978026 | PRJEB2925_P_NODE_11359_length_328_cov_2.017065_g10084_i0 | PRJEB2925 | 11359 | 328 | 2.017065 | 6.6159732 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 176 | 1.71e-53 | NR | MDP9310114.1 | 2026724 | g10084 | i0 | 76.1 | 1.99390243902439 | 109 | 26 | 99.7 | 0 | 327 | 1 | 10 | 118 | MDP9310114.1 AAA family ATPase [Chloroflexota bacterium] | diamond | 654 | 176 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 22978029 | 22978029 | PRJEB2925_P_NODE_11579_length_323_cov_1.000000_g10304_i0 | PRJEB2925 | 11579 | 323 | 1 | 3.23 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 154 | 1.8199999999999998e-43 | NR | RIK38072.1 | 2026724 | g10304 | i0 | 67.3 | 0.993808049535604 | 107 | 35 | 99.4 | 0 | 1 | 321 | 105 | 211 | RIK38072.1 MAG: iron ABC transporter permease [Chloroflexota bacterium] | diamond | 321 | 154 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 22978062 | 22978062 | PRJEB2925_P_NODE_14139_length_273_cov_1.844538_g12861_i0 | PRJEB2925 | 14139 | 273 | 1.844538 | 5.03558874 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 102 | 2.45e-17 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g12861 | i0 | 84.259 | 1.66666666666667 | 108 | 13 | 39 | 4 | 1 | 107 | 1333838 | 1333734 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 455 | 102 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 26811766 | 26811766 | PRJEB2925_P_NODE_15541_length_254_cov_1.315068_g14263_i0 | PRJEB2925 | 15541 | 254 | 1.315068 | 3.34027272 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 57.8 | 7.56e-8 | NR | TME31709.1 | 2026724 | g14263 | i0 | 57.1 | 0.496062992125984 | 42 | 18 | 49.6 | 0 | 128 | 253 | 18 | 59 | TME31709.1 MAG: methyltransferase domain-containing protein, partial [Chloroflexota bacterium] | diamond | 126 | 57.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27184633 | 27184633 | PRJEB2925_P_NODE_16282_length_244_cov_2.086124_g15004_i0 | PRJEB2925 | 16282 | 244 | 2.086124 | 5.09014256 | Bacillati | 1783272 | Bacteria | Bacteria | 63.2 | 2.38e-9 | NR | MCB9418910.1 | 2614247 | g15004 | i0 | 64.2 | 1.84426229508197 | 53 | 14 | 59 | 1 | 244 | 101 | 464 | 516 | MCB9418910.1 alpha/beta hydrolase [Ardenticatenaceae bacterium] | diamond | 450 | 63.2 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Ardenticatenales | Ardenticatenaceae | Ardenticatenaceae bacterium | |||
| 27381098 | 27381098 | PRJEB2925_P_NODE_16063_length_247_cov_1.891509_g14785_i0 | PRJEB2925 | 16063 | 247 | 1.891509 | 4.67202723 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 44.7 | 0.00285 | NR | HEX6605921.1 | 2448782 | g14785 | i0 | 67.9 | 0.668016194331984 | 28 | 9 | 34 | 0 | 246 | 163 | 78 | 105 | HEX6605921.1 VOC family protein [Chloroflexia bacterium] | diamond | 165 | 44.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 27697035 | 27697035 | PRJEB2925_P_NODE_13884_length_277_cov_1.169421_g12606_i0 | PRJEB2925 | 13884 | 277 | 1.169421 | 3.23929617 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 153 | 1.7799999999999994e-42 | NR | HEY7293479.1 | 2026734 | g12606 | i0 | 83.7 | 2.98916967509025 | 92 | 15 | 99.6 | 0 | 1 | 276 | 150 | 241 | HEY7293479.1 hypothetical protein [Dehalococcoidia bacterium] | diamond | 828 | 153 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 28801583 | 28801583 | PRJEB2925_P_NODE_7708_length_452_cov_1.868106_g6505_i0 | PRJEB2925 | 7708 | 452 | 1.868106 | 8.44383912 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 171 | 7.28e-48 | NR | MCB0095845.1 | 2614250 | g6505 | i0 | 60.4 | 0.988938053097345 | 149 | 56 | 97.6 | 3 | 442 | 2 | 11 | 158 | MCB0095845.1 TraM recognition domain-containing protein [Caldilineaceae bacterium] | diamond | 447 | 171 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 29528057 | 29528057 | PRJEB2925_P_NODE_16150_length_246_cov_1.625592_g14872_i0 | PRJEB2925 | 16150 | 246 | 1.625592 | 3.99895632 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 126 | 3.18e-32 | NR | HOU11745.1 | 2052143 | g14872 | i0 | 70.4 | 6.91463414634146 | 81 | 24 | 98.8 | 0 | 244 | 2 | 331 | 411 | HOU11745.1 sulfatase [Anaerolineae bacterium] | diamond | 1701 | 126 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29748713 | 29748713 | PRJEB2925_P_NODE_711_length_4157_cov_5.362931_g541_i0 | PRJEB2925 | 711 | 4157 | 5.362931 | 222.93704167 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 293 | 1.05e-84 | NR | MDP9374897.1 | 2026724 | g541 | i0 | 48.2 | 0.26052441664662 | 361 | 170 | 25.2 | 4 | 2989 | 4035 | 11 | 366 | MDP9374897.1 protein rep [Chloroflexota bacterium] | diamond | 1083 | 293 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31859852 | 31859852 | PRJEB2925_P_NODE_11537_length_324_cov_1.384083_g10262_i0 | PRJEB2925 | 11537 | 324 | 1.384083 | 4.48442892 | Bacteria | 2 | Bacteria | Bacteria | 188 | 5.3800000000000006e-58 | NR | MFN8515805.1 | 2448782 | g10262 | i0 | 97.9 | 1.78703703703704 | 97 | 2 | 89.8 | 0 | 323 | 33 | 132 | 228 | MFN8515805.1 response regulator transcription factor [Chloroflexia bacterium] | diamond | 579 | 188 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 31859853 | 31859853 | PRJEB2925_P_NODE_13037_length_292_cov_1.712062_g11760_i0 | PRJEB2925 | 13037 | 292 | 1.712062 | 4.99922104 | Bacteria | 2 | Bacteria | Bacteria | 181 | 3.72e-51 | NR | MFN8513264.1 | 2448782 | g11760 | i0 | 85.4 | 1.97260273972603 | 96 | 14 | 98.6 | 0 | 290 | 3 | 563 | 658 | MFN8513264.1 hypothetical protein [Chloroflexia bacterium] | diamond | 576 | 181 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 31993057 | 31993057 | PRJEB2925_P_NODE_15418_length_256_cov_1.266968_g14140_i0 | PRJEB2925 | 15418 | 256 | 1.266968 | 3.24343808 | Chloroflexales bacterium | 2725990 | Bacteria | Bacteria | 130 | 3.8e-33 | NR | MBC8075354.1 | 2725990 | g14140 | i0 | 72.9 | 0.99609375 | 85 | 23 | 99.6 | 0 | 256 | 2 | 261 | 345 | MBC8075354.1 hypothetical protein [Chloroflexales bacterium] | diamond | 255 | 130 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexales bacterium | ||||
| 32049806 | 32049806 | PRJEB2925_P_NODE_13858_length_277_cov_2.041322_g12580_i0 | PRJEB2925 | 13858 | 277 | 2.041322 | 5.65446194 | Ktedonosporobacter | 2692417 | Bacteria | Bacteria | 89 | 1.81e-20 | NR | MBV9792236.1 | 2026724 | g12580 | i0 | 56 | 2.72924187725632 | 91 | 35 | 97.5 | 2 | 270 | 1 | 18 | 104 | MBV9792236.1 acyltransferase family protein [Chloroflexota bacterium] | diamond | 756 | 89 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32214612 | 32214612 | PRJEB2925_P_NODE_14958_length_262_cov_1.233480_g13680_i0 | PRJEB2925 | 14958 | 262 | 1.23348 | 3.2317176 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 92.8 | 5.86e-20 | NR | MDP9372867.1 | 2026724 | g13680 | i0 | 73.7 | 1.24809160305344 | 57 | 15 | 65.3 | 0 | 6 | 176 | 339 | 395 | MDP9372867.1 CoA transferase [Chloroflexota bacterium] | diamond | 327 | 92.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32499566 | 32499566 | PRJEB2925_P_NODE_15619_length_253_cov_1.467890_g14341_i0 | PRJEB2925 | 15619 | 253 | 1.46789 | 3.7137617 | Ktedonobacterales bacterium | 2306968 | Bacteria | Bacteria | 90.5 | 6.74e-19 | NR | HEY7984741.1 | 2306968 | g14341 | i0 | 54.8 | 2.96442687747036 | 84 | 36 | 99.6 | 1 | 252 | 1 | 620 | 701 | HEY7984741.1 galactose oxidase-like domain-containing protein [Ktedonobacterales bacterium] | diamond | 750 | 90.5 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacterales 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);;