contig_metadata
23 rows where bioproject = "PRJNA934332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 910643 | 910643 | PRJNA934332_P_NODE_6541_length_268_cov_1.282051_g6454_i0 | PRJNA934332 | 6541 | 268 | 1.282051 | 3.43589668 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 78.7 | 4.05e-10 | NTclustered | gi|2225500096|gb|CP095464.1| | 2026799 | g6454 | i0 | 95.833 | 2.27238805970149 | 48 | 2 | 18 | 0 | 134 | 181 | 853476 | 853429 | MAG: Verrucomicrobia bacterium isolate LL51 chromosome, complete genome | blastn | 609 | 78.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 9838624 | 9838624 | PRJNA934332_P_NODE_7648_length_251_cov_0.865169_g7561_i0 | PRJNA934332 | 7648 | 251 | 0.865169 | 2.17157419 | Lacunisphaera sp. | 1961806 | Bacteria | Bacteria | 137 | 9.93e-39 | NR | MDI1250817.1 | 1961806 | g7561 | i0 | 82.7 | 3.83665338645418 | 75 | 13 | 89.6 | 0 | 22 | 246 | 1 | 75 | MDI1250817.1 superoxide dismutase [Lacunisphaera sp.] | diamond | 963 | 137 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera sp. | |
| 14938543 | 14938543 | PRJNA934332_P_NODE_7232_length_255_cov_1.692308_g7145_i0 | PRJNA934332 | 7232 | 255 | 1.692308 | 4.3153854 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 145 | 2.38e-38 | NR | HXJ55024.1 | 2499141 | g7145 | i0 | 77.1 | 0.976470588235294 | 83 | 19 | 97.6 | 0 | 254 | 6 | 240 | 322 | HXJ55024.1 DUF1549 and DUF1553 domain-containing protein [Verrucomicrobiia bacterium] | diamond | 249 | 145 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 17488924 | 17488924 | PRJNA934332_P_NODE_7854_length_250_cov_0.870056_g7767_i0 | PRJNA934332 | 7854 | 250 | 0.870056 | 2.17514 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 296 | 9.47e-76 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g7767 | i0 | 88.048 | 26.208 | 251 | 28 | 100 | 2 | 1 | 250 | 1315177 | 1315426 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 6552 | 296 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 18762310 | 18762310 | PRJNA934332_P_NODE_7115_length_257_cov_1.695652_g7028_i0 | PRJNA934332 | 7115 | 257 | 1.695652 | 4.35782564 | Pedosphaera parvula | 1032527 | Bacteria | Bacteria | 337 | 5.759999999999998e-88 | NTclustered | gi|183579829|emb|AM905426.1| | 320771 | g7028 | i0 | 90.272 | 9.94163424124514 | 257 | 25 | 100 | 0 | 1 | 257 | 846 | 1102 | Bacterium Ellin514 23S rRNA gene, isolate Ellin514 | blastn | 2555 | 337 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera parvula | |
| 20037294 | 20037294 | PRJNA934332_P_NODE_8496_length_248_cov_1.760000_g8409_i0 | PRJNA934332 | 8496 | 248 | 1.76 | 4.3648 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 165 | 1.17e-48 | NR | MDQ3624226.1 | 2026799 | g8409 | i0 | 93.9 | 1.98387096774194 | 82 | 5 | 99.2 | 0 | 246 | 1 | 196 | 277 | MDQ3624226.1 RtcB family protein [Verrucomicrobiota bacterium] | diamond | 492 | 165 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 21312693 | 21312693 | PRJNA934332_P_NODE_6177_length_274_cov_1.203980_g6090_i0 | PRJNA934332 | 6177 | 274 | 1.20398 | 3.2989052 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 178 | 1.4e-54 | NR | HUS36062.1 | 2499141 | g6090 | i0 | 90.1 | 0.996350364963504 | 91 | 9 | 99.6 | 0 | 274 | 2 | 73 | 163 | HUS36062.1 4Fe-4S dicluster domain-containing protein [Verrucomicrobiia bacterium] | diamond | 273 | 178 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 26771790 | 26771790 | PRJNA934332_P_NODE_9161_length_247_cov_0.885057_g9074_i0 | PRJNA934332 | 9161 | 247 | 0.885057 | 2.18609079 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 114 | 5.31e-28 | NR | MBI5693049.1 | 2026799 | g9074 | i0 | 72.9 | 0.850202429149798 | 70 | 19 | 85 | 0 | 37 | 246 | 20 | 89 | MBI5693049.1 prolyl oligopeptidase family serine peptidase [Verrucomicrobiota bacterium] | diamond | 210 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27214440 | 27214440 | PRJNA934332_P_NODE_9902_length_245_cov_0.895349_g9815_i0 | PRJNA934332 | 9902 | 245 | 0.895349 | 2.19360505 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 56.6 | 5.08e-7 | NR | MCC7375888.1 | 2026801 | g9815 | i0 | 34.6 | 0.955102040816327 | 78 | 51 | 95.5 | 0 | 5 | 238 | 3203 | 3280 | MCC7375888.1 lamin tail domain-containing protein [Verrucomicrobiales bacterium] | diamond | 234 | 56.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 27309643 | 27309643 | PRJNA934332_P_NODE_5483_length_286_cov_1.394366_g5396_i0 | PRJNA934332 | 5483 | 286 | 1.394366 | 3.98788676 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 58.2 | 1.13e-7 | NR | MBI5772962.1 | 2026799 | g5396 | i0 | 61 | 0.43006993006993 | 41 | 16 | 43 | 0 | 283 | 161 | 179 | 219 | MBI5772962.1 TIGR00730 family Rossman fold protein [Verrucomicrobiota bacterium] | diamond | 123 | 58.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27341198 | 27341198 | PRJNA934332_P_NODE_10643_length_243_cov_0.905882_g10556_i0 | PRJNA934332 | 10643 | 243 | 0.905882 | 2.20129326 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 115 | 3.96e-29 | NR | HEV8541500.1 | 2499141 | g10556 | i0 | 68.8 | 0.987654320987654 | 80 | 25 | 98.8 | 0 | 241 | 2 | 46 | 125 | HEV8541500.1 GDSL-type esterase/lipase family protein [Verrucomicrobiia bacterium] | diamond | 240 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 27657011 | 27657011 | PRJNA934332_P_NODE_6444_length_270_cov_0.939086_g6357_i0 | PRJNA934332 | 6444 | 270 | 0.939086 | 2.5355322 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 80.9 | 2.76e-16 | NR | HVY71846.1 | 2499141 | g6357 | i0 | 56 | 1.01111111111111 | 91 | 35 | 98.9 | 2 | 3 | 269 | 52 | 139 | HVY71846.1 LysM domain-containing protein [Verrucomicrobiia bacterium] | diamond | 273 | 80.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 28453350 | 28453350 | PRJNA934332_P_NODE_9706_length_245_cov_0.895349_g9619_i0 | PRJNA934332 | 9706 | 245 | 0.895349 | 2.19360505 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 63.2 | 2.49e-9 | NR | MCI0535047.1 | 2026801 | g9619 | i0 | 56 | 2.41224489795918 | 50 | 21 | 60 | 1 | 245 | 99 | 1697 | 1746 | MCI0535047.1 Ig-like domain-containing protein [Verrucomicrobiales bacterium] | diamond | 591 | 63.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 28800290 | 28800290 | PRJNA934332_P_NODE_11247_length_241_cov_0.916667_g11160_i0 | PRJNA934332 | 11247 | 241 | 0.916667 | 2.20916747 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 47 | 0.00113 | NR | WP_265595598.1 | 1403819 | g11160 | i0 | 39 | 1.56846473029046 | 59 | 36 | 73.4 | 0 | 216 | 40 | 188 | 246 | WP_265595598.1 cell division protein ZipA C-terminal FtsZ-binding domain-containing protein [Verrucomicrobium sp. BvORR106] | diamond | 378 | 47 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium sp. BvORR106 | |
| 28824791 | 28824791 | PRJNA934332_P_NODE_6468_length_269_cov_1.571429_g6381_i0 | PRJNA934332 | 6468 | 269 | 1.571429 | 4.22714401 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 42.7 | 0.0451 | NR | MBT6958160.1 | 2026771 | g6381 | i0 | 35.8 | 0.591078066914498 | 53 | 34 | 59.1 | 0 | 2 | 160 | 153 | 205 | MBT6958160.1 hypothetical protein [Opitutia bacterium] | diamond | 159 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 28919618 | 28919618 | PRJNA934332_P_NODE_10788_length_242_cov_0.911243_g10701_i0 | PRJNA934332 | 10788 | 242 | 0.911243 | 2.20520806 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 159 | 4.789999999999999e-46 | NR | MEI6465726.1 | 2026799 | g10701 | i0 | 91.3 | 0.991735537190083 | 80 | 7 | 99.2 | 0 | 241 | 2 | 243 | 322 | MEI6465726.1 inositol monophosphatase [Verrucomicrobiota bacterium] | diamond | 240 | 159 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28958609 | 28958609 | PRJNA934332_P_NODE_7548_length_251_cov_0.865169_g7461_i0 | PRJNA934332 | 7548 | 251 | 0.865169 | 2.17157419 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 122 | 2.5899999999999997e-31 | NR | HOB32286.1 | 2026799 | g7461 | i0 | 72 | 4.9003984063745 | 82 | 23 | 98 | 0 | 5 | 250 | 69 | 150 | HOB32286.1 zinc-binding dehydrogenase [Verrucomicrobiota bacterium] | diamond | 1230 | 122 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29014824 | 29014824 | PRJNA934332_P_NODE_10608_length_243_cov_0.905882_g10521_i0 | PRJNA934332 | 10608 | 243 | 0.905882 | 2.20129326 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 153 | 1.22e-43 | NR | MES2571320.1 | 2026799 | g10521 | i0 | 95 | 0.987654320987654 | 80 | 4 | 98.8 | 0 | 241 | 2 | 117 | 196 | MES2571320.1 YncE family protein [Verrucomicrobiota bacterium] | diamond | 240 | 153 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29361867 | 29361867 | PRJNA934332_P_NODE_11489_length_229_cov_2.955128_g11402_i0 | PRJNA934332 | 11489 | 229 | 2.955128 | 6.76724312 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 92.8 | 3.75e-22 | NR | HVY69913.1 | 2499141 | g11402 | i0 | 78.8 | 0.681222707423581 | 52 | 11 | 68.1 | 0 | 157 | 2 | 1 | 52 | HVY69913.1 BlaI/MecI/CopY family transcriptional regulator [Verrucomicrobiia bacterium] | diamond | 156 | 92.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 30404551 | 30404551 | PRJNA934332_P_NODE_11513_length_226_cov_2.013072_g11426_i0 | PRJNA934332 | 11513 | 226 | 2.013072 | 4.54954272 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 52.8 | 8.51e-6 | NR | MCL4176897.1 | 2026799 | g11426 | i0 | 47.5 | 7.04867256637168 | 59 | 29 | 75.7 | 1 | 173 | 3 | 75 | 133 | MCL4176897.1 flotillin family protein [Verrucomicrobiota bacterium] | diamond | 1593 | 52.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30695437 | 30695437 | PRJNA934332_P_NODE_8853_length_248_cov_0.880000_g8766_i0 | PRJNA934332 | 8853 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 124 | 1.16e-31 | NR | PAW70934.1 | 1982322 | g8766 | i0 | 86.8 | 1.64516129032258 | 68 | 9 | 82.3 | 0 | 205 | 2 | 1 | 68 | PAW70934.1 MAG: hypothetical protein B9S35_14195 [Opitutia bacterium Tous-C5TDCM] | diamond | 408 | 124 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium Tous-C5TDCM | ||||
| 31573734 | 31573734 | PRJNA934332_P_NODE_5736_length_282_cov_1.138756_g5649_i0 | PRJNA934332 | 5736 | 282 | 1.138756 | 3.21129192 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 137 | 1.02e-36 | NR | MDB6003364.1 | 1965333 | g5649 | i0 | 90 | 0.851063829787234 | 80 | 7 | 85.1 | 1 | 42 | 281 | 4 | 82 | MDB6003364.1 hypothetical protein [Prosthecobacter sp.] | diamond | 240 | 137 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 32403227 | 32403227 | PRJNA934332_P_NODE_6799_length_263_cov_1.621053_g6712_i0 | PRJNA934332 | 6799 | 263 | 1.621053 | 4.26336939 | Pedosphaera | 1032526 | Bacteria | Bacteria | 113 | 7.89e-27 | NR | MDB6022549.1 | 2024890 | g6712 | i0 | 67.8 | 1.98479087452471 | 87 | 28 | 99.2 | 0 | 263 | 3 | 322 | 408 | MDB6022549.1 hypothetical protein [Pedosphaera sp.] | diamond | 522 | 113 | 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);;