contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA753112" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4557179 | 4557179 | PRJNA753112_P_NODE_11184_length_406_cov_0.936937_g10842_i0 | PRJNA753112 | 11184 | 406 | 0.936937 | 3.80396422 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 103 | 1.62e-25 | NR | KAH9399477.1 | 59818 | g10842 | i0 | 43.8 | 13.5 | 121 | 64 | 86.5 | 2 | 29 | 379 | 12 | 132 | KAH9399477.1 60S ribosomal protein L22 [Tyrophagus putrescentiae] | diamond | 5481 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Acaridae | Tyrophagus | Tyrophagus putrescentiae | |
| 7107972 | 7107972 | PRJNA753112_P_NODE_7806_length_489_cov_1.959135_g7464_i0 | PRJNA753112 | 7806 | 489 | 1.959135 | 9.58017015 | Daphnia sinensis | 1820382 | Arthropoda | Arthropoda | 132 | 9.92e-36 | NR | KAI9549990.1 | 1820382 | g7464 | i0 | 48.2 | 3.34969325153374 | 137 | 70 | 83.4 | 1 | 473 | 66 | 45 | 181 | KAI9549990.1 hypothetical protein GHT06_007518 [Daphnia sinensis] | diamond | 1638 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia sinensis | |
| 24153100 | 24153100 | PRJNA753112_P_NODE_11339_length_403_cov_2.360606_g10997_i0 | PRJNA753112 | 11339 | 403 | 2.360606 | 9.51324218 | Dermatophagoides farinae | 6954 | Arthropoda | Arthropoda | 159 | 1.18e-45 | NR | XP_046909420.1 | 6954 | g10997 | i0 | 60.2 | 23.7617866004963 | 133 | 42 | 99 | 2 | 5 | 403 | 65 | 186 | XP_046909420.1 40S ribosomal protein S2-like [Dermatophagoides farinae] | diamond | 9576 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Pyroglyphidae | Dermatophagoides | Dermatophagoides farinae | |
| 28379307 | 28379307 | PRJNA753112_P_NODE_23146_length_283_cov_1.719048_g22804_i0 | PRJNA753112 | 23146 | 283 | 1.719048 | 4.86490584 | Uloborus diversus | 327109 | Arthropoda | Arthropoda | 119 | 1.51e-30 | NR | XP_054713810.1 | 327109 | g22804 | i0 | 54.7 | 1.99293286219081 | 95 | 42 | 99.6 | 1 | 2 | 283 | 80 | 174 | XP_054713810.1 ribosome biogenesis protein BRX1 homolog [Uloborus diversus] | diamond | 564 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Uloboridae | Uloborus | Uloborus diversus | |
| 28726676 | 28726676 | PRJNA753112_P_NODE_9827_length_433_cov_1.733333_g9485_i0 | PRJNA753112 | 9827 | 433 | 1.733333 | 7.50533189 | Lepeophtheirus salmonis | 72036 | Arthropoda | Arthropoda | 98.6 | 1.35e-22 | NR | ADD38186.1 | 72036 | g9485 | i0 | 35.3 | 0.963048498845266 | 139 | 85 | 96.3 | 1 | 429 | 13 | 3 | 136 | ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] | diamond | 417 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Hexanauplia | Siphonostomatoida | Caligidae | Lepeophtheirus | Lepeophtheirus salmonis | |
| 30567990 | 30567990 | PRJNA753112_P_NODE_12733_length_379_cov_4.751634_g12391_i0 | PRJNA753112 | 12733 | 379 | 4.751634 | 18.00869286 | root | 1 | Root_unresolved | Root_unresolved | 46.2 | 0.00665 | NR | BAM20583.1 | 76194 | g12391 | i0 | 37.9 | 1.58311345646438 | 66 | 35 | 47.5 | 1 | 241 | 62 | 57 | 122 | BAM20583.1 unknown secreted protein, partial [Papilio polytes] | diamond | 600 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Papilionidae | Papilio | Papilio polytes |
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);;