contig_metadata
16 rows where bioproject = "PRJEB11748", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Altimarinota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12461722 | 12461722 | PRJEB11748_P_NODE_107730_length_401_cov_13.208824_g105556_i0 | PRJEB11748 | 107730 | 401 | 13.208824 | 52.96738424 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 178 | 2.21e-52 | NR | MBW7954399.1 | 2044595 | g105556 | i0 | 70.4 | 8.48379052369077 | 125 | 37 | 93.5 | 0 | 375 | 1 | 43 | 167 | MBW7954399.1 recombinase RecA [Candidatus Altimarinota bacterium] | diamond | 3402 | 178 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 14042021 | 14042021 | PRJEB11748_P_NODE_108272_length_400_cov_10.861357_g106098_i0 | PRJEB11748 | 108272 | 400 | 10.861357 | 43.445428 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 643 | 4.969999999999999e-180 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g106098 | i0 | 97.361 | 0.9475 | 379 | 8 | 95 | 2 | 1 | 378 | 1102212 | 1101835 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 379 | 643 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 16591506 | 16591506 | PRJEB11748_P_NODE_140234_length_348_cov_2.790941_g138055_i0 | PRJEB11748 | 140234 | 348 | 2.790941 | 9.71247468 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 173 | 3.29e-51 | NR | HLG25804.1 | 2044595 | g138055 | i0 | 79.4 | 1.75862068965517 | 102 | 21 | 87.9 | 0 | 324 | 19 | 134 | 235 | HLG25804.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Candidatus Altimarinota bacterium] | diamond | 612 | 173 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 19140193 | 19140193 | PRJEB11748_P_NODE_140736_length_347_cov_6.527972_g138557_i0 | PRJEB11748 | 140736 | 347 | 6.527972 | 22.65206284 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 433 | 1e-116 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g138557 | i0 | 90.826 | 10.193083573487 | 327 | 24 | 93 | 6 | 3 | 325 | 891329 | 891005 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 3537 | 433 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 22659597 | 22659597 | PRJEB11748_P_NODE_105218_length_406_cov_34.095652_g103046_i0 | PRJEB11748 | 105218 | 406 | 34.095652 | 138.42834712 | Bacteria | 2 | Bacteria | Bacteria | 161 | 6.2e-35 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g103046 | i0 | 80.841 | 54.7364532019704 | 214 | 34 | 52 | 6 | 3 | 213 | 1250285 | 1250494 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 22223 | 161 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 27475212 | 27475212 | PRJEB11748_P_NODE_202843_length_281_cov_5.295455_g200660_i0 | PRJEB11748 | 202843 | 281 | 5.295455 | 14.88022855 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 109 | 5.31e-27 | NR | MDP5039129.1 | 2044595 | g200660 | i0 | 83.6 | 0.715302491103203 | 67 | 11 | 71.5 | 0 | 3 | 203 | 44 | 110 | MDP5039129.1 ABC transporter permease [Candidatus Altimarinota bacterium] | diamond | 201 | 109 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28896085 | 28896085 | PRJEB11748_P_NODE_397388_length_167_cov_6.490566_g395205_i0 | PRJEB11748 | 397388 | 167 | 6.490566 | 10.83924522 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 72.4 | 4.35e-14 | NR | MBP7823007.1 | 2044595 | g395205 | i0 | 70.6 | 0.916167664670659 | 51 | 15 | 91.6 | 0 | 155 | 3 | 25 | 75 | MBP7823007.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 153 | 72.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29369737 | 29369737 | PRJEB11748_P_NODE_212489_length_273_cov_6.061321_g210306_i0 | PRJEB11748 | 212489 | 273 | 6.061321 | 16.54740633 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 96.7 | 3.9900000000000005e-21 | NR | MDD5770483.1 | 2044595 | g210306 | i0 | 76.3 | 0.648351648351648 | 59 | 14 | 64.8 | 0 | 203 | 27 | 263 | 321 | MDD5770483.1 TldD/PmbA family protein [Candidatus Altimarinota bacterium] | diamond | 177 | 96.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29621819 | 29621819 | PRJEB11748_P_NODE_222470_length_265_cov_21.745098_g220287_i0 | PRJEB11748 | 222470 | 265 | 21.745098 | 57.6245097 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 136 | 2.39e-39 | NR | MBP7823566.1 | 2044595 | g220287 | i0 | 79.5 | 0.939622641509434 | 83 | 17 | 94 | 0 | 250 | 2 | 32 | 114 | MBP7823566.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 249 | 136 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30127294 | 30127294 | PRJEB11748_P_NODE_152272_length_332_cov_7.992620_g150090_i0 | PRJEB11748 | 152272 | 332 | 7.99262 | 26.5354984 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 85.5 | 1.04e-16 | NR | MFA6918007.1 | 2044595 | g150090 | i0 | 45 | 0.903614457831325 | 100 | 55 | 90.4 | 0 | 310 | 11 | 16 | 115 | MFA6918007.1 PEP/pyruvate-binding domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 300 | 85.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30727884 | 30727884 | PRJEB11748_P_NODE_202634_length_281_cov_9.177273_g200451_i0 | PRJEB11748 | 202634 | 281 | 9.177273 | 25.78813713 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 93.2 | 3.31e-20 | NR | MCD5380526.1 | 2044595 | g200451 | i0 | 65.7 | 0.715302491103203 | 67 | 22 | 70.5 | 1 | 63 | 260 | 32 | 98 | MCD5380526.1 3-deoxy-7-phosphoheptulonate synthase [Candidatus Altimarinota bacterium] | diamond | 201 | 93.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31012274 | 31012274 | PRJEB11748_P_NODE_18995_length_1060_cov_6.182182_g17529_i0 | PRJEB11748 | 18995 | 1060 | 6.182182 | 65.5311292 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 85.5 | 5.99e-14 | NR | MDD5213257.1 | 2044595 | g17529 | i0 | 72 | 0.141509433962264 | 50 | 14 | 14.2 | 0 | 787 | 936 | 1622 | 1671 | MDD5213257.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 150 | 85.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32182592 | 32182592 | PRJEB11748_P_NODE_197958_length_285_cov_6.767857_g195775_i0 | PRJEB11748 | 197958 | 285 | 6.767857 | 19.28839245 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 153 | 5.93e-43 | NR | MBP7773621.1 | 2044595 | g195775 | i0 | 76.9 | 0.957894736842105 | 91 | 21 | 95.8 | 0 | 273 | 1 | 158 | 248 | MBP7773621.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 273 | 153 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32499236 | 32499236 | PRJEB11748_P_NODE_331459_length_206_cov_0.882759_g329276_i0 | PRJEB11748 | 331459 | 206 | 0.882759 | 1.81848354 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 57.4 | 1.33e-7 | NR | MFA6090731.1 | 2044595 | g329276 | i0 | 47.8 | 2.00970873786408 | 69 | 34 | 97.6 | 1 | 6 | 206 | 187 | 255 | MFA6090731.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 414 | 57.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32751271 | 32751271 | PRJEB11748_P_NODE_39020_length_698_cov_57.394035_g37016_i0 | PRJEB11748 | 39020 | 698 | 57.394035 | 400.6103643 | Candidatus Gracilibacteria bacterium CG2_3 | 2044595 | Bacteria | Bacteria | 116 | 1.2599999999999998e-29 | NR | OIP53574.1 | 1805211 | g37016 | i0 | 90.3 | 0.26647564469914 | 62 | 6 | 26.6 | 0 | 346 | 161 | 36 | 97 | OIP53574.1 MAG: hypothetical protein AUK10_02285 [Candidatus Gracilibacteria bacterium CG2_30_37_12] | diamond | 186 | 116 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium CG2_30_37_12 | ||||||
| 32814025 | 32814025 | PRJEB11748_P_NODE_166480_length_316_cov_2.596078_g164297_i0 | PRJEB11748 | 166480 | 316 | 2.596078 | 8.20360648 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 112 | 8.29e-29 | NR | MCF7843965.1 | 2044595 | g164297 | i0 | 63.3 | 0.75 | 79 | 29 | 75 | 0 | 308 | 72 | 89 | 167 | MCF7843965.1 crossover junction endodeoxyribonuclease RuvC [Candidatus Altimarinota bacterium] | diamond | 237 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota 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);;