contig_metadata
26 rows where bioproject = "PRJNA688931", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1944530 | 1944530 | PRJNA688931_P_NODE_29482_length_187_cov_1.434783_g29269_i0 | PRJNA688931 | 29482 | 187 | 1.434783 | 2.68304421 | Roseiflexus sp. RS-1 | 357808 | Bacteria | Bacteria | 84.2 | 5.68e-12 | NTclustered | gi|470481958|ref|NR_076505.1| | 357808 | g29269 | i0 | 81.553 | 1.6524064171123 | 103 | 17 | 55 | 1 | 83 | 185 | 294 | 194 | Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence | blastn | 309 | 84.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexus | Roseiflexus sp. RS-1 | ||
| 5006405 | 5006405 | PRJNA688931_P_NODE_32944_length_175_cov_2.253968_g32731_i0 | PRJNA688931 | 32944 | 175 | 2.253968 | 3.944444 | Chloroflexus | 1107 | Bacteria | Bacteria | 176 | 8.38e-40 | NTclustered | gi|470483916|ref|NR_076619.1| | 152260 | g32731 | i0 | 85.714 | 85.7428571428571 | 168 | 22 | 95 | 2 | 9 | 175 | 665 | 831 | Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence | blastn | 15005 | 176 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexus | Chloroflexus aggregans | ||
| 12147991 | 12147991 | PRJNA688931_P_NODE_8470_length_368_cov_3.479624_g8257_i0 | PRJNA688931 | 8470 | 368 | 3.479624 | 12.80501632 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 169 | 2.51e-51 | NR | MDO9333994.1 | 2026733 | g8257 | i0 | 94.6 | 0.75 | 92 | 4 | 74.2 | 1 | 367 | 95 | 48 | 139 | MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium] | diamond | 276 | 169 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 14697386 | 14697386 | PRJNA688931_P_NODE_20392_length_227_cov_0.870787_g20179_i0 | PRJNA688931 | 20392 | 227 | 0.870787 | 1.97668649 | Roseiflexus sp. RS-1 | 357808 | Bacteria | Bacteria | 200 | 6.819999999999998e-47 | NTclustered | gi|470481958|ref|NR_076505.1| | 357808 | g20179 | i0 | 83.478 | 8.14537444933921 | 230 | 22 | 100 | 11 | 1 | 227 | 1137 | 1353 | Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence | blastn | 1849 | 200 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexus | Roseiflexus sp. RS-1 | ||
| 14697397 | 14697397 | PRJNA688931_P_NODE_21612_length_220_cov_1.473684_g21399_i0 | PRJNA688931 | 21612 | 220 | 1.473684 | 3.2421048 | Thermosporothrix sp. COM3 | 2490863 | Bacteria | Bacteria | 272 | 1.37e-68 | NTclustered | gi|1606557374|dbj|AP019376.1| | 2490863 | g21399 | i0 | 89.189 | 162.872727272727 | 222 | 18 | 99 | 5 | 3 | 220 | 5333811 | 5333592 | Thermosporothrix sp. COM3 DNA, nearly complete genome | blastn | 35832 | 272 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Thermosporotrichaceae | Thermosporothrix | Thermosporothrix sp. COM3 | ||
| 22345880 | 22345880 | PRJNA688931_P_NODE_29898_length_185_cov_3.455882_g29685_i0 | PRJNA688931 | 29898 | 185 | 3.455882 | 6.3933817 | Herpetosiphon aurantiacus | 65 | Bacteria | Bacteria | 139 | 1.18e-28 | NTclustered | gi|159889572|gb|CP000875.1| | 316274 | g29685 | i0 | 81.006 | 0.967567567567568 | 179 | 31 | 96 | 3 | 1 | 178 | 4626783 | 4626959 | Herpetosiphon aurantiacus DSM 785, complete genome | blastn | 179 | 139 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphon | Herpetosiphon aurantiacus | ||
| 27019029 | 27019029 | PRJNA688931_P_NODE_2462_length_727_cov_3.163717_g2293_i0 | PRJNA688931 | 2462 | 727 | 3.163717 | 23.00022259 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 57.8 | 6.64e-6 | NR | MPZ48756.1 | 2026734 | g2293 | i0 | 31 | 2.34387895460798 | 187 | 118 | 77.2 | 4 | 603 | 43 | 66 | 241 | MPZ48756.1 aquaporin [Dehalococcoidia bacterium] | diamond | 1704 | 57.8 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 27283509 | 27283509 | PRJNA688931_P_NODE_2003_length_800_cov_2.840213_g1846_i0 | PRJNA688931 | 2003 | 800 | 2.840213 | 22.721704 | Bacteria | 2 | Bacteria | Bacteria | 48.1 | 0.0134 | NR | NLF66045.1 | 2026724 | g1846 | i0 | 28.7 | 1.12125 | 101 | 70 | 37.5 | 2 | 436 | 137 | 51 | 150 | NLF66045.1 hypothetical protein [Chloroflexota bacterium] | diamond | 897 | 48.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27398479 | 27398479 | PRJNA688931_P_NODE_2083_length_785_cov_3.548913_g1925_i0 | PRJNA688931 | 2083 | 785 | 3.548913 | 27.85896705 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 150 | 1.07e-40 | NR | MCK9486999.1 | 2026734 | g1925 | i0 | 39.6 | 1.6968152866242 | 227 | 129 | 86 | 4 | 16 | 690 | 4 | 224 | MCK9486999.1 aquaporin [Dehalococcoidia bacterium] | diamond | 1332 | 150 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 27524663 | 27524663 | PRJNA688931_P_NODE_34783_length_170_cov_1.256198_g34570_i0 | PRJNA688931 | 34783 | 170 | 1.256198 | 2.1355366 | Anaerolineales bacterium HSG24 | 3055600 | Bacteria | Bacteria | 45.1 | 0.00214 | NR | MDM8527564.1 | 3055600 | g34570 | i0 | 45.6 | 1.00588235294118 | 57 | 29 | 97.1 | 1 | 170 | 6 | 604 | 660 | MDM8527564.1 response regulator [Anaerolineales bacterium HSG24] | diamond | 171 | 45.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium HSG24 | ||||
| 28282201 | 28282201 | PRJNA688931_P_NODE_18166_length_241_cov_0.916667_g17953_i0 | PRJNA688931 | 18166 | 241 | 0.916667 | 2.20916747 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 85.9 | 5.65e-18 | NR | MEX2229091.1 | 2026734 | g17953 | i0 | 65.3 | 1.92946058091286 | 49 | 17 | 61 | 0 | 1 | 147 | 217 | 265 | MEX2229091.1 MIP/aquaporin family protein [Dehalococcoidia bacterium] | diamond | 465 | 85.9 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 28345549 | 28345549 | PRJNA688931_P_NODE_25526_length_202_cov_1.464052_g25313_i0 | PRJNA688931 | 25526 | 202 | 1.464052 | 2.95738504 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42 | 0.0413 | NR | MDE2885761.1 | 2026724 | g25313 | i0 | 34 | 0.742574257425743 | 50 | 27 | 74.3 | 1 | 195 | 46 | 456 | 499 | MDE2885761.1 trypsin-like peptidase domain-containing protein [Chloroflexota bacterium] | diamond | 150 | 42 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28440458 | 28440458 | PRJNA688931_P_NODE_5966_length_450_cov_1.698254_g5754_i0 | PRJNA688931 | 5966 | 450 | 1.698254 | 7.642143 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 94 | 4.91e-19 | NR | TMG21631.1 | 2026724 | g5754 | i0 | 46.2 | 1.04 | 156 | 76 | 100 | 5 | 450 | 1 | 581 | 734 | TMG21631.1 MAG: tandem-95 repeat protein [Chloroflexota bacterium] | diamond | 468 | 94 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28472033 | 28472033 | PRJNA688931_P_NODE_8126_length_377_cov_3.033537_g7913_i0 | PRJNA688931 | 8126 | 377 | 3.033537 | 11.43643449 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 69.3 | 2.5e-11 | NR | MCL4272608.1 | 2073117 | g7913 | i0 | 40.2 | 1.30503978779841 | 82 | 45 | 65.3 | 1 | 246 | 1 | 2 | 79 | MCL4272608.1 aquaporin [Anaerolineales bacterium] | diamond | 492 | 69.3 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28546813 | 28546813 | PRJNA688931_P_NODE_26087_length_200_cov_1.172185_g25874_i0 | PRJNA688931 | 26087 | 200 | 1.172185 | 2.34437 | PVC group | 1783257 | Bacteria | Bacteria | 55.5 | 6.48e-7 | NR | MCI0710930.1 | 2026724 | g25874 | i0 | 40.9 | 7.665 | 66 | 38 | 99 | 1 | 198 | 1 | 88 | 152 | MCI0710930.1 zinc-binding dehydrogenase [Chloroflexota bacterium] | diamond | 1533 | 55.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28925319 | 28925319 | PRJNA688931_P_NODE_28128_length_192_cov_1.090909_g27915_i0 | PRJNA688931 | 28128 | 192 | 1.090909 | 2.09454528 | Bacteria | 2 | Bacteria | Bacteria | 72.8 | 3.11e-13 | NR | HET9199509.1 | 2026734 | g27915 | i0 | 52.4 | 5.890625 | 63 | 30 | 98.4 | 0 | 3 | 191 | 242 | 304 | HET9199509.1 D-2-hydroxyacid dehydrogenase [Dehalococcoidia bacterium] | diamond | 1131 | 73.2 | 0.994535519125683 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 29418976 | 29418976 | PRJNA688931_P_NODE_34669_length_170_cov_1.677686_g34456_i0 | PRJNA688931 | 34669 | 170 | 1.677686 | 2.8520662 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 42 | 0.0266 | NR | MDH4137170.1 | 2052143 | g34456 | i0 | 40.4 | 0.829411764705882 | 47 | 28 | 82.9 | 0 | 149 | 9 | 192 | 238 | MDH4137170.1 cellobiose phosphorylase [Anaerolineae bacterium] | diamond | 141 | 42 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29545283 | 29545283 | PRJNA688931_P_NODE_35750_length_168_cov_1.310924_g35537_i0 | PRJNA688931 | 35750 | 168 | 1.310924 | 2.20235232 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 76.3 | 2.87e-15 | NR | MCB0009405.1 | 2073117 | g35537 | i0 | 60.4 | 0.946428571428571 | 53 | 20 | 92.9 | 1 | 1 | 156 | 91 | 143 | MCB0009405.1 metallophosphatase domain-containing protein [Anaerolineales bacterium] | diamond | 159 | 76.3 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 29556769 | 29556769 | PRJNA688931_P_NODE_19090_length_235_cov_0.833333_g18877_i0 | PRJNA688931 | 19090 | 235 | 0.833333 | 1.95833255 | FCB group | 1783270 | Bacteria | Bacteria | 60.8 | 2.73e-9 | NR | MFN2285900.1 | 2052143 | g18877 | i0 | 50 | 2.59148936170213 | 46 | 23 | 58.7 | 0 | 164 | 27 | 36 | 81 | MFN2285900.1 leucine-rich repeat domain-containing protein [Anaerolineae bacterium] | diamond | 609 | 61.2 | 0.993464052287582 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30367119 | 30367119 | PRJNA688931_P_NODE_9912_length_336_cov_2.285714_g9699_i0 | PRJNA688931 | 9912 | 336 | 2.285714 | 7.67999904 | Herpetosiphon llansteffanensis | 2094568 | Bacteria | Bacteria | 100 | 4.6199999999999997e-23 | NR | WP_205701354.1 | 2094568 | g9699 | i0 | 58.7 | 0.821428571428571 | 92 | 37 | 82.1 | 1 | 59 | 334 | 156 | 246 | WP_205701354.1 peptidoglycan-binding domain-containing protein [Herpetosiphon llansteffanensis] | diamond | 276 | 100 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphon | Herpetosiphon llansteffanensis | ||
| 30808985 | 30808985 | PRJNA688931_P_NODE_16114_length_256_cov_1.560386_g15901_i0 | PRJNA688931 | 16114 | 256 | 1.560386 | 3.99458816 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 41.2 | 0.0486 | NR | MFA7296954.1 | 2026734 | g15901 | i0 | 43.4 | 0.62109375 | 53 | 22 | 56.3 | 3 | 80 | 223 | 56 | 105 | MFA7296954.1 metal-sensitive transcriptional regulator [Dehalococcoidia bacterium] | diamond | 159 | 41.2 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 31062006 | 31062006 | PRJNA688931_P_NODE_14335_length_273_cov_1.727679_g14122_i0 | PRJNA688931 | 14335 | 273 | 1.727679 | 4.71656367 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 61.2 | 1.33e-8 | NR | MFN8447328.1 | 2052143 | g14122 | i0 | 40.3 | 1.52747252747253 | 72 | 43 | 79.1 | 0 | 268 | 53 | 241 | 312 | MFN8447328.1 FAD-dependent oxidoreductase [Anaerolineae bacterium] | diamond | 417 | 61.2 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31262884 | 31262884 | PRJNA688931_P_NODE_26335_length_199_cov_1.040000_g26122_i0 | PRJNA688931 | 26335 | 199 | 1.04 | 2.0696 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 55.5 | 6.86e-7 | NR | MSP78358.1 | 2026734 | g26122 | i0 | 48.1 | 20.9698492462312 | 54 | 28 | 81.4 | 0 | 7 | 168 | 438 | 491 | MSP78358.1 elongation factor G [Dehalococcoidia bacterium] | diamond | 4173 | 55.5 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 32263981 | 32263981 | PRJNA688931_P_NODE_7438_length_398_cov_1.730659_g7225_i0 | PRJNA688931 | 7438 | 398 | 1.730659 | 6.88802282 | Chloroflexales bacterium | 2725990 | Bacteria | Bacteria | 54.3 | 1.79e-5 | NR | NTU82595.1 | 2725990 | g7225 | i0 | 31.9 | 3.33165829145729 | 116 | 72 | 87.4 | 1 | 51 | 398 | 21 | 129 | NTU82595.1 VWA domain-containing protein [Chloroflexales bacterium] | diamond | 1326 | 54.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexales bacterium | ||||
| 32421887 | 32421887 | PRJNA688931_P_NODE_26619_length_198_cov_1.033557_g26406_i0 | PRJNA688931 | 26619 | 198 | 1.033557 | 2.04644286 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 55.1 | 5.31e-7 | NR | MFN2194855.1 | 2073117 | g26406 | i0 | 45.8 | 0.893939393939394 | 59 | 32 | 89.4 | 0 | 192 | 16 | 27 | 85 | MFN2194855.1 histidine phosphatase family protein [Anaerolineales bacterium] | diamond | 177 | 55.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32894737 | 32894737 | PRJNA688931_P_NODE_19100_length_234_cov_4.156757_g18887_i0 | PRJNA688931 | 19100 | 234 | 4.156757 | 9.72681138 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 58.2 | 6.45e-8 | NR | HLH71787.1 | 2026724 | g18887 | i0 | 40.3 | 0.987179487179487 | 77 | 44 | 98.7 | 1 | 2 | 232 | 9 | 83 | HLH71787.1 aquaporin [Chloroflexota bacterium] | diamond | 231 | 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);;