contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA658591" and tax_phylum = "Arthropoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15928415 | 15928415 | PRJNA658591_S_NODE_7313_length_180_cov_3.572519_g7250_i0 | PRJNA658591 | 7313 | 180 | 3.5725189999999998 | 6.4305342 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 86.7 | 5.34e-18 | NR | XP_054279391.1 | 74068 | g7250 | i0 | 67.2 | 33.9166666666667 | 58 | 19 | 96.7 | 0 | 5 | 178 | 413 | 470 | XP_054279391.1 unconventional myosin-Va isoform X2 [Macrosteles quadrilineatus] | diamond | 6105 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Cicadellidae | Macrosteles | Macrosteles quadrilineatus | |
| 28344626 | 28344626 | PRJNA658591_S_NODE_7866_length_176_cov_1.228346_g7803_i0 | PRJNA658591 | 7866 | 176 | 1.228346 | 2.16188896 | Cyamophila willieti | 2604842 | Arthropoda | Arthropoda | 66.2 | 7.71e-11 | NR | KAL1459258.1 | 2604842 | g7803 | i0 | 53.8 | 0.886363636363636 | 52 | 24 | 88.6 | 0 | 176 | 21 | 39 | 90 | KAL1459258.1 hypothetical protein WDU94_011261 [Cyamophila willieti] | diamond | 156 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Psyllidae | Cyamophila | Cyamophila willieti | |
| 28881338 | 28881338 | PRJNA658591_S_NODE_5668_length_198_cov_1.744966_g5605_i0 | PRJNA658591 | 5668 | 198 | 1.744966 | 3.45503268 | Acanthoscelides obtectus | 200917 | Arthropoda | Arthropoda | 65.9 | 1.37e-10 | NR | CAH1965250.1 | 200917 | g5605 | i0 | 53.8 | 1.42424242424242 | 52 | 23 | 77.3 | 1 | 45 | 197 | 66 | 117 | CAH1965250.1 unnamed protein product [Acanthoscelides obtectus] | diamond | 282 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Chrysomelidae | Acanthoscelides | Acanthoscelides obtectus | |
| 29650985 | 29650985 | PRJNA658591_S_NODE_6330_length_190_cov_1.106383_g6267_i0 | PRJNA658591 | 6330 | 190 | 1.106383 | 2.1021277 | root | 1 | Root_unresolved | Root_unresolved | 106 | 5.53e-25 | NR | XP_054715256.1 | 327109 | g6267 | i0 | 69.4 | 13.7052631578947 | 62 | 19 | 97.9 | 0 | 188 | 3 | 423 | 484 | XP_054715256.1 ribonucleoside-diphosphate reductase large subunit-like [Uloborus diversus] | diamond | 2604 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Uloboridae | Uloborus | Uloborus diversus | |
| 29745857 | 29745857 | PRJNA658591_S_NODE_9630_length_165_cov_1.258621_g9567_i0 | PRJNA658591 | 9630 | 165 | 1.258621 | 2.07672465 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 80.1 | 6.23e-16 | NR | XP_023212881.1 | 218467 | g9567 | i0 | 73.6 | 4.85454545454545 | 53 | 14 | 96.4 | 0 | 7 | 165 | 209 | 261 | XP_023212881.1 inosine-5'-monophosphate dehydrogenase 2-like [Centruroides sculpturatus] | diamond | 801 | 80.5 | 0.995031055900621 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Scorpiones | Buthidae | Centruroides | Centruroides sculpturatus | |
| 30251738 | 30251738 | PRJNA658591_S_NODE_1132_length_382_cov_4.702703_g1069_i0 | PRJNA658591 | 1132 | 382 | 4.702703 | 17.96432546 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 155 | 8.12e-46 | NR | KAH8020767.1 | 6941 | g1069 | i0 | 60 | 20.4502617801047 | 115 | 46 | 90.3 | 0 | 345 | 1 | 1 | 115 | KAH8020767.1 hypothetical protein HPB51_003424 [Rhipicephalus microplus] | diamond | 7812 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Rhipicephalus | Rhipicephalus microplus | |
| 30788692 | 30788692 | PRJNA658591_S_NODE_2994_length_251_cov_6.366337_g2931_i0 | PRJNA658591 | 2994 | 251 | 6.366337 | 15.97950587 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.5 | 1.08e-9 | NR | XP_014238573.1 | 7493 | g2931 | i0 | 62.8 | 2.2589641434263 | 43 | 16 | 51.4 | 0 | 247 | 119 | 217 | 259 | XP_014238573.1 40S ribosomal protein S4 [Trichogramma pretiosum] | diamond | 567 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Trichogrammatidae | Trichogramma | Trichogramma pretiosum | |
| 31515971 | 31515971 | PRJNA658591_S_NODE_5256_length_204_cov_1.335484_g5193_i0 | PRJNA658591 | 5256 | 204 | 1.335484 | 2.72438736 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 50.1 | 5.67e-5 | NR | CAB4065159.1 | 72036 | g5193 | i0 | 48 | 4.83823529411765 | 50 | 26 | 73.5 | 0 | 8 | 157 | 396 | 445 | CAB4065159.1 unnamed protein product [Lepeophtheirus salmonis] | diamond | 987 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Hexanauplia | Siphonostomatoida | Caligidae | Lepeophtheirus | Lepeophtheirus salmonis |
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);;