contig_metadata
8 rows where bioproject = "PRJNA488043", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Absconditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19575562 | 19575562 | PRJNA488043_P_NODE_12576_length_270_cov_2.273859_g10335_i0 | PRJNA488043 | 12576 | 270 | 2.273859 | 6.1394193 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 89 | 2.77e-18 | NR | HNG96670.1 | 2927939 | g10335 | i0 | 53.4 | 0.977777777777778 | 88 | 38 | 97.8 | 2 | 268 | 5 | 325 | 409 | HNG96670.1 AAA family ATPase [Candidatus Absconditabacterales bacterium] | diamond | 264 | 89 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 27076328 | 27076328 | PRJNA488043_P_NODE_2642_length_926_cov_2.329989_g1320_i0 | PRJNA488043 | 2642 | 926 | 2.329989 | 21.57569814 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 173 | 1.02e-45 | NR | HNG96670.1 | 2927939 | g1320 | i0 | 48.8 | 0.677105831533477 | 209 | 101 | 65.8 | 1 | 637 | 29 | 38 | 246 | HNG96670.1 AAA family ATPase [Candidatus Absconditabacterales bacterium] | diamond | 627 | 173 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 27297590 | 27297590 | PRJNA488043_P_NODE_6643_length_487_cov_2.240175_g4561_i0 | PRJNA488043 | 6643 | 487 | 2.240175 | 10.90965225 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 52 | 1.41e-4 | NR | HNG96770.1 | 2927939 | g4561 | i0 | 57.8 | 0.277207392197125 | 45 | 18 | 27.1 | 1 | 104 | 235 | 181 | 225 | HNG96770.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 135 | 52 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 27455734 | 27455734 | PRJNA488043_P_NODE_2743_length_906_cov_2.309008_g1320_i1 | PRJNA488043 | 2743 | 906 | 2.309008 | 20.91961248 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 173 | 8.26e-46 | NR | HNG96670.1 | 2927939 | g1320 | i1 | 48.8 | 0.69205298013245 | 209 | 101 | 67.2 | 1 | 270 | 878 | 38 | 246 | HNG96670.1 AAA family ATPase [Candidatus Absconditabacterales bacterium] | diamond | 627 | 173 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 27865864 | 27865864 | PRJNA488043_P_NODE_1205_length_1542_cov_2.393258_g461_i0 | PRJNA488043 | 1205 | 1542 | 2.393258 | 36.90403836 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 273 | 5.67e-84 | NR | HNG96902.1 | 2927939 | g461 | i0 | 52.8 | 0.494163424124514 | 254 | 120 | 49.4 | 0 | 1472 | 711 | 60 | 313 | HNG96902.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 762 | 273 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 29823375 | 29823375 | PRJNA488043_P_NODE_15231_length_224_cov_2.687179_g12989_i0 | PRJNA488043 | 15231 | 224 | 2.687179 | 6.01928096 | Candidatus Absconditabacteria bacterium | 3018262 | Bacteria | Bacteria | 42.7 | 0.00628 | NR | MEF2175250.1 | 3018262 | g12989 | i0 | 57.6 | 0.441964285714286 | 33 | 14 | 44.2 | 0 | 185 | 87 | 16 | 48 | MEF2175250.1 hotdog fold domain-containing protein [Candidatus Absconditabacteria bacterium] | diamond | 99 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacteria bacterium | ||||||
| 30139130 | 30139130 | PRJNA488043_P_NODE_12612_length_269_cov_2.591667_g10371_i0 | PRJNA488043 | 12612 | 269 | 2.591667 | 6.97158423 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 56.6 | 6.58e-7 | NR | HNG96670.1 | 2927939 | g10371 | i0 | 35 | 0.669144981412639 | 60 | 39 | 66.9 | 0 | 267 | 88 | 413 | 472 | HNG96670.1 AAA family ATPase [Candidatus Absconditabacterales bacterium] | diamond | 180 | 56.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 32447778 | 32447778 | PRJNA488043_P_NODE_9299_length_363_cov_2.446108_g7069_i0 | PRJNA488043 | 9299 | 363 | 2.446108 | 8.87937204 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 52 | 4.91e-5 | NR | HNG96770.1 | 2927939 | g7069 | i0 | 57.8 | 0.371900826446281 | 45 | 18 | 36.4 | 1 | 260 | 129 | 181 | 225 | HNG96770.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 135 | 52 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales 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);;