contig_metadata
24 rows where bioproject = "PRJNA841653", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2106251 | 2106251 | PRJNA841653_P_NODE_49142_length_248_cov_0.880000_g48468_i0 | PRJNA841653 | 49142 | 248 | 0.88 | 2.1824 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 156 | 2.28e-44 | NR | WP_331052338.1 | 2029185 | g48468 | i0 | 97.5 | 1.95967741935484 | 81 | 2 | 98 | 0 | 4 | 246 | 102 | 182 | WP_331052338.1 sigma 54-interacting transcriptional regulator [Longimicrobium sp.] | diamond | 486 | 156 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 2506391 | 2506391 | PRJNA841653_P_NODE_47782_length_249_cov_0.875000_g47108_i0 | PRJNA841653 | 47782 | 249 | 0.875 | 2.17875 | Gemmatirosa | 1706036 | Bacteria | Bacteria | 252 | 2.07e-62 | NTclustered | gi|2874253995|emb|OY970320.1| | 246130 | g47108 | i0 | 88.517 | 73.9277108433735 | 209 | 22 | 84 | 2 | 30 | 237 | 231424 | 231631 | MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1 | blastn | 18408 | 252 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | uncultured Gemmatimonadaceae bacterium | ||
| 3782763 | 3782763 | PRJNA841653_P_NODE_49763_length_248_cov_0.828571_g49089_i0 | PRJNA841653 | 49763 | 248 | 0.828571 | 2.05485608 | Gemmatirosa | 1706036 | Bacteria | Bacteria | 219 | 2.0899999999999994e-52 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g49089 | i0 | 83.265 | 71.1209677419355 | 245 | 33 | 97 | 8 | 2 | 242 | 421109 | 420869 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 17638 | 219 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 7209119 | 7209119 | PRJNA841653_P_NODE_57686_length_243_cov_0.905882_g57012_i0 | PRJNA841653 | 57686 | 243 | 0.905882 | 2.20129326 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 157 | 8.11e-43 | NR | HXT47261.1 | 2026741 | g57012 | i0 | 97.5 | 0.987654320987654 | 80 | 2 | 98.8 | 0 | 3 | 242 | 241 | 320 | HXT47261.1 oligopeptide transporter, OPT family [Gemmatimonadaceae bacterium] | diamond | 240 | 157 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 11034571 | 11034571 | PRJNA841653_P_NODE_53289_length_246_cov_0.890173_g52615_i0 | PRJNA841653 | 53289 | 246 | 0.890173 | 2.18982558 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 91.6 | 4.71e-14 | NTclustered | gi|2874254107|emb|OY970192.1| | 412054 | g52615 | i0 | 90 | 74.3333333333333 | 70 | 7 | 28 | 0 | 176 | 245 | 1593291 | 1593222 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1 | blastn | 18286 | 91.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 16133141 | 16133141 | PRJNA841653_P_NODE_31333_length_291_cov_1.408257_g30659_i0 | PRJNA841653 | 31333 | 291 | 1.408257 | 4.09802787 | Gemmatimonas phototrophica | 1379270 | Bacteria | Bacteria | 442 | 1.3699999999999994e-119 | NTclustered | gi|1015602748|gb|CP011454.1| | 1379270 | g30659 | i0 | 94.464 | 69.6701030927835 | 289 | 12 | 99 | 4 | 1 | 287 | 2075022 | 2074736 | Gemmatimonas phototrophica strain AP64, complete genome | blastn | 20274 | 442 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas phototrophica | |
| 19956874 | 19956874 | PRJNA841653_P_NODE_32736_length_286_cov_0.981221_g32062_i0 | PRJNA841653 | 32736 | 286 | 0.981221 | 2.80629206 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 109 | 1.54e-25 | NR | PYP60641.1 | 2026742 | g32062 | i0 | 67.5 | 3.34615384615385 | 80 | 18 | 83.9 | 2 | 242 | 3 | 5 | 76 | PYP60641.1 MAG: alpha-N-arabinofuranosidase [Gemmatimonadota bacterium] | diamond | 957 | 109 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 21232556 | 21232556 | PRJNA841653_P_NODE_34017_length_281_cov_1.350962_g33343_i0 | PRJNA841653 | 34017 | 281 | 1.350962 | 3.79620322 | Gaopeijia maritima | 3119007 | Bacteria | Bacteria | 150 | 8.929999999999999e-32 | NTclustered | gi|2716997671|gb|CP144380.1| | 3119007 | g33343 | i0 | 90.517 | 4.5729537366548 | 116 | 7 | 41 | 2 | 17 | 130 | 725216 | 725329 | Gaopeijia maritima strain DH-78 chromosome, complete genome | blastn | 1285 | 150 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Gaopeijiales | Gaopeijiaceae | Gaopeijia | Gaopeijia maritima | |
| 21232747 | 21232747 | PRJNA841653_P_NODE_44177_length_251_cov_0.865169_g43503_i0 | PRJNA841653 | 44177 | 251 | 0.865169 | 2.17157419 | Gemmatimonas sp. UBA7669 | 1946568 | Bacteria | Bacteria | 154 | 1.82e-42 | NR | WP_291159065.1 | 1946568 | g43503 | i0 | 98.8 | 0.956175298804781 | 80 | 1 | 95.6 | 0 | 3 | 242 | 62 | 141 | WP_291159065.1 glycoside hydrolase family 10 protein [Gemmatimonas sp. UBA7669] | diamond | 240 | 154 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. UBA7669 | |
| 23782838 | 23782838 | PRJNA841653_P_NODE_36559_length_272_cov_1.482412_g35885_i0 | PRJNA841653 | 36559 | 272 | 1.482412 | 4.03216064 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 112 | 6.82e-27 | NR | HEX9279349.1 | 2448054 | g35885 | i0 | 63.3 | 0.992647058823529 | 90 | 33 | 99.3 | 0 | 272 | 3 | 191 | 280 | HEX9279349.1 CocE/NonD family hydrolase C-terminal non-catalytic domain-containing protein [Gemmatimonadales bacterium] | diamond | 270 | 112 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 23783256 | 23783256 | PRJNA841653_P_NODE_60479_length_242_cov_0.911243_g59805_i0 | PRJNA841653 | 60479 | 242 | 0.911243 | 2.20520806 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 137 | 5.85e-28 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g59805 | i0 | 91.919 | 1.67355371900826 | 99 | 7 | 40 | 1 | 4 | 101 | 2192805 | 2192707 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 405 | 137 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 24182322 | 24182322 | PRJNA841653_P_NODE_30879_length_293_cov_1.400000_g30205_i0 | PRJNA841653 | 30879 | 293 | 1.4 | 4.102 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 126 | 1.04e-33 | NR | MBA3655786.1 | 2026741 | g30205 | i0 | 65.6 | 0.95221843003413 | 93 | 32 | 95.2 | 0 | 5 | 283 | 66 | 158 | MBA3655786.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 279 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27339297 | 27339297 | PRJNA841653_P_NODE_47783_length_249_cov_0.875000_g47109_i0 | PRJNA841653 | 47783 | 249 | 0.875 | 2.17875 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 129 | 1.92e-32 | NR | HWJ23594.1 | 2026741 | g47109 | i0 | 72.8 | 1.95180722891566 | 81 | 18 | 97.6 | 1 | 3 | 245 | 769 | 845 | HWJ23594.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 486 | 129 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27655148 | 27655148 | PRJNA841653_P_NODE_34564_length_279_cov_1.446602_g33890_i0 | PRJNA841653 | 34564 | 279 | 1.446602 | 4.03601958 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 132 | 8.65e-34 | NR | MCA9751759.1 | 2026742 | g33890 | i0 | 64.1 | 1.98924731182796 | 92 | 33 | 98.9 | 0 | 276 | 1 | 45 | 136 | MCA9751759.1 carbamoyltransferase [Gemmatimonadota bacterium] | diamond | 555 | 132 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28073766 | 28073766 | PRJNA841653_P_NODE_46865_length_249_cov_0.875000_g46191_i0 | PRJNA841653 | 46865 | 249 | 0.875 | 2.17875 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 127 | 2.94e-33 | NR | WP_331073884.1 | 2029185 | g46191 | i0 | 74.4 | 3.95180722891566 | 82 | 21 | 98.8 | 0 | 3 | 248 | 196 | 277 | WP_331073884.1 sulfate ABC transporter substrate-binding protein [Longimicrobium sp.] | diamond | 984 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 29675343 | 29675343 | PRJNA841653_P_NODE_46370_length_249_cov_3.818182_g45696_i0 | PRJNA841653 | 46370 | 249 | 3.818182 | 9.50727318 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 43.5 | 0.0213 | NR | HMG12470.1 | 2026741 | g45696 | i0 | 39.1 | 1.5421686746988 | 64 | 35 | 77.1 | 1 | 198 | 7 | 48 | 107 | HMG12470.1 chloride channel protein [Gemmatimonadaceae bacterium] | diamond | 384 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29706825 | 29706825 | PRJNA841653_P_NODE_45130_length_250_cov_0.870056_g44456_i0 | PRJNA841653 | 45130 | 250 | 0.870056 | 2.17514 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 48.5 | 3.63e-4 | NR | HWZ60203.1 | 2026741 | g44456 | i0 | 35 | 1.836 | 80 | 46 | 91.2 | 2 | 15 | 242 | 464 | 541 | HWZ60203.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 459 | 48.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29896864 | 29896864 | PRJNA841653_P_NODE_45691_length_250_cov_0.870056_g45017_i0 | PRJNA841653 | 45691 | 250 | 0.870056 | 2.17514 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 117 | 2.17e-28 | NR | HUQ82762.1 | 2026741 | g45017 | i0 | 72.8 | 1.872 | 81 | 22 | 97.2 | 0 | 8 | 250 | 202 | 282 | HUQ82762.1 multicopper oxidase family protein [Gemmatimonadaceae bacterium] | diamond | 468 | 117 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29991544 | 29991544 | PRJNA841653_P_NODE_21231_length_354_cov_1.074733_g20557_i0 | PRJNA841653 | 21231 | 354 | 1.074733 | 3.80455482 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 69.3 | 6.75e-11 | NR | MBI4541102.1 | 2026742 | g20557 | i0 | 42 | 1.19491525423729 | 81 | 41 | 65.3 | 2 | 10 | 240 | 1050 | 1128 | MBI4541102.1 helicase [Gemmatimonadota bacterium] | diamond | 423 | 69.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30307940 | 30307940 | PRJNA841653_P_NODE_13852_length_442_cov_23.737127_g13181_i0 | PRJNA841653 | 13852 | 442 | 23.737127 | 104.91810134 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 45.1 | 0.0422 | NR | HET9637540.1 | 2026741 | g13181 | i0 | 38.1 | 0.427601809954751 | 63 | 35 | 42.8 | 1 | 225 | 413 | 48 | 106 | HET9637540.1 chloride channel protein [Gemmatimonadaceae bacterium] | diamond | 189 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30695008 | 30695008 | PRJNA841653_P_NODE_61453_length_241_cov_0.916667_g60779_i0 | PRJNA841653 | 61453 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 150 | 4.88e-40 | NR | MFL5618614.1 | 2026741 | g60779 | i0 | 88.3 | 3.82157676348548 | 77 | 9 | 95.9 | 0 | 241 | 11 | 762 | 838 | MFL5618614.1 dihydropteroate synthase [Gemmatimonadaceae bacterium] | diamond | 921 | 151 | 0.993377483443709 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30884637 | 30884637 | PRJNA841653_P_NODE_50934_length_247_cov_0.885057_g50260_i0 | PRJNA841653 | 50934 | 247 | 0.885057 | 2.18609079 | Bacteria | 2 | Bacteria | Bacteria | 143 | 4.78e-40 | NR | MDQ6635024.1 | 2026742 | g50260 | i0 | 85 | 9.68016194331984 | 80 | 12 | 97.2 | 0 | 7 | 246 | 171 | 250 | MDQ6635024.1 phytanoyl-CoA dioxygenase family protein [Gemmatimonadota bacterium] | diamond | 2391 | 144 | 0.993055555555556 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31824560 | 31824560 | PRJNA841653_P_NODE_55257_length_244_cov_3.631579_g54583_i0 | PRJNA841653 | 55257 | 244 | 3.631579 | 8.86105276 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 42.7 | 0.0366 | NR | HET9637540.1 | 2026741 | g54583 | i0 | 40 | 0.737704918032787 | 60 | 32 | 73.8 | 1 | 24 | 203 | 51 | 106 | HET9637540.1 chloride channel protein [Gemmatimonadaceae bacterium] | diamond | 180 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32466190 | 32466190 | PRJNA841653_P_NODE_15539_length_416_cov_24.865889_g14867_i0 | PRJNA841653 | 15539 | 416 | 24.865889 | 103.44209824000001 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.0346 | NR | HET9637540.1 | 2026741 | g14867 | i0 | 38.1 | 1.21153846153846 | 63 | 35 | 45.4 | 1 | 199 | 387 | 48 | 106 | HET9637540.1 chloride channel protein [Gemmatimonadaceae bacterium] | diamond | 504 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae 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);;