contig_metadata
4 rows where bioproject = "PRJNA758398", tax_phylum = "Nanobdellota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14768942 | 14768942 | PRJNA758398_S_NODE_6072_length_387_cov_1.411243_g5931_i0 | PRJNA758398 | 6072 | 387 | 1.411243 | 5.46151041 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 173 | 2.01e-47 | NR | MCA9485224.1 | 2026764 | g5931 | i0 | 65.3 | 0.961240310077519 | 124 | 43 | 96.1 | 0 | 16 | 387 | 262 | 385 | MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon] | diamond | 372 | 173 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 27210892 | 27210892 | PRJNA758398_S_NODE_35542_length_180_cov_1.557252_g35401_i0 | PRJNA758398 | 35542 | 180 | 1.557252 | 2.8030536 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 62.4 | 1.84e-9 | NR | MBU2639269.1 | 2026764 | g35401 | i0 | 53.4 | 0.966666666666667 | 58 | 26 | 96.7 | 1 | 6 | 179 | 323 | 379 | MBU2639269.1 DNA-directed RNA polymerase subunit A'' [Nanoarchaeota archaeon] | diamond | 174 | 62.4 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29210307 | 29210307 | PRJNA758398_S_NODE_35509_length_180_cov_1.557252_g35368_i0 | PRJNA758398 | 35509 | 180 | 1.557252 | 2.8030536 | root | 1 | Root_unresolved | Root_unresolved | 47 | 4.8e-4 | NR | MCH8067188.1 | 2026764 | g35368 | i0 | 52.8 | 2.93333333333333 | 36 | 17 | 60 | 0 | 123 | 16 | 161 | 196 | MCH8067188.1 VIT1/CCC1 transporter family protein [Nanoarchaeota archaeon] | diamond | 528 | 47 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32834219 | 32834219 | PRJNA758398_S_NODE_55540_length_152_cov_2.475728_g55399_i0 | PRJNA758398 | 55540 | 152 | 2.475728 | 3.76310656 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 50.8 | 1.49e-5 | NR | MCA9485224.1 | 2026764 | g55399 | i0 | 49 | 1.83552631578947 | 49 | 25 | 96.7 | 0 | 6 | 152 | 247 | 295 | MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon] | diamond | 279 | 50.8 | 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);;