contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA492280" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26633197 | 26633197 | PRJNA492280_P_NODE_24481_length_164_cov_2.661417_g24374_i0 | PRJNA492280 | 24481 | 164 | 2.661417 | 4.36472388 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 49.7 | 2.5e-5 | NR | HVY70133.1 | 2499141 | g24374 | i0 | 56.8 | 0.804878048780488 | 44 | 19 | 80.5 | 0 | 2 | 133 | 53 | 96 | HVY70133.1 ECF-type sigma factor [Verrucomicrobiia bacterium] | diamond | 132 | 49.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 26776081 | 26776081 | PRJNA492280_P_NODE_21161_length_164_cov_3.133858_g21054_i0 | PRJNA492280 | 21161 | 164 | 3.133858 | 5.13952712 | Pedosphaera | 1032526 | Bacteria | Bacteria | 77.4 | 5.89e-15 | NR | MSU04578.1 | 2024890 | g21054 | i0 | 61 | 2.81707317073171 | 77 | 7 | 98.8 | 1 | 2 | 163 | 43 | 119 | MSU04578.1 hypothetical protein [Pedosphaera sp.] | diamond | 462 | 77.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera sp. | |
| 26823382 | 26823382 | PRJNA492280_P_NODE_12461_length_164_cov_6.480315_g12354_i0 | PRJNA492280 | 12461 | 164 | 6.480315 | 10.6277166 | Pedosphaera sp. | 2024890 | Bacteria | Bacteria | 49.7 | 4.56e-5 | NR | MSU04772.1 | 2024890 | g12354 | i0 | 100 | 0.439024390243902 | 24 | 0 | 43.9 | 0 | 160 | 89 | 817 | 840 | MSU04772.1 hypothetical protein [Pedosphaera sp.] | diamond | 72 | 49.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera sp. | |
| 27044795 | 27044795 | PRJNA492280_P_NODE_23462_length_164_cov_2.803150_g23355_i0 | PRJNA492280 | 23462 | 164 | 2.80315 | 4.597166 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 55.5 | 4.11e-7 | NR | RFC45908.1 | 2026799 | g23355 | i0 | 75.7 | 2.70731707317073 | 37 | 8 | 67.7 | 1 | 162 | 52 | 155 | 190 | RFC45908.1 MAG: beta-propeller fold [Verrucomicrobiota bacterium] | diamond | 444 | 55.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27629667 | 27629667 | PRJNA492280_P_NODE_32804_length_150_cov_5.008850_g32697_i0 | PRJNA492280 | 32804 | 150 | 5.00885 | 7.513275 | Prosthecobacter | 48463 | Bacteria | Bacteria | 47.4 | 2.41e-4 | NR | MBV6501187.1 | 1965333 | g32697 | i0 | 95.8 | 4.82 | 24 | 1 | 48 | 0 | 149 | 78 | 579 | 602 | MBV6501187.1 hypothetical protein [Prosthecobacter sp.] | diamond | 723 | 47.8 | 0.99163179916318 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 27960791 | 27960791 | PRJNA492280_P_NODE_15805_length_164_cov_4.299213_g15698_i0 | PRJNA492280 | 15805 | 164 | 4.299213 | 7.05070932 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 48.5 | 1.16e-4 | NR | MEI7773390.1 | 2026799 | g15698 | i0 | 91.7 | 1.31707317073171 | 24 | 2 | 43.9 | 0 | 91 | 162 | 579 | 602 | MEI7773390.1 thioredoxin domain-containing protein [Verrucomicrobiota bacterium] | diamond | 216 | 48.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28181572 | 28181572 | PRJNA492280_P_NODE_33486_length_150_cov_3.955752_g33379_i0 | PRJNA492280 | 33486 | 150 | 3.955752 | 5.933628 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 43.1 | 0.00756 | NR | TMQ01562.1 | 2026799 | g33379 | i0 | 62.5 | 0.48 | 24 | 9 | 48 | 0 | 77 | 148 | 94 | 117 | TMQ01562.1 MAG: DUF1080 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 72 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28560839 | 28560839 | PRJNA492280_P_NODE_14907_length_164_cov_4.622047_g14800_i0 | PRJNA492280 | 14907 | 164 | 4.622047 | 7.58015708 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 52 | 6.88e-6 | NR | MEN9403412.1 | 2026799 | g14800 | i0 | 92 | 0.457317073170732 | 25 | 2 | 45.7 | 0 | 163 | 89 | 33 | 57 | MEN9403412.1 Inositol 2-dehydrogenase [Verrucomicrobiota bacterium] | diamond | 75 | 52 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28655520 | 28655520 | PRJNA492280_P_NODE_26787_length_163_cov_3.912698_g26680_i0 | PRJNA492280 | 26787 | 163 | 3.912698 | 6.37769774 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 50.1 | 1.5e-6 | NR | WP_294232248.1 | 1965333 | g26680 | i0 | 100 | 0.404907975460123 | 22 | 0 | 40.5 | 0 | 90 | 155 | 30 | 51 | WP_294232248.1 hypothetical protein [Prosthecobacter sp.] | diamond | 66 | 50.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 29003188 | 29003188 | PRJNA492280_P_NODE_14948_length_164_cov_4.606299_g14841_i0 | PRJNA492280 | 14948 | 164 | 4.606299 | 7.55433036 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 48.1 | 1.6e-4 | NR | MBM3865737.1 | 2026799 | g14841 | i0 | 63.2 | 0.695121951219512 | 38 | 10 | 62.2 | 1 | 61 | 162 | 737 | 774 | MBM3865737.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 114 | 48.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29523966 | 29523966 | PRJNA492280_P_NODE_19750_length_164_cov_3.377953_g19643_i0 | PRJNA492280 | 19750 | 164 | 3.377953 | 5.53984292 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 62 | 2.03e-9 | NR | WP_294383978.1 | 1965333 | g19643 | i0 | 59.6 | 3.64024390243902 | 52 | 20 | 93.3 | 1 | 4 | 156 | 328 | 379 | WP_294383978.1 DUF1553 domain-containing protein [Prosthecobacter sp.] | diamond | 597 | 62 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 29665420 | 29665420 | PRJNA492280_P_NODE_31210_length_151_cov_3.324561_g31103_i0 | PRJNA492280 | 31210 | 151 | 3.324561 | 5.02008711 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 48.5 | 9.77e-5 | NR | HEV7403119.1 | 2811408 | g31103 | i0 | 46 | 5.14569536423841 | 63 | 16 | 89.4 | 1 | 147 | 13 | 736 | 798 | HEV7403119.1 carbohydrate binding domain-containing protein [Chthoniobacteraceae bacterium] | diamond | 777 | 48.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 29681447 | 29681447 | PRJNA492280_P_NODE_22750_length_164_cov_2.897638_g22643_i0 | PRJNA492280 | 22750 | 164 | 2.897638 | 4.75212632 | Bacteria | 2 | Bacteria | Bacteria | 84.7 | 1.26e-17 | NR | MEY2466629.1 | 2026799 | g22643 | i0 | 84.9 | 5.81707317073171 | 53 | 7 | 97 | 1 | 3 | 161 | 34 | 85 | MEY2466629.1 pyruvate kinase [Verrucomicrobiota bacterium] | diamond | 954 | 85.5 | 0.990643274853801 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29966095 | 29966095 | PRJNA492280_P_NODE_23331_length_164_cov_2.818898_g23224_i0 | PRJNA492280 | 23331 | 164 | 2.818898 | 4.62299272 | Bacteria | 2 | Bacteria | Bacteria | 86.7 | 1.05e-18 | NR | HUR56723.1 | 2006848 | g23224 | i0 | 65.7 | 7.35365853658537 | 67 | 10 | 98.8 | 1 | 1 | 162 | 217 | 283 | HUR56723.1 NAD(P)-dependent oxidoreductase [Opitutaceae bacterium] | diamond | 1206 | 86.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 29981626 | 29981626 | PRJNA492280_P_NODE_22511_length_164_cov_2.929134_g22404_i0 | PRJNA492280 | 22511 | 164 | 2.929134 | 4.80377976 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 48.1 | 1.57e-4 | NR | KAB2653290.1 | 2026799 | g22404 | i0 | 61.9 | 2.03048780487805 | 42 | 16 | 76.8 | 0 | 130 | 5 | 26 | 67 | KAB2653290.1 MAG: type IV pilus twitching motility protein PilT [Verrucomicrobiota bacterium] | diamond | 333 | 48.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30314102 | 30314102 | PRJNA492280_P_NODE_26032_length_164_cov_2.244094_g25925_i0 | PRJNA492280 | 26032 | 164 | 2.244094 | 3.68031416 | Prosthecobacter | 48463 | Bacteria | Bacteria | 54.3 | 1.8e-7 | NR | WP_294404807.1 | 1965333 | g25925 | i0 | 53 | 2.41463414634146 | 66 | 6 | 75 | 1 | 127 | 5 | 12 | 77 | WP_294404807.1 aspartate 1-decarboxylase [Prosthecobacter sp.] | diamond | 396 | 54.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 30345718 | 30345718 | PRJNA492280_P_NODE_32452_length_150_cov_6.159292_g32345_i0 | PRJNA492280 | 32452 | 150 | 6.159292 | 9.238938 | Bacteria | 2 | Bacteria | Bacteria | 41.6 | 0.02 | NR | MEY5015909.1 | 2026799 | g32345 | i0 | 69.2 | 0.98 | 26 | 8 | 52 | 0 | 80 | 3 | 98 | 123 | MEY5015909.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 147 | 41.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30708235 | 30708235 | PRJNA492280_P_NODE_19014_length_164_cov_3.496063_g18907_i0 | PRJNA492280 | 19014 | 164 | 3.496063 | 5.73354332 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 41.2 | 0.043 | NR | MFN0129558.1 | 2026801 | g18907 | i0 | 78.3 | 0.420731707317073 | 23 | 5 | 42.1 | 0 | 6 | 74 | 198 | 220 | MFN0129558.1 hypothetical protein [Verrucomicrobiales bacterium] | diamond | 69 | 41.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 30771663 | 30771663 | PRJNA492280_P_NODE_33554_length_150_cov_3.876106_g33447_i0 | PRJNA492280 | 33554 | 150 | 3.876106 | 5.814159 | Rariglobus sp. | 2706526 | Bacteria | Bacteria | 62 | 1.62e-9 | NR | MDF3056361.1 | 2706526 | g33447 | i0 | 64.4 | 0.9 | 45 | 16 | 90 | 0 | 6 | 140 | 192 | 236 | MDF3056361.1 alpha-L-rhamnosidase [Rariglobus sp.] | diamond | 135 | 62 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Rariglobus | Rariglobus sp. | |
| 30929477 | 30929477 | PRJNA492280_P_NODE_8174_length_185_cov_3.432432_g8067_i0 | PRJNA492280 | 8174 | 185 | 3.432432 | 6.3499992 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 59.7 | 1.66e-8 | NR | MEZ5385719.1 | 1965333 | g8067 | i0 | 93.5 | 0.502702702702703 | 31 | 2 | 50.3 | 0 | 18 | 110 | 13 | 43 | MEZ5385719.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex transferase subunit TsaD [Prosthecobacter sp.] | diamond | 93 | 59.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 30945619 | 30945619 | PRJNA492280_P_NODE_25614_length_164_cov_2.425197_g25507_i0 | PRJNA492280 | 25614 | 164 | 2.425197 | 3.97732308 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 54.3 | 1.05e-6 | NR | MBC8010073.1 | 2006848 | g25507 | i0 | 95.8 | 16.9573170731707 | 24 | 1 | 43.9 | 0 | 92 | 163 | 108 | 131 | MBC8010073.1 DUF3604 domain-containing protein [Opitutaceae bacterium] | diamond | 2781 | 54.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 31830612 | 31830612 | PRJNA492280_P_NODE_23177_length_164_cov_2.834646_g23070_i0 | PRJNA492280 | 23177 | 164 | 2.8346460000000002 | 4.64881944 | Bacteria | 2 | Bacteria | Bacteria | 55.5 | 4.15e-7 | NR | MFO1457948.1 | 2026799 | g23070 | i0 | 100 | 0.878048780487805 | 24 | 0 | 43.9 | 0 | 162 | 91 | 265 | 288 | MFO1457948.1 immunoglobulin domain-containing protein [Verrucomicrobiota bacterium] | diamond | 144 | 55.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32004658 | 32004658 | PRJNA492280_P_NODE_32258_length_150_cov_7.371681_g32151_i0 | PRJNA492280 | 32258 | 150 | 7.371681 | 11.0575215 | Opitutaceae bacterium TAV4 | 278959 | Bacteria | Bacteria | 66.2 | 5.4e-11 | NR | RRJ94455.1 | 278959 | g32151 | i0 | 47.6 | 3.36 | 84 | 8 | 96 | 2 | 147 | 4 | 314 | 397 | RRJ94455.1 hypothetical protein Ga0100231_008930 [Opitutaceae bacterium TAV4] | diamond | 504 | 66.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium TAV4 | ||
| 32067790 | 32067790 | PRJNA492280_P_NODE_20358_length_164_cov_3.275591_g20251_i0 | PRJNA492280 | 20358 | 164 | 3.275591 | 5.37196924 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 43.9 | 0.00498 | NR | HYG83803.1 | 2499141 | g20251 | i0 | 100 | 0.768292682926829 | 20 | 0 | 36.6 | 0 | 73 | 14 | 160 | 179 | HYG83803.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 126 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32226272 | 32226272 | PRJNA492280_P_NODE_13798_length_164_cov_5.181102_g13691_i0 | PRJNA492280 | 13798 | 164 | 5.181102 | 8.49700728 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 54.7 | 7.66e-7 | NR | KAB2661166.1 | 2026799 | g13691 | i0 | 100 | 0.439024390243902 | 24 | 0 | 43.9 | 0 | 6 | 77 | 389 | 412 | KAB2661166.1 MAG: DUF1552 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 72 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32432086 | 32432086 | PRJNA492280_P_NODE_14519_length_164_cov_4.779528_g14412_i0 | PRJNA492280 | 14519 | 164 | 4.779528 | 7.83842592 | Bacteria | 2 | Bacteria | Bacteria | 45.1 | 0.00192 | NR | HUF42920.1 | 2499141 | g14412 | i0 | 88 | 0.896341463414634 | 25 | 3 | 45.7 | 0 | 162 | 88 | 293 | 317 | HUF42920.1 ABC transporter substrate-binding protein [Verrucomicrobiia bacterium] | diamond | 147 | 45.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32511200 | 32511200 | PRJNA492280_P_NODE_32499_length_150_cov_5.911504_g32392_i0 | PRJNA492280 | 32499 | 150 | 5.911504 | 8.867256 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 92.4 | 3.2e-20 | NR | KAB2661199.1 | 2026799 | g32392 | i0 | 84.2 | 1.14 | 57 | 0 | 96 | 1 | 6 | 149 | 606 | 662 | KAB2661199.1 MAG: 4Fe-4S dicluster domain-containing protein [Verrucomicrobiota bacterium] | diamond | 171 | 92.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota 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);;