contig_metadata
11 rows where bioproject = "PRJNA493632" and tax_phylum = "Candidatus Peregrinibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1103607 | 1103607 | PRJNA493632_P_NODE_623381_length_243_cov_1.076471_g619940_i0 | PRJNA493632 | 623381 | 243 | 1.076471 | 2.61582453 | Candidatus Peribacter | 1803399 | Bacteria | Bacteria | 211 | 3.41e-50 | NTclustered | gi|946529367|gb|CP013062.1| | 1735162 | g619940 | i0 | 83.628 | 299.205761316872 | 226 | 35 | 93 | 2 | 1 | 225 | 1197282 | 1197058 | MAG: Candidatus Peribacter riflensis, complete genome | blastn | 72707 | 211 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacter | Candidatus Peribacter riflensis | |||
| 1736333 | 1736333 | PRJNA493632_P_NODE_305702_length_293_cov_3.468182_g302264_i0 | PRJNA493632 | 305702 | 293 | 3.468182 | 10.16177326 | Candidatus Peregrinibacteria bacterium Greene | 2030811 | Bacteria | Bacteria | 147 | 5.22e-40 | NR | TSC57980.1 | 2017154 | g302264 | i0 | 67 | 1.98634812286689 | 97 | 32 | 99.3 | 0 | 291 | 1 | 103 | 199 | TSC57980.1 MAG: 4-alpha-glucanotransferase [Candidatus Peregrinibacteria bacterium Greene0416_19] | diamond | 582 | 147 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium Greene0416_19 | ||||||
| 18310312 | 18310312 | PRJNA493632_P_NODE_150055_length_386_cov_2.460064_g146632_i0 | PRJNA493632 | 150055 | 386 | 2.460064 | 9.49584704 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 84.2 | 1.31e-11 | NTclustered | gi|2225492643|gb|CP082927.1| | 2053688 | g146632 | i0 | 86.25 | 0.207253886010363 | 80 | 8 | 20 | 3 | 308 | 386 | 366434 | 366511 | MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome | blastn | 80 | 84.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 27677000 | 27677000 | PRJNA493632_P_NODE_102024_length_451_cov_1.600529_g98623_i0 | PRJNA493632 | 102024 | 451 | 1.600529 | 7.21838579 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 255 | 8.48e-84 | NR | MBP7114424.1 | 2735830 | g98623 | i0 | 100 | 0.957871396895787 | 144 | 0 | 95.8 | 0 | 433 | 2 | 1 | 144 | MBP7114424.1 hypothetical protein [Candidatus Peribacteraceae bacterium] | diamond | 432 | 255 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 28102995 | 28102995 | PRJNA493632_P_NODE_494005_length_253_cov_1.711111_g490566_i0 | PRJNA493632 | 494005 | 253 | 1.711111 | 4.32911083 | Bacteria | 2 | Bacteria | Bacteria | 106 | 4.500000000000001e-28 | NR | MCA9377848.1 | 2030811 | g490566 | i0 | 60.8 | 1.87351778656126 | 79 | 31 | 93.7 | 0 | 17 | 253 | 1 | 79 | MCA9377848.1 hypothetical protein [Candidatus Peregrinibacteria bacterium] | diamond | 474 | 107 | 0.990654205607477 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 28245092 | 28245092 | PRJNA493632_P_NODE_698346_length_228_cov_2.561290_g694905_i0 | PRJNA493632 | 698346 | 228 | 2.56129 | 5.8397412 | Candidatus Peribacteria bacterium RIFCSPHIGHO2_ | 2053688 | Bacteria | Bacteria | 61.6 | 8.99e-10 | NR | OGJ63382.1 | 1801919 | g694905 | i0 | 82.9 | 0.460526315789474 | 35 | 6 | 46.1 | 0 | 123 | 227 | 93 | 127 | OGJ63382.1 MAG: hypothetical protein A3C52_05380 [Candidatus Peribacteria bacterium RIFCSPHIGHO2_02_FULL_51_15] | diamond | 105 | 61.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium RIFCSPHIGHO2_02_FULL_51_15 | |||||
| 30393082 | 30393082 | PRJNA493632_P_NODE_603213_length_244_cov_46.374269_g599772_i0 | PRJNA493632 | 603213 | 244 | 46.374269 | 113.15321636 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 41.6 | 0.0279 | NR | MCB9809420.1 | 2053688 | g599772 | i0 | 42.9 | 0.516393442622951 | 42 | 24 | 51.6 | 0 | 239 | 114 | 34 | 75 | MCB9809420.1 ABC transporter substrate-binding protein [Candidatus Peribacteria bacterium] | diamond | 126 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 31308788 | 31308788 | PRJNA493632_P_NODE_196635_length_347_cov_2.043796_g193201_i0 | PRJNA493632 | 196635 | 347 | 2.043796 | 7.09197212 | Candidatus Peribacter riflensis | 1735162 | Bacteria | Bacteria | 47.4 | 8.35e-4 | NR | ALM10403.1 | 1735162 | g193201 | i0 | 52 | 0.432276657060519 | 50 | 23 | 43.2 | 1 | 90 | 239 | 30 | 78 | ALM10403.1 MAG: hypothetical protein PeribacterA2_1045 [Candidatus Peribacter riflensis] | diamond | 150 | 47.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacter | Candidatus Peribacter riflensis | |||
| 31435243 | 31435243 | PRJNA493632_P_NODE_103736_length_448_cov_1.642667_g100332_i0 | PRJNA493632 | 103736 | 448 | 1.642667 | 7.35914816 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 260 | 4.229999999999999e-87 | NR | MBP9850226.1 | 2735830 | g100332 | i0 | 100 | 0.877232142857143 | 131 | 0 | 87.7 | 0 | 405 | 13 | 1 | 131 | MBP9850226.1 hypothetical protein [Candidatus Peribacteraceae bacterium] | diamond | 393 | 260 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 31656737 | 31656737 | PRJNA493632_P_NODE_642857_length_242_cov_0.911243_g639416_i0 | PRJNA493632 | 642857 | 242 | 0.911243 | 2.20520806 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 45.4 | 0.00423 | NR | MBI2463361.1 | 2030811 | g639416 | i0 | 37.9 | 0.818181818181818 | 66 | 40 | 81.8 | 1 | 3 | 200 | 740 | 804 | MBI2463361.1 DUF2341 domain-containing protein [Candidatus Peregrinibacteria bacterium] | diamond | 198 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 31941393 | 31941393 | PRJNA493632_P_NODE_464777_length_259_cov_1.408602_g461338_i0 | PRJNA493632 | 464777 | 259 | 1.408602 | 3.64827918 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 60.8 | 6.9e-10 | NR | MBI4235222.1 | 2030811 | g461338 | i0 | 61.5 | 0.451737451737452 | 39 | 15 | 45.2 | 0 | 237 | 121 | 6 | 44 | MBI4235222.1 hypothetical protein [Candidatus Peregrinibacteria bacterium] | diamond | 117 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria 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);;