contig_metadata
9 rows where bioproject = "PRJEB50332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119446 | 119446 | PRJEB50332_P_NODE_16541_length_204_cov_0.909091_g16459_i0 | PRJEB50332 | 16541 | 204 | 0.909091 | 1.85454564 | Verrucomicrobium spinosum | 2736 | Bacteria | Bacteria | 217 | 5.959999999999999e-52 | NTclustered | gi|12583973|gb|AF245377.1| | 240016 | g16459 | i0 | 88.525 | 9.12745098039216 | 183 | 16 | 88 | 5 | 4 | 183 | 473 | 293 | Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence | blastn | 1862 | 217 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium spinosum | |
| 7368787 | 7368787 | PRJEB50332_P_NODE_14886_length_207_cov_0.890411_g14804_i0 | PRJEB50332 | 14886 | 207 | 0.890411 | 1.84315077 | Akkermansia | 239934 | Bacteria | Bacteria | 383 | 5.65e-102 | NTclustered | gi|2240218473|gb|CP097283.1| | 239935 | g14804 | i0 | 100 | 99.7149758454106 | 207 | 0 | 100 | 0 | 1 | 207 | 874343 | 874137 | Akkermansia muciniphila strain NB2A-8-WC chromosome | blastn | 20641 | 383 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia muciniphila | |
| 20520258 | 20520258 | PRJEB50332_P_NODE_10777_length_220_cov_1.547170_g10695_i0 | PRJEB50332 | 10777 | 220 | 1.54717 | 3.403774 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 366 | 6.13e-97 | NTclustered | gi|2874254019|emb|OY970344.1| | 412056 | g10695 | i0 | 96.804 | 34.7909090909091 | 219 | 7 | 99 | 0 | 1 | 219 | 736117 | 735899 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 | blastn | 7654 | 366 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 29086378 | 29086378 | PRJEB50332_P_NODE_9548_length_227_cov_1.307229_g9466_i0 | PRJEB50332 | 9548 | 227 | 1.307229 | 2.96740983 | Terrimicrobium sp. | 1965319 | Bacteria | Bacteria | 155 | 1.6e-43 | NR | HEY6675541.1 | 1965319 | g9466 | i0 | 92 | 0.991189427312775 | 75 | 6 | 99.1 | 0 | 1 | 225 | 250 | 324 | HEY6675541.1 hypothetical protein [Terrimicrobium sp.] | diamond | 225 | 155 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobium | Terrimicrobium sp. | |
| 29244142 | 29244142 | PRJEB50332_P_NODE_15869_length_205_cov_1.354167_g15787_i0 | PRJEB50332 | 15869 | 205 | 1.354167 | 2.77604235 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 80.1 | 1.48e-15 | NR | HYG84357.1 | 2499141 | g15787 | i0 | 64.1 | 0.936585365853659 | 64 | 21 | 93.7 | 1 | 3 | 194 | 199 | 260 | HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 192 | 80.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29275513 | 29275513 | PRJEB50332_P_NODE_1169_length_503_cov_2.416290_g1088_i0 | PRJEB50332 | 1169 | 503 | 2.41629 | 12.1539387 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 58.5 | 6.62e-7 | NR | HEX3818319.1 | 2201154 | g1088 | i0 | 37.3 | 0.656063618290258 | 110 | 59 | 63.8 | 5 | 497 | 177 | 120 | 222 | HEX3818319.1 CAP domain-containing protein [Chthoniobacterales bacterium] | diamond | 330 | 58.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 29521513 | 29521513 | PRJEB50332_P_NODE_8610_length_232_cov_1.976608_g8528_i0 | PRJEB50332 | 8610 | 232 | 1.976608 | 4.58573056 | Prosthecobacter | 48463 | Bacteria | Bacteria | 135 | 7.98e-36 | NR | MDZ4289601.1 | 1965333 | g8528 | i0 | 84 | 4.84913793103448 | 75 | 12 | 97 | 0 | 227 | 3 | 40 | 114 | MDZ4289601.1 cytochrome c peroxidase [Prosthecobacter sp.] | diamond | 1125 | 136 | 0.992647058823529 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 30918378 | 30918378 | PRJEB50332_P_NODE_11314_length_217_cov_1.666667_g11232_i0 | PRJEB50332 | 11314 | 217 | 1.666667 | 3.61666739 | Horticoccus sp. 23ND18S-11 | 3391832 | Bacteria | Bacteria | 143 | 1.64e-38 | NR | WP_414662761.1 | 3391832 | g11232 | i0 | 86.1 | 2.98617511520737 | 72 | 10 | 99.5 | 0 | 217 | 2 | 233 | 304 | WP_414662761.1 NAD(P)/FAD-dependent oxidoreductase [Horticoccus sp. 23ND18S-11] | diamond | 648 | 143 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Horticoccus | Horticoccus sp. 23ND18S-11 | |
| 30981600 | 30981600 | PRJEB50332_P_NODE_18414_length_192_cov_2.465649_g18332_i0 | PRJEB50332 | 18414 | 192 | 2.465649 | 4.73404608 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 64.7 | 7.99e-12 | NR | HJT45844.1 | 2201154 | g18332 | i0 | 52.5 | 6.703125 | 59 | 27 | 92.2 | 1 | 177 | 1 | 22 | 79 | HJT45844.1 ATP-grasp domain-containing protein [Chthoniobacterales bacterium] | diamond | 1287 | 64.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales 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);;