contig_metadata
5 rows where bioproject = "PRJNA572587" and tax_phylum = "Synergistota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18410774 | 18410774 | PRJNA572587_P_NODE_24395_length_227_cov_60.174157_g24067_i0 | PRJNA572587 | 24395 | 227 | 60.174157 | 136.59533639 | Cloacibacillus porcorum | 1197717 | Bacteria | Bacteria | 287 | 5.09e-73 | NTclustered | gi|1050315908|gb|CP016757.1| | 1197717 | g24067 | i0 | 94.149 | 70.7400881057269 | 188 | 11 | 83 | 0 | 1 | 188 | 635890 | 635703 | Cloacibacillus porcorum strain CL-84 chromosome, complete genome | blastn | 16058 | 287 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Cloacibacillus | Cloacibacillus porcorum | ||
| 26636268 | 26636268 | PRJNA572587_P_NODE_12701_length_327_cov_1.420863_g12373_i0 | PRJNA572587 | 12701 | 327 | 1.420863 | 4.64622201 | Acetomicrobium sp. S15 = DSM 1 | 1872099 | Bacteria | Bacteria | 123 | 5.700000000000001e-30 | NR | WP_198469754.1 | 2529858 | g12373 | i0 | 58.5 | 1.95412844036697 | 106 | 44 | 97.2 | 0 | 8 | 325 | 622 | 727 | WP_198469754.1 phosphoadenosine phosphosulfate reductase family protein [Acetomicrobium sp. S15 = DSM 107314] | diamond | 639 | 123 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Acetomicrobiaceae | Acetomicrobium | Acetomicrobium sp. S15 = DSM 107314 | ||
| 26713032 | 26713032 | PRJNA572587_P_NODE_26161_length_219_cov_2.035294_g25833_i0 | PRJNA572587 | 26161 | 219 | 2.035294 | 4.45729386 | Bacteria | 2 | Bacteria | Bacteria | 92.4 | 1.66e-20 | NR | WP_005659958.1 | 47055 | g25833 | i0 | 69.2 | 4.45205479452055 | 65 | 20 | 89 | 0 | 197 | 3 | 51 | 115 | WP_005659958.1 hydroxymethylglutaryl-CoA lyase [Dethiosulfovibrio peptidovorans] | diamond | 975 | 92.8 | 0.995689655172414 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Dethiosulfovibrio | Dethiosulfovibrio peptidovorans | ||
| 29731832 | 29731832 | PRJNA572587_P_NODE_32450_length_194_cov_28.731034_g32122_i0 | PRJNA572587 | 32450 | 194 | 28.731034 | 55.73820596 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 84 | 5.81e-17 | NR | MBP8633506.1 | 2053624 | g32122 | i0 | 95.6 | 2.78350515463918 | 45 | 2 | 69.6 | 0 | 42 | 176 | 106 | 150 | MBP8633506.1 TRAP transporter permease [Synergistaceae bacterium] | diamond | 540 | 84 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 30598483 | 30598483 | PRJNA572587_P_NODE_20353_length_251_cov_2.118812_g20025_i0 | PRJNA572587 | 20353 | 251 | 2.118812 | 5.31821812 | FCB group | 1783270 | Bacteria | Bacteria | 106 | 2.7699999999999993e-28 | NR | WP_008520715.1 | 428711 | g20025 | i0 | 86.5 | 5.25896414342629 | 52 | 7 | 62.2 | 0 | 188 | 33 | 1 | 52 | WP_008520715.1 MULTISPECIES: rubredoxin [Jonquetella] | diamond | 1320 | 107 | 0.990654205607477 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Jonquetella |
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);;