contig_metadata
15 rows where bioproject = "PRJNA1022392" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12916024 | 12916024 | PRJNA1022392_P_NODE_55831_length_182_cov_5.096296_g55162_i0 | PRJNA1022392 | 55831 | 182 | 5.096296 | 9.27525872 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 115 | 2.95e-28 | NR | MBS0646121.1 | 2026799 | g55162 | i0 | 98.3 | 1.97802197802198 | 60 | 1 | 98.9 | 0 | 1 | 180 | 119 | 178 | MBS0646121.1 helicase [Verrucomicrobiota bacterium] | diamond | 360 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 18014278 | 18014278 | PRJNA1022392_P_NODE_63855_length_172_cov_2.376000_g63186_i0 | PRJNA1022392 | 63855 | 172 | 2.376 | 4.08672 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 107 | 1.21e-25 | NR | MDB6071009.1 | 2026801 | g63186 | i0 | 96.5 | 2.98255813953488 | 57 | 2 | 99.4 | 0 | 172 | 2 | 271 | 327 | MDB6071009.1 signal recognition particle protein [Verrucomicrobiales bacterium] | diamond | 513 | 107 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 21838938 | 21838938 | PRJNA1022392_P_NODE_35238_length_206_cov_2.308176_g34569_i0 | PRJNA1022392 | 35238 | 206 | 2.308176 | 4.75484256 | Luteolibacter sp. Populi | 3230487 | Bacteria | Bacteria | 63.9 | 8.32e-6 | NTclustered | gi|2774618348|gb|CP161812.1| | 3230487 | g34569 | i0 | 97.368 | 29.621359223301 | 38 | 0 | 18 | 1 | 1 | 37 | 4881630 | 4881667 | Luteolibacter sp. Populi chromosome, complete genome | blastn | 6102 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. Populi | |
| 26591507 | 26591507 | PRJNA1022392_P_NODE_21701_length_227_cov_7.088889_g21032_i0 | PRJNA1022392 | 21701 | 227 | 7.088889 | 16.09177803 | Opitutales bacterium | 2026772 | Bacteria | Bacteria | 47.4 | 6.71e-4 | NR | HNX04777.1 | 2026772 | g21032 | i0 | 42.6 | 1.4273127753304 | 54 | 20 | 67.4 | 2 | 48 | 200 | 14 | 59 | HNX04777.1 prepilin peptidase [Opitutales bacterium] | diamond | 324 | 47.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 27027049 | 27027049 | PRJNA1022392_P_NODE_39082_length_200_cov_4.215686_g38413_i0 | PRJNA1022392 | 39082 | 200 | 4.215686 | 8.431372 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 53.9 | 2.78e-7 | NR | MBS0623293.1 | 2026799 | g38413 | i0 | 87.1 | 1.485 | 31 | 4 | 46.5 | 0 | 95 | 3 | 16 | 46 | MBS0623293.1 helix-turn-helix transcriptional regulator [Verrucomicrobiota bacterium] | diamond | 297 | 54.3 | 0.992633517495396 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28677313 | 28677313 | PRJNA1022392_P_NODE_30427_length_206_cov_3.503145_g29758_i0 | PRJNA1022392 | 30427 | 206 | 3.503145 | 7.2164787 | Opitutia bacterium Tous-C4FEB | 1982321 | Bacteria | Bacteria | 45.1 | 0.00354 | NR | PAW86769.1 | 1982321 | g29758 | i0 | 57.6 | 1.25242718446602 | 33 | 13 | 46.6 | 1 | 2 | 97 | 230 | 262 | PAW86769.1 MAG: hypothetical protein B9S26_15220 [Opitutia bacterium Tous-C4FEB] | diamond | 258 | 45.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium Tous-C4FEB | ||||
| 28740385 | 28740385 | PRJNA1022392_P_NODE_35947_length_205_cov_7.189873_g35278_i0 | PRJNA1022392 | 35947 | 205 | 7.189873 | 14.73923965 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 111 | 1.4700000000000002e-27 | NR | MDQ2919592.1 | 2026799 | g35278 | i0 | 86.8 | 1.99024390243902 | 68 | 7 | 99.5 | 1 | 204 | 1 | 102 | 167 | MDQ2919592.1 ATP-binding protein [Verrucomicrobiota bacterium] | diamond | 408 | 111 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28835089 | 28835089 | PRJNA1022392_P_NODE_83988_length_151_cov_4.942308_g83319_i0 | PRJNA1022392 | 83988 | 151 | 4.942308 | 7.46288508 | Rariglobus sp. | 2706526 | Bacteria | Bacteria | 79.7 | 2.22e-16 | NR | MDF3056521.1 | 2706526 | g83319 | i0 | 85.4 | 0.95364238410596 | 48 | 7 | 95.4 | 0 | 149 | 6 | 129 | 176 | MDF3056521.1 lipolytic protein family [Rariglobus sp.] | diamond | 144 | 79.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Rariglobus | Rariglobus sp. | |
| 29340382 | 29340382 | PRJNA1022392_P_NODE_54729_length_184_cov_1.715328_g54060_i0 | PRJNA1022392 | 54729 | 184 | 1.715328 | 3.15620352 | Chthoniobacter sp. | 2510640 | Bacteria | Bacteria | 74.3 | 1.12e-13 | NR | MDR3403487.1 | 2510640 | g54060 | i0 | 72.2 | 2.60869565217391 | 54 | 5 | 71.7 | 1 | 52 | 183 | 37 | 90 | MDR3403487.1 IS256 family transposase [Chthoniobacter sp.] | diamond | 480 | 74.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 29750476 | 29750476 | PRJNA1022392_P_NODE_75451_length_161_cov_0.894737_g74782_i0 | PRJNA1022392 | 75451 | 161 | 0.894737 | 1.44052657 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 40.8 | 0.0471 | NR | MEN9813905.1 | 2026799 | g74782 | i0 | 53.1 | 0.596273291925466 | 32 | 15 | 59.6 | 0 | 119 | 24 | 89 | 120 | MEN9813905.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 96 | 40.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29813775 | 29813775 | PRJNA1022392_P_NODE_67051_length_168_cov_2.586777_g66382_i0 | PRJNA1022392 | 67051 | 168 | 2.586777 | 4.34578536 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 67 | 3.59e-11 | NR | RYD83861.1 | 2026800 | g66382 | i0 | 58.5 | 0.946428571428571 | 53 | 22 | 94.6 | 0 | 8 | 166 | 83 | 135 | RYD83861.1 MAG: hypothetical protein EOP84_07100 [Verrucomicrobiaceae bacterium] | diamond | 159 | 67 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31488928 | 31488928 | PRJNA1022392_P_NODE_50496_length_189_cov_3.739437_g49827_i0 | PRJNA1022392 | 50496 | 189 | 3.739437 | 7.06753593 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 57.8 | 8.93e-8 | NR | MES2468863.1 | 2026799 | g49827 | i0 | 46.8 | 0.984126984126984 | 62 | 33 | 98.4 | 0 | 3 | 188 | 500 | 561 | MES2468863.1 protein kinase [Verrucomicrobiota bacterium] | diamond | 186 | 57.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31868121 | 31868121 | PRJNA1022392_P_NODE_36957_length_205_cov_2.670886_g36288_i0 | PRJNA1022392 | 36957 | 205 | 2.670886 | 5.4753163 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 60.8 | 9.24e-9 | NR | MFT3990581.1 | 1962973 | g36288 | i0 | 86.7 | 2.51707317073171 | 30 | 4 | 43.9 | 0 | 1 | 90 | 336 | 365 | MFT3990581.1 sulfatase [Luteolibacter sp.] | diamond | 516 | 60.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 32216389 | 32216389 | PRJNA1022392_P_NODE_21178_length_231_cov_2.146739_g20509_i0 | PRJNA1022392 | 21178 | 231 | 2.146739 | 4.95896709 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 91.3 | 2.01e-19 | NR | MCW0217363.1 | 1965333 | g20509 | i0 | 60.6 | 0.922077922077922 | 71 | 28 | 92.2 | 0 | 231 | 19 | 31 | 101 | MCW0217363.1 hypothetical protein [Prosthecobacter sp.] | diamond | 213 | 91.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 32658469 | 32658469 | PRJNA1022392_P_NODE_38820_length_201_cov_6.220779_g38151_i0 | PRJNA1022392 | 38820 | 201 | 6.220779 | 12.50376579 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 46.2 | 0.00121 | NR | HEY4988935.1 | 2006848 | g38151 | i0 | 38.5 | 1.56716417910448 | 52 | 25 | 76.1 | 2 | 48 | 200 | 14 | 59 | HEY4988935.1 prepilin peptidase [Opitutaceae bacterium] | diamond | 315 | 46.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae 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);;