contig_metadata
9 rows where bioproject = "PRJNA725806", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 711742 | 711742 | PRJNA725806_P_NODE_139421_length_174_cov_0.992701_g139119_i0 | PRJNA725806 | 139421 | 174 | 0.99270099999999994 | 1.72729974 | Luteolibacter luteus | 2728835 | Bacteria | Bacteria | 255 | 1.04e-63 | NTclustered | gi|1835317346|gb|CP051774.1| | 2728835 | g139119 | i0 | 97.333 | 220.465517241379 | 150 | 4 | 86 | 0 | 25 | 174 | 3803514 | 3803663 | Luteolibacter luteus strain G-1-1-1 chromosome, complete genome | blastn | 38361 | 255 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter luteus | |
| 8365182 | 8365182 | PRJNA725806_P_NODE_327_length_1066_cov_7.145773_g236_i0 | PRJNA725806 | 327 | 1066 | 7.145773 | 76.17394018 | Luteolibacter luteus | 2728835 | Bacteria | Bacteria | 1799 | 0 | NTclustered | gi|1835317346|gb|CP051774.1| | 2728835 | g236 | i0 | 98.066 | 278.549718574109 | 1034 | 20 | 97 | 0 | 14 | 1047 | 3804911 | 3803878 | Luteolibacter luteus strain G-1-1-1 chromosome, complete genome | blastn | 296934 | 1799 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter luteus | |
| 13465644 | 13465644 | PRJNA725806_P_NODE_30911_length_285_cov_1.552419_g30614_i0 | PRJNA725806 | 30911 | 285 | 1.552419 | 4.42439415 | Prosthecobacter vanneervenii | 48466 | Bacteria | Bacteria | 488 | 1.6899999999999999e-133 | NTclustered | gi|12583975|gb|AF245379.1|AF245379 | 48466 | g30614 | i0 | 97.544 | 92.7543859649123 | 285 | 7 | 100 | 0 | 1 | 285 | 623 | 907 | Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence | blastn | 26435 | 488 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter vanneervenii | |
| 19838924 | 19838924 | PRJNA725806_P_NODE_75356_length_218_cov_1.895028_g75055_i0 | PRJNA725806 | 75356 | 218 | 1.895028 | 4.13116104 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 112 | 2.84e-30 | NR | MBN9693547.1 | 2026799 | g75055 | i0 | 72.2 | 1.98165137614679 | 72 | 20 | 99.1 | 0 | 217 | 2 | 28 | 99 | MBN9693547.1 DUF2200 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 432 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 24146006 | 24146006 | PRJNA725806_P_NODE_44899_length_257_cov_1.036364_g44602_i0 | PRJNA725806 | 44899 | 257 | 1.036364 | 2.66345548 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 127 | 1.5299999999999998e-32 | NR | MCU0794078.1 | 2006848 | g44602 | i0 | 75.6 | 0.910505836575875 | 78 | 19 | 91.1 | 0 | 236 | 3 | 346 | 423 | MCU0794078.1 Gfo/Idh/MocA family oxidoreductase [Opitutaceae bacterium] | diamond | 234 | 127 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 28757554 | 28757554 | PRJNA725806_P_NODE_8087_length_395_cov_2.368715_g7802_i0 | PRJNA725806 | 8087 | 395 | 2.368715 | 9.35642425 | Opitutus sp. | 1913982 | Bacteria | Bacteria | 44.7 | 0.037 | NR | MCR6655915.1 | 1913982 | g7802 | i0 | 38.3 | 0.455696202531646 | 60 | 35 | 44.1 | 1 | 17 | 190 | 72 | 131 | MCR6655915.1 MFS transporter [Opitutus sp.] | diamond | 180 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. | |
| 28820432 | 28820432 | PRJNA725806_P_NODE_185188_length_154_cov_1.401709_g184886_i0 | PRJNA725806 | 185188 | 154 | 1.401709 | 2.15863186 | Chthoniobacter sp. | 2510640 | Bacteria | Bacteria | 90.1 | 2.03e-19 | NR | MEZ0256187.1 | 2510640 | g184886 | i0 | 76.5 | 0.993506493506494 | 51 | 12 | 99.4 | 0 | 153 | 1 | 213 | 263 | MEZ0256187.1 arylsulfatase [Chthoniobacter sp.] | diamond | 153 | 90.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 29420472 | 29420472 | PRJNA725806_P_NODE_100729_length_197_cov_1.225000_g100427_i0 | PRJNA725806 | 100729 | 197 | 1.225 | 2.41325 | Opitutia bacterium SCGC AG-212-L18 | 1799660 | Bacteria | Bacteria | 42.7 | 0.0203 | NR | OAI50256.1 | 1799660 | g100427 | i0 | 30.9 | 0.83756345177665 | 55 | 35 | 83.8 | 1 | 11 | 175 | 243 | 294 | OAI50256.1 hypothetical protein AYO37_01275 [Opitutia bacterium SCGC AG-212-L18] | diamond | 165 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium SCGC AG-212-L18 | ||||
| 31094864 | 31094864 | PRJNA725806_P_NODE_170575_length_159_cov_7.139344_g170273_i0 | PRJNA725806 | 170575 | 159 | 7.139344 | 11.35155696 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 45.8 | 9.66e-4 | NR | MBQ3241214.1 | 1872421 | g170273 | i0 | 40.4 | 0.886792452830189 | 47 | 24 | 88.7 | 1 | 12 | 152 | 423 | 465 | MBQ3241214.1 hypothetical protein [Akkermansia sp.] | diamond | 141 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. |
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);;