contig_metadata
19 rows where bioproject = "PRJDB4470" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1283971 | 1283971 | PRJDB4470_P_NODE_65782_length_232_cov_1.103825_g64627_i0 | PRJDB4470 | 65782 | 232 | 1.103825 | 2.560874 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 230 | 8.929999999999999e-56 | NTclustered | gi|2813917447|gb|CP170506.1| | 2811408 | g64627 | i0 | 84.848 | 37.9353448275862 | 231 | 32 | 99 | 3 | 1 | 230 | 3047922 | 3047694 | MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome | blastn | 8801 | 230 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 2559015 | 2559015 | PRJDB4470_P_NODE_119683_length_163_cov_0.894737_g118528_i0 | PRJDB4470 | 119683 | 163 | 0.894737 | 1.45842131 | Prosthecobacter sp. SYSU 5D2 | 3134134 | Bacteria | Bacteria | 107 | 2.07e-27 | NR | WP_346332765.1 | 3134134 | g118528 | i0 | 90.7 | 0.993865030674847 | 54 | 5 | 99.4 | 0 | 2 | 163 | 129 | 182 | WP_346332765.1 type 1 glutamine amidotransferase domain-containing protein [Prosthecobacter sp. SYSU 5D2] | diamond | 162 | 107 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. SYSU 5D2 | |
| 3835880 | 3835880 | PRJDB4470_P_NODE_67284_length_227_cov_3.129213_g66129_i0 | PRJDB4470 | 67284 | 227 | 3.129213 | 7.10331351 | Lacunisphaera limnophila | 1838286 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|1070531674|gb|CP016094.1| | 1838286 | g66129 | i0 | 100 | 0.127753303964758 | 29 | 0 | 13 | 0 | 178 | 206 | 1818139 | 1818111 | Lacunisphaera limnophila strain IG16b, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera limnophila | |
| 7662053 | 7662053 | PRJDB4470_P_NODE_67487_length_227_cov_1.432584_g66332_i0 | PRJDB4470 | 67487 | 227 | 1.432584 | 3.25196568 | Fontisphaera persica | 2974023 | Bacteria | Bacteria | 231 | 2.4199999999999997e-56 | NTclustered | gi|2439237958|gb|CP116615.1| | 2974023 | g66332 | i0 | 85.345 | 12.9471365638767 | 232 | 24 | 100 | 10 | 1 | 227 | 3862168 | 3862394 | Fontisphaera persica strain B-154 chromosome, complete genome | blastn | 2939 | 231 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Fontisphaeraceae | Fontisphaera | Fontisphaera persica | |
| 8936475 | 8936475 | PRJDB4470_P_NODE_42948_length_326_cov_2.870036_g41795_i0 | PRJDB4470 | 42948 | 326 | 2.870036 | 9.35631736 | Prosthecobacter vanneervenii | 48466 | Bacteria | Bacteria | 569 | 6.839999999999998e-158 | NTclustered | gi|12583975|gb|AF245379.1|AF245379 | 48466 | g41795 | i0 | 98.16 | 163.70245398773 | 326 | 6 | 100 | 0 | 1 | 326 | 345 | 670 | Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence | blastn | 53367 | 569 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter vanneervenii | |
| 16586267 | 16586267 | PRJDB4470_P_NODE_3134_length_1280_cov_15.156783_g2697_i0 | PRJDB4470 | 3134 | 1280 | 15.156783 | 194.0068224 | Fontisphaera persica | 2974023 | Bacteria | Bacteria | 1085 | 0 | NTclustered | gi|2439237958|gb|CP116615.1| | 2974023 | g2697 | i0 | 85.377 | 168.49453125 | 1060 | 139 | 82 | 10 | 179 | 1225 | 3862490 | 3861434 | Fontisphaera persica strain B-154 chromosome, complete genome | blastn | 215673 | 1085 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Fontisphaeraceae | Fontisphaera | Fontisphaera persica | |
| 17861091 | 17861091 | PRJDB4470_P_NODE_17935_length_574_cov_6.099048_g16864_i0 | PRJDB4470 | 17935 | 574 | 6.099048 | 35.00853552 | Prosthecobacter fusiformis | 48464 | Bacteria | Bacteria | 244 | 8.71e-60 | NTclustered | gi|12583974|gb|AF245378.1|AF245378 | 48464 | g16864 | i0 | 78.607 | 247.905923344948 | 402 | 63 | 67 | 16 | 50 | 436 | 582 | 189 | Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence | blastn | 142298 | 244 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter fusiformis | |
| 23933670 | 23933670 | PRJDB4470_P_NODE_118619_length_163_cov_0.912281_g117464_i0 | PRJDB4470 | 118619 | 163 | 0.912281 | 1.48701803 | Rubritalea | 361050 | Bacteria | Bacteria | 107 | 2.91e-25 | NR | WP_018970057.1 | 361055 | g117464 | i0 | 96.3 | 6.95705521472393 | 54 | 2 | 99.4 | 0 | 2 | 163 | 170 | 223 | WP_018970057.1 carbamoyl-phosphate synthase large subunit [Rubritalea marina] | diamond | 1134 | 107 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Rubritaleaceae | Rubritalea | Rubritalea marina | |
| 27411991 | 27411991 | PRJDB4470_P_NODE_105343_length_167_cov_0.864407_g104188_i0 | PRJDB4470 | 105343 | 167 | 0.864407 | 1.44355969 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 47.4 | 1.39e-4 | NR | MEO6245693.1 | 2006848 | g104188 | i0 | 48.6 | 0.664670658682635 | 37 | 19 | 66.5 | 0 | 31 | 141 | 93 | 129 | MEO6245693.1 hypothetical protein [Opitutaceae bacterium] | diamond | 111 | 47.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 27474838 | 27474838 | PRJDB4470_P_NODE_113203_length_165_cov_0.870690_g112048_i0 | PRJDB4470 | 113203 | 165 | 0.87069 | 1.4366385 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 62.4 | 1.47e-9 | NR | MEN9677548.1 | 2026799 | g112048 | i0 | 97.1 | 0.618181818181818 | 34 | 1 | 61.8 | 0 | 103 | 2 | 1 | 34 | MEN9677548.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 102 | 62.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27664506 | 27664506 | PRJDB4470_P_NODE_114964_length_164_cov_0.904348_g113809_i0 | PRJDB4470 | 114964 | 164 | 0.904348 | 1.48313072 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 41.2 | 0.0453 | NR | MEI7962728.1 | 2026799 | g113809 | i0 | 48.8 | 0.786585365853659 | 43 | 21 | 78.7 | 1 | 130 | 2 | 280 | 321 | MEI7962728.1 NAD-dependent DNA ligase LigA [Verrucomicrobiota bacterium] | diamond | 129 | 41.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28390509 | 28390509 | PRJDB4470_P_NODE_86526_length_188_cov_1.266187_g85371_i0 | PRJDB4470 | 86526 | 188 | 1.266187 | 2.38043156 | Verrucomicrobium sp. BvORR | 72225 | Bacteria | Bacteria | 65.9 | 1.61e-11 | NR | WP_265592646.1 | 1396418 | g85371 | i0 | 45.8 | 0.941489361702128 | 59 | 32 | 94.1 | 0 | 179 | 3 | 48 | 106 | WP_265592646.1 hypothetical protein [Verrucomicrobium sp. BvORR034] | diamond | 177 | 65.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium sp. BvORR034 | |
| 28485282 | 28485282 | PRJDB4470_P_NODE_105727_length_167_cov_0.864407_g104572_i0 | PRJDB4470 | 105727 | 167 | 0.864407 | 1.44355969 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 89.7 | 9.9e-21 | NR | MCI0538931.1 | 2026801 | g104572 | i0 | 87.3 | 1.97604790419162 | 55 | 7 | 98.8 | 0 | 166 | 2 | 79 | 133 | MCI0538931.1 GNAT family N-acetyltransferase [Verrucomicrobiales bacterium] | diamond | 330 | 89.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 29963430 | 29963430 | PRJDB4470_P_NODE_116811_length_164_cov_0.878261_g115656_i0 | PRJDB4470 | 116811 | 164 | 0.878261 | 1.44034804 | Bacteria | 2 | Bacteria | Bacteria | 77.4 | 7.53e-15 | NR | MEI7775712.1 | 2026799 | g115656 | i0 | 69.1 | 2.01219512195122 | 55 | 16 | 98.8 | 1 | 162 | 1 | 296 | 350 | MEI7775712.1 DUF1549 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 330 | 77.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31005990 | 31005990 | PRJDB4470_P_NODE_80674_length_198_cov_1.026846_g79519_i0 | PRJDB4470 | 80674 | 198 | 1.026846 | 2.03315508 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 106 | 8.72e-25 | NR | WP_165107678.1 | 1324935 | g79519 | i0 | 83.1 | 5.87878787878788 | 65 | 11 | 98.5 | 0 | 197 | 3 | 750 | 814 | WP_165107678.1 magnesium-translocating P-type ATPase [Limisphaera ngatamarikiensis] | diamond | 1164 | 107 | 0.990654205607477 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Limisphaeraceae | Limisphaera | Limisphaera ngatamarikiensis | |
| 31163691 | 31163691 | PRJDB4470_P_NODE_123735_length_162_cov_0.902655_g122580_i0 | PRJDB4470 | 123735 | 162 | 0.902655 | 1.4623011 | Luteolibacter | 518753 | Bacteria | Bacteria | 108 | 3.9099999999999997e-28 | NR | RYD32642.1 | 2026800 | g122580 | i0 | 96.3 | 2 | 54 | 2 | 100 | 0 | 162 | 1 | 53 | 106 | RYD32642.1 MAG: IMP dehydrogenase, partial [Verrucomicrobiaceae bacterium] | diamond | 324 | 108 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31169677 | 31169677 | PRJDB4470_P_NODE_70795_length_219_cov_0.800000_g69640_i0 | PRJDB4470 | 70795 | 219 | 0.8 | 1.752 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 42 | 0.0479 | NR | MEK7781196.1 | 2026799 | g69640 | i0 | 31.6 | 1.04109589041096 | 76 | 41 | 90.4 | 2 | 200 | 3 | 209 | 283 | MEK7781196.1 cytochrome c biogenesis protein CcsA [Verrucomicrobiota bacterium] | diamond | 228 | 42 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32150579 | 32150579 | PRJDB4470_P_NODE_67378_length_227_cov_1.876404_g66223_i0 | PRJDB4470 | 67378 | 227 | 1.876404 | 4.25943708 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 45.4 | 3.95e-4 | NR | MFT3829826.1 | 2006848 | g66223 | i0 | 43.9 | 0.753303964757709 | 57 | 27 | 75.3 | 2 | 201 | 31 | 14 | 65 | MFT3829826.1 hypothetical protein [Opitutaceae bacterium] | diamond | 171 | 45.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 32340556 | 32340556 | PRJDB4470_P_NODE_122159_length_162_cov_0.920354_g121004_i0 | PRJDB4470 | 122159 | 162 | 0.920354 | 1.49097348 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 71.6 | 2.37e-14 | NR | MDB6117400.1 | 2026800 | g121004 | i0 | 65.3 | 0.907407407407407 | 49 | 17 | 90.7 | 0 | 149 | 3 | 44 | 92 | MDB6117400.1 hypothetical protein [Verrucomicrobiaceae bacterium] | diamond | 147 | 71.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae 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);;