contig_metadata
20 rows where bioproject = "PRJNA1226487", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22011697 | 22011697 | PRJNA1226487_P_NODE_51578_length_270_cov_1.563452_g51476_i0 | PRJNA1226487 | 51578 | 270 | 1.563452 | 4.2213204 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 63.9 | 1.14e-5 | NTclustered | gi|2891482138|emb|OZ219871.1| | 2026734 | g51476 | i0 | 97.297 | 1.28888888888889 | 37 | 1 | 14 | 0 | 1 | 37 | 35778 | 35814 | MAG: Dehalococcoidia bacterium isolate adc01b0e-c114-4b94-a05b-fd73c1a39460 genome assembly, chromosome: 5 | blastn | 348 | 63.9 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 26914497 | 26914497 | PRJNA1226487_P_NODE_57262_length_261_cov_1.638298_g57160_i0 | PRJNA1226487 | 57262 | 261 | 1.638298 | 4.27595778 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 146 | 1.93e-38 | NR | HLF78640.1 | 2026734 | g57160 | i0 | 78.2 | 1 | 87 | 18 | 98.9 | 1 | 2 | 259 | 725 | 811 | HLF78640.1 transglycosylase domain-containing protein [Dehalococcoidia bacterium] | diamond | 261 | 146 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 27167398 | 27167398 | PRJNA1226487_P_NODE_45982_length_279_cov_1.495146_g45880_i0 | PRJNA1226487 | 45982 | 279 | 1.495146 | 4.17145734 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 103 | 1.2e-24 | NR | HYN75003.1 | 3047546 | g45880 | i0 | 63 | 0.989247311827957 | 92 | 34 | 98.9 | 0 | 277 | 2 | 124 | 215 | HYN75003.1 methyl-accepting chemotaxis protein [Candidatus Limnocylindria bacterium] | diamond | 276 | 103 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 27249558 | 27249558 | PRJNA1226487_P_NODE_15643_length_388_cov_35.168254_g15541_i0 | PRJNA1226487 | 15643 | 388 | 35.168254 | 136.45282552 | Bacillati | 1783272 | Bacteria | Bacteria | 52.8 | 5.84e-5 | NR | MCC7372909.1 | 2026724 | g15541 | i0 | 50 | 1.15979381443299 | 50 | 21 | 38.7 | 2 | 234 | 383 | 41 | 86 | MCC7372909.1 carbohydrate binding domain-containing protein [Chloroflexota bacterium] | diamond | 450 | 52.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27293999 | 27293999 | PRJNA1226487_P_NODE_76483_length_242_cov_1.822485_g76381_i0 | PRJNA1226487 | 76483 | 242 | 1.822485 | 4.4104137 | Tepidiformaceae bacterium | 3022862 | Bacteria | Bacteria | 70.1 | 4.64e-13 | NR | HKS91096.1 | 3022862 | g76381 | i0 | 83.3 | 0.91735537190082606 | 36 | 6 | 44.6 | 0 | 2 | 109 | 35 | 70 | HKS91096.1 (4Fe-4S)-binding protein [Tepidiformaceae bacterium] | diamond | 222 | 70.1 | 1 | Bacteria | Bacillati | Chloroflexota | Tepidiformia | Tepidiformales | Tepidiformaceae | Tepidiformaceae bacterium | |||
| 27325661 | 27325661 | PRJNA1226487_P_NODE_63923_length_251_cov_1.730337_g63821_i0 | PRJNA1226487 | 63923 | 251 | 1.730337 | 4.34314587 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 44.3 | 0.00806 | NR | MDP9366921.1 | 2026724 | g63821 | i0 | 53.1 | 0.681274900398406 | 32 | 15 | 38.2 | 0 | 154 | 249 | 3 | 34 | MDP9366921.1 J domain-containing protein [Chloroflexota bacterium] | diamond | 171 | 44.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27609927 | 27609927 | PRJNA1226487_P_NODE_76404_length_242_cov_1.822485_g76302_i0 | PRJNA1226487 | 76404 | 242 | 1.822485 | 4.4104137 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 58.5 | 9.67e-8 | NR | HSM84848.1 | 2952938 | g76302 | i0 | 92.9 | 2.71487603305785 | 28 | 2 | 34.7 | 0 | 2 | 85 | 442 | 469 | HSM84848.1 glycosyltransferase [Candidatus Limnocylindrales bacterium] | diamond | 657 | 58.5 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 27988773 | 27988773 | PRJNA1226487_P_NODE_72325_length_245_cov_1.790698_g72223_i0 | PRJNA1226487 | 72325 | 245 | 1.790698 | 4.3872101 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 63.2 | 2.69e-11 | NR | HSM86740.1 | 2952938 | g72223 | i0 | 93.9 | 0.808163265306122 | 33 | 2 | 40.4 | 0 | 1 | 99 | 15 | 47 | HSM86740.1 hypothetical protein [Candidatus Limnocylindrales bacterium] | diamond | 198 | 63.2 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 28146777 | 28146777 | PRJNA1226487_P_NODE_47185_length_277_cov_1.509804_g47083_i0 | PRJNA1226487 | 47185 | 277 | 1.509804 | 4.18215708 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 69.7 | 1.85e-11 | NR | HZO31743.1 | 2026724 | g47083 | i0 | 85.4 | 0.444043321299639 | 41 | 6 | 44.4 | 0 | 123 | 1 | 89 | 129 | HZO31743.1 ABC transporter substrate-binding protein [Chloroflexota bacterium] | diamond | 123 | 69.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29157155 | 29157155 | PRJNA1226487_P_NODE_1629_length_804_cov_5.852257_g1549_i0 | PRJNA1226487 | 1629 | 804 | 5.852257 | 47.05214628 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 150 | 6.56e-37 | NR | HTI71413.1 | 3047546 | g1549 | i0 | 38.9 | 4.76865671641791 | 262 | 144 | 93.7 | 9 | 45 | 797 | 22 | 278 | HTI71413.1 response regulator [Candidatus Limnocylindria bacterium] | diamond | 3834 | 150 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 29504183 | 29504183 | PRJNA1226487_P_NODE_42190_length_285_cov_1.452830_g42088_i0 | PRJNA1226487 | 42190 | 285 | 1.45283 | 4.1405655 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 148 | 9.5e-41 | NR | MFN8632546.1 | 2026724 | g42088 | i0 | 80.7 | 3.70526315789474 | 88 | 17 | 92.6 | 0 | 22 | 285 | 1 | 88 | MFN8632546.1 glycosyltransferase [Chloroflexota bacterium] | diamond | 1056 | 148 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29819801 | 29819801 | PRJNA1226487_P_NODE_62731_length_253_cov_1.711111_g62629_i0 | PRJNA1226487 | 62731 | 253 | 1.711111 | 4.32911083 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 100 | 5.27e-25 | NR | HZO30302.1 | 2026724 | g62629 | i0 | 71.2 | 0.782608695652174 | 66 | 19 | 78.3 | 0 | 248 | 51 | 70 | 135 | HZO30302.1 hypothetical protein [Chloroflexota bacterium] | diamond | 198 | 100 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29977925 | 29977925 | PRJNA1226487_P_NODE_77851_length_241_cov_1.833333_g77749_i0 | PRJNA1226487 | 77851 | 241 | 1.833333 | 4.41833253 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 101 | 8.939999999999999e-23 | NR | HZO29119.1 | 2026724 | g77749 | i0 | 66.2 | 0.95850622406639 | 77 | 26 | 95.9 | 0 | 239 | 9 | 560 | 636 | HZO29119.1 protein kinase [Chloroflexota bacterium] | diamond | 231 | 101 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30167379 | 30167379 | PRJNA1226487_P_NODE_77872_length_241_cov_1.833333_g77770_i0 | PRJNA1226487 | 77872 | 241 | 1.833333 | 4.41833253 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 130 | 7.56e-36 | NR | MDP8924163.1 | 2026724 | g77770 | i0 | 95.6 | 0.846473029045643 | 68 | 3 | 84.6 | 0 | 204 | 1 | 1 | 68 | MDP8924163.1 response regulator transcription factor [Chloroflexota bacterium] | diamond | 204 | 130 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30198907 | 30198907 | PRJNA1226487_P_NODE_49092_length_274_cov_1.532338_g48990_i0 | PRJNA1226487 | 49092 | 274 | 1.532338 | 4.19860612 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 161 | 4.59e-46 | NR | HSM86137.1 | 2952938 | g48990 | i0 | 86.8 | 0.996350364963504 | 91 | 12 | 99.6 | 0 | 273 | 1 | 172 | 262 | HSM86137.1 FAD-dependent oxidoreductase [Candidatus Limnocylindrales bacterium] | diamond | 273 | 161 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 30389118 | 30389118 | PRJNA1226487_P_NODE_56113_length_263_cov_1.621053_g56011_i0 | PRJNA1226487 | 56113 | 263 | 1.621053 | 4.26336939 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 86.3 | 2.19e-17 | NR | MBA2448348.1 | 2026724 | g56011 | i0 | 84.8 | 1.06083650190114 | 46 | 7 | 52.5 | 0 | 3 | 140 | 472 | 517 | MBA2448348.1 AMP-binding protein [Chloroflexota bacterium] | diamond | 279 | 86.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30609710 | 30609710 | PRJNA1226487_P_NODE_133_length_1798_cov_3.026087_g110_i0 | PRJNA1226487 | 133 | 1798 | 3.026087 | 54.40904426 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 275 | 8.72e-78 | NR | HND47414.1 | 2073117 | g110 | i0 | 41.7 | 0.6440489432703 | 386 | 213 | 63.2 | 8 | 1796 | 660 | 464 | 844 | HND47414.1 hypothetical protein [Anaerolineales bacterium] | diamond | 1158 | 275 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 30849764 | 30849764 | PRJNA1226487_P_NODE_1594_length_811_cov_2.265583_g1514_i0 | PRJNA1226487 | 1594 | 811 | 2.265583 | 18.37387813 | Bacillati | 1783272 | Bacteria | Bacteria | 46.2 | 0.00456 | NR | MEZ4511601.1 | 2026724 | g1514 | i0 | 43.1 | 0.514180024660913 | 51 | 29 | 18.9 | 0 | 1 | 153 | 1 | 51 | MEZ4511601.1 tetratricopeptide repeat protein [Chloroflexota bacterium] | diamond | 417 | 46.6 | 0.991416309012876 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31494989 | 31494989 | PRJNA1226487_P_NODE_46516_length_278_cov_1.502439_g46414_i0 | PRJNA1226487 | 46516 | 278 | 1.502439 | 4.17678042 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 134 | 7.95e-36 | NR | MCC7370421.1 | 2026724 | g46414 | i0 | 74.7 | 0.982014388489209 | 91 | 23 | 98.2 | 0 | 3 | 275 | 197 | 287 | MCC7370421.1 flippase-like domain-containing protein [Chloroflexota bacterium] | diamond | 273 | 134 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32064163 | 32064163 | PRJNA1226487_P_NODE_57998_length_260_cov_1.647059_g57896_i0 | PRJNA1226487 | 57998 | 260 | 1.647059 | 4.2823534 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 132 | 7.96e-37 | NR | HSM86242.1 | 2952938 | g57896 | i0 | 75.6 | 3.96923076923077 | 86 | 21 | 99.2 | 0 | 259 | 2 | 87 | 172 | HSM86242.1 hypothetical protein [Candidatus Limnocylindrales bacterium] | diamond | 1032 | 132 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales 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);;