contig_metadata
20 rows where bioproject = "PRJNA1255065" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7431073 | 7431073 | PRJNA1255065_P_NODE_144106_length_163_cov_0.912281_g141878_i0 | PRJNA1255065 | 144106 | 163 | 0.912281 | 1.48701803 | Opitutus sp. | 1913982 | Bacteria | Bacteria | 86.7 | 9.63e-19 | NR | MBA3848571.1 | 1913982 | g141878 | i0 | 62.3 | 0.975460122699387 | 53 | 20 | 97.5 | 0 | 1 | 159 | 85 | 137 | MBA3848571.1 alpha/beta hydrolase [Opitutus sp.] | diamond | 159 | 86.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. | |
| 15663162 | 15663162 | PRJNA1255065_P_NODE_153373_length_162_cov_0.920354_g151145_i0 | PRJNA1255065 | 153373 | 162 | 0.920354 | 1.49097348 | Roseimicrobium sp. ORNL1 | 2711231 | Bacteria | Bacteria | 217 | 4.5199999999999996e-52 | NTclustered | gi|1815841271|gb|CP049143.1| | 2711231 | g151145 | i0 | 90.741 | 1 | 162 | 15 | 100 | 0 | 1 | 162 | 3695970 | 3696131 | Roseimicrobium sp. ORNL1 chromosome, complete genome | blastn | 162 | 217 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Roseimicrobium | Roseimicrobium sp. ORNL1 | |
| 27453232 | 27453232 | PRJNA1255065_P_NODE_126743_length_166_cov_0.888889_g124515_i0 | PRJNA1255065 | 126743 | 166 | 0.888889 | 1.47555574 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 106 | 1.12e-25 | NR | RYD40511.1 | 2026800 | g124515 | i0 | 92.7 | 0.993975903614458 | 55 | 4 | 99.4 | 0 | 1 | 165 | 156 | 210 | RYD40511.1 MAG: hypothetical protein EOP83_35170, partial [Verrucomicrobiaceae bacterium] | diamond | 165 | 106 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 28431887 | 28431887 | PRJNA1255065_P_NODE_151066_length_162_cov_0.920354_g148838_i0 | PRJNA1255065 | 151066 | 162 | 0.920354 | 1.49097348 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 85.9 | 7.64e-18 | NR | MCF7765245.1 | 2026799 | g148838 | i0 | 78.8 | 0.962962962962963 | 52 | 11 | 96.3 | 0 | 160 | 5 | 1253 | 1304 | MCF7765245.1 PmoA family protein [Verrucomicrobiota bacterium] | diamond | 156 | 85.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28670856 | 28670856 | PRJNA1255065_P_NODE_140187_length_164_cov_0.904348_g137959_i0 | PRJNA1255065 | 140187 | 164 | 0.904348 | 1.48313072 | Rariglobus | 2706524 | Bacteria | Bacteria | 97.4 | 6.97e-22 | NR | MBC8040811.1 | 2006848 | g137959 | i0 | 92.6 | 2.96341463414634 | 54 | 4 | 98.8 | 0 | 162 | 1 | 785 | 838 | MBC8040811.1 ABC transporter permease [Opitutaceae bacterium] | diamond | 486 | 98.2 | 0.991853360488798 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 29176077 | 29176077 | PRJNA1255065_P_NODE_112009_length_168_cov_0.873950_g109781_i0 | PRJNA1255065 | 112009 | 168 | 0.87395 | 1.468236 | Bacteria | 2 | Bacteria | Bacteria | 60.5 | 7.43e-9 | NR | MES2709612.1 | 2026799 | g109781 | i0 | 53.8 | 3.76785714285714 | 52 | 24 | 92.9 | 0 | 2 | 157 | 738 | 789 | MES2709612.1 lamin tail domain-containing protein [Verrucomicrobiota bacterium] | diamond | 633 | 60.8 | 0.995065789473684 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29239160 | 29239160 | PRJNA1255065_P_NODE_108229_length_169_cov_0.866667_g106001_i0 | PRJNA1255065 | 108229 | 169 | 0.866667 | 1.46466723 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 62.8 | 6.24e-10 | NR | MFI5337259.1 | 2026772 | g106001 | i0 | 84.8 | 1.20710059171598 | 33 | 5 | 58.6 | 0 | 100 | 2 | 7 | 39 | MFI5337259.1 PIG-L deacetylase family protein [Opitutales bacterium] | diamond | 204 | 62.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 29523234 | 29523234 | PRJNA1255065_P_NODE_97830_length_176_cov_2.165354_g95602_i0 | PRJNA1255065 | 97830 | 176 | 2.165354 | 3.81102304 | Bacteria | 2 | Bacteria | Bacteria | 47.4 | 3.44e-4 | NR | HNX04777.1 | 2026772 | g95602 | i0 | 43.1 | 1.73863636363636 | 51 | 24 | 86.9 | 1 | 21 | 173 | 14 | 59 | HNX04777.1 prepilin peptidase [Opitutales bacterium] | diamond | 306 | 47.8 | 0.99163179916318 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 29852742 | 29852742 | PRJNA1255065_P_NODE_114751_length_168_cov_0.873950_g112523_i0 | PRJNA1255065 | 114751 | 168 | 0.87395 | 1.468236 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 61.6 | 3e-9 | NR | MBM3861874.1 | 2026799 | g112523 | i0 | 50.9 | 0.982142857142857 | 55 | 27 | 98.2 | 0 | 168 | 4 | 485 | 539 | MBM3861874.1 glycosyltransferase [Verrucomicrobiota bacterium] | diamond | 165 | 61.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30010781 | 30010781 | PRJNA1255065_P_NODE_126111_length_166_cov_0.888889_g123883_i0 | PRJNA1255065 | 126111 | 166 | 0.888889 | 1.47555574 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 100 | 1.62e-23 | NR | HWB07432.1 | 2026801 | g123883 | i0 | 83.3 | 0.975903614457831 | 54 | 9 | 97.6 | 0 | 164 | 3 | 157 | 210 | HWB07432.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex transferase subunit TsaD [Verrucomicrobiales bacterium] | diamond | 162 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 30327081 | 30327081 | PRJNA1255065_P_NODE_117212_length_167_cov_0.881356_g114984_i0 | PRJNA1255065 | 117212 | 167 | 0.881356 | 1.47186452 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 42 | 0.0254 | NR | MCU0788643.1 | 2026799 | g114984 | i0 | 30.6 | 0.880239520958084 | 49 | 33 | 88 | 1 | 19 | 165 | 120 | 167 | MCU0788643.1 alpha-mannosidase [Verrucomicrobiota bacterium] | diamond | 147 | 42 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30421732 | 30421732 | PRJNA1255065_P_NODE_105213_length_169_cov_0.866667_g102985_i0 | PRJNA1255065 | 105213 | 169 | 0.866667 | 1.46466723 | Opitutus sp. | 1913982 | Bacteria | Bacteria | 96.7 | 1.41e-21 | NR | MEO7597842.1 | 1913982 | g102985 | i0 | 92.9 | 5.96449704142012 | 56 | 4 | 99.4 | 0 | 2 | 169 | 590 | 645 | MEO7597842.1 excinuclease ABC subunit UvrB [Opitutus sp.] | diamond | 1008 | 96.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. | |
| 30484630 | 30484630 | PRJNA1255065_P_NODE_119053_length_167_cov_0.881356_g116825_i0 | PRJNA1255065 | 119053 | 167 | 0.881356 | 1.47186452 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 45.4 | 0.00149 | NR | HEY1793795.1 | 2006848 | g116825 | i0 | 41.2 | 0.916167664670659 | 51 | 30 | 91.6 | 0 | 154 | 2 | 100 | 150 | HEY1793795.1 hypothetical protein [Opitutaceae bacterium] | diamond | 153 | 45.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 30674022 | 30674022 | PRJNA1255065_P_NODE_94833_length_180_cov_1.190840_g92605_i0 | PRJNA1255065 | 94833 | 180 | 1.19084 | 2.143512 | Verrucomicrobia bacterium ADurb.Bin474 | 1852931 | Bacteria | Bacteria | 71.6 | 3.44e-13 | NR | OPZ74474.1 | 1852931 | g92605 | i0 | 55.2 | 0.966666666666667 | 58 | 26 | 96.7 | 0 | 7 | 180 | 99 | 156 | OPZ74474.1 MAG: hypothetical protein BWY82_00684 [Verrucomicrobia bacterium ADurb.Bin474] | diamond | 174 | 71.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobia bacterium ADurb.Bin474 | |||||
| 30832058 | 30832058 | PRJNA1255065_P_NODE_109394_length_169_cov_0.866667_g107166_i0 | PRJNA1255065 | 109394 | 169 | 0.866667 | 1.46466723 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 76.6 | 3.89e-15 | NR | HWB03498.1 | 2026801 | g107166 | i0 | 72 | 0.887573964497041 | 50 | 14 | 88.8 | 0 | 5 | 154 | 199 | 248 | HWB03498.1 hypothetical protein [Verrucomicrobiales bacterium] | diamond | 150 | 76.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 30832061 | 30832061 | PRJNA1255065_P_NODE_120874_length_167_cov_0.881356_g118646_i0 | PRJNA1255065 | 120874 | 167 | 0.881356 | 1.47186452 | Opitutus sp. | 1913982 | Bacteria | Bacteria | 101 | 1.72e-24 | NR | MEO7598703.1 | 1913982 | g118646 | i0 | 89.1 | 0.988023952095808 | 55 | 6 | 98.8 | 0 | 165 | 1 | 23 | 77 | MEO7598703.1 pseudouridine synthase [Opitutus sp.] | diamond | 165 | 101 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. | |
| 31053551 | 31053551 | PRJNA1255065_P_NODE_150935_length_162_cov_0.920354_g148707_i0 | PRJNA1255065 | 150935 | 162 | 0.920354 | 1.49097348 | Opitutus sp. | 1913982 | Bacteria | Bacteria | 73.2 | 2.12e-13 | NR | MEO7598439.1 | 1913982 | g148707 | i0 | 75.5 | 0.981481481481482 | 53 | 13 | 98.1 | 0 | 2 | 160 | 127 | 179 | MEO7598439.1 HD domain-containing phosphohydrolase [Opitutus sp.] | diamond | 159 | 73.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. | |
| 32413469 | 32413469 | PRJNA1255065_P_NODE_144199_length_163_cov_0.912281_g141971_i0 | PRJNA1255065 | 144199 | 163 | 0.912281 | 1.48701803 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 60.8 | 9.8e-10 | NR | HWB04359.1 | 2026801 | g141971 | i0 | 75.6 | 0.754601226993865 | 41 | 10 | 75.5 | 0 | 39 | 161 | 1 | 41 | HWB04359.1 type VI secretion system baseplate subunit TssE [Verrucomicrobiales bacterium] | diamond | 123 | 60.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 32494753 | 32494753 | PRJNA1255065_P_NODE_120379_length_167_cov_0.881356_g118151_i0 | PRJNA1255065 | 120379 | 167 | 0.881356 | 1.47186452 | Bacteria | 2 | Bacteria | Bacteria | 77.4 | 7.92e-15 | NR | MFM1768404.1 | 2026799 | g118151 | i0 | 67.3 | 3.95209580838323 | 55 | 18 | 98.8 | 0 | 1 | 165 | 383 | 437 | MFM1768404.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 660 | 77.8 | 0.994858611825193 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32603053 | 32603053 | PRJNA1255065_P_NODE_111420_length_168_cov_0.873950_g109192_i0 | PRJNA1255065 | 111420 | 168 | 0.87395 | 1.468236 | Terrimicrobiaceae bacterium | 2832348 | Bacteria | Bacteria | 43.5 | 0.00719 | NR | MCK9588077.1 | 2832348 | g109192 | i0 | 45.5 | 1.60714285714286 | 44 | 24 | 78.6 | 0 | 163 | 32 | 433 | 476 | MCK9588077.1 hypothetical protein [Terrimicrobiaceae bacterium] | diamond | 270 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobiaceae 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);;