contig_metadata
13 rows where bioproject = "PRJNA704949" and tax_phylum = "Candidatus Parcubacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3247564 | 3247564 | PRJNA704949_P_NODE_30183_length_1447_cov_2.022175_g21149_i0 | PRJNA704949 | 30183 | 1447 | 2.022175 | 29.26087225 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 336 | 2.7e-109 | NR | MBW3537902.1 | 2762014 | g21149 | i0 | 58.6 | 0.611610228058051 | 295 | 120 | 60.7 | 2 | 136 | 1014 | 13 | 307 | MBW3537902.1 orotidine-5'-phosphate decarboxylase [Candidatus Parcubacteria bacterium] | diamond | 885 | 336 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 9616195 | 9616195 | PRJNA704949_P_NODE_1203288_length_232_cov_1.136612_g1187951_i0 | PRJNA704949 | 1203288 | 232 | 1.136612 | 2.63693984 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 94.4 | 2.22e-20 | NR | RMD63071.1 | 2762014 | g1187951 | i0 | 57.1 | 1.99137931034483 | 77 | 33 | 99.6 | 0 | 2 | 232 | 350 | 426 | RMD63071.1 MAG: hypothetical protein D6833_06050, partial [Candidatus Parcubacteria bacterium] | diamond | 462 | 95.1 | 0.992639327024185 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 26861733 | 26861733 | PRJNA704949_P_NODE_1043661_length_253_cov_2.730392_g1028325_i0 | PRJNA704949 | 1043661 | 253 | 2.730392 | 6.90789176 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 53.1 | 7.55e-6 | NR | MEN9389858.1 | 2762014 | g1028325 | i0 | 38 | 1.82608695652174 | 79 | 36 | 88.9 | 3 | 28 | 252 | 1 | 70 | MEN9389858.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 462 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 27020176 | 27020176 | PRJNA704949_P_NODE_7522_length_4467_cov_6.721141_g3105_i0 | PRJNA704949 | 7522 | 4467 | 6.721141 | 300.23336847 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 152 | 2.56e-37 | NR | MEY4744399.1 | 2762014 | g3105 | i0 | 39.6 | 0.142377434519812 | 212 | 114 | 13.6 | 3 | 1773 | 2381 | 1 | 207 | MEY4744399.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 636 | 152 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 27114701 | 27114701 | PRJNA704949_P_NODE_337702_length_465_cov_2.286058_g322761_i0 | PRJNA704949 | 337702 | 465 | 2.286058 | 10.6301697 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 144 | 1.5e-38 | NR | MBW3568924.1 | 2762014 | g322761 | i0 | 55.8 | 0.832258064516129 | 129 | 56 | 82.6 | 1 | 82 | 465 | 1 | 129 | MBW3568924.1 phenylalanine--tRNA ligase subunit alpha [Candidatus Parcubacteria bacterium] | diamond | 387 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 27336058 | 27336058 | PRJNA704949_P_NODE_1726843_length_183_cov_1.164179_g1711504_i0 | PRJNA704949 | 1726843 | 183 | 1.164179 | 2.13044757 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 70.1 | 3.04e-13 | NR | MBW3568550.1 | 2762014 | g1711504 | i0 | 68.9 | 1 | 61 | 17 | 98.4 | 2 | 3 | 182 | 82 | 141 | MBW3568550.1 septum formation initiator family protein [Candidatus Parcubacteria bacterium] | diamond | 183 | 70.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 28630674 | 28630674 | PRJNA704949_P_NODE_1452347_length_205_cov_1.615385_g1437009_i0 | PRJNA704949 | 1452347 | 205 | 1.615385 | 3.31153925 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 70.5 | 3.84e-12 | NR | MBC7766561.1 | 2762014 | g1437009 | i0 | 52.9 | 0.995121951219512 | 68 | 29 | 99.5 | 1 | 1 | 204 | 517 | 581 | MBC7766561.1 AAA family ATPase [Candidatus Parcubacteria bacterium] | diamond | 204 | 70.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 29041030 | 29041030 | PRJNA704949_P_NODE_1073108_length_249_cov_1.680000_g1057772_i0 | PRJNA704949 | 1073108 | 249 | 1.68 | 4.1832 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 75.5 | 8.16e-14 | NR | MBC7766560.1 | 2762014 | g1057772 | i0 | 41.5 | 0.987951807228916 | 82 | 47 | 98.8 | 1 | 248 | 3 | 128 | 208 | MBC7766560.1 transposase family protein [Candidatus Parcubacteria bacterium] | diamond | 246 | 75.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 30114458 | 30114458 | PRJNA704949_P_NODE_1322612_length_218_cov_1.538462_g1307275_i0 | PRJNA704949 | 1322612 | 218 | 1.538462 | 3.35384716 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 68.9 | 4.99e-12 | NR | MCG2701398.1 | 2762014 | g1307275 | i0 | 59.3 | 4.98165137614679 | 59 | 24 | 81.2 | 0 | 36 | 212 | 141 | 199 | MCG2701398.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 1086 | 68.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 30683615 | 30683615 | PRJNA704949_P_NODE_857253_length_286_cov_1.329114_g841919_i0 | PRJNA704949 | 857253 | 286 | 1.329114 | 3.80126604 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 79.3 | 1.39e-15 | NR | MBW3568952.1 | 2762014 | g841919 | i0 | 48.4 | 0.954545454545455 | 91 | 47 | 95.5 | 0 | 286 | 14 | 140 | 230 | MBW3568952.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 273 | 79.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 31031500 | 31031500 | PRJNA704949_P_NODE_667015_length_331_cov_1.184397_g651687_i0 | PRJNA704949 | 667015 | 331 | 1.184397 | 3.92035407 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 127 | 1.66e-33 | NR | MBW3568703.1 | 2762014 | g651687 | i0 | 59.8 | 0.969788519637462 | 107 | 42 | 96.1 | 1 | 6 | 323 | 26 | 132 | MBW3568703.1 YmdB family metallophosphoesterase [Candidatus Parcubacteria bacterium] | diamond | 321 | 127 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 31789898 | 31789898 | PRJNA704949_P_NODE_452577_length_405_cov_1.460674_g437377_i0 | PRJNA704949 | 452577 | 405 | 1.460674 | 5.9157297 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 201 | 1.16e-61 | NR | MBW3568881.1 | 2762014 | g437377 | i0 | 72 | 0.977777777777778 | 132 | 37 | 97.8 | 0 | 2 | 397 | 94 | 225 | MBW3568881.1 mechanosensitive ion channel family protein [Candidatus Parcubacteria bacterium] | diamond | 396 | 201 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 31979984 | 31979984 | PRJNA704949_P_NODE_967578_length_265_cov_4.583333_g952243_i0 | PRJNA704949 | 967578 | 265 | 4.583333 | 12.14583245 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 139 | 4.48e-37 | NR | MBW3568683.1 | 2762014 | g952243 | i0 | 78.4 | 1.99245283018868 | 88 | 19 | 99.6 | 0 | 2 | 265 | 265 | 352 | MBW3568683.1 serine hydroxymethyltransferase [Candidatus Parcubacteria bacterium] | diamond | 528 | 139 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria 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);;