contig_metadata
5 rows where analysis = "diamond", bioproject = "PRJNA849646" and tax_phylum = "Chordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22514929 | 22514929 | PRJNA849646_P_NODE_2158_length_373_cov_2.383333_g2040_i0 | PRJNA849646 | 2158 | 373 | 2.383333 | 8.88983209 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 146 | 3.93e-41 | NR | AAH61437.1 | 8364 | g2040 | i0 | 79.2 | 6.82037533512064 | 106 | 22 | 85.3 | 0 | 3 | 320 | 137 | 242 | AAH61437.1 40S ribosomal protein S6 [Xenopus tropicalis] | diamond | 2544 | 147 | 0.993197278911565 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 30244588 | 30244588 | PRJNA849646_P_NODE_1452_length_429_cov_2.452247_g1335_i0 | PRJNA849646 | 1452 | 429 | 2.452247 | 10.52013963 | Mus musculus | 10090 | Chordata | Chordata | 290 | 4.4099999999999997e-94 | NR | NP_001165572.1 | 10090 | g1335 | i0 | 100 | 0.993006993006993 | 142 | 0 | 99.3 | 0 | 427 | 2 | 82 | 223 | NP_001165572.1 ribonuclease inhibitor isoform b [Mus musculus] | diamond | 426 | 290 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 30465930 | 30465930 | PRJNA849646_P_NODE_20393_length_267_cov_4.262887_g20275_i0 | PRJNA849646 | 20393 | 267 | 4.262887 | 11.38190829 | Equus asinus | 9793 | Chordata | Chordata | 44.7 | 0.00877 | NR | XP_044612074.1 | 9793 | g20275 | i0 | 69.2 | 0.921348314606742 | 26 | 8 | 29.2 | 0 | 106 | 183 | 204 | 229 | XP_044612074.1 C-type lectin domain family 7 member A isoform X3 [Equus asinus] | diamond | 246 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Perissodactyla | Equidae | Equus | Equus asinus | |
| 30465938 | 30465938 | PRJNA849646_P_NODE_41213_length_230_cov_2.668790_g41095_i0 | PRJNA849646 | 41213 | 230 | 2.66879 | 6.138217 | Ranitomeya imitator | 111125 | Chordata | Chordata | 44.7 | 0.00671 | NR | CAJ0964628.1 | 111125 | g41095 | i0 | 51.1 | 2.03478260869565 | 45 | 18 | 53.5 | 1 | 80 | 202 | 920 | 964 | CAJ0964628.1 unnamed protein product [Ranitomeya imitator] | diamond | 468 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 32552941 | 32552941 | PRJNA849646_P_NODE_5619_length_310_cov_2.890295_g5501_i0 | PRJNA849646 | 5619 | 310 | 2.890295 | 8.9599145 | Sorex fumeus | 62283 | Chordata | Chordata | 45.1 | 0.0112 | NR | XP_055971594.1 | 62283 | g5501 | i0 | 45.3 | 2.41935483870968 | 53 | 29 | 51.3 | 0 | 235 | 77 | 227 | 279 | XP_055971594.1 syntaxin-2 [Sorex fumeus] | diamond | 750 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Soricidae | Sorex | Sorex fumeus |
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);;