contig_metadata
13 rows where bioproject = "PRJEB66218", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Minisyncoccota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23084675 | 23084675 | PRJEB66218_P_NODE_239059_length_202_cov_1.241135_g236628_i0 | PRJEB66218 | 239059 | 202 | 1.241135 | 2.5070927 | Candidatus Phycocordibacter aenigmaticus | 1948796 | Bacteria | Bacteria | 217 | 5.89e-52 | NTclustered | gi|2862534145|gb|CP174359.1| | 1948796 | g236628 | i0 | 86.275 | 24.0742574257426 | 204 | 23 | 100 | 5 | 1 | 202 | 75426 | 75226 | MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome | blastn | 4863 | 217 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccia | Candidatus Phycocordibacterales | Candidatus Phycocordibacteraceae | Candidatus Phycocordibacter | Candidatus Phycocordibacter aenigmaticus | ||
| 26907511 | 26907511 | PRJEB66218_P_NODE_64122_length_407_cov_2.297688_g61699_i0 | PRJEB66218 | 64122 | 407 | 2.297688 | 9.35159016 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 102 | 3.1e-22 | NR | MDR3571089.1 | 2053589 | g61699 | i0 | 41.2 | 1.002457002457 | 136 | 75 | 99.5 | 2 | 406 | 2 | 244 | 375 | MDR3571089.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 408 | 102 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27223512 | 27223512 | PRJEB66218_P_NODE_67483_length_394_cov_1.153153_g65059_i0 | PRJEB66218 | 67483 | 394 | 1.153153 | 4.54342282 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 67.8 | 2.58e-10 | NR | MDR3549717.1 | 2053589 | g65059 | i0 | 38 | 0.822335025380711 | 108 | 57 | 82.2 | 3 | 64 | 387 | 52 | 149 | MDR3549717.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 324 | 67.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27508240 | 27508240 | PRJEB66218_P_NODE_43663_length_523_cov_2.629870_g41255_i0 | PRJEB66218 | 43663 | 523 | 2.62987 | 13.7542201 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 153 | 1.79e-40 | NR | MDR3558125.1 | 2053589 | g41255 | i0 | 43.9 | 0.992351816443595 | 173 | 97 | 99.2 | 0 | 3 | 521 | 157 | 329 | MDR3558125.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 519 | 153 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29339469 | 29339469 | PRJEB66218_P_NODE_73709_length_372_cov_1.713826_g71284_i0 | PRJEB66218 | 73709 | 372 | 1.713826 | 6.37543272 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 56.6 | 2.08e-6 | NR | MDR3558125.1 | 2053589 | g71284 | i0 | 45 | 0.483870967741935 | 60 | 33 | 48.4 | 0 | 3 | 182 | 348 | 407 | MDR3558125.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 180 | 56.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29465265 | 29465265 | PRJEB66218_P_NODE_6750_length_1752_cov_1.850976_g5699_i0 | PRJEB66218 | 6750 | 1752 | 1.850976 | 32.42909952 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 69.7 | 4.66e-9 | NR | MCF7815915.1 | 2053589 | g5699 | i0 | 39.6 | 0.190068493150685 | 111 | 61 | 18.8 | 4 | 1416 | 1745 | 35 | 140 | MCF7815915.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 333 | 69.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29591571 | 29591571 | PRJEB66218_P_NODE_71790_length_378_cov_2.018927_g69365_i0 | PRJEB66218 | 71790 | 378 | 2.018927 | 7.63154406 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 92 | 9.23e-21 | NR | MDR3571063.1 | 2053589 | g69365 | i0 | 69.7 | 0.523809523809524 | 66 | 20 | 52.4 | 0 | 2 | 199 | 89 | 154 | MDR3571063.1 prohibitin family protein [Candidatus Paceibacterota bacterium] | diamond | 198 | 92 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29623029 | 29623029 | PRJEB66218_P_NODE_79430_length_355_cov_1.176871_g77004_i0 | PRJEB66218 | 79430 | 355 | 1.176871 | 4.17789205 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 84.7 | 2.58e-16 | NR | MDR3570672.1 | 2053589 | g77004 | i0 | 38.3 | 0.971830985915493 | 115 | 50 | 79.4 | 2 | 3 | 284 | 847 | 961 | MDR3570672.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 345 | 84.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30634111 | 30634111 | PRJEB66218_P_NODE_13_length_18476_cov_27.593212_g12_i0 | PRJEB66218 | 13 | 18476 | 27.593212 | 5098.12184912 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 119 | 6.82e-22 | NR | MBP9715270.1 | 2053589 | g12 | i0 | 33.6 | 0.0690084433860143 | 425 | 215 | 6.8 | 15 | 17220 | 15970 | 1604 | 1971 | MBP9715270.1 fibronectin type III domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 1275 | 119 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30792320 | 30792320 | PRJEB66218_P_NODE_30714_length_661_cov_1.945000_g28397_i0 | PRJEB66218 | 30714 | 661 | 1.945 | 12.85645 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 122 | 7.38e-28 | NR | MDR3571089.1 | 2053589 | g28397 | i0 | 38.9 | 1.94704992435703 | 216 | 130 | 97.1 | 2 | 3 | 644 | 403 | 618 | MDR3571089.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 1287 | 122 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30950460 | 30950460 | PRJEB66218_P_NODE_16194_length_1013_cov_7.676471_g14332_i0 | PRJEB66218 | 16194 | 1013 | 7.676471 | 77.76265123 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 244 | 9.45e-69 | NR | MBP9715270.1 | 2053589 | g14332 | i0 | 47.6 | 0.989141164856861 | 334 | 164 | 98.9 | 3 | 1005 | 4 | 1661 | 1983 | MBP9715270.1 fibronectin type III domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 1002 | 244 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31202590 | 31202590 | PRJEB66218_P_NODE_213555_length_208_cov_0.877551_g211125_i0 | PRJEB66218 | 213555 | 208 | 0.877551 | 1.82530608 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 58.2 | 8.73e-8 | NR | MDR3547909.1 | 2053589 | g211125 | i0 | 41.7 | 1.81730769230769 | 60 | 35 | 86.5 | 0 | 1 | 180 | 408 | 467 | MDR3547909.1 DNA polymerase [Candidatus Paceibacterota bacterium] | diamond | 378 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32342214 | 32342214 | PRJEB66218_P_NODE_99859_length_307_cov_1.479675_g97431_i0 | PRJEB66218 | 99859 | 307 | 1.479675 | 4.54260225 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 95.5 | 2.42e-20 | NR | MDR3570672.1 | 2053589 | g97431 | i0 | 50.5 | 1.00651465798046 | 103 | 50 | 99.7 | 1 | 1 | 306 | 262 | 364 | MDR3570672.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 309 | 95.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota 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);;