contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA716463" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8362103 | 8362103 | PRJNA716463_P_NODE_95727_length_255_cov_2.307692_g95310_i0 | PRJNA716463 | 95727 | 255 | 2.307692 | 5.8846146 | Bacteria | 2 | Bacteria | Bacteria | 117 | 1.87e-29 | NR | MBX7207946.1 | 2026800 | g95310 | i0 | 65.1 | 2.94117647058824 | 86 | 29 | 100 | 1 | 255 | 1 | 201 | 286 | MBX7207946.1 isoaspartyl peptidase/L-asparaginase [Verrucomicrobiaceae bacterium] | diamond | 750 | 118 | 0.991525423728814 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 9636597 | 9636597 | PRJNA716463_P_NODE_53408_length_288_cov_2.493023_g52991_i0 | PRJNA716463 | 53408 | 288 | 2.493023 | 7.17990624 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 118 | 5.73e-29 | NR | WP_415910608.1 | 3398393 | g52991 | i0 | 80.5 | 1.61458333333333 | 77 | 12 | 77.1 | 1 | 288 | 67 | 405 | 481 | WP_415910608.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatB [Oleiharenicola sp. Vm1] | diamond | 465 | 118 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola sp. Vm1 | |
| 13461639 | 13461639 | PRJNA716463_P_NODE_44731_length_295_cov_2.927928_g44314_i0 | PRJNA716463 | 44731 | 295 | 2.927928 | 8.6373876 | Luteolibacter arcticus | 1581411 | Bacteria | Bacteria | 185 | 1.58e-53 | NR | WP_264490580.1 | 1581411 | g44314 | i0 | 87.4 | 1.04745762711864 | 103 | 8 | 99.7 | 1 | 295 | 2 | 336 | 438 | WP_264490580.1 methyltransferase domain-containing protein [Luteolibacter arcticus] | diamond | 309 | 185 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter arcticus | |
| 13461963 | 13461963 | PRJNA716463_P_NODE_64631_length_280_cov_2.574879_g64214_i0 | PRJNA716463 | 64631 | 280 | 2.574879 | 7.2096612 | Rariglobus sp. | 2706526 | Bacteria | Bacteria | 74.3 | 1.52e-13 | NR | MDF3058217.1 | 2706526 | g64214 | i0 | 76.1 | 0.492857142857143 | 46 | 11 | 49.3 | 0 | 142 | 279 | 181 | 226 | MDF3058217.1 two component transcriptional regulator, LytTR family [Rariglobus sp.] | diamond | 138 | 74.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Rariglobus | Rariglobus sp. | |
| 26608617 | 26608617 | PRJNA716463_P_NODE_7981_length_403_cov_2.366667_g7568_i0 | PRJNA716463 | 7981 | 403 | 2.366667 | 9.53766801 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 74.7 | 2.05e-13 | NR | MBV9008586.1 | 2026799 | g7568 | i0 | 37.2 | 0.96029776674938 | 129 | 69 | 96 | 4 | 396 | 10 | 59 | 175 | MBV9008586.1 VPDSG-CTERM sorting domain-containing protein [Verrucomicrobiota bacterium] | diamond | 387 | 74.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 26650748 | 26650748 | PRJNA716463_P_NODE_25261_length_310_cov_2.962025_g24844_i0 | PRJNA716463 | 25261 | 310 | 2.962025 | 9.1822775 | Prosthecobacter | 48463 | Bacteria | Bacteria | 187 | 2.99e-53 | NR | WP_377165974.1 | 445931 | g24844 | i0 | 83.8 | 7.51935483870968 | 111 | 9 | 98.7 | 1 | 308 | 3 | 125 | 235 | WP_377165974.1 hypothetical protein [Prosthecobacter fluviatilis] | diamond | 2331 | 187 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter fluviatilis | |
| 27083679 | 27083679 | PRJNA716463_P_NODE_85902_length_264_cov_1.371728_g85485_i0 | PRJNA716463 | 85902 | 264 | 1.371728 | 3.62136192 | Terrimicrobiaceae bacterium | 2832348 | Bacteria | Bacteria | 94.4 | 7.5e-21 | NR | HRJ72634.1 | 2832348 | g85485 | i0 | 84.5 | 0.659090909090909 | 58 | 8 | 64.8 | 1 | 175 | 5 | 182 | 239 | HRJ72634.1 hemolysin family protein [Terrimicrobiaceae bacterium] | diamond | 174 | 94.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobiaceae bacterium | ||
| 28062646 | 28062646 | PRJNA716463_P_NODE_36325_length_299_cov_3.261062_g35908_i0 | PRJNA716463 | 36325 | 299 | 3.261062 | 9.75057538 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 103 | 1.3899999999999998e-23 | NR | WP_294397657.1 | 1965333 | g35908 | i0 | 98 | 2.45819397993311 | 49 | 1 | 49.2 | 0 | 297 | 151 | 200 | 248 | WP_294397657.1 sulfatase [Prosthecobacter sp.] | diamond | 735 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 28094291 | 28094291 | PRJNA716463_P_NODE_24545_length_310_cov_3.033755_g24128_i0 | PRJNA716463 | 24545 | 310 | 3.033755 | 9.4046405 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 118 | 2.06e-30 | NR | HTS16620.1 | 2499141 | g24128 | i0 | 53.1 | 2.5258064516129 | 130 | 32 | 97.7 | 1 | 3 | 305 | 105 | 234 | HTS16620.1 SDR family oxidoreductase [Verrucomicrobiia bacterium] | diamond | 783 | 118 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 28220384 | 28220384 | PRJNA716463_P_NODE_104126_length_248_cov_0.880000_g103709_i0 | PRJNA716463 | 104126 | 248 | 0.88 | 2.1824 | Methylacidimicrobium sp. AP8 | 2730359 | Bacteria | Bacteria | 83.6 | 1.63e-16 | NR | WP_202213981.1 | 2730359 | g103709 | i0 | 57.3 | 0.991935483870968 | 82 | 35 | 99.2 | 0 | 2 | 247 | 62 | 143 | WP_202213981.1 IS200/IS605 family accessory protein TnpB-related protein [Methylacidimicrobium sp. AP8] | diamond | 246 | 83.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Methylacidimicrobium | Methylacidimicrobium sp. AP8 | ||||
| 28851896 | 28851896 | PRJNA716463_P_NODE_82008_length_267_cov_1.587629_g81591_i0 | PRJNA716463 | 82008 | 267 | 1.587629 | 4.23896943 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 53.5 | 4.49e-6 | NR | TMP91036.1 | 2026799 | g81591 | i0 | 36.7 | 0.887640449438202 | 79 | 50 | 88.8 | 0 | 253 | 17 | 16 | 94 | TMP91036.1 MAG: hypothetical protein E6L07_13950 [Verrucomicrobiota bacterium] | diamond | 237 | 53.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28883566 | 28883566 | PRJNA716463_P_NODE_12528_length_338_cov_4.600000_g12113_i0 | PRJNA716463 | 12528 | 338 | 4.6 | 15.548 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 58.9 | 2.36e-7 | NR | MBO4544706.1 | 2026799 | g12113 | i0 | 50 | 0.479289940828402 | 54 | 26 | 47.9 | 1 | 199 | 38 | 619 | 671 | MBO4544706.1 S8 family serine peptidase [Verrucomicrobiota bacterium] | diamond | 162 | 58.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29073286 | 29073286 | PRJNA716463_P_NODE_42968_length_296_cov_3.923767_g42551_i0 | PRJNA716463 | 42968 | 296 | 3.923767 | 11.61435032 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 43.9 | 0.0266 | NR | NBQ55952.1 | 2026799 | g42551 | i0 | 48.6 | 0.35472972972973 | 35 | 17 | 34.5 | 1 | 110 | 211 | 169 | 203 | NBQ55952.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 105 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29683176 | 29683176 | PRJNA716463_P_NODE_104190_length_248_cov_0.880000_g103773_i0 | PRJNA716463 | 104190 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 73.6 | 5.48e-13 | NR | PAW61946.1 | 1982330 | g103773 | i0 | 48.8 | 2.03225806451613 | 84 | 35 | 93.1 | 2 | 2 | 232 | 502 | 584 | PAW61946.1 MAG: hypothetical protein B9S37_03870 [Verrucomicrobiia bacterium Tous-C3TDCM] | diamond | 504 | 73.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium Tous-C3TDCM | ||||
| 30146491 | 30146491 | PRJNA716463_P_NODE_17012_length_310_cov_5.337553_g16595_i0 | PRJNA716463 | 17012 | 310 | 5.337553 | 16.5464143 | Prosthecobacter vanneervenii | 48466 | Bacteria | Bacteria | 63.9 | 2.97e-9 | NR | WP_184339930.1 | 48466 | g16595 | i0 | 56 | 0.483870967741935 | 50 | 22 | 48.4 | 0 | 1 | 150 | 349 | 398 | WP_184339930.1 hypothetical protein [Prosthecobacter vanneervenii] | diamond | 150 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter vanneervenii | |
| 30209733 | 30209733 | PRJNA716463_P_NODE_13852_length_323_cov_6.896000_g13436_i0 | PRJNA716463 | 13852 | 323 | 6.896 | 22.27408 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 56.2 | 3.67e-7 | NR | MBU6402233.1 | 2026799 | g13436 | i0 | 42.9 | 0.715170278637771 | 77 | 41 | 71.5 | 2 | 231 | 1 | 34 | 107 | MBU6402233.1 universal stress protein [Verrucomicrobiota bacterium] | diamond | 231 | 56.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30620651 | 30620651 | PRJNA716463_P_NODE_96653_length_254_cov_2.524862_g96236_i0 | PRJNA716463 | 96653 | 254 | 2.524862 | 6.41314948 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 129 | 1.84e-35 | NR | MEN9842156.1 | 2026799 | g96236 | i0 | 80.5 | 2.90551181102362 | 82 | 16 | 96.9 | 0 | 8 | 253 | 45 | 126 | MEN9842156.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 738 | 129 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30905190 | 30905190 | PRJNA716463_P_NODE_49394_length_291_cov_1.995413_g48977_i0 | PRJNA716463 | 49394 | 291 | 1.995413 | 5.80665183 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 157 | 1.4e-42 | NR | MEQ1840604.1 | 2026801 | g48977 | i0 | 86.5 | 0.989690721649485 | 96 | 13 | 99 | 0 | 288 | 1 | 322 | 417 | MEQ1840604.1 GumC family protein [Verrucomicrobiales bacterium] | diamond | 288 | 157 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 31125908 | 31125908 | PRJNA716463_P_NODE_90195_length_260_cov_2.144385_g89778_i0 | PRJNA716463 | 90195 | 260 | 2.144385 | 5.575401 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 148 | 7.879999999999997e-42 | NR | HEY5893907.1 | 2201154 | g89778 | i0 | 74.4 | 2.93076923076923 | 86 | 22 | 99.2 | 0 | 3 | 260 | 3 | 88 | HEY5893907.1 TniB family NTP-binding protein [Chthoniobacterales bacterium] | diamond | 762 | 148 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 31315958 | 31315958 | PRJNA716463_P_NODE_99595_length_251_cov_3.421348_g99178_i0 | PRJNA716463 | 99595 | 251 | 3.421348 | 8.58758348 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 126 | 4.68e-35 | NR | HEU0038023.1 | 2499141 | g99178 | i0 | 93.1 | 1.38645418326693 | 58 | 4 | 69.3 | 0 | 174 | 1 | 1 | 58 | HEU0038023.1 IS1595 family transposase [Verrucomicrobiia bacterium] | diamond | 348 | 126 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31916947 | 31916947 | PRJNA716463_P_NODE_68177_length_277_cov_4.284314_g67760_i0 | PRJNA716463 | 68177 | 277 | 4.284314 | 11.86754978 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 132 | 1.28e-33 | NR | MDB6076274.1 | 2562705 | g67760 | i0 | 71.1 | 0.974729241877256 | 90 | 26 | 97.5 | 0 | 272 | 3 | 1405 | 1494 | MDB6076274.1 hypothetical protein [Akkermansiaceae bacterium] | diamond | 270 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 32106737 | 32106737 | PRJNA716463_P_NODE_59038_length_284_cov_2.545024_g58621_i0 | PRJNA716463 | 59038 | 284 | 2.545024 | 7.22786816 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 55.8 | 1.49e-6 | NR | MEY4489506.1 | 2026799 | g58621 | i0 | 81.8 | 0.348591549295775 | 33 | 6 | 34.9 | 0 | 99 | 1 | 309 | 341 | MEY4489506.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 99 | 55.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32201740 | 32201740 | PRJNA716463_P_NODE_17758_length_310_cov_4.590717_g17341_i0 | PRJNA716463 | 17758 | 310 | 4.590717 | 14.2312227 | Chthoniobacter flavus | 191863 | Bacteria | Bacteria | 66.2 | 4.26e-10 | NR | WP_006979497.1 | 191863 | g17341 | i0 | 73.5 | 2.37096774193548 | 49 | 13 | 47.4 | 0 | 163 | 309 | 305 | 353 | WP_006979497.1 competence/damage-inducible protein A [Chthoniobacter flavus] | diamond | 735 | 66.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter flavus | |
| 32518397 | 32518397 | PRJNA716463_P_NODE_9059_length_384_cov_3.318328_g8646_i0 | PRJNA716463 | 9059 | 384 | 3.318328 | 12.74237952 | Verrucomicrobiales bacterium VVV1 | 2015575 | Bacteria | Bacteria | 121 | 2.06e-33 | NR | OYV05323.1 | 2015575 | g8646 | i0 | 93.8 | 0.5 | 64 | 4 | 50 | 0 | 3 | 194 | 9 | 72 | OYV05323.1 MAG: XRE family transcriptional regulator [Verrucomicrobiales bacterium VVV1] | diamond | 192 | 121 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium VVV1 | |||
| 32896061 | 32896061 | PRJNA716463_P_NODE_83200_length_266_cov_1.782383_g82783_i0 | PRJNA716463 | 83200 | 266 | 1.782383 | 4.74113878 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 58.5 | 1.34e-7 | NR | HEY1171948.1 | 2499141 | g82783 | i0 | 74.2 | 0.665413533834586 | 31 | 8 | 35 | 0 | 65 | 157 | 603 | 633 | HEY1171948.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 177 | 58.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia 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);;