contig_metadata
10 rows where bioproject = "PRJNA1011844" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27058718 | 27058718 | PRJNA1011844_P_NODE_66082_length_479_cov_8.472906_g57651_i0 | PRJNA1011844 | 66082 | 479 | 8.472906 | 40.58521974 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 50.8 | 6.27e-4 | NR | MBN2199281.1 | 2052149 | g57651 | i0 | 30.7 | 2.84968684759916 | 101 | 58 | 62.6 | 3 | 425 | 126 | 204 | 293 | MBN2199281.1 serine/threonine-protein kinase [Candidatus Aminicenantes bacterium] | diamond | 1365 | 51.2 | 0.9921875 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 27153076 | 27153076 | PRJNA1011844_P_NODE_73182_length_435_cov_2.337017_g64696_i0 | PRJNA1011844 | 73182 | 435 | 2.337017 | 10.16602395 | Bacteria | 2 | Bacteria | Bacteria | 66.6 | 1.3e-9 | NR | OQX52116.1 | 1968529 | g64696 | i0 | 33.6 | 3.50344827586207 | 134 | 76 | 91 | 6 | 38 | 433 | 395 | 517 | OQX52116.1 MAG: hypothetical protein B5M54_09730 [Candidatus Aminicenantes bacterium 4484_214] | diamond | 1524 | 66.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium 4484_214 | ||||||
| 27887608 | 27887608 | PRJNA1011844_P_NODE_8045_length_1969_cov_33.741561_g5639_i0 | PRJNA1011844 | 8045 | 1969 | 33.741561 | 664.37133609 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 81.3 | 4.23e-12 | NR | MCK4431699.1 | 2052149 | g5639 | i0 | 47.7 | 0.393092940578974 | 86 | 40 | 12.6 | 2 | 1959 | 1711 | 301 | 384 | MCK4431699.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Aminicenantes bacterium] | diamond | 774 | 81.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 28448482 | 28448482 | PRJNA1011844_P_NODE_140786_length_256_cov_3.562842_g132208_i0 | PRJNA1011844 | 140786 | 256 | 3.562842 | 9.12087552 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 56.6 | 2.18e-7 | NR | MCK4647111.1 | 2052149 | g132208 | i0 | 43.8 | 3.0703125 | 89 | 43 | 97.3 | 3 | 251 | 3 | 71 | 158 | MCK4647111.1 ankyrin repeat domain-containing protein [Candidatus Aminicenantes bacterium] | diamond | 786 | 57 | 0.992982456140351 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 29245345 | 29245345 | PRJNA1011844_P_NODE_161029_length_241_cov_1.755952_g152449_i0 | PRJNA1011844 | 161029 | 241 | 1.755952 | 4.23184432 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 42.4 | 0.0491 | NR | UCH95104.1 | 2052149 | g152449 | i0 | 58.3 | 0.448132780082988 | 36 | 15 | 44.8 | 0 | 114 | 7 | 24 | 59 | UCH95104.1 MAG: ArgE/DapE family deacylase [Candidatus Aminicenantes bacterium] | diamond | 108 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 29877024 | 29877024 | PRJNA1011844_P_NODE_9191_length_1858_cov_37.473950_g5639_i1 | PRJNA1011844 | 9191 | 1858 | 37.47395 | 696.265991 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 81.3 | 3.81e-12 | NR | MCK4431699.1 | 2052149 | g5639 | i1 | 47.7 | 0.416576964477933 | 86 | 40 | 13.4 | 2 | 11 | 259 | 301 | 384 | MCK4431699.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Aminicenantes bacterium] | diamond | 774 | 81.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 30129203 | 30129203 | PRJNA1011844_P_NODE_150732_length_248_cov_0.880000_g142153_i0 | PRJNA1011844 | 150732 | 248 | 0.88 | 2.1824 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 54.3 | 3.4e-6 | NR | MBP1767247.1 | 2052149 | g142153 | i0 | 40.7 | 0.713709677419355 | 59 | 32 | 67.7 | 1 | 247 | 80 | 821 | 879 | MBP1767247.1 polyketide synthase [Candidatus Aminicenantes bacterium] | diamond | 177 | 54.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 30160993 | 30160993 | PRJNA1011844_P_NODE_85672_length_375_cov_4.685430_g77126_i0 | PRJNA1011844 | 85672 | 375 | 4.68543 | 17.5703625 | Candidatus Aminicenantes bacterium RBG_19FT_COMBO_65_3 | 2052149 | Bacteria | Bacteria | 55.8 | 3.11e-6 | NR | OGD29178.1 | 1797277 | g77126 | i0 | 35 | 1.96 | 123 | 66 | 97.6 | 4 | 371 | 6 | 11 | 120 | OGD29178.1 MAG: sugar kinase [Candidatus Aminicenantes bacterium RBG_19FT_COMBO_65_30] | diamond | 735 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium RBG_19FT_COMBO_65_30 | ||||||
| 30729850 | 30729850 | PRJNA1011844_P_NODE_32874_length_894_cov_16.559074_g25810_i0 | PRJNA1011844 | 32874 | 894 | 16.559074 | 148.03812156 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 80.1 | 8.73e-13 | NR | MCK4431699.1 | 2052149 | g25810 | i0 | 46.5 | 1.36241610738255 | 86 | 41 | 27.9 | 2 | 884 | 636 | 301 | 384 | MCK4431699.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Aminicenantes bacterium] | diamond | 1218 | 80.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 31014226 | 31014226 | PRJNA1011844_P_NODE_32875_length_894_cov_16.387333_g25811_i0 | PRJNA1011844 | 32875 | 894 | 16.387333 | 146.50275702 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 80.1 | 8.73e-13 | NR | MCK4431699.1 | 2052149 | g25811 | i0 | 46.5 | 1.36241610738255 | 86 | 41 | 27.9 | 2 | 884 | 636 | 301 | 384 | MCK4431699.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Aminicenantes bacterium] | diamond | 1218 | 80.1 | 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);;