contig_metadata
24 rows where bioproject = "PRJNA950981" and tax_clade = "PVC group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26645470 | 26645470 | PRJNA950981_P_NODE_16381_length_253_cov_1.783333_g16205_i0 | PRJNA950981 | 16381 | 253 | 1.783333 | 4.51183249 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 103 | 1.09e-25 | NR | MBY0309153.1 | 2052180 | g16205 | i0 | 62.1 | 1.03162055335968 | 87 | 29 | 98.4 | 1 | 2 | 250 | 19 | 105 | MBY0309153.1 hypothetical protein [Phycisphaerales bacterium] | diamond | 261 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 27246813 | 27246813 | PRJNA950981_P_NODE_7383_length_365_cov_0.804795_g7207_i0 | PRJNA950981 | 7383 | 365 | 0.804795 | 2.93750175 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 90.1 | 5.47e-19 | NR | MBY0309332.1 | 2052180 | g7207 | i0 | 72.2 | 0.591780821917808 | 72 | 15 | 59.2 | 3 | 216 | 1 | 28 | 94 | MBY0309332.1 ankyrin repeat domain-containing protein [Phycisphaerales bacterium] | diamond | 216 | 90.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 27310244 | 27310244 | PRJNA950981_P_NODE_7603_length_360_cov_2.045296_g7427_i0 | PRJNA950981 | 7603 | 360 | 2.045296 | 7.3630656 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 43.9 | 0.0454 | NR | MBY0309101.1 | 2052180 | g7427 | i0 | 33.3 | 0.825 | 99 | 60 | 77.5 | 1 | 71 | 349 | 161 | 259 | MBY0309101.1 transposase family protein [Phycisphaerales bacterium] | diamond | 297 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 27531088 | 27531088 | PRJNA950981_P_NODE_6303_length_391_cov_1.135220_g6127_i0 | PRJNA950981 | 6303 | 391 | 1.13522 | 4.4387102 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 269 | 2.139999999999999e-87 | NR | MBY0307194.1 | 2052180 | g6127 | i0 | 99.2 | 0.989769820971867 | 129 | 1 | 99 | 0 | 389 | 3 | 178 | 306 | MBY0307194.1 cation transporter [Phycisphaerales bacterium] | diamond | 387 | 269 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 27689381 | 27689381 | PRJNA950981_P_NODE_17884_length_250_cov_0.881356_g17708_i0 | PRJNA950981 | 17884 | 250 | 0.881356 | 2.20339 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 105 | 1.7699999999999998e-24 | NR | MBY0307335.1 | 2052180 | g17708 | i0 | 67.5 | 0.96 | 80 | 23 | 96 | 2 | 9 | 248 | 378 | 454 | MBY0307335.1 hypothetical protein [Phycisphaerales bacterium] | diamond | 240 | 105 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 27815504 | 27815504 | PRJNA950981_P_NODE_17144_length_252_cov_0.871508_g16968_i0 | PRJNA950981 | 17144 | 252 | 0.871508 | 2.19620016 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 77 | 3.45e-14 | NR | MBY0309310.1 | 2052180 | g16968 | i0 | 78.7 | 0.55952380952381 | 47 | 10 | 56 | 0 | 251 | 111 | 560 | 606 | MBY0309310.1 right-handed parallel beta-helix repeat-containing protein [Phycisphaerales bacterium] | diamond | 141 | 77 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 27878433 | 27878433 | PRJNA950981_P_NODE_4705_length_447_cov_1.403743_g4529_i0 | PRJNA950981 | 4705 | 447 | 1.403743 | 6.27473121 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 133 | 1.5399999999999998e-37 | NR | MBY0307178.1 | 2052180 | g4529 | i0 | 90 | 0.469798657718121 | 70 | 7 | 47 | 0 | 211 | 2 | 1 | 70 | MBY0307178.1 hypothetical protein [Phycisphaerales bacterium] | diamond | 210 | 133 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 27941676 | 27941676 | PRJNA950981_P_NODE_19425_length_247_cov_0.896552_g19249_i0 | PRJNA950981 | 19425 | 247 | 0.896552 | 2.21448344 | Mariniblastus sp. | 2005381 | Bacteria | Bacteria | 43.1 | 0.0264 | NR | MCH2178714.1 | 2005381 | g19249 | i0 | 30.4 | 0.959514170040486 | 79 | 50 | 89.9 | 1 | 6 | 227 | 112 | 190 | MCH2178714.1 type II secretion system F family protein [Mariniblastus sp.] | diamond | 237 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Mariniblastus | Mariniblastus sp. | |
| 28225499 | 28225499 | PRJNA950981_P_NODE_11166_length_306_cov_1.326180_g10990_i0 | PRJNA950981 | 11166 | 306 | 1.32618 | 4.0581108 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 114 | 5.630000000000001e-27 | NR | MBY0309215.1 | 2052180 | g10990 | i0 | 100 | 0.549019607843137 | 56 | 0 | 54.9 | 0 | 3 | 170 | 881 | 936 | MBY0309215.1 protein kinase [Phycisphaerales bacterium] | diamond | 168 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 28351992 | 28351992 | PRJNA950981_P_NODE_19386_length_247_cov_0.896552_g19210_i0 | PRJNA950981 | 19386 | 247 | 0.896552 | 2.21448344 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 54.3 | 3.25e-6 | NR | MBY0307876.1 | 2052180 | g19210 | i0 | 71.4 | 0.801619433198381 | 35 | 10 | 42.5 | 0 | 1 | 105 | 1 | 35 | MBY0307876.1 ankyrin repeat domain-containing protein [Phycisphaerales bacterium] | diamond | 198 | 54.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 28604661 | 28604661 | PRJNA950981_P_NODE_18007_length_250_cov_0.881356_g17831_i0 | PRJNA950981 | 18007 | 250 | 0.881356 | 2.20339 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 55.5 | 3.55e-7 | NR | MBY0308907.1 | 2052180 | g17831 | i0 | 39.2 | 0.888 | 74 | 44 | 88.8 | 1 | 2 | 223 | 3 | 75 | MBY0308907.1 ankyrin repeat domain-containing protein [Phycisphaerales bacterium] | diamond | 222 | 55.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 29236228 | 29236228 | PRJNA950981_P_NODE_13869_length_277_cov_1.078431_g13693_i0 | PRJNA950981 | 13869 | 277 | 1.078431 | 2.98725387 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 93.6 | 8.930000000000001e-21 | NR | MBY0309332.1 | 2052180 | g13693 | i0 | 82.8 | 0.628158844765343 | 58 | 9 | 62.8 | 1 | 34 | 207 | 37 | 93 | MBY0309332.1 ankyrin repeat domain-containing protein [Phycisphaerales bacterium] | diamond | 174 | 93.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 29558311 | 29558311 | PRJNA950981_P_NODE_12190_length_294_cov_1.411765_g12014_i0 | PRJNA950981 | 12190 | 294 | 1.411765 | 4.1505891 | Bacteria | 2 | Bacteria | Bacteria | 72.4 | 1.37e-12 | NR | HEV3120617.1 | 2691532 | g12014 | i0 | 48.3 | 1.80612244897959 | 87 | 31 | 88.8 | 2 | 266 | 6 | 10 | 82 | HEV3120617.1 tRNA pseudouridine(55) synthase TruB [Isosphaeraceae bacterium] | diamond | 531 | 72.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Isosphaeraceae bacterium | ||
| 29583119 | 29583119 | PRJNA950981_P_NODE_19190_length_247_cov_0.896552_g19014_i0 | PRJNA950981 | 19190 | 247 | 0.896552 | 2.21448344 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 82.4 | 3.56e-16 | NR | MBY0307974.1 | 2052180 | g19014 | i0 | 97.6 | 0.497975708502024 | 41 | 1 | 49.8 | 0 | 125 | 247 | 1 | 41 | MBY0307974.1 hypothetical protein [Phycisphaerales bacterium] | diamond | 123 | 82.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 30151697 | 30151697 | PRJNA950981_P_NODE_19232_length_247_cov_0.896552_g19056_i0 | PRJNA950981 | 19232 | 247 | 0.896552 | 2.21448344 | Pirellulaceae bacterium | 2699754 | Bacteria | Bacteria | 42.7 | 0.0402 | NR | MCU0959533.1 | 2699754 | g19056 | i0 | 43.4 | 0.643724696356275 | 53 | 30 | 64.4 | 0 | 163 | 5 | 182 | 234 | MCU0959533.1 hypothetical protein [Pirellulaceae bacterium] | diamond | 159 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellulaceae bacterium | ||
| 30342073 | 30342073 | PRJNA950981_P_NODE_6432_length_387_cov_0.993631_g6256_i0 | PRJNA950981 | 6432 | 387 | 0.993631 | 3.84535197 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 80.5 | 6.64e-16 | NR | MFT5207936.1 | 2035772 | g6256 | i0 | 37.2 | 1.96899224806202 | 129 | 74 | 97.7 | 3 | 5 | 382 | 30 | 154 | MFT5207936.1 peroxiredoxin [Candidatus Omnitrophota bacterium] | diamond | 762 | 80.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30436590 | 30436590 | PRJNA950981_P_NODE_9073_length_335_cov_1.190840_g8897_i0 | PRJNA950981 | 9073 | 335 | 1.19084 | 3.989314 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 67.8 | 1.78e-10 | NR | MEY2612968.1 | 2026780 | g8897 | i0 | 45.3 | 0.850746268656716 | 95 | 48 | 83.3 | 3 | 283 | 5 | 206 | 298 | MEY2612968.1 Large cysteine-rich periplasmic protein omcB precursor [Planctomycetota bacterium] | diamond | 285 | 67.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30942007 | 30942007 | PRJNA950981_P_NODE_12714_length_288_cov_1.813953_g12538_i0 | PRJNA950981 | 12714 | 288 | 1.813953 | 5.22418464 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 90.9 | 7.78e-19 | NR | MBS0647573.1 | 2026799 | g12538 | i0 | 45.6 | 0.9375 | 90 | 49 | 93.8 | 0 | 287 | 18 | 775 | 864 | MBS0647573.1 DDE-type integrase/transposase/recombinase [Verrucomicrobiota bacterium] | diamond | 270 | 90.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31005060 | 31005060 | PRJNA950981_P_NODE_18214_length_249_cov_0.886364_g18038_i0 | PRJNA950981 | 18214 | 249 | 0.886364 | 2.20704636 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 157 | 4.43e-45 | NR | MBY0309327.1 | 2052180 | g18038 | i0 | 98.8 | 0.987951807228916 | 82 | 1 | 98.8 | 0 | 2 | 247 | 229 | 310 | MBY0309327.1 patatin-like phospholipase family protein [Phycisphaerales bacterium] | diamond | 246 | 157 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 31226086 | 31226086 | PRJNA950981_P_NODE_19335_length_247_cov_0.896552_g19159_i0 | PRJNA950981 | 19335 | 247 | 0.896552 | 2.21448344 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 62.4 | 4.87e-9 | NR | HVM59820.1 | 2499141 | g19159 | i0 | 50 | 2.45344129554656 | 72 | 32 | 85 | 3 | 10 | 219 | 2666 | 2735 | HVM59820.1 HYR domain-containing protein [Verrucomicrobiia bacterium] | diamond | 606 | 62.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31542609 | 31542609 | PRJNA950981_P_NODE_6236_length_393_cov_1.068750_g6060_i0 | PRJNA950981 | 6236 | 393 | 1.06875 | 4.2001875 | Candidatus Uabimicrobium helgolandensis | 3095367 | Bacteria | Bacteria | 57 | 2.14e-6 | NR | WP_372369741.1 | 3095367 | g6060 | i0 | 47.9 | 0.732824427480916 | 48 | 25 | 36.6 | 0 | 384 | 241 | 1085 | 1132 | WP_372369741.1 DUF4062 domain-containing protein [Candidatus Uabimicrobium helgolandensis] | diamond | 288 | 57 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Uabimicrobiia | Candidatus Uabimicrobiales | Candidatus Uabimicrobiaceae | Candidatus Uabimicrobium | Candidatus Uabimicrobium helgolandensis | |
| 32175439 | 32175439 | PRJNA950981_P_NODE_12198_length_294_cov_1.411765_g12022_i0 | PRJNA950981 | 12198 | 294 | 1.411765 | 4.1505891 | Pirellulales bacterium | 2715253 | Bacteria | Bacteria | 61.6 | 1.58e-8 | NR | MFO0915845.1 | 2715253 | g12022 | i0 | 48.1 | 0.551020408163265 | 54 | 28 | 55.1 | 0 | 41 | 202 | 878 | 931 | MFO0915845.1 hypothetical protein [Pirellulales bacterium] | diamond | 162 | 61.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulales bacterium | |||
| 32206906 | 32206906 | PRJNA950981_P_NODE_19698_length_246_cov_0.901734_g19522_i0 | PRJNA950981 | 19698 | 246 | 0.901734 | 2.21826564 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 53.1 | 7.46e-6 | NR | MEK7414778.1 | 2026780 | g19522 | i0 | 34.6 | 0.98780487804878 | 81 | 51 | 96.3 | 1 | 2 | 238 | 33 | 113 | MEK7414778.1 hypothetical protein [Planctomycetota bacterium] | diamond | 243 | 53.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32491798 | 32491798 | PRJNA950981_P_NODE_17139_length_252_cov_0.871508_g16963_i0 | PRJNA950981 | 17139 | 252 | 0.871508 | 2.19620016 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 90.9 | 4.68e-19 | NR | MBL8872133.1 | 2026779 | g16963 | i0 | 59.7 | 0.857142857142857 | 72 | 28 | 84.5 | 1 | 24 | 236 | 226 | 297 | MBL8872133.1 carboxypeptidase regulatory-like domain-containing protein [Planctomycetaceae bacterium] | diamond | 216 | 90.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae 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);;