contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA800090" and tax_kingdom = "Nanobdellati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26800825 | 26800825 | PRJNA800090_P_NODE_122701_length_288_cov_1.333333_g120516_i0 | PRJNA800090 | 122701 | 288 | 1.333333 | 3.83999904 | Candidatus Altiarchaeota archaeon | 2599821 | Archaea | Archaea | 43.1 | 0.0497 | NR | MFH0860014.1 | 2599821 | g120516 | i0 | 43.9 | 0.427083333333333 | 41 | 23 | 42.7 | 0 | 126 | 4 | 1837 | 1877 | MFH0860014.1 lamin tail domain-containing protein [Candidatus Altiarchaeota archaeon] | diamond | 123 | 43.1 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeota archaeon | ||||||
| 28705332 | 28705332 | PRJNA800090_P_NODE_183807_length_231_cov_1.777778_g181622_i0 | PRJNA800090 | 183807 | 231 | 1.777778 | 4.10666718 | Archaea | 2157 | Archaea | Archaea | 42.4 | 0.0331 | NR | MFP3257804.1 | 1577684 | g181622 | i0 | 40 | 1.75324675324675 | 45 | 27 | 58.4 | 0 | 63 | 197 | 48 | 92 | MFP3257804.1 hypothetical protein [Candidatus Nanopusillus acidilobi] | diamond | 405 | 42.4 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Nanoarchaeales | Nanopusillaceae | Candidatus Nanopusillus | Candidatus Nanopusillus acidilobi | ||
| 29485415 | 29485415 | PRJNA800090_P_NODE_55770_length_472_cov_1.925558_g53586_i0 | PRJNA800090 | 55770 | 472 | 1.925558 | 9.08863376 | Candidatus Undinarchaeales archaeon | 3042728 | Archaea | Archaea | 77.8 | 2.61e-13 | NR | MDP7078847.1 | 3042728 | g53586 | i0 | 32.4 | 2.8093220338983 | 173 | 75 | 99.2 | 7 | 2 | 469 | 549 | 696 | MDP7078847.1 hypothetical protein [Candidatus Undinarchaeales archaeon] | diamond | 1326 | 77.8 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Undinarchaeales | Candidatus Undinarchaeales archaeon | ||||
| 32709229 | 32709229 | PRJNA800090_P_NODE_101640_length_323_cov_1.149606_g99455_i0 | PRJNA800090 | 101640 | 323 | 1.149606 | 3.71322738 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 79.7 | 1.01e-14 | NR | MBW2991731.1 | 2026803 | g99455 | i0 | 45.6 | 1.05882352941176 | 114 | 47 | 95.7 | 4 | 7 | 315 | 507 | 616 | MBW2991731.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 342 | 79.7 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon |
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);;