contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1108009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2763796 | 2763796 | PRJNA1108009_P_NODE_26723_length_248_cov_0.880000_g26405_i0 | PRJNA1108009 | 26723 | 248 | 0.88 | 2.1824 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 169 | 1.41e-49 | NR | MBR6576899.1 | 1872421 | g26405 | i0 | 98.8 | 1.98387096774194 | 82 | 1 | 99.2 | 0 | 2 | 247 | 127 | 208 | MBR6576899.1 hypothetical protein [Akkermansia sp.] | diamond | 492 | 169 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 10416612 | 10416612 | PRJNA1108009_P_NODE_30909_length_242_cov_0.911243_g30591_i0 | PRJNA1108009 | 30909 | 242 | 0.911243 | 2.20520806 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 160 | 1.0499999999999999e-47 | NR | MBR6575989.1 | 1872421 | g30591 | i0 | 98.8 | 2.96280991735537 | 80 | 1 | 99.2 | 0 | 240 | 1 | 90 | 169 | MBR6575989.1 succinate dehydrogenase/fumarate reductase iron-sulfur subunit [Akkermansia sp.] | diamond | 717 | 160 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 26592663 | 26592663 | PRJNA1108009_P_NODE_28401_length_246_cov_0.890173_g28083_i0 | PRJNA1108009 | 28401 | 246 | 0.890173 | 2.18982558 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 55.5 | 1.21e-6 | NR | MBP3500293.1 | 1872421 | g28083 | i0 | 89.3 | 1.02439024390244 | 28 | 3 | 34.1 | 0 | 85 | 2 | 325 | 352 | MBP3500293.1 ATP-binding protein [Akkermansia sp.] | diamond | 252 | 55.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 27099257 | 27099257 | PRJNA1108009_P_NODE_20402_length_284_cov_1.464455_g20084_i0 | PRJNA1108009 | 20402 | 284 | 1.464455 | 4.1590522 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 164 | 1.26e-44 | NR | MBR5876709.1 | 1872421 | g20084 | i0 | 84 | 1.98591549295775 | 94 | 15 | 99.3 | 0 | 2 | 283 | 55 | 148 | MBR5876709.1 toll/interleukin-1 receptor domain-containing protein [Akkermansia sp.] | diamond | 564 | 164 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 27099262 | 27099262 | PRJNA1108009_P_NODE_27702_length_247_cov_0.885057_g27384_i0 | PRJNA1108009 | 27702 | 247 | 0.885057 | 2.18609079 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 85.9 | 2.45e-17 | NR | MBR3902735.1 | 1872421 | g27384 | i0 | 60.7 | 1.02024291497976 | 84 | 24 | 99.6 | 2 | 247 | 2 | 190 | 266 | MBR3902735.1 autotransporter outer membrane beta-barrel domain-containing protein [Akkermansia sp.] | diamond | 252 | 85.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 27225571 | 27225571 | PRJNA1108009_P_NODE_23783_length_257_cov_1.369565_g23465_i0 | PRJNA1108009 | 23783 | 257 | 1.369565 | 3.51978205 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 174 | 2.5599999999999994e-48 | NR | MBQ7024911.1 | 1872421 | g23465 | i0 | 98.8 | 1.98443579766537 | 85 | 1 | 99.2 | 0 | 256 | 2 | 468 | 552 | MBQ7024911.1 hypothetical protein [Akkermansia sp.] | diamond | 510 | 174 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 27288964 | 27288964 | PRJNA1108009_P_NODE_31383_length_241_cov_0.916667_g31065_i0 | PRJNA1108009 | 31383 | 241 | 0.916667 | 2.20916747 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 167 | 6.859999999999999e-47 | NR | MBQ9829073.1 | 1872421 | g31065 | i0 | 97.5 | 0.995850622406639 | 80 | 2 | 99.6 | 0 | 240 | 1 | 187 | 266 | MBQ9829073.1 membrane protein insertase YidC [Akkermansia sp.] | diamond | 240 | 167 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 27604984 | 27604984 | PRJNA1108009_P_NODE_31724_length_241_cov_0.916667_g31406_i0 | PRJNA1108009 | 31724 | 241 | 0.916667 | 2.20916747 | Opitutales bacterium | 2026772 | Bacteria | Bacteria | 65.9 | 1.47e-10 | NR | MBR5623192.1 | 2026772 | g31406 | i0 | 55.4 | 0.921161825726141 | 74 | 23 | 83.4 | 2 | 236 | 36 | 206 | 276 | MBR5623192.1 MotA/TolQ/ExbB proton channel family protein [Opitutales bacterium] | diamond | 222 | 65.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 28204518 | 28204518 | PRJNA1108009_P_NODE_26326_length_249_cov_0.875000_g26008_i0 | PRJNA1108009 | 26326 | 249 | 0.875 | 2.17875 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 162 | 1.04e-48 | NR | MBR3943771.1 | 1872421 | g26008 | i0 | 96.4 | 2 | 83 | 3 | 100 | 0 | 1 | 249 | 57 | 139 | MBR3943771.1 septum formation protein Maf [Akkermansia sp.] | diamond | 498 | 162 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 28330930 | 28330930 | PRJNA1108009_P_NODE_27026_length_248_cov_0.880000_g26708_i0 | PRJNA1108009 | 27026 | 248 | 0.88 | 2.1824 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 61.6 | 8.74e-9 | NR | MBQ9835454.1 | 1872421 | g26708 | i0 | 90.3 | 0.375 | 31 | 3 | 37.5 | 0 | 246 | 154 | 604 | 634 | MBQ9835454.1 sulfatase-like hydrolase/transferase [Akkermansia sp.] | diamond | 93 | 61.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 28488949 | 28488949 | PRJNA1108009_P_NODE_31547_length_241_cov_0.916667_g31229_i0 | PRJNA1108009 | 31547 | 241 | 0.916667 | 2.20916747 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 116 | 5e-28 | NR | MBR6576566.1 | 1872421 | g31229 | i0 | 69.2 | 0.970954356846473 | 78 | 24 | 97.1 | 0 | 7 | 240 | 407 | 484 | MBR6576566.1 hypothetical protein [Akkermansia sp.] | diamond | 234 | 116 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 28520547 | 28520547 | PRJNA1108009_P_NODE_21567_length_275_cov_1.356436_g21249_i0 | PRJNA1108009 | 21567 | 275 | 1.356436 | 3.730199 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 144 | 4.02e-42 | NR | MBQ8377312.1 | 1872421 | g21249 | i0 | 95.8 | 0.774545454545455 | 71 | 3 | 77.5 | 0 | 63 | 275 | 1 | 71 | MBQ8377312.1 helix-turn-helix transcriptional regulator [Akkermansia sp.] | diamond | 213 | 144 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 28931001 | 28931001 | PRJNA1108009_P_NODE_26908_length_248_cov_0.880000_g26590_i0 | PRJNA1108009 | 26908 | 248 | 0.88 | 2.1824 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 164 | 1.08e-45 | NR | MBQ3217635.1 | 1872421 | g26590 | i0 | 96.3 | 0.991935483870968 | 82 | 3 | 99.2 | 0 | 1 | 246 | 40 | 121 | MBQ3217635.1 amidophosphoribosyltransferase [Akkermansia sp.] | diamond | 246 | 164 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 29025959 | 29025959 | PRJNA1108009_P_NODE_27788_length_247_cov_0.885057_g27470_i0 | PRJNA1108009 | 27788 | 247 | 0.885057 | 2.18609079 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 158 | 7.92e-43 | NR | MBP3500224.1 | 1872421 | g27470 | i0 | 87.8 | 1.9919028340081 | 82 | 10 | 99.6 | 0 | 246 | 1 | 860 | 941 | MBP3500224.1 hypothetical protein [Akkermansia sp.] | diamond | 492 | 158 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 29309751 | 29309751 | PRJNA1108009_P_NODE_29449_length_244_cov_0.900585_g29131_i0 | PRJNA1108009 | 29449 | 244 | 0.900585 | 2.1974274 | Opitutales bacterium | 2026772 | Bacteria | Bacteria | 90.1 | 4.97e-19 | NR | MDY6069594.1 | 2026772 | g29131 | i0 | 56.8 | 1.99180327868852 | 81 | 35 | 99.6 | 0 | 244 | 2 | 318 | 398 | MDY6069594.1 glycosyltransferase family 4 protein [Opitutales bacterium] | diamond | 486 | 90.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 29814893 | 29814893 | PRJNA1108009_P_NODE_23751_length_257_cov_2.326087_g23433_i0 | PRJNA1108009 | 23751 | 257 | 2.326087 | 5.97804359 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 135 | 1.54e-36 | NR | MBR5331169.1 | 1872421 | g23433 | i0 | 93.8 | 0.75875486381323 | 65 | 4 | 75.9 | 0 | 195 | 1 | 1 | 65 | MBR5331169.1 thioredoxin family protein [Akkermansia sp.] | diamond | 195 | 135 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 30289266 | 30289266 | PRJNA1108009_P_NODE_29632_length_244_cov_0.900585_g29314_i0 | PRJNA1108009 | 29632 | 244 | 0.900585 | 2.1974274 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 153 | 1.2e-45 | NR | MBR5889330.1 | 1872421 | g29314 | i0 | 90.1 | 0.995901639344262 | 81 | 8 | 99.6 | 0 | 2 | 244 | 53 | 133 | MBR5889330.1 hypothetical protein [Akkermansia sp.] | diamond | 243 | 153 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 30731172 | 30731172 | PRJNA1108009_P_NODE_28054_length_246_cov_0.890173_g27736_i0 | PRJNA1108009 | 28054 | 246 | 0.890173 | 2.18982558 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 154 | 7.8e-45 | NR | MBR2144576.1 | 1872421 | g27736 | i0 | 91.4 | 0.98780487804878 | 81 | 7 | 98.8 | 0 | 244 | 2 | 96 | 176 | MBR2144576.1 glycoside hydrolase family 95 protein [Akkermansia sp.] | diamond | 243 | 154 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 31932577 | 31932577 | PRJNA1108009_P_NODE_30317_length_243_cov_0.905882_g29999_i0 | PRJNA1108009 | 30317 | 243 | 0.905882 | 2.20129326 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 167 | 5.26e-49 | NR | MBQ6941246.1 | 1872421 | g29999 | i0 | 100 | 0.987654320987654 | 80 | 0 | 98.8 | 0 | 241 | 2 | 195 | 274 | MBQ6941246.1 hypothetical protein [Akkermansia sp.] | diamond | 240 | 167 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 32122679 | 32122679 | PRJNA1108009_P_NODE_21338_length_277_cov_1.264706_g21020_i0 | PRJNA1108009 | 21338 | 277 | 1.264706 | 3.50323562 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 89.7 | 1.42e-18 | NR | MBQ8479279.1 | 1872421 | g21020 | i0 | 84 | 1.08303249097473 | 50 | 8 | 54.2 | 0 | 126 | 275 | 72 | 121 | MBQ8479279.1 replicative DNA helicase [Akkermansia sp.] | diamond | 300 | 89.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 32185869 | 32185869 | PRJNA1108009_P_NODE_24898_length_251_cov_0.865169_g24580_i0 | PRJNA1108009 | 24898 | 251 | 0.865169 | 2.17157419 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 79.3 | 4.03e-15 | NR | MBQ8479294.1 | 1872421 | g24580 | i0 | 51.8 | 0.99203187250996006 | 83 | 40 | 99.2 | 0 | 250 | 2 | 193 | 275 | MBQ8479294.1 hypothetical protein [Akkermansia sp.] | diamond | 249 | 79.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 32470753 | 32470753 | PRJNA1108009_P_NODE_22939_length_264_cov_1.230366_g22621_i0 | PRJNA1108009 | 22939 | 264 | 1.230366 | 3.24816624 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 149 | 1.84e-39 | NR | MBQ9829201.1 | 1872421 | g22621 | i0 | 84.1 | 1 | 88 | 14 | 100 | 0 | 1 | 264 | 76 | 163 | MBQ9829201.1 family 20 glycosylhydrolase [Akkermansia sp.] | diamond | 264 | 149 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 32754400 | 32754400 | PRJNA1108009_P_NODE_25600_length_250_cov_0.870056_g25282_i0 | PRJNA1108009 | 25600 | 250 | 0.870056 | 2.17514 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 88.2 | 2.44e-20 | NR | MBE6415432.1 | 2562705 | g25282 | i0 | 93.5 | 0.552 | 46 | 3 | 55.2 | 0 | 139 | 2 | 1 | 46 | MBE6415432.1 ribosome silencing factor [Akkermansiaceae bacterium] | diamond | 138 | 88.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 32848821 | 32848821 | PRJNA1108009_P_NODE_25460_length_250_cov_0.870056_g25142_i0 | PRJNA1108009 | 25460 | 250 | 0.870056 | 2.17514 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 162 | 1.83e-45 | NR | MEE1265810.1 | 1872421 | g25142 | i0 | 95.2 | 0.996 | 83 | 4 | 99.6 | 0 | 1 | 249 | 363 | 445 | MEE1265810.1 hypothetical protein [Akkermansia sp.] | diamond | 249 | 162 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia 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);;