contig_metadata
8 rows where bioproject = "PRJNA315399", tax_phylum = "Candidatus Woesearchaeota" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27200687 | 27200687 | PRJNA315399_S_NODE_86542_length_185_cov_5.513514_g86341_i0 | PRJNA315399 | 86542 | 185 | 5.513514 | 10.2000009 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 47.4 | 1.63e-4 | NR | MBT4697185.1 | 2026803 | g86341 | i0 | 41.5 | 0.859459459459459 | 53 | 31 | 85.9 | 0 | 15 | 173 | 67 | 119 | MBT4697185.1 terminase [Candidatus Woesearchaeota archaeon] | diamond | 159 | 47.4 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 28085074 | 28085074 | PRJNA315399_S_NODE_145_length_1419_cov_18.175109_g138_i0 | PRJNA315399 | 145 | 1419 | 18.175109 | 257.90479671 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 85.5 | 5.59e-15 | NR | MFA6089737.1 | 2026803 | g138 | i0 | 62.7 | 0.141649048625793 | 67 | 25 | 14.2 | 0 | 538 | 338 | 2 | 68 | MFA6089737.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 201 | 85.5 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 28653529 | 28653529 | PRJNA315399_S_NODE_108707_length_174_cov_10.664234_g108506_i0 | PRJNA315399 | 108707 | 174 | 10.664234 | 18.55576716 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 41.6 | 0.00468 | NR | MDA3856313.1 | 2026803 | g108506 | i0 | 55.8 | 0.741379310344828 | 43 | 17 | 74.1 | 1 | 42 | 170 | 9 | 49 | MDA3856313.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 129 | 41.6 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 29442576 | 29442576 | PRJNA315399_P_NODE_63590_length_223_cov_5.575269_g63142_i0 | PRJNA315399 | 63590 | 223 | 5.575269 | 12.43284987 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 76.3 | 2.13e-15 | NR | MBM3202278.1 | 2026803 | g63142 | i0 | 62.1 | 0.780269058295964 | 58 | 22 | 78 | 0 | 17 | 190 | 13 | 70 | MBM3202278.1 DUF4815 domain-containing protein [Candidatus Woesearchaeota archaeon] | diamond | 174 | 76.3 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 30296072 | 30296072 | PRJNA315399_S_NODE_17872_length_290_cov_4.909091_g17671_i0 | PRJNA315399 | 17872 | 290 | 4.909091 | 14.2363639 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 42.7 | 0.021 | NR | MAG49958.1 | 2026803 | g17671 | i0 | 39.3 | 0.631034482758621 | 61 | 29 | 63.1 | 2 | 8 | 190 | 63 | 115 | MAG49958.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 183 | 42.7 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 31528280 | 31528280 | PRJNA315399_P_NODE_69996_length_218_cov_3.314917_g69548_i0 | PRJNA315399 | 69996 | 218 | 3.314917 | 7.22651906 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 73.9 | 2.73e-13 | NR | MAG48594.1 | 2026803 | g69548 | i0 | 60.3 | 0.86697247706422 | 63 | 22 | 86.7 | 2 | 9 | 197 | 599 | 658 | MAG48594.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 189 | 73.9 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 32445803 | 32445803 | PRJNA315399_P_NODE_276559_length_180_cov_3.118881_g276111_i0 | PRJNA315399 | 276559 | 180 | 3.118881 | 5.6139858 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 82 | 6.67e-19 | NR | MBM3204041.1 | 2026803 | g276111 | i0 | 83.7 | 0.816666666666667 | 49 | 8 | 81.7 | 0 | 148 | 2 | 1 | 49 | MBM3204041.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 147 | 82 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 32540803 | 32540803 | PRJNA315399_P_NODE_99_length_1068_cov_9.904947_g66_i0 | PRJNA315399 | 99 | 1068 | 9.904947 | 105.78483396 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 84.7 | 4.32e-15 | NR | MFA6089737.1 | 2026803 | g66 | i0 | 66.1 | 0.174157303370787 | 62 | 21 | 17.4 | 0 | 248 | 63 | 2 | 63 | MFA6089737.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 186 | 84.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);;