contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA494251" and tax_phylum = "Nanobdellota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26918739 | 26918739 | PRJNA494251_P_NODE_21902_length_306_cov_1.832618_g21588_i0 | PRJNA494251 | 21902 | 306 | 1.832618 | 5.60781108 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 56.2 | 8.08e-7 | NR | MEK6959885.1 | 2026764 | g21588 | i0 | 37.7 | 1.46078431372549 | 77 | 48 | 75.5 | 0 | 233 | 3 | 12 | 88 | MEK6959885.1 tRNA-dependent cyclodipeptide synthase [Nanoarchaeota archaeon] | diamond | 447 | 56.2 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 27139764 | 27139764 | PRJNA494251_P_NODE_31982_length_265_cov_1.604167_g31668_i0 | PRJNA494251 | 31982 | 265 | 1.604167 | 4.25104255 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 122 | 3.49e-30 | NR | MCA9485224.1 | 2026764 | g31668 | i0 | 63.2 | 0.984905660377358 | 87 | 31 | 97.4 | 1 | 2 | 259 | 196 | 282 | MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon] | diamond | 261 | 122 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 27866478 | 27866478 | PRJNA494251_P_NODE_30445_length_270_cov_1.670051_g30131_i0 | PRJNA494251 | 30445 | 270 | 1.670051 | 4.5091377 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 133 | 6.09e-34 | NR | MCA9485224.1 | 2026764 | g30131 | i0 | 71.1 | 1 | 90 | 26 | 100 | 0 | 270 | 1 | 485 | 574 | MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon] | diamond | 270 | 133 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 28940330 | 28940330 | PRJNA494251_P_NODE_39288_length_249_cov_0.875000_g38974_i0 | PRJNA494251 | 39288 | 249 | 0.875 | 2.17875 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 59.3 | 5.58e-8 | NR | MBU0461306.1 | 2026764 | g38974 | i0 | 34.9 | 1 | 83 | 43 | 95.2 | 2 | 241 | 5 | 252 | 327 | MBU0461306.1 class I tRNA ligase family protein [Nanoarchaeota archaeon] | diamond | 249 | 59.3 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29382167 | 29382167 | PRJNA494251_P_NODE_12489_length_385_cov_1.807692_g12182_i0 | PRJNA494251 | 12489 | 385 | 1.807692 | 6.9596142 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 67.4 | 7.83e-11 | NR | MEK6909328.1 | 2026764 | g12182 | i0 | 30.4 | 4.70649350649351 | 125 | 72 | 97.4 | 2 | 2 | 376 | 66 | 175 | MEK6909328.1 alpha/beta hydrolase [Nanoarchaeota archaeon] | diamond | 1812 | 67.4 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 31024886 | 31024886 | PRJNA494251_P_NODE_34415_length_258_cov_1.151351_g34101_i0 | PRJNA494251 | 34415 | 258 | 1.151351 | 2.97048558 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 45.4 | 0.00512 | NR | MBU0460971.1 | 2026764 | g34101 | i0 | 47.9 | 1.44186046511628 | 48 | 21 | 54.7 | 3 | 258 | 118 | 512 | 556 | MBU0460971.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 372 | 45.4 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota 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);;