contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA505329" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26633873 | 26633873 | PRJNA505329_P_NODE_30121_length_187_cov_1.500000_g29650_i0 | PRJNA505329 | 30121 | 187 | 1.5 | 2.805 | Haloferula sp. | 2497595 | Bacteria | Bacteria | 72.4 | 5.87e-13 | NR | MEP4079701.1 | 2497595 | g29650 | i0 | 50 | 2.80748663101604 | 60 | 30 | 96.3 | 0 | 4 | 183 | 45 | 104 | MEP4079701.1 alpha/beta hydrolase [Haloferula sp.] | diamond | 525 | 72.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Haloferula | Haloferula sp. | |
| 27266773 | 27266773 | PRJNA505329_P_NODE_34163_length_181_cov_1.553030_g33692_i0 | PRJNA505329 | 34163 | 181 | 1.55303 | 2.8109843 | Luteolibacter soli | 3135280 | Bacteria | Bacteria | 92.8 | 3.64e-20 | NR | WP_341403761.1 | 3135280 | g33692 | i0 | 86.8 | 0.878453038674033 | 53 | 7 | 87.8 | 0 | 18 | 176 | 13 | 65 | WP_341403761.1 PQQ-dependent sugar dehydrogenase [Luteolibacter soli] | diamond | 159 | 92.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter soli | |
| 27929927 | 27929927 | PRJNA505329_P_NODE_47405_length_164_cov_1.782609_g46934_i0 | PRJNA505329 | 47405 | 164 | 1.782609 | 2.92347876 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 89.7 | 2.68e-20 | NR | MES2308695.1 | 2026799 | g46934 | i0 | 81.1 | 0.969512195121951 | 53 | 10 | 97 | 0 | 4 | 162 | 47 | 99 | MES2308695.1 phosphoadenylyl-sulfate reductase [Verrucomicrobiota bacterium] | diamond | 159 | 89.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28466820 | 28466820 | PRJNA505329_P_NODE_50306_length_161_cov_3.651786_g49835_i0 | PRJNA505329 | 50306 | 161 | 3.651786 | 5.87937546 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 90.1 | 2.48e-19 | NR | HOW63730.1 | 2026799 | g49835 | i0 | 84.3 | 0.950310559006211 | 51 | 8 | 95 | 0 | 156 | 4 | 1152 | 1202 | HOW63730.1 N-6 DNA methylase [Verrucomicrobiota bacterium] | diamond | 153 | 90.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28877085 | 28877085 | PRJNA505329_P_NODE_42828_length_168_cov_1.739496_g42357_i0 | PRJNA505329 | 42828 | 168 | 1.739496 | 2.92235328 | Luteolibacter arcticus | 1581411 | Bacteria | Bacteria | 88.2 | 1.21e-18 | NR | WP_264487087.1 | 1581411 | g42357 | i0 | 74.5 | 0.982142857142857 | 55 | 14 | 98.2 | 0 | 167 | 3 | 157 | 211 | WP_264487087.1 hypothetical protein [Luteolibacter arcticus] | diamond | 165 | 88.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter arcticus | |
| 29350818 | 29350818 | PRJNA505329_P_NODE_34769_length_180_cov_1.572519_g34298_i0 | PRJNA505329 | 34769 | 180 | 1.572519 | 2.8305341999999998 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 115 | 9.579999999999999e-30 | NR | RYD20321.1 | 2026800 | g34298 | i0 | 96.5 | 0.95 | 57 | 2 | 95 | 0 | 178 | 8 | 193 | 249 | RYD20321.1 MAG: hypothetical protein EOP88_15530 [Verrucomicrobiaceae bacterium] | diamond | 171 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 29366257 | 29366257 | PRJNA505329_P_NODE_50089_length_162_cov_0.920354_g49618_i0 | PRJNA505329 | 50089 | 162 | 0.920354 | 1.49097348 | Pedosphaera | 1032526 | Bacteria | Bacteria | 64.7 | 1.11e-10 | NR | MSU84092.1 | 2024890 | g49618 | i0 | 79.1 | 4.51851851851852 | 43 | 7 | 75.9 | 1 | 123 | 1 | 148 | 190 | MSU84092.1 exopolysaccharide biosynthesis protein [Pedosphaera sp.] | diamond | 732 | 65.1 | 0.993855606758833 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera sp. | |
| 29618410 | 29618410 | PRJNA505329_P_NODE_50690_length_160_cov_2.738739_g50219_i0 | PRJNA505329 | 50690 | 160 | 2.738739 | 4.3819824 | Luteolibacter | 518753 | Bacteria | Bacteria | 108 | 8.17e-29 | NR | WP_200351539.1 | 1144680 | g50219 | i0 | 92.3 | 2.925 | 52 | 4 | 97.5 | 0 | 159 | 4 | 61 | 112 | WP_200351539.1 Fur family transcriptional regulator [Luteolibacter yonseiensis] | diamond | 468 | 108 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter yonseiensis | |
| 29634506 | 29634506 | PRJNA505329_P_NODE_12890_length_233_cov_3.048913_g12419_i0 | PRJNA505329 | 12890 | 233 | 3.048913 | 7.10396729 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 66.6 | 7.72e-11 | NR | MBM3839945.1 | 2026799 | g12419 | i0 | 93.8 | 0.412017167381974 | 32 | 2 | 41.2 | 0 | 135 | 230 | 194 | 225 | MBM3839945.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 96 | 66.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29666112 | 29666112 | PRJNA505329_P_NODE_30470_length_186_cov_3.197080_g29999_i0 | PRJNA505329 | 30470 | 186 | 3.19708 | 5.9465688 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 99 | 3.639999999999999e-23 | NR | MCX6958484.1 | 2499141 | g29999 | i0 | 90 | 1.93548387096774 | 60 | 6 | 96.8 | 0 | 5 | 184 | 172 | 231 | MCX6958484.1 IS256 family transposase [Verrucomicrobiia bacterium] | diamond | 360 | 99 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 30108613 | 30108613 | PRJNA505329_P_NODE_23992_length_197_cov_3.189189_g23521_i0 | PRJNA505329 | 23992 | 197 | 3.189189 | 6.28270233 | Verrucomicrobiota bacterium JB024 | 3064553 | Bacteria | Bacteria | 101 | 4.15e-25 | NR | MDP0495863.1 | 3064553 | g23521 | i0 | 100 | 0.791878172588833 | 52 | 0 | 79.2 | 0 | 5 | 160 | 143 | 194 | MDP0495863.1 hypothetical protein [Verrucomicrobiota bacterium JB024] | diamond | 156 | 101 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium JB024 | |||||
| 30330333 | 30330333 | PRJNA505329_P_NODE_42892_length_168_cov_1.731092_g42421_i0 | PRJNA505329 | 42892 | 168 | 1.731092 | 2.90823456 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 96.7 | 1.3400000000000002e-21 | NR | WP_348216044.1 | 1962973 | g42421 | i0 | 70.9 | 1.96428571428571 | 55 | 16 | 98.2 | 0 | 2 | 166 | 424 | 478 | WP_348216044.1 polysaccharide lyase family protein [Luteolibacter sp.] | diamond | 330 | 96.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 30582398 | 30582398 | PRJNA505329_P_NODE_23253_length_198_cov_4.798658_g22782_i0 | PRJNA505329 | 23253 | 198 | 4.798658 | 9.50134284 | Prosthecobacter vanneervenii | 48466 | Bacteria | Bacteria | 86.3 | 8.44e-18 | NR | WP_184340962.1 | 48466 | g22782 | i0 | 52.7 | 2.75757575757576 | 91 | 15 | 95.5 | 1 | 8 | 196 | 86 | 176 | WP_184340962.1 DNA polymerase III subunit beta [Prosthecobacter vanneervenii] | diamond | 546 | 86.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter vanneervenii | |
| 30772341 | 30772341 | PRJNA505329_P_NODE_25834_length_193_cov_2.715278_g25363_i0 | PRJNA505329 | 25834 | 193 | 2.715278 | 5.24048654 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 43.1 | 0.0128 | NR | MES2568622.1 | 2026799 | g25363 | i0 | 48.1 | 0.839378238341969 | 54 | 28 | 83.9 | 0 | 28 | 189 | 20 | 73 | MES2568622.1 LamG domain-containing protein [Verrucomicrobiota bacterium] | diamond | 162 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31182618 | 31182618 | PRJNA505329_P_NODE_37375_length_176_cov_1.614173_g36904_i0 | PRJNA505329 | 37375 | 176 | 1.614173 | 2.84094448 | Terrimicrobiaceae bacterium | 2832348 | Bacteria | Bacteria | 77 | 1.23e-14 | NR | HEY5954088.1 | 2832348 | g36904 | i0 | 68.4 | 0.971590909090909 | 57 | 18 | 97.2 | 0 | 4 | 174 | 181 | 237 | HEY5954088.1 hypothetical protein [Terrimicrobiaceae bacterium] | diamond | 171 | 77 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobiaceae bacterium | ||
| 31182621 | 31182621 | PRJNA505329_P_NODE_45435_length_166_cov_0.888889_g44964_i0 | PRJNA505329 | 45435 | 166 | 0.888889 | 1.47555574 | Luteolibacter sp. SL25 | 1962973 | Bacteria | Bacteria | 95.9 | 2.07e-23 | NR | WP_267670013.1 | 2995170 | g44964 | i0 | 77.8 | 7.80722891566265 | 54 | 12 | 97.6 | 0 | 162 | 1 | 3 | 56 | WP_267670013.1 DUF6428 family protein [Luteolibacter sp. SL250] | diamond | 1296 | 95.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 31973666 | 31973666 | PRJNA505329_P_NODE_41578_length_169_cov_2.558333_g41107_i0 | PRJNA505329 | 41578 | 169 | 2.558333 | 4.32358277 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 67.4 | 2.58e-11 | NR | HUR41170.1 | 2499141 | g41107 | i0 | 60 | 0.887573964497041 | 50 | 20 | 88.8 | 0 | 17 | 166 | 302 | 351 | HUR41170.1 aminotransferase class V-fold PLP-dependent enzyme [Verrucomicrobiia bacterium] | diamond | 150 | 67.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32353647 | 32353647 | PRJNA505329_P_NODE_46099_length_165_cov_1.784483_g45628_i0 | PRJNA505329 | 46099 | 165 | 1.784483 | 2.94439695 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 123 | 9.55e-33 | NR | MEI6248025.1 | 2026799 | g45628 | i0 | 96.3 | 2.94545454545455 | 54 | 2 | 98.2 | 0 | 4 | 165 | 104 | 157 | MEI6248025.1 DUF1080 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 486 | 123 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32606290 | 32606290 | PRJNA505329_P_NODE_34420_length_180_cov_3.122137_g33949_i0 | PRJNA505329 | 34420 | 180 | 3.122137 | 5.6198466 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 115 | 1.72e-30 | NR | MCX6973608.1 | 2026799 | g33949 | i0 | 96.5 | 1.9 | 57 | 2 | 95 | 0 | 5 | 175 | 77 | 133 | MCX6973608.1 phosphatase PAP2 family protein [Verrucomicrobiota bacterium] | diamond | 342 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32637540 | 32637540 | PRJNA505329_P_NODE_52120_length_154_cov_2.923810_g51649_i0 | PRJNA505329 | 52120 | 154 | 2.92381 | 4.5026674 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 62 | 1.32e-9 | NR | MEO5959580.1 | 2006848 | g51649 | i0 | 56.3 | 3.75974025974026 | 48 | 21 | 93.5 | 0 | 149 | 6 | 84 | 131 | MEO5959580.1 DUF72 domain-containing protein [Opitutaceae bacterium] | diamond | 579 | 62 | 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);;