contig_metadata
9 rows where bioproject = "PRJNA222400", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 367262 | 367262 | PRJNA222400_P_NODE_9001_length_163_cov_0.912281_g8968_i0 | PRJNA222400 | 9001 | 163 | 0.912281 | 1.48701803 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 82.8 | 7.68e-17 | NR | WP_068772074.1 | 1184151 | g8968 | i0 | 78.8 | 5.8159509202454 | 52 | 11 | 95.7 | 0 | 161 | 6 | 31 | 82 | WP_068772074.1 phosphoglycerate kinase [Termitidicoccus mucosus] | diamond | 948 | 82.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Termitidicoccus | Termitidicoccus mucosus | |
| 27249782 | 27249782 | PRJNA222400_P_NODE_483_length_733_cov_2.514620_g455_i0 | PRJNA222400 | 483 | 733 | 2.51462 | 18.4321646 | Bacteria | 2 | Bacteria | Bacteria | 61.6 | 6.25e-7 | NR | MCX6884131.1 | 2026799 | g455 | i0 | 31.3 | 1.08458390177353 | 128 | 83 | 50.8 | 2 | 608 | 237 | 44 | 170 | MCX6884131.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 795 | 62 | 0.993548387096774 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27832034 | 27832034 | PRJNA222400_P_NODE_1064_length_500_cov_1.917960_g1031_i0 | PRJNA222400 | 1064 | 500 | 1.91796 | 9.5898 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 47 | 0.00862 | NR | MBT15889.1 | 2026801 | g1031 | i0 | 29.6 | 0.648 | 108 | 63 | 60 | 3 | 14 | 313 | 58 | 160 | MBT15889.1 hypothetical protein [Verrucomicrobiales bacterium] | diamond | 324 | 47 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 28779188 | 28779188 | PRJNA222400_P_NODE_5587_length_190_cov_0.964539_g5554_i0 | PRJNA222400 | 5587 | 190 | 0.964539 | 1.8326241 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 51.6 | 1.36e-5 | NR | HQF39152.1 | 2006848 | g5554 | i0 | 49.2 | 4.56315789473684 | 61 | 29 | 96.3 | 1 | 184 | 2 | 305 | 363 | HQF39152.1 serpin family protein [Opitutaceae bacterium] | diamond | 867 | 51.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 29000700 | 29000700 | PRJNA222400_P_NODE_1368_length_442_cov_1.521628_g1335_i0 | PRJNA222400 | 1368 | 442 | 1.521628 | 6.72559576 | Chthoniobacter sp. | 2510640 | Bacteria | Bacteria | 61.2 | 1.16e-7 | NR | WP_348543608.1 | 2510640 | g1335 | i0 | 35.8 | 0.834841628959276 | 123 | 75 | 80.8 | 4 | 58 | 414 | 83 | 205 | WP_348543608.1 beta strand repeat-containing protein, partial [Chthoniobacter sp.] | diamond | 369 | 61.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 31053725 | 31053725 | PRJNA222400_P_NODE_1655_length_396_cov_1.285303_g1622_i0 | PRJNA222400 | 1655 | 396 | 1.285303 | 5.08979988 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 52.8 | 6.63e-5 | NR | MBK9138994.1 | 2026799 | g1622 | i0 | 50 | 0.378787878787879 | 50 | 23 | 37.9 | 1 | 394 | 245 | 1265 | 1312 | MBK9138994.1 S8 family serine peptidase [Verrucomicrobiota bacterium] | diamond | 150 | 52.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31545644 | 31545644 | PRJNA222400_P_NODE_2336_length_323_cov_1.503650_g2303_i0 | PRJNA222400 | 2336 | 323 | 1.50365 | 4.8567895 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 123 | 1.29e-31 | NR | PYL06424.1 | 2026799 | g2303 | i0 | 65.2 | 8.30340557275542 | 89 | 31 | 82.7 | 0 | 56 | 322 | 1 | 89 | PYL06424.1 MAG: NADPH:quinone reductase [Verrucomicrobiota bacterium] | diamond | 2682 | 124 | 0.991935483870968 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32002224 | 32002224 | PRJNA222400_P_NODE_298_length_891_cov_1.720903_g275_i0 | PRJNA222400 | 298 | 891 | 1.720903 | 15.33324573 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 56.2 | 6.62e-5 | NR | MEM7396574.1 | 2026799 | g275 | i0 | 31.3 | 0.387205387205387 | 115 | 74 | 37 | 2 | 533 | 204 | 227 | 341 | MEM7396574.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 345 | 56.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32097097 | 32097097 | PRJNA222400_P_NODE_3118_length_265_cov_1.101852_g3085_i0 | PRJNA222400 | 3118 | 265 | 1.101852 | 2.9199078 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 80.9 | 1.88e-15 | NR | MCX6968401.1 | 2026799 | g3085 | i0 | 50.7 | 0.80377358490566 | 71 | 35 | 80.4 | 0 | 50 | 262 | 544 | 614 | MCX6968401.1 PAS domain S-box protein [Verrucomicrobiota bacterium] | diamond | 213 | 80.9 | 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);;