contig_metadata
17 rows where bioproject = "PRJNA781196", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14787881 | 14787881 | PRJNA781196_P_NODE_36192_length_295_cov_1.945946_g35815_i0 | PRJNA781196 | 36192 | 295 | 1.945946 | 5.7405407 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 195 | 4.3e-45 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g35815 | i0 | 80.916 | 1.77627118644068 | 262 | 37 | 86 | 9 | 41 | 295 | 274305 | 274560 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 524 | 195 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 27558850 | 27558850 | PRJNA781196_P_NODE_24064_length_350_cov_1.126354_g23687_i0 | PRJNA781196 | 24064 | 350 | 1.126354 | 3.942239 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 168 | 9.03e-46 | NR | UCH60768.1 | 2073117 | g23687 | i0 | 67.9 | 7.68857142857143 | 112 | 36 | 96 | 0 | 348 | 13 | 703 | 814 | UCH60768.1 MAG: aldehyde dehydrogenase family protein [Anaerolineales bacterium] | diamond | 2691 | 168 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28411651 | 28411651 | PRJNA781196_P_NODE_29746_length_321_cov_1.689516_g29369_i0 | PRJNA781196 | 29746 | 321 | 1.689516 | 5.42334636 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 129 | 3.25e-35 | NR | MBN1317765.1 | 2073117 | g29369 | i0 | 63.7 | 0.850467289719626 | 91 | 31 | 85 | 1 | 2 | 274 | 96 | 184 | MBN1317765.1 hypoxanthine phosphoribosyltransferase [Anaerolineales bacterium] | diamond | 273 | 129 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28916485 | 28916485 | PRJNA781196_P_NODE_32108_length_311_cov_1.252101_g31731_i0 | PRJNA781196 | 32108 | 311 | 1.252101 | 3.89403411 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 74.7 | 8.27e-14 | NR | MEW5941887.1 | 2026724 | g31731 | i0 | 40.6 | 1.9967845659164 | 96 | 54 | 92.6 | 2 | 299 | 12 | 67 | 159 | MEW5941887.1 hypothetical protein [Chloroflexota bacterium] | diamond | 621 | 74.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29201068 | 29201068 | PRJNA781196_P_NODE_43829_length_270_cov_1.817259_g43452_i0 | PRJNA781196 | 43829 | 270 | 1.817259 | 4.9065993 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 80.9 | 1.89e-15 | NR | MFM2032208.1 | 2026724 | g43452 | i0 | 42 | 3.9 | 88 | 50 | 97.8 | 1 | 269 | 6 | 326 | 412 | MFM2032208.1 hypothetical protein [Chloroflexota bacterium] | diamond | 1053 | 80.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29358857 | 29358857 | PRJNA781196_P_NODE_62989_length_244_cov_1.818713_g62612_i0 | PRJNA781196 | 62989 | 244 | 1.818713 | 4.43765972 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 43.1 | 0.0262 | NR | TET97323.1 | 2026734 | g62612 | i0 | 41.7 | 1.47540983606557 | 60 | 29 | 66.4 | 1 | 197 | 36 | 342 | 401 | TET97323.1 MAG: CoA transferase [Dehalococcoidia bacterium] | diamond | 360 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 29484798 | 29484798 | PRJNA781196_P_NODE_60290_length_246_cov_0.901734_g59913_i0 | PRJNA781196 | 60290 | 246 | 0.901734 | 2.21826564 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 43.5 | 0.0204 | NR | MFN2196847.1 | 2073117 | g59913 | i0 | 29.2 | 0.792682926829268 | 65 | 32 | 73.2 | 2 | 232 | 53 | 191 | 246 | MFN2196847.1 beta-galactosidase [Anaerolineales bacterium] | diamond | 195 | 43.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 29557436 | 29557436 | PRJNA781196_P_NODE_62030_length_245_cov_0.906977_g61653_i0 | PRJNA781196 | 62030 | 245 | 0.906977 | 2.22209365 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 57.4 | 2.57e-7 | NR | MBM3120076.1 | 2026724 | g61653 | i0 | 40.5 | 3.79591836734694 | 79 | 37 | 96.7 | 1 | 238 | 2 | 179 | 247 | MBM3120076.1 DUF1073 domain-containing protein [Chloroflexota bacterium] | diamond | 930 | 57.8 | 0.993079584775087 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29579508 | 29579508 | PRJNA781196_P_NODE_20250_length_376_cov_0.891089_g19873_i0 | PRJNA781196 | 20250 | 376 | 0.891089 | 3.35049464 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 44.3 | 0.0253 | NR | TET74592.1 | 2026734 | g19873 | i0 | 32.5 | 0.638297872340426 | 80 | 50 | 63.8 | 1 | 322 | 83 | 49 | 124 | TET74592.1 MAG: hypothetical protein E3J42_04935 [Dehalococcoidia bacterium] | diamond | 240 | 44.3 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 29958727 | 29958727 | PRJNA781196_P_NODE_52131_length_252_cov_0.871508_g51754_i0 | PRJNA781196 | 52131 | 252 | 0.871508 | 2.19620016 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 96.3 | 9.49e-23 | NR | HKZ84559.1 | 2052143 | g51754 | i0 | 57.1 | 1 | 84 | 36 | 100 | 0 | 252 | 1 | 33 | 116 | HKZ84559.1 Uma2 family endonuclease [Anaerolineae bacterium] | diamond | 252 | 96.3 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30843523 | 30843523 | PRJNA781196_P_NODE_53474_length_251_cov_0.876404_g53097_i0 | PRJNA781196 | 53474 | 251 | 0.876404 | 2.19977404 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 92.4 | 3.05e-21 | NR | MBT3336464.1 | 2052143 | g53097 | i0 | 52.4 | 6.75298804780877 | 82 | 39 | 98 | 0 | 5 | 250 | 47 | 128 | MBT3336464.1 NUDIX hydrolase [Anaerolineae bacterium] | diamond | 1695 | 92.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31222321 | 31222321 | PRJNA781196_P_NODE_17315_length_401_cov_1.039634_g16938_i0 | PRJNA781196 | 17315 | 401 | 1.039634 | 4.16893234 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 55.5 | 6.07e-6 | NR | MBN2547678.1 | 2073117 | g16938 | i0 | 30.1 | 0.770573566084788 | 103 | 64 | 77.1 | 2 | 399 | 91 | 195 | 289 | MBN2547678.1 SAM-dependent methyltransferase [Anaerolineales bacterium] | diamond | 309 | 55.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 31665260 | 31665260 | PRJNA781196_P_NODE_31257_length_314_cov_1.941909_g30880_i0 | PRJNA781196 | 31257 | 314 | 1.941909 | 6.09759426 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 54.3 | 7.65e-6 | NR | MFN8470933.1 | 2052143 | g30880 | i0 | 37.1 | 1.0031847133758 | 105 | 62 | 98.4 | 3 | 309 | 1 | 36 | 138 | MFN8470933.1 heavy metal translocating P-type ATPase [Anaerolineae bacterium] | diamond | 315 | 54.3 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31864356 | 31864356 | PRJNA781196_P_NODE_57097_length_248_cov_1.337143_g56720_i0 | PRJNA781196 | 57097 | 248 | 1.337143 | 3.31611464 | Bacteria | 2 | Bacteria | Bacteria | 57.4 | 2.69e-7 | NR | MCB0032951.1 | 2073117 | g56720 | i0 | 40.4 | 6.03629032258065 | 89 | 42 | 95.6 | 3 | 1 | 237 | 243 | 330 | MCB0032951.1 vanadium-dependent haloperoxidase [Anaerolineales bacterium] | diamond | 1497 | 57.8 | 0.993079584775087 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32013375 | 32013375 | PRJNA781196_P_NODE_49438_length_254_cov_1.292818_g49061_i0 | PRJNA781196 | 49438 | 254 | 1.292818 | 3.28375772 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 44.3 | 0.0118 | NR | HLO34209.1 | 2073117 | g49061 | i0 | 37.3 | 0.791338582677165 | 67 | 37 | 79.1 | 1 | 33 | 233 | 340 | 401 | HLO34209.1 ferric reductase-like transmembrane domain-containing protein [Anaerolineales bacterium] | diamond | 201 | 44.3 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32076641 | 32076641 | PRJNA781196_P_NODE_24158_length_349_cov_1.695652_g23781_i0 | PRJNA781196 | 24158 | 349 | 1.695652 | 5.91782548 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 93.2 | 2.67e-19 | NR | MDZ4278680.1 | 2026734 | g23781 | i0 | 48.2 | 0.962750716332378 | 112 | 54 | 95.4 | 3 | 345 | 13 | 161 | 269 | MDZ4278680.1 flexitail domain-containing putative surface protein [Dehalococcoidia bacterium] | diamond | 336 | 93.2 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 32875494 | 32875494 | PRJNA781196_P_NODE_19940_length_378_cov_1.531148_g19563_i0 | PRJNA781196 | 19940 | 378 | 1.531148 | 5.78773944 | Bacillati | 1783272 | Bacteria | Bacteria | 76.6 | 6.3e-14 | NR | UCF61233.1 | 2024896 | g19563 | i0 | 49.4 | 6.83333333333333 | 87 | 34 | 69 | 2 | 264 | 4 | 9 | 85 | UCF61233.1 MAG: hypothetical protein JSV37_00735 [Anaerolineaceae bacterium] | diamond | 2583 | 76.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae 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);;