contig_metadata
23 rows where bioproject = "PRJNA358490", tax_clade = "PVC group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2949643 | 2949643 | PRJNA358490_P_NODE_3303_length_787_cov_3.122995_g3090_i0 | PRJNA358490 | 3303 | 787 | 3.122995 | 24.57797065 | Sulfuriroseicoccus oceanibius | 2707525 | Bacteria | Bacteria | 462 | 3.08e-125 | NTclustered | gi|1953472588|gb|CP066776.1| | 2707525 | g3090 | i0 | 89.037 | 94.9097839898348 | 374 | 39 | 87 | 2 | 415 | 787 | 632231 | 631859 | Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome | blastn | 74694 | 462 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Sulfuriroseicoccus | Sulfuriroseicoccus oceanibius | |
| 6776647 | 6776647 | PRJNA358490_P_NODE_17186_length_159_cov_1.500000_g16842_i0 | PRJNA358490 | 17186 | 159 | 1.5 | 2.385 | Luteolibacter sp. Populi | 3230487 | Bacteria | Bacteria | 196 | 5.75e-46 | NTclustered | gi|2774618348|gb|CP161812.1| | 3230487 | g16842 | i0 | 90.066 | 421.987421383648 | 151 | 15 | 95 | 0 | 2 | 152 | 3261583 | 3261433 | Luteolibacter sp. Populi chromosome, complete genome | blastn | 67096 | 196 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. Populi | |
| 8052323 | 8052323 | PRJNA358490_P_NODE_4227_length_686_cov_1.944359_g3986_i0 | PRJNA358490 | 4227 | 686 | 1.944359 | 13.33830274 | Luteolibacter yonseiensis | 1144680 | Bacteria | Bacteria | 395 | 4.65e-137 | NR | WP_200352398.1 | 1144680 | g3986 | i0 | 87.3 | 0.966472303206997 | 221 | 28 | 96.6 | 0 | 684 | 22 | 17 | 237 | WP_200352398.1 triose-phosphate isomerase [Luteolibacter yonseiensis] | diamond | 663 | 395 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter yonseiensis | |
| 10602780 | 10602780 | PRJNA358490_P_NODE_1929_length_1010_cov_2.929969_g1789_i0 | PRJNA358490 | 1929 | 1010 | 2.929969 | 29.5926869 | Luteolibacter sp. LG18 | 2819286 | Bacteria | Bacteria | 686 | 0 | NTclustered | gi|2585939279|dbj|AP024600.1| | 2819286 | g1789 | i0 | 79.3 | 3.74257425742574 | 1000 | 191 | 98 | 13 | 22 | 1010 | 110019 | 109025 | Luteolibacter sp. LG18 DNA, complete genome | blastn | 3780 | 686 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. LG18 | |
| 11877682 | 11877682 | PRJNA358490_P_NODE_16090_length_169_cov_1.569231_g15746_i0 | PRJNA358490 | 16090 | 169 | 1.569231 | 2.65200039 | Haloferula helveola | 490095 | Bacteria | Bacteria | 91.6 | 2.99e-14 | NTclustered | gi|2647781590|dbj|AP024702.1| | 490095 | g15746 | i0 | 83.505 | 1.63313609467456 | 97 | 16 | 57 | 0 | 5 | 101 | 2179358 | 2179454 | Haloferula helveola CN-1 DNA, complete genome | blastn | 276 | 91.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Haloferula | Haloferula helveola | |
| 13826593 | 13826593 | PRJNA358490_P_NODE_13411_length_211_cov_1.401163_g13067_i0 | PRJNA358490 | 13411 | 211 | 1.401163 | 2.95645393 | Luteolibacter | 518753 | Bacteria | Bacteria | 133 | 6.669999999999999e-37 | NR | HEX7261068.1 | 1962973 | g13067 | i0 | 98.6 | 8.90047393364929 | 70 | 1 | 99.5 | 0 | 2 | 211 | 14 | 83 | HEX7261068.1 metal ABC transporter permease [Luteolibacter sp.] | diamond | 1878 | 133 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 15701649 | 15701649 | PRJNA358490_P_NODE_1433_length_1130_cov_16.079743_g1319_i0 | PRJNA358490 | 1433 | 1130 | 16.079743 | 181.7010959 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 1295 | 0 | NTclustered | gi|2874253793|emb|OY969777.1| | 412056 | g1319 | i0 | 90.622 | 321.958407079646 | 981 | 84 | 87 | 5 | 153 | 1130 | 2364712 | 2365687 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1 | blastn | 363813 | 1295 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 16976446 | 16976446 | PRJNA358490_P_NODE_3294_length_788_cov_4.217623_g3083_i0 | PRJNA358490 | 3294 | 788 | 4.217623 | 33.23486924 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 708 | 0 | NTclustered | gi|2874253793|emb|OY969777.1| | 412056 | g3083 | i0 | 86.76 | 263.121827411167 | 642 | 77 | 81 | 8 | 146 | 783 | 2364708 | 2365345 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1 | blastn | 207340 | 708 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 23351010 | 23351010 | PRJNA358490_P_NODE_3079_length_816_cov_2.694981_g2874_i0 | PRJNA358490 | 3079 | 816 | 2.694981 | 21.99104496 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 488 | 3.509999999999999e-168 | NR | MES2920318.1 | 2026799 | g2874 | i0 | 88.5 | 1.91544117647059 | 260 | 30 | 95.6 | 0 | 27 | 806 | 221 | 480 | MES2920318.1 putative porin [Verrucomicrobiota bacterium] | diamond | 1563 | 488 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 24625234 | 24625234 | PRJNA358490_P_NODE_16860_length_162_cov_1.268293_g16516_i0 | PRJNA358490 | 16860 | 162 | 1.268293 | 2.05463466 | Luteolibacter sp. LG18 | 2819286 | Bacteria | Bacteria | 163 | 5.97e-36 | NTclustered | gi|2585939279|dbj|AP024600.1| | 2819286 | g16516 | i0 | 85 | 74.8333333333333 | 160 | 24 | 99 | 0 | 1 | 160 | 5179506 | 5179347 | Luteolibacter sp. LG18 DNA, complete genome | blastn | 12123 | 163 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. LG18 | |
| 26648617 | 26648617 | PRJNA358490_P_NODE_2701_length_870_cov_3.336943_g2516_i0 | PRJNA358490 | 2701 | 870 | 3.336943 | 29.0314041 | Luteolibacter | 518753 | Bacteria | Bacteria | 214 | 5.600000000000001e-59 | NR | MEI7910059.1 | 2026799 | g2516 | i0 | 47.6 | 2.0551724137931 | 294 | 129 | 95.5 | 6 | 870 | 40 | 535 | 820 | MEI7910059.1 autotransporter-associated beta strand repeat-containing protein [Verrucomicrobiota bacterium] | diamond | 1788 | 214 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27959234 | 27959234 | PRJNA358490_P_NODE_15605_length_174_cov_2.377778_g15261_i0 | PRJNA358490 | 15605 | 174 | 2.377778 | 4.13733372 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 87.4 | 2.47e-18 | NR | HWB03578.1 | 2026801 | g15261 | i0 | 71.9 | 0.982758620689655 | 57 | 16 | 98.3 | 0 | 172 | 2 | 386 | 442 | HWB03578.1 cytochrome c oxidase subunit 3 [Verrucomicrobiales bacterium] | diamond | 171 | 87.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 28527828 | 28527828 | PRJNA358490_P_NODE_15547_length_175_cov_1.529412_g15203_i0 | PRJNA358490 | 15547 | 175 | 1.529412 | 2.676471 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 72.4 | 5.24e-13 | NR | MEI7910059.1 | 2026799 | g15203 | i0 | 60.3 | 0.994285714285714 | 58 | 23 | 99.4 | 0 | 175 | 2 | 470 | 527 | MEI7910059.1 autotransporter-associated beta strand repeat-containing protein [Verrucomicrobiota bacterium] | diamond | 174 | 72.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28874886 | 28874886 | PRJNA358490_P_NODE_18328_length_151_cov_1.151786_g17984_i0 | PRJNA358490 | 18328 | 151 | 1.151786 | 1.73919686 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 86.3 | 1.22e-18 | NR | MES2921678.1 | 2026799 | g17984 | i0 | 98 | 1.98675496688742 | 50 | 1 | 99.3 | 0 | 2 | 151 | 100 | 149 | MES2921678.1 metal ABC transporter permease [Verrucomicrobiota bacterium] | diamond | 300 | 86.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29113134 | 29113134 | PRJNA358490_P_NODE_7968_length_437_cov_1.545226_g7627_i0 | PRJNA358490 | 7968 | 437 | 1.545226 | 6.75263762 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 80.9 | 8.06e-15 | NR | WP_146853078.1 | 748831 | g7627 | i0 | 79.1 | 1.05720823798627 | 43 | 9 | 29.5 | 0 | 375 | 247 | 27 | 69 | WP_146853078.1 sialidase family protein [Brevifollis gellanilyticus] | diamond | 462 | 80.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Brevifollis | Brevifollis gellanilyticus | |
| 29380089 | 29380089 | PRJNA358490_P_NODE_10609_length_303_cov_2.132576_g10267_i0 | PRJNA358490 | 10609 | 303 | 2.132576 | 6.46170528 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 119 | 2.4199999999999998e-32 | NR | RFC50620.1 | 2026799 | g10267 | i0 | 71.4 | 1.8019801980198 | 91 | 22 | 90.1 | 2 | 274 | 2 | 3 | 89 | RFC50620.1 MAG: Cytochrome C oxidase subunit IV [Verrucomicrobiota bacterium] | diamond | 546 | 119 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29695479 | 29695479 | PRJNA358490_P_NODE_10310_length_317_cov_1.273381_g9968_i0 | PRJNA358490 | 10310 | 317 | 1.273381 | 4.03661777 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 197 | 1.49e-57 | NR | MES2922912.1 | 2026799 | g9968 | i0 | 91.4 | 0.993690851735016 | 105 | 9 | 99.4 | 0 | 317 | 3 | 348 | 452 | MES2922912.1 AI-2E family transporter [Verrucomicrobiota bacterium] | diamond | 315 | 197 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29980095 | 29980095 | PRJNA358490_P_NODE_3471_length_766_cov_3.220083_g3252_i0 | PRJNA358490 | 3471 | 766 | 3.220083 | 24.66583578 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 288 | 4.36e-93 | NR | MES2924107.1 | 2026799 | g3252 | i0 | 88.9 | 0.634464751958224 | 162 | 17 | 63.4 | 1 | 260 | 745 | 3 | 163 | MES2924107.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 486 | 288 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29980096 | 29980096 | PRJNA358490_P_NODE_4751_length_639_cov_1.436667_g4480_i0 | PRJNA358490 | 4751 | 639 | 1.436667 | 9.18030213 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 98.2 | 9.83e-20 | NR | MEO5713535.1 | 1962973 | g4480 | i0 | 58 | 2.17840375586854 | 88 | 37 | 41.3 | 0 | 85 | 348 | 20 | 107 | MEO5713535.1 leucine-rich repeat domain-containing protein [Luteolibacter sp.] | diamond | 1392 | 98.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 31261091 | 31261091 | PRJNA358490_P_NODE_13875_length_201_cov_1.512346_g13531_i0 | PRJNA358490 | 13875 | 201 | 1.512346 | 3.03981546 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 130 | 2.78e-33 | NR | HEX2861055.1 | 1961806 | g13531 | i0 | 89.4 | 4.92537313432836 | 66 | 7 | 98.5 | 0 | 3 | 200 | 557 | 622 | HEX2861055.1 ABC transporter permease [Lacunisphaera sp.] | diamond | 990 | 130 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera sp. | |
| 31767060 | 31767060 | PRJNA358490_P_NODE_6677_length_505_cov_2.175966_g6347_i0 | PRJNA358490 | 6677 | 505 | 2.175966 | 10.9886283 | Luteolibacter | 518753 | Bacteria | Bacteria | 304 | 7.599999999999999e-102 | NR | HEX7262126.1 | 1962973 | g6347 | i0 | 83.2 | 4.96039603960396 | 167 | 28 | 99.2 | 0 | 3 | 503 | 62 | 228 | HEX7262126.1 MYG1 family protein [Luteolibacter sp.] | diamond | 2505 | 304 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 31876394 | 31876394 | PRJNA358490_P_NODE_11457_length_270_cov_1.233766_g11113_i0 | PRJNA358490 | 11457 | 270 | 1.233766 | 3.3311682 | Verrucomicrobia bacterium LW23 | 2161867 | Bacteria | Bacteria | 127 | 4.55e-35 | NR | PTX92056.1 | 2161867 | g11113 | i0 | 69.7 | 4.11111111111111 | 99 | 19 | 97.8 | 2 | 269 | 6 | 85 | 183 | PTX92056.1 hypothetical protein DB346_24215 [Verrucomicrobia bacterium LW23] | diamond | 1110 | 127 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobia bacterium LW23 | |||||
| 32224693 | 32224693 | PRJNA358490_P_NODE_3018_length_826_cov_2.880559_g2816_i0 | PRJNA358490 | 3018 | 826 | 2.880559 | 23.79341734 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 451 | 3.409999999999999e-143 | NR | MES2923304.1 | 2026799 | g2816 | i0 | 88.3 | 0.966101694915254 | 266 | 31 | 96.6 | 0 | 19 | 816 | 1126 | 1391 | MES2923304.1 glycoside hydrolase family 98 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 798 | 451 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota 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);;