contig_metadata
6 rows where bioproject = "PRJNA1180292" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7971100 | 7971100 | PRJNA1180292_P_NODE_12947_length_242_cov_0.923077_g12815_i0 | PRJNA1180292 | 12947 | 242 | 0.923077 | 2.23384634 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 176 | 1.24e-39 | NTclustered | gi|2874253936|emb|OY970261.1| | 2052149 | g12815 | i0 | 81.69 | 1.79752066115702 | 213 | 37 | 88 | 2 | 31 | 242 | 278491 | 278280 | MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.1.29 genome assembly, chromosome: 1 | blastn | 435 | 176 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 13071535 | 13071535 | PRJNA1180292_P_NODE_8291_length_252_cov_0.871508_g8159_i0 | PRJNA1180292 | 8291 | 252 | 0.871508 | 2.19620016 | Bacteria | 2 | Bacteria | Bacteria | 147 | 6.829999999999999e-40 | NR | MCJ7565615.1 | 2052149 | g8159 | i0 | 85.2 | 8.64285714285714 | 81 | 12 | 96.4 | 0 | 251 | 9 | 331 | 411 | MCJ7565615.1 L-aspartate oxidase [Candidatus Aminicenantes bacterium] | diamond | 2178 | 148 | 0.993243243243243 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 27230191 | 27230191 | PRJNA1180292_P_NODE_10363_length_248_cov_0.891429_g10231_i0 | PRJNA1180292 | 10363 | 248 | 0.891429 | 2.21074392 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 103 | 2.65e-26 | NR | MCJ7525599.1 | 2052149 | g10231 | i0 | 89.3 | 1.35483870967742 | 56 | 6 | 67.7 | 0 | 168 | 1 | 1 | 56 | MCJ7525599.1 hypothetical protein [Candidatus Aminicenantes bacterium] | diamond | 336 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 28745953 | 28745953 | PRJNA1180292_P_NODE_9007_length_251_cov_0.876404_g8875_i0 | PRJNA1180292 | 9007 | 251 | 0.876404 | 2.19977404 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 105 | 4.339999999999999e-24 | NR | MCJ7587295.1 | 2052149 | g8875 | i0 | 61 | 4.88844621513944 | 82 | 32 | 98 | 0 | 247 | 2 | 259 | 340 | MCJ7587295.1 PAS domain S-box protein [Candidatus Aminicenantes bacterium] | diamond | 1227 | 105 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 29756193 | 29756193 | PRJNA1180292_P_NODE_8931_length_251_cov_0.876404_g8799_i0 | PRJNA1180292 | 8931 | 251 | 0.876404 | 2.19977404 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 47 | 0.00126 | NR | MCX6576695.1 | 2052149 | g8799 | i0 | 50 | 0.597609561752988 | 50 | 24 | 58.6 | 1 | 250 | 104 | 316 | 365 | MCX6576695.1 hypothetical protein [Candidatus Aminicenantes bacterium] | diamond | 150 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 31272942 | 31272942 | PRJNA1180292_P_NODE_9475_length_250_cov_0.881356_g9343_i0 | PRJNA1180292 | 9475 | 250 | 0.881356 | 2.20339 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 138 | 1.79e-36 | NR | MBP7707671.1 | 2052149 | g9343 | i0 | 69.9 | 0.996 | 83 | 25 | 99.6 | 0 | 250 | 2 | 412 | 494 | MBP7707671.1 IS3 family transposase [Candidatus Aminicenantes bacterium] | diamond | 249 | 138 | 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);;