contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA473799" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1720289 | 1720289 | PRJNA473799_P_NODE_16042_length_287_cov_1.186916_g15768_i0 | PRJNA473799 | 16042 | 287 | 1.186916 | 3.40644892 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 155 | 6.469999999999999e-45 | NR | MBN8707784.1 | 2026799 | g15768 | i0 | 83.2 | 1.98606271777003 | 95 | 16 | 99.3 | 0 | 286 | 2 | 76 | 170 | MBN8707784.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 570 | 155 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 6198825 | 6198825 | PRJNA473799_P_NODE_26665_length_265_cov_1.484375_g26391_i0 | PRJNA473799 | 26665 | 265 | 1.484375 | 3.93359375 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 129 | 7.38e-33 | NR | HXI71490.1 | 2499141 | g26391 | i0 | 75.3 | 5.69433962264151 | 85 | 21 | 96.2 | 0 | 1 | 255 | 499 | 583 | HXI71490.1 ABC transporter ATP-binding protein [Verrucomicrobiia bacterium] | diamond | 1509 | 130 | 0.992307692307692 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 10649356 | 10649356 | PRJNA473799_P_NODE_29329_length_260_cov_1.352941_g29055_i0 | PRJNA473799 | 29329 | 260 | 1.352941 | 3.5176466 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 125 | 3.75e-31 | NR | HEV7402098.1 | 2811408 | g29055 | i0 | 73.3 | 0.992307692307692 | 86 | 23 | 99.2 | 0 | 1 | 258 | 839 | 924 | HEV7402098.1 vitamin B12 dependent-methionine synthase activation domain-containing protein [Chthoniobacteraceae bacterium] | diamond | 258 | 125 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 11924065 | 11924065 | PRJNA473799_P_NODE_13770_length_294_cov_2.176471_g13496_i0 | PRJNA473799 | 13770 | 294 | 2.176471 | 6.39882474 | Opitutus sp. | 1913982 | Bacteria | Bacteria | 189 | 1.95e-53 | NR | MCR6657178.1 | 1913982 | g13496 | i0 | 94.8 | 3.95918367346939 | 97 | 5 | 99 | 0 | 293 | 3 | 217 | 313 | MCR6657178.1 alanine--tRNA ligase [Opitutus sp.] | diamond | 1164 | 189 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. | |
| 11924275 | 11924275 | PRJNA473799_P_NODE_29990_length_259_cov_1.129032_g29716_i0 | PRJNA473799 | 29990 | 259 | 1.129032 | 2.92419288 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 121 | 1.73e-32 | NR | HEY1107531.1 | 2006848 | g29716 | i0 | 69.8 | 0.996138996138996 | 86 | 26 | 99.6 | 0 | 2 | 259 | 18 | 103 | HEY1107531.1 helix-turn-helix domain-containing protein [Opitutaceae bacterium] | diamond | 258 | 121 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 27455615 | 27455615 | PRJNA473799_P_NODE_45763_length_245_cov_0.895349_g45489_i0 | PRJNA473799 | 45763 | 245 | 0.895349 | 2.19360505 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 116 | 5.95e-32 | NR | MBE0540196.1 | 2026799 | g45489 | i0 | 71.6 | 1.81224489795918 | 74 | 21 | 90.6 | 0 | 23 | 244 | 1 | 74 | MBE0540196.1 type II toxin-antitoxin system RelE/ParE family toxin [Verrucomicrobiota bacterium] | diamond | 444 | 116 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27581657 | 27581657 | PRJNA473799_P_NODE_40364_length_248_cov_0.880000_g40090_i0 | PRJNA473799 | 40364 | 248 | 0.88 | 2.1824 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 140 | 1.14e-38 | NR | HSH37339.1 | 2201154 | g40090 | i0 | 87.8 | 0.991935483870968 | 82 | 10 | 99.2 | 0 | 247 | 2 | 201 | 282 | HSH37339.1 phosphatidate cytidylyltransferase [Chthoniobacterales bacterium] | diamond | 246 | 140 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 27676688 | 27676688 | PRJNA473799_P_NODE_31384_length_256_cov_2.016393_g31110_i0 | PRJNA473799 | 31384 | 256 | 2.016393 | 5.16196608 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 144 | 2.84e-38 | NR | HEV7406367.1 | 2811408 | g31110 | i0 | 89.4 | 0.99609375 | 85 | 9 | 99.6 | 0 | 1 | 255 | 424 | 508 | HEV7406367.1 TolC family protein [Chthoniobacteraceae bacterium] | diamond | 255 | 144 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 27771348 | 27771348 | PRJNA473799_P_NODE_25824_length_267_cov_1.077320_g25550_i0 | PRJNA473799 | 25824 | 267 | 1.07732 | 2.8764444 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 63.2 | 3.15e-9 | NR | MCB1204293.1 | 2499141 | g25550 | i0 | 47.2 | 0.808988764044944 | 72 | 38 | 80.9 | 0 | 263 | 48 | 522 | 593 | MCB1204293.1 integrin [Verrucomicrobiia bacterium] | diamond | 216 | 63.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 27771353 | 27771353 | PRJNA473799_P_NODE_47784_length_244_cov_0.900585_g47510_i0 | PRJNA473799 | 47784 | 244 | 0.900585 | 2.1974274 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 124 | 1.59e-32 | NR | MES2694568.1 | 2026799 | g47510 | i0 | 73.8 | 0.983606557377049 | 80 | 21 | 98.4 | 0 | 3 | 242 | 26 | 105 | MES2694568.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 240 | 124 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27819070 | 27819070 | PRJNA473799_P_NODE_16624_length_286_cov_0.985915_g16350_i0 | PRJNA473799 | 16624 | 286 | 0.985915 | 2.8197169 | Bacteria | 2 | Bacteria | Bacteria | 200 | 2.99e-58 | NR | MDQ6656158.1 | 2026799 | g16350 | i0 | 87.4 | 13.9615384615385 | 95 | 12 | 99.7 | 0 | 285 | 1 | 128 | 222 | MDQ6656158.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 3993 | 200 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29397579 | 29397579 | PRJNA473799_P_NODE_46669_length_245_cov_0.895349_g46395_i0 | PRJNA473799 | 46669 | 245 | 0.895349 | 2.19360505 | Candidatus Methylacidithermus | 2839095 | Bacteria | Bacteria | 52.8 | 1.11e-5 | NR | MEY2543018.1 | 2026799 | g46395 | i0 | 54.2 | 1.15102040816327 | 48 | 22 | 58.8 | 0 | 177 | 34 | 82 | 129 | MEY2543018.1 two-component system, NarL family, sensor histidine kinase UhpB [Verrucomicrobiota bacterium] | diamond | 282 | 53.1 | 0.994350282485876 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29507657 | 29507657 | PRJNA473799_P_NODE_44430_length_246_cov_0.890173_g44156_i0 | PRJNA473799 | 44430 | 246 | 0.890173 | 2.18982558 | Pedosphaera sp. | 2024890 | Bacteria | Bacteria | 149 | 4.16e-41 | NR | MDB6016188.1 | 2024890 | g44156 | i0 | 82.7 | 12.780487804878 | 81 | 14 | 98.8 | 0 | 245 | 3 | 34 | 114 | MDB6016188.1 amidase, hydantoinase/carbamoylase family [Pedosphaera sp.] | diamond | 3144 | 149 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera sp. | |
| 29728480 | 29728480 | PRJNA473799_P_NODE_24250_length_270_cov_1.065990_g23976_i0 | PRJNA473799 | 24250 | 270 | 1.06599 | 2.878173 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 42.7 | 0.0499 | NR | MAL85231.1 | 2026771 | g23976 | i0 | 40.5 | 0.466666666666667 | 42 | 25 | 46.7 | 0 | 27 | 152 | 111 | 152 | MAL85231.1 hypothetical protein [Opitutia bacterium] | diamond | 126 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 29886788 | 29886788 | PRJNA473799_P_NODE_16091_length_287_cov_1.088785_g15817_i0 | PRJNA473799 | 16091 | 287 | 1.088785 | 3.12481295 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 186 | 3.019999999999999e-55 | NR | MBR5875722.1 | 1872421 | g15817 | i0 | 90.5 | 0.993031358885017 | 95 | 9 | 99.3 | 0 | 3 | 287 | 10 | 104 | MBR5875722.1 ISL3 family transposase [Akkermansia sp.] | diamond | 285 | 186 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 30044514 | 30044514 | PRJNA473799_P_NODE_47811_length_244_cov_0.900585_g47537_i0 | PRJNA473799 | 47811 | 244 | 0.900585 | 2.1974274 | Roseimicrobium sp. ORNL1 | 2711231 | Bacteria | Bacteria | 114 | 1.43e-27 | NR | WP_165210582.1 | 2711231 | g47537 | i0 | 63 | 0.995901639344262 | 81 | 30 | 99.6 | 0 | 244 | 2 | 401 | 481 | WP_165210582.1 pectate lyase [Roseimicrobium sp. ORNL1] | diamond | 243 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Roseimicrobium | Roseimicrobium sp. ORNL1 | |
| 30139005 | 30139005 | PRJNA473799_P_NODE_45212_length_245_cov_2.116279_g44938_i0 | PRJNA473799 | 45212 | 245 | 2.116279 | 5.18488355 | Verrucomicrobiaceae bacterium SCGC AG-212-N21 | 1799659 | Bacteria | Bacteria | 132 | 1.13e-33 | NR | OAI57579.1 | 1799659 | g44938 | i0 | 79.2 | 0.942857142857143 | 77 | 16 | 94.3 | 0 | 13 | 243 | 22 | 98 | OAI57579.1 hypothetical protein AYO49_01865 [Verrucomicrobiaceae bacterium SCGC AG-212-N21] | diamond | 231 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium SCGC AG-212-N21 | ||
| 31340145 | 31340145 | PRJNA473799_P_NODE_50156_length_243_cov_0.905882_g49882_i0 | PRJNA473799 | 50156 | 243 | 0.905882 | 2.20129326 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 63.2 | 2.43e-9 | NR | MEI7909206.1 | 2026799 | g49882 | i0 | 55.6 | 1.76543209876543 | 63 | 28 | 77.8 | 0 | 189 | 1 | 303 | 365 | MEI7909206.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 429 | 63.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31403569 | 31403569 | PRJNA473799_P_NODE_24916_length_268_cov_2.153846_g24642_i0 | PRJNA473799 | 24916 | 268 | 2.153846 | 5.77230728 | Lacunisphaera sp. | 1961806 | Bacteria | Bacteria | 134 | 1.32e-36 | NR | HEX7632160.1 | 1961806 | g24642 | i0 | 79.3 | 0.973880597014925 | 87 | 18 | 97.4 | 0 | 2 | 262 | 187 | 273 | HEX7632160.1 helix-turn-helix domain-containing protein [Lacunisphaera sp.] | diamond | 261 | 134 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera sp. | |
| 31561739 | 31561739 | PRJNA473799_P_NODE_20776_length_277_cov_1.029412_g20502_i0 | PRJNA473799 | 20776 | 277 | 1.029412 | 2.85147124 | Verrucomicrobiaceae bacterium SCGC AG-212-N21 | 1799659 | Bacteria | Bacteria | 110 | 1.6499999999999999e-28 | NR | OAI58087.1 | 1799659 | g20502 | i0 | 68.4 | 0.823104693140794 | 76 | 24 | 82.3 | 0 | 228 | 1 | 1 | 76 | OAI58087.1 hypothetical protein AYO49_05870 [Verrucomicrobiaceae bacterium SCGC AG-212-N21] | diamond | 228 | 110 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium SCGC AG-212-N21 | ||
| 31925616 | 31925616 | PRJNA473799_P_NODE_43517_length_246_cov_1.601156_g43243_i0 | PRJNA473799 | 43517 | 246 | 1.601156 | 3.93884376 | Bacteria | 2 | Bacteria | Bacteria | 50.8 | 5.49e-5 | NR | MBC8008730.1 | 2006848 | g43243 | i0 | 39 | 2 | 82 | 50 | 100 | 0 | 246 | 1 | 347 | 428 | MBC8008730.1 pilus assembly protein PilM [Opitutaceae bacterium] | diamond | 492 | 51.2 | 0.9921875 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 32099300 | 32099300 | PRJNA473799_P_NODE_21538_length_275_cov_1.524752_g21264_i0 | PRJNA473799 | 21538 | 275 | 1.524752 | 4.193068 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 180 | 3.55e-53 | NR | MBN8246190.1 | 2026799 | g21264 | i0 | 100 | 0.992727272727273 | 91 | 0 | 99.3 | 0 | 274 | 2 | 175 | 265 | MBN8246190.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 273 | 180 | 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);;