contig_metadata
18 rows where bioproject = "PRJNA857857" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13989758 | 13989758 | PRJNA857857_P_NODE_9311_length_512_cov_1.227790_g8874_i0 | PRJNA857857 | 9311 | 512 | 1.22779 | 6.2862848 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 251 | 6.12e-81 | NR | MEY3480008.1 | 2026799 | g8874 | i0 | 76.8 | 19.48828125 | 151 | 35 | 88.5 | 0 | 456 | 4 | 98 | 248 | MEY3480008.1 Phosphoglycerate mutase 1 [Verrucomicrobiota bacterium] | diamond | 9978 | 251 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 19971895 | 19971895 | PRJNA857857_P_NODE_45736_length_245_cov_0.895349_g45287_i0 | PRJNA857857 | 45736 | 245 | 0.895349 | 2.19360505 | Akkermansia massiliensis | 2927224 | Bacteria | Bacteria | 113 | 1e-20 | NTclustered | gi|2736739857|gb|CP156916.1| | 2927224 | g45287 | i0 | 85.321 | 6.97551020408163 | 109 | 16 | 44 | 0 | 137 | 245 | 2449833 | 2449725 | Akkermansia massiliensis strain Akk273 chromosome, complete genome | blastn | 1709 | 113 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia massiliensis | |
| 26897048 | 26897048 | PRJNA857857_P_NODE_29181_length_286_cov_1.319249_g28732_i0 | PRJNA857857 | 29181 | 286 | 1.319249 | 3.77305214 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 42.7 | 0.0433 | NR | MEI6341235.1 | 2026799 | g28732 | i0 | 42 | 0.524475524475524 | 50 | 27 | 50.3 | 1 | 157 | 14 | 109 | 158 | MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] | diamond | 150 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27149468 | 27149468 | PRJNA857857_P_NODE_23322_length_323_cov_1.828000_g22873_i0 | PRJNA857857 | 23322 | 323 | 1.828 | 5.90444 | Luteolibacter marinus | 2776705 | Bacteria | Bacteria | 58.5 | 2.23e-7 | NR | WP_193215151.1 | 2776705 | g22873 | i0 | 61.4 | 1.65325077399381 | 44 | 14 | 40.9 | 1 | 134 | 3 | 5 | 45 | WP_193215151.1 aldo/keto reductase [Luteolibacter marinus] | diamond | 534 | 58.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter marinus | |
| 27308145 | 27308145 | PRJNA857857_P_NODE_51103_length_241_cov_0.916667_g50654_i0 | PRJNA857857 | 51103 | 241 | 0.916667 | 2.20916747 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 166 | 5.27e-51 | NR | MFT6180689.1 | 2562705 | g50654 | i0 | 97.5 | 4.9792531120332 | 80 | 2 | 99.6 | 0 | 2 | 241 | 6 | 85 | MFT6180689.1 dCMP deaminase [Akkermansiaceae bacterium] | diamond | 1200 | 166 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 27750299 | 27750299 | PRJNA857857_P_NODE_20564_length_345_cov_1.250000_g20115_i0 | PRJNA857857 | 20564 | 345 | 1.25 | 4.3125 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 163 | 8.49e-49 | NR | MBN8246636.1 | 2026799 | g20115 | i0 | 71.8 | 3.88695652173913 | 110 | 30 | 95.7 | 1 | 10 | 339 | 8 | 116 | MBN8246636.1 glutathione peroxidase [Verrucomicrobiota bacterium] | diamond | 1341 | 163 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28326395 | 28326395 | PRJNA857857_P_NODE_17006_length_381_cov_1.035714_g16559_i0 | PRJNA857857 | 17006 | 381 | 1.035714 | 3.94607034 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 55.1 | 8.28e-6 | NR | HOX57815.1 | 2026799 | g16559 | i0 | 45 | 0.984251968503937 | 60 | 31 | 47.2 | 1 | 180 | 359 | 595 | 652 | HOX57815.1 dihydrodipicolinate synthase family protein [Verrucomicrobiota bacterium] | diamond | 375 | 55.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28413177 | 28413177 | PRJNA857857_P_NODE_10446_length_486_cov_1.259080_g10006_i0 | PRJNA857857 | 10446 | 486 | 1.25908 | 6.1191288 | Verrucomicrobium sp. BvORR | 72225 | Bacteria | Bacteria | 57.4 | 3.66e-6 | NR | WP_050024832.1 | 1396418 | g10006 | i0 | 47.6 | 0.388888888888889 | 63 | 33 | 38.9 | 0 | 1 | 189 | 646 | 708 | WP_050024832.1 protein kinase domain-containing protein [Verrucomicrobium sp. BvORR034] | diamond | 189 | 57.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium sp. BvORR034 | |
| 28737041 | 28737041 | PRJNA857857_P_NODE_39147_length_250_cov_0.864407_g38698_i0 | PRJNA857857 | 39147 | 250 | 0.864407 | 2.1610175 | PVC group | 1783257 | Bacteria | Bacteria | 82.8 | 3.22e-16 | NR | MBX7209452.1 | 2026800 | g38698 | i0 | 47.6 | 2.988 | 82 | 43 | 98.4 | 0 | 246 | 1 | 443 | 524 | MBX7209452.1 molecular chaperone HtpG [Verrucomicrobiaceae bacterium] | diamond | 747 | 83.6 | 0.990430622009569 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 28760337 | 28760337 | PRJNA857857_P_NODE_46047_length_245_cov_0.895349_g45598_i0 | PRJNA857857 | 46047 | 245 | 0.895349 | 2.19360505 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 55.8 | 1.92e-7 | NR | MBT7853776.1 | 2026771 | g45598 | i0 | 74.2 | 1.2734693877551 | 31 | 8 | 38 | 0 | 95 | 3 | 36 | 66 | MBT7853776.1 hypothetical protein [Opitutia bacterium] | diamond | 312 | 55.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 29044769 | 29044769 | PRJNA857857_P_NODE_23688_length_321_cov_0.983871_g23239_i0 | PRJNA857857 | 23688 | 321 | 0.983871 | 3.15822591 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 111 | 5.57e-26 | NR | HTS19718.1 | 2499141 | g23239 | i0 | 52.4 | 0.981308411214953 | 105 | 50 | 98.1 | 0 | 317 | 3 | 227 | 331 | HTS19718.1 glycoside hydrolase family 28 protein [Verrucomicrobiia bacterium] | diamond | 315 | 111 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29549584 | 29549584 | PRJNA857857_P_NODE_22350_length_330_cov_2.392996_g21901_i0 | PRJNA857857 | 22350 | 330 | 2.392996 | 7.8968868 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 82 | 1.41e-15 | NR | MFM2295308.1 | 2026799 | g21901 | i0 | 43.8 | 1.1 | 121 | 48 | 92.7 | 4 | 1 | 306 | 44 | 163 | MFM2295308.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 363 | 82 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29707202 | 29707202 | PRJNA857857_P_NODE_35390_length_256_cov_1.262295_g34941_i0 | PRJNA857857 | 35390 | 256 | 1.262295 | 3.2314752 | Candidatus Methylacidiphilales bacterium | 2720631 | Bacteria | Bacteria | 63.9 | 1.5e-9 | NR | HUB66648.1 | 2720631 | g34941 | i0 | 49.2 | 0.69140625 | 59 | 28 | 69.1 | 1 | 4 | 180 | 249 | 305 | HUB66648.1 hypothetical protein [Candidatus Methylacidiphilales bacterium] | diamond | 177 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Methylacidiphilae | Methylacidiphilales | Candidatus Methylacidiphilales bacterium | |||
| 30348103 | 30348103 | PRJNA857857_P_NODE_39852_length_249_cov_0.875000_g39403_i0 | PRJNA857857 | 39852 | 249 | 0.875 | 2.17875 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 50.1 | 1.12e-4 | NR | AKC81624.1 | 1637999 | g39403 | i0 | 39.1 | 1.78313253012048 | 69 | 33 | 81.9 | 2 | 1 | 204 | 45 | 105 | AKC81624.1 hypothetical protein IMCC26134_00465 [Verrucomicrobia bacterium IMCC26134] | diamond | 444 | 50.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobia bacterium IMCC26134 | |||||
| 30371484 | 30371484 | PRJNA857857_P_NODE_47132_length_244_cov_0.900585_g46683_i0 | PRJNA857857 | 47132 | 244 | 0.900585 | 2.1974274 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 123 | 4.1e-32 | NR | MEI6781227.1 | 2026799 | g46683 | i0 | 74.1 | 3 | 81 | 21 | 99.6 | 0 | 243 | 1 | 103 | 183 | MEI6781227.1 shikimate dehydrogenase [Verrucomicrobiota bacterium] | diamond | 732 | 123 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30528924 | 30528924 | PRJNA857857_P_NODE_22433_length_330_cov_1.194553_g21984_i0 | PRJNA857857 | 22433 | 330 | 1.194553 | 3.9420249 | Opitutus sp. | 1913982 | Bacteria | Bacteria | 129 | 5.41e-33 | NR | HWL14429.1 | 1913982 | g21984 | i0 | 58.8 | 2.78181818181818 | 102 | 42 | 92.7 | 0 | 23 | 328 | 94 | 195 | HWL14429.1 glycoside hydrolase family 27 protein [Opitutus sp.] | diamond | 918 | 129 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. | |
| 32646990 | 32646990 | PRJNA857857_P_NODE_39060_length_250_cov_0.870056_g38611_i0 | PRJNA857857 | 39060 | 250 | 0.870056 | 2.17514 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 46.6 | 0.00181 | NR | MDP4624182.1 | 2562705 | g38611 | i0 | 35.1 | 0.924 | 77 | 48 | 90 | 2 | 250 | 26 | 724 | 800 | MDP4624182.1 carbohydrate-binding protein [Akkermansiaceae bacterium] | diamond | 231 | 46.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 32899085 | 32899085 | PRJNA857857_P_NODE_24800_length_313_cov_1.208333_g24351_i0 | PRJNA857857 | 24800 | 313 | 1.208333 | 3.78208229 | Pedosphaera sp. | 2024890 | Bacteria | Bacteria | 48.1 | 5.5e-4 | NR | MSU84020.1 | 2024890 | g24351 | i0 | 59.4 | 0.306709265175719 | 32 | 13 | 30.7 | 0 | 110 | 205 | 69 | 100 | MSU84020.1 ankyrin repeat domain-containing protein [Pedosphaera sp.] | diamond | 96 | 48.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera sp. |
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);;