contig_metadata
21 rows where bioproject = "PRJNA540466", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6222082 | 6222082 | PRJNA540466_S_NODE_52625_length_259_cov_1.161290_g52076_i0 | PRJNA540466 | 52625 | 259 | 1.16129 | 3.0077411 | Chloroflexota | 200795 | Bacteria | Bacteria | 228 | 3.649999999999999e-55 | NTclustered | gi|2874253788|emb|OY969772.1| | 1672391 | g52076 | i0 | 84.519 | 663.409266409266 | 239 | 28 | 91 | 7 | 1 | 235 | 670146 | 670379 | MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1 | blastn | 171823 | 228 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 10712154 | 10712154 | PRJNA540466_S_NODE_42109_length_284_cov_1.056872_g41560_i0 | PRJNA540466 | 42109 | 284 | 1.056872 | 3.00151648 | Bacillati | 1783272 | Bacteria | Bacteria | 80.1 | 1.67e-17 | NR | WP_012258253.1 | 1107 | g41560 | i0 | 92.7 | 9.09507042253521 | 41 | 3 | 43.3 | 0 | 1 | 123 | 33 | 73 | WP_012258253.1 MULTISPECIES: translation initiation factor IF-1 [Chloroflexus] | diamond | 2583 | 80.5 | 0.995031055900621 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexus | |||
| 26666046 | 26666046 | PRJNA540466_S_NODE_46941_length_271_cov_1.787879_g46392_i0 | PRJNA540466 | 46941 | 271 | 1.787879 | 4.84515209 | Ardenticatenaceae bacterium | 2614247 | Bacteria | Bacteria | 89.7 | 1.66e-20 | NR | MCZ7571880.1 | 2614247 | g46392 | i0 | 63.4 | 1.53874538745387 | 71 | 25 | 78.6 | 1 | 268 | 56 | 75 | 144 | MCZ7571880.1 CBS domain-containing protein [Ardenticatenaceae bacterium] | diamond | 417 | 89.7 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Ardenticatenales | Ardenticatenaceae | Ardenticatenaceae bacterium | |||
| 26697871 | 26697871 | PRJNA540466_S_NODE_43921_length_279_cov_1.126214_g43372_i0 | PRJNA540466 | 43921 | 279 | 1.126214 | 3.14213706 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 69.3 | 2.43e-11 | NR | MFL5735690.1 | 2448782 | g43372 | i0 | 39 | 1.73118279569892 | 82 | 50 | 88.2 | 0 | 274 | 29 | 376 | 457 | MFL5735690.1 aminoglycoside phosphotransferase family protein [Chloroflexia bacterium] | diamond | 483 | 69.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 27678366 | 27678366 | PRJNA540466_S_NODE_35284_length_306_cov_1.987124_g34735_i0 | PRJNA540466 | 35284 | 306 | 1.987124 | 6.08059944 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 65.1 | 1.05e-9 | NR | MBX3051894.1 | 2614250 | g34735 | i0 | 53.6 | 1.63725490196078 | 56 | 26 | 54.9 | 0 | 24 | 191 | 412 | 467 | MBX3051894.1 hypothetical protein [Caldilineaceae bacterium] | diamond | 501 | 65.1 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 27930691 | 27930691 | PRJNA540466_S_NODE_71805_length_202_cov_4.271318_g71256_i0 | PRJNA540466 | 71805 | 202 | 4.271318 | 8.62806236 | Ardenticatenales bacterium | 2614248 | Bacteria | Bacteria | 45.1 | 0.00335 | NR | MCB8951558.1 | 2614248 | g71256 | i0 | 72.4 | 1.69306930693069 | 29 | 8 | 43.1 | 0 | 166 | 80 | 470 | 498 | MCB8951558.1 extracellular solute-binding protein [Ardenticatenales bacterium] | diamond | 342 | 45.1 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Ardenticatenales | Ardenticatenales bacterium | ||||
| 28056837 | 28056837 | PRJNA540466_S_NODE_48665_length_267_cov_1.963918_g48116_i0 | PRJNA540466 | 48665 | 267 | 1.963918 | 5.24366106 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 108 | 4.91e-26 | NR | MDQ5851343.1 | 2026724 | g48116 | i0 | 59.3 | 0.910112359550562 | 81 | 33 | 91 | 0 | 1 | 243 | 192 | 272 | MDQ5851343.1 Rieske (2Fe-2S) protein [Chloroflexota bacterium] | diamond | 243 | 108 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28324363 | 28324363 | PRJNA540466_S_NODE_54806_length_254_cov_4.298343_g54257_i0 | PRJNA540466 | 54806 | 254 | 4.298343 | 10.91779122 | Bacteria | 2 | Bacteria | Bacteria | 103 | 2.4e-24 | NR | MDQ4074842.1 | 2026724 | g54257 | i0 | 57.3 | 2.65748031496063 | 75 | 32 | 88.6 | 0 | 2 | 226 | 123 | 197 | MDQ4074842.1 class I SAM-dependent methyltransferase [Chloroflexota bacterium] | diamond | 675 | 103 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28657021 | 28657021 | PRJNA540466_S_NODE_67547_length_230_cov_2.554140_g66998_i0 | PRJNA540466 | 67547 | 230 | 2.55414 | 5.874522 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 58.2 | 1.16e-7 | NR | MDA1129087.1 | 2026724 | g66998 | i0 | 61.4 | 1.72173913043478 | 44 | 17 | 57.4 | 0 | 62 | 193 | 385 | 428 | MDA1129087.1 M1 family metallopeptidase [Chloroflexota bacterium] | diamond | 396 | 58.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28751559 | 28751559 | PRJNA540466_S_NODE_32287_length_318_cov_1.853061_g31738_i0 | PRJNA540466 | 32287 | 318 | 1.853061 | 5.89273398 | Ardenticatenaceae bacterium | 2614247 | Bacteria | Bacteria | 72.4 | 1.05e-13 | NR | MCB9430965.1 | 2614247 | g31738 | i0 | 51.5 | 1.29245283018868 | 68 | 33 | 64.2 | 0 | 287 | 84 | 59 | 126 | MCB9430965.1 profilin [Ardenticatenaceae bacterium] | diamond | 411 | 72.4 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Ardenticatenales | Ardenticatenaceae | Ardenticatenaceae bacterium | |||
| 28782986 | 28782986 | PRJNA540466_S_NODE_20067_length_395_cov_1.798137_g19518_i0 | PRJNA540466 | 20067 | 395 | 1.798137 | 7.10264115 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 92.8 | 1.63e-19 | NR | HSJ56786.1 | 2052143 | g19518 | i0 | 54.7 | 1.86835443037975 | 86 | 37 | 65.3 | 1 | 17 | 274 | 156 | 239 | HSJ56786.1 hypothetical protein [Anaerolineae bacterium] | diamond | 738 | 92.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28972751 | 28972751 | PRJNA540466_S_NODE_71988_length_200_cov_9.472441_g71439_i0 | PRJNA540466 | 71988 | 200 | 9.472441 | 18.944882 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 70.9 | 2.54e-12 | NR | MBL8162772.1 | 2052143 | g71439 | i0 | 58.3 | 0.9 | 60 | 25 | 90 | 0 | 19 | 198 | 28 | 87 | MBL8162772.1 iron ABC transporter permease [Anaerolineae bacterium] | diamond | 180 | 70.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29208689 | 29208689 | PRJNA540466_S_NODE_19849_length_397_cov_1.712963_g19300_i0 | PRJNA540466 | 19849 | 397 | 1.712963 | 6.80046311 | Bacteria | 2 | Bacteria | Bacteria | 183 | 2.8299999999999997e-56 | NR | MBW3631976.1 | 2026724 | g19300 | i0 | 80.2 | 6.86901763224181 | 101 | 20 | 76.3 | 0 | 381 | 79 | 11 | 111 | MBW3631976.1 DUF402 domain-containing protein [Chloroflexota bacterium] | diamond | 2727 | 184 | 0.994565217391304 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29587100 | 29587100 | PRJNA540466_S_NODE_50030_length_264_cov_1.989529_g49481_i0 | PRJNA540466 | 50030 | 264 | 1.989529 | 5.25235656 | root | 1 | Root_unresolved | Root_unresolved | 73.6 | 4.37e-13 | NR | HWP28168.1 | 2026724 | g49481 | i0 | 40.7 | 4.61363636363636 | 81 | 41 | 84.1 | 1 | 38 | 259 | 182 | 262 | HWP28168.1 multicopper oxidase domain-containing protein [Chloroflexota bacterium] | diamond | 1218 | 73.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30836114 | 30836114 | PRJNA540466_S_NODE_30414_length_326_cov_5.146245_g29865_i0 | PRJNA540466 | 30414 | 326 | 5.146245 | 16.7767587 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 87.4 | 1.97e-17 | NR | MBA3868902.1 | 2052143 | g29865 | i0 | 75.5 | 0.487730061349693 | 53 | 13 | 48.8 | 0 | 74 | 232 | 34 | 86 | MBA3868902.1 HAMP domain-containing histidine kinase [Anaerolineae bacterium] | diamond | 159 | 87.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31025811 | 31025811 | PRJNA540466_S_NODE_61135_length_245_cov_1.343023_g60586_i0 | PRJNA540466 | 61135 | 245 | 1.343023 | 3.29040635 | Chloroflexales bacterium | 2725990 | Bacteria | Bacteria | 74.3 | 1.16e-13 | NR | MCG8353079.1 | 2725990 | g60586 | i0 | 48.6 | 0.906122448979592 | 74 | 38 | 90.6 | 0 | 232 | 11 | 205 | 278 | MCG8353079.1 DMT family transporter [Chloroflexales bacterium] | diamond | 222 | 74.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexales bacterium | ||||
| 31214855 | 31214855 | PRJNA540466_S_NODE_59015_length_248_cov_1.160000_g58466_i0 | PRJNA540466 | 59015 | 248 | 1.16 | 2.8768 | Ardenticatenaceae bacterium | 2614247 | Bacteria | Bacteria | 137 | 5.63e-36 | NR | HEX8683536.1 | 2614247 | g58466 | i0 | 76.8 | 0.991935483870968 | 82 | 19 | 99.2 | 0 | 2 | 247 | 454 | 535 | HEX8683536.1 M14 family metallopeptidase [Ardenticatenaceae bacterium] | diamond | 246 | 137 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Ardenticatenales | Ardenticatenaceae | Ardenticatenaceae bacterium | |||
| 31483449 | 31483449 | PRJNA540466_S_NODE_42596_length_282_cov_3.296651_g42047_i0 | PRJNA540466 | 42596 | 282 | 3.296651 | 9.29655582 | PVC group | 1783257 | Bacteria | Bacteria | 55.5 | 4.19e-7 | NR | MCC7447236.1 | 2052143 | g42047 | i0 | 53.2 | 3.86170212765957 | 47 | 22 | 50 | 0 | 2 | 142 | 100 | 146 | MCC7447236.1 NADAR family protein [Anaerolineae bacterium] | diamond | 1089 | 55.8 | 0.99462365591397806 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31626384 | 31626384 | PRJNA540466_S_NODE_21296_length_384_cov_2.990354_g20747_i0 | PRJNA540466 | 21296 | 384 | 2.990354 | 11.48295936 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 112 | 1.99e-28 | NR | MEO1289767.1 | 2026724 | g20747 | i0 | 73.4 | 2.5546875 | 64 | 17 | 50 | 0 | 378 | 187 | 103 | 166 | MEO1289767.1 DUF427 domain-containing protein [Chloroflexota bacterium] | diamond | 981 | 112 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31657874 | 31657874 | PRJNA540466_S_NODE_46037_length_273_cov_2.365000_g45488_i0 | PRJNA540466 | 46037 | 273 | 2.365 | 6.45645 | Ardenticatenales bacterium | 2614248 | Bacteria | Bacteria | 64.3 | 1.03e-10 | NR | MEO8084589.1 | 2614248 | g45488 | i0 | 37.2 | 0.945054945054945 | 86 | 53 | 93.4 | 1 | 18 | 272 | 45 | 130 | MEO8084589.1 ML domain-containing protein [Ardenticatenales bacterium] | diamond | 258 | 64.3 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Ardenticatenales | Ardenticatenales bacterium | ||||
| 31752904 | 31752904 | PRJNA540466_S_NODE_47157_length_270_cov_3.868020_g46608_i0 | PRJNA540466 | 47157 | 270 | 3.86802 | 10.443654 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 59.3 | 7.37e-8 | NR | MDP9316185.1 | 2026724 | g46608 | i0 | 48.3 | 1.33333333333333 | 60 | 31 | 66.7 | 0 | 239 | 60 | 146 | 205 | MDP9316185.1 peptide ABC transporter substrate-binding protein [Chloroflexota bacterium] | diamond | 360 | 59.3 | 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);;