contig_metadata
19 rows where bioproject = "PRJEB11523" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1288041 | 1288041 | PRJEB11523_P_NODE_782_length_683_cov_2.708202_g715_i0 | PRJEB11523 | 782 | 683 | 2.708202 | 18.49701966 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 410 | 5.15e-137 | NR | HEY4498428.1 | 2053589 | g715 | i0 | 91.2 | 0.992679355783309 | 226 | 20 | 99.3 | 0 | 3 | 680 | 300 | 525 | HEY4498428.1 elongation factor G [Candidatus Paceibacterota bacterium] | diamond | 678 | 410 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 10216536 | 10216536 | PRJEB11523_P_NODE_5829_length_191_cov_17.091549_g5751_i0 | PRJEB11523 | 5829 | 191 | 17.091549 | 32.64485859 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 84 | 8.09e-19 | NR | MFA6385964.1 | 2053589 | g5751 | i0 | 81.5 | 1.64921465968586 | 54 | 10 | 84.8 | 0 | 164 | 3 | 54 | 107 | MFA6385964.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 315 | 84 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 12461623 | 12461623 | PRJEB11523_P_NODE_310_length_1088_cov_9.067372_g261_i0 | PRJEB11523 | 310 | 1088 | 9.067372 | 98.65300736 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 248 | 3.5000000000000007e-71 | NR | MBP6885901.1 | 2053589 | g261 | i0 | 52.2 | 0.692095588235294 | 251 | 114 | 68.4 | 3 | 748 | 5 | 1 | 248 | MBP6885901.1 transglycosylase domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 753 | 248 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 21690368 | 21690368 | PRJEB11523_P_NODE_4098_length_236_cov_15.860963_g4020_i0 | PRJEB11523 | 4098 | 236 | 15.860963 | 37.43187268 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 63.5 | 1.33e-9 | NR | HEY4503935.1 | 2053589 | g4020 | i0 | 67.4 | 0.584745762711864 | 46 | 15 | 58.5 | 0 | 92 | 229 | 1 | 46 | HEY4503935.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 138 | 63.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26811259 | 26811259 | PRJEB11523_P_NODE_7841_length_165_cov_1.568966_g7763_i0 | PRJEB11523 | 7841 | 165 | 1.568966 | 2.5887939 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 67 | 1.66e-11 | NR | HXK35149.1 | 2053589 | g7763 | i0 | 54.5 | 4.98181818181818 | 55 | 25 | 100 | 0 | 1 | 165 | 191 | 245 | HXK35149.1 triose-phosphate isomerase [Candidatus Paceibacterota bacterium] | diamond | 822 | 67 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27158863 | 27158863 | PRJEB11523_P_NODE_1362_length_493_cov_51.707207_g1284_i0 | PRJEB11523 | 1362 | 493 | 51.707207 | 254.91653051 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 176 | 1.87e-53 | NR | HEY4480312.1 | 2053589 | g1284 | i0 | 74.4 | 0.711967545638945 | 117 | 30 | 71.2 | 0 | 486 | 136 | 17 | 133 | HEY4480312.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 351 | 176 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28295991 | 28295991 | PRJEB11523_P_NODE_3106_length_284_cov_50.851064_g3028_i0 | PRJEB11523 | 3106 | 284 | 50.851064 | 144.41702176 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 162 | 5.83e-44 | NR | MBP6888568.1 | 2053589 | g3028 | i0 | 98.9 | 0.919014084507042 | 87 | 1 | 91.9 | 0 | 19 | 279 | 979 | 1065 | MBP6888568.1 efflux RND transporter permease subunit [Candidatus Paceibacterota bacterium] | diamond | 261 | 162 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28611866 | 28611866 | PRJEB11523_P_NODE_1207_length_533_cov_18.421488_g1130_i0 | PRJEB11523 | 1207 | 533 | 18.421488 | 98.18653104 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 184 | 3.54e-52 | NR | HEY4503668.1 | 2053589 | g1130 | i0 | 50 | 3.98499061913696 | 182 | 82 | 97.4 | 1 | 3 | 521 | 254 | 435 | HEY4503668.1 phospholipid carrier-dependent glycosyltransferase [Candidatus Paceibacterota bacterium] | diamond | 2124 | 184 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29085567 | 29085567 | PRJEB11523_P_NODE_5308_length_202_cov_13.320261_g5230_i0 | PRJEB11523 | 5308 | 202 | 13.320261 | 26.90692722 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 42 | 0.0105 | NR | MDD4784499.1 | 2053589 | g5230 | i0 | 48.7 | 0.579207920792079 | 39 | 20 | 57.9 | 0 | 13 | 129 | 19 | 57 | MDD4784499.1 16S rRNA (uracil(1498)-N(3))-methyltransferase [Candidatus Paceibacterota bacterium] | diamond | 117 | 42 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29432452 | 29432452 | PRJEB11523_P_NODE_3210_length_278_cov_2.672489_g3132_i0 | PRJEB11523 | 3210 | 278 | 2.672489 | 7.42951942 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 155 | 1.97e-41 | NR | HTK33279.1 | 2053589 | g3132 | i0 | 95.2 | 1.82374100719424 | 84 | 4 | 90.6 | 0 | 2 | 253 | 1146 | 1229 | HTK33279.1 DNA-directed RNA polymerase subunit beta' [Candidatus Paceibacterota bacterium] | diamond | 507 | 155 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29558938 | 29558938 | PRJEB11523_P_NODE_1390_length_487_cov_32.666667_g1312_i0 | PRJEB11523 | 1390 | 487 | 32.666667 | 159.08666829 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 196 | 2.2000000000000008e-59 | NR | MFA7201647.1 | 2053589 | g1312 | i0 | 69.9 | 0.819301848049281 | 133 | 40 | 81.9 | 0 | 456 | 58 | 159 | 291 | MFA7201647.1 prepilin peptidase [Candidatus Paceibacterota bacterium] | diamond | 399 | 196 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29748207 | 29748207 | PRJEB11523_P_NODE_5471_length_199_cov_1.153333_g5393_i0 | PRJEB11523 | 5471 | 199 | 1.153333 | 2.29513267 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 79.3 | 6.43e-17 | NR | MBP7804966.1 | 2053589 | g5393 | i0 | 73.5 | 0.738693467336683 | 49 | 13 | 73.9 | 0 | 17 | 163 | 92 | 140 | MBP7804966.1 dUTP diphosphatase [Candidatus Paceibacterota bacterium] | diamond | 147 | 79.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30064240 | 30064240 | PRJEB11523_P_NODE_5052_length_208_cov_2.754717_g4974_i0 | PRJEB11523 | 5052 | 208 | 2.754717 | 5.72981136 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 83.2 | 1.33e-16 | NR | MFA7192167.1 | 2053589 | g4974 | i0 | 57.4 | 0.879807692307692 | 61 | 26 | 88 | 0 | 26 | 208 | 309 | 369 | MFA7192167.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 183 | 83.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30349266 | 30349266 | PRJEB11523_P_NODE_4732_length_216_cov_9.988024_g4654_i0 | PRJEB11523 | 4732 | 216 | 9.988024 | 21.57413184 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 59.3 | 3.65e-8 | NR | MBP9803094.1 | 2053589 | g4654 | i0 | 52.3 | 0.902777777777778 | 65 | 25 | 87.5 | 3 | 201 | 13 | 215 | 275 | MBP9803094.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 195 | 59.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30791040 | 30791040 | PRJEB11523_P_NODE_2814_length_303_cov_7.381890_g2736_i0 | PRJEB11523 | 2814 | 303 | 7.38189 | 22.3671267 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 54.7 | 3.15e-7 | NR | MCX8513643.1 | 2053589 | g2736 | i0 | 46.3 | 0.534653465346535 | 54 | 29 | 53.5 | 0 | 82 | 243 | 1 | 54 | MCX8513643.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 162 | 54.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30791042 | 30791042 | PRJEB11523_P_NODE_5214_length_204_cov_11.438710_g5136_i0 | PRJEB11523 | 5214 | 204 | 11.43871 | 23.3349684 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 43.1 | 0.0123 | NR | MFA7286029.1 | 2053589 | g5136 | i0 | 47.4 | 0.838235294117647 | 57 | 29 | 83.8 | 1 | 176 | 6 | 116 | 171 | MFA7286029.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 171 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31265051 | 31265051 | PRJEB11523_P_NODE_1135_length_553_cov_4.521825_g1059_i0 | PRJEB11523 | 1135 | 553 | 4.521825 | 25.00569225 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 270 | 5.8e-87 | NR | MDR3519797.1 | 2053589 | g1059 | i0 | 79.7 | 0.960216998191682 | 177 | 36 | 96 | 0 | 1 | 531 | 123 | 299 | MDR3519797.1 YibE/F family protein [Candidatus Paceibacterota bacterium] | diamond | 531 | 270 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32087496 | 32087496 | PRJEB11523_P_NODE_2798_length_304_cov_3.741176_g2720_i0 | PRJEB11523 | 2798 | 304 | 3.741176 | 11.37317504 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 174 | 4.68e-51 | NR | HLP86711.1 | 2053589 | g2720 | i0 | 93.6 | 4.63815789473684 | 94 | 6 | 92.8 | 0 | 282 | 1 | 229 | 322 | HLP86711.1 rod shape-determining protein [Candidatus Paceibacterota bacterium] | diamond | 1410 | 174 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32562381 | 32562381 | PRJEB11523_P_NODE_1079_length_570_cov_35.959693_g1003_i0 | PRJEB11523 | 1079 | 570 | 35.959693 | 204.9702501 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 191 | 4.959999999999999e-54 | NR | HEY4516099.1 | 2053589 | g1003 | i0 | 54.6 | 3.85789473684211 | 185 | 77 | 94.7 | 2 | 2 | 541 | 313 | 495 | HEY4516099.1 glycosyltransferase family 39 protein [Candidatus Paceibacterota bacterium] | diamond | 2199 | 191 | 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);;