contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA704949" and tax_phylum = "Candidatus Aminicenantota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27051685 | 27051685 | PRJNA704949_P_NODE_2108122_length_164_cov_0.904348_g2092783_i0 | PRJNA704949 | 2108122 | 164 | 0.904348 | 1.48313072 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 57 | 1.18e-7 | NR | MBL7083566.1 | 2052149 | g2092783 | i0 | 54.7 | 1.92073170731707 | 53 | 22 | 95.1 | 2 | 6 | 161 | 265 | 316 | MBL7083566.1 alkaline phosphatase D family protein [Candidatus Aminicenantes bacterium] | diamond | 315 | 57 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 29336218 | 29336218 | PRJNA704949_P_NODE_94949_length_802_cov_2.661355_g82654_i0 | PRJNA704949 | 94949 | 802 | 2.661355 | 21.3440671 | Bacteria | 2 | Bacteria | Bacteria | 69.7 | 2.6e-9 | NR | NIM16446.1 | 2052149 | g82654 | i0 | 27.8 | 2.98503740648379 | 266 | 112 | 99.5 | 8 | 2 | 799 | 694 | 879 | NIM16446.1 AAA family ATPase [Candidatus Aminicenantes bacterium] | diamond | 2394 | 69.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 30683663 | 30683663 | PRJNA704949_P_NODE_99013_length_788_cov_1.829499_g86614_i0 | PRJNA704949 | 99013 | 788 | 1.829499 | 14.41645212 | SCandidatus Aminicenantes bacterium Aminicenantia_JdfR_composite | 2950077 | Bacteria | Bacteria | 200 | 2.2699999999999994e-54 | NR | MCP2520885.1 | 2950077 | g86614 | i0 | 60.3 | 4.17639593908629 | 156 | 62 | 59.4 | 0 | 13 | 480 | 1197 | 1352 | MCP2520885.1 ATP-binding protein [SCandidatus Aminicenantes bacterium Aminicenantia_JdfR_composite] | diamond | 3291 | 200 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | SCandidatus Aminicenantes bacterium Aminicenantia_JdfR_composite | ||||||
| 30694344 | 30694344 | PRJNA704949_P_NODE_550513_length_367_cov_1.081761_g535207_i0 | PRJNA704949 | 550513 | 367 | 1.081761 | 3.97006287 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 107 | 1.56e-25 | NR | MCX6560890.1 | 2052149 | g535207 | i0 | 48 | 4.02179836512262 | 123 | 61 | 98.1 | 1 | 365 | 6 | 93 | 215 | MCX6560890.1 hydroxyethylthiazole kinase [Candidatus Aminicenantes bacterium] | diamond | 1476 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 30809923 | 30809923 | PRJNA704949_P_NODE_2082314_length_164_cov_2.260870_g2066975_i0 | PRJNA704949 | 2082314 | 164 | 2.26087 | 3.7078268 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 70.1 | 1.24e-13 | NR | HOW44168.1 | 2052149 | g2066975 | i0 | 61.1 | 3.95121951219512 | 54 | 21 | 98.8 | 0 | 2 | 163 | 17 | 70 | HOW44168.1 Rid family detoxifying hydrolase [Candidatus Aminicenantes bacterium] | diamond | 648 | 70.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 32675274 | 32675274 | PRJNA704949_P_NODE_336940_length_466_cov_1.148681_g322003_i0 | PRJNA704949 | 336940 | 466 | 1.148681 | 5.35285346 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 144 | 1.36e-36 | NR | MCK4645000.1 | 2052149 | g322003 | i0 | 45 | 0.972103004291845 | 151 | 80 | 95.3 | 1 | 21 | 464 | 866 | 1016 | MCK4645000.1 DUF5107 domain-containing protein [Candidatus Aminicenantes bacterium] | diamond | 453 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes 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);;