contig_metadata
11 rows where bioproject = "PRJNA752572", tax_kingdom = "Metazoa" and tax_phylum = "Echinodermata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 728625 | 728625 | PRJNA752572_P_NODE_65701_length_336_cov_2.269103_g65194_i0 | PRJNA752572 | 65701 | 336 | 2.269103 | 7.62418608 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 82.8 | 3.87e-16 | NR | XP_787753.3 | 7668 | g65194 | i0 | 50.7 | 1.95535714285714 | 73 | 36 | 65.2 | 0 | 225 | 7 | 227 | 299 | XP_787753.3 gamma-glutamyl hydrolase [Strongylocentrotus purpuratus] | diamond | 657 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 16031251 | 16031251 | PRJNA752572_P_NODE_473_length_2099_cov_2.583333_g425_i0 | PRJNA752572 | 473 | 2099 | 2.583333 | 54.22415967 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 56.5 | 0.017 | NTclustered | gi|1826614671|ref|XM_033244361.1| | 1529436 | g425 | i0 | 90.476 | 0.0200095283468318 | 42 | 4 | 2 | 0 | 1986 | 2027 | 1802 | 1761 | PREDICTED: Anneissia japonica uncharacterized LOC117103748 (LOC117103748), mRNA | blastn | 42 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27337462 | 27337462 | PRJNA752572_P_NODE_192443_length_192_cov_1.528662_g191936_i0 | PRJNA752572 | 192443 | 192 | 1.528662 | 2.93503104 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 70.1 | 4.38e-12 | NR | XP_071498811.1 | 105358 | g191936 | i0 | 47 | 3.0625 | 66 | 32 | 98.4 | 1 | 4 | 192 | 229 | 294 | XP_071498811.1 peroxisomal multifunctional enzyme type 2-like [Diadema antillarum] | diamond | 588 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 28032094 | 28032094 | PRJNA752572_P_NODE_157805_length_213_cov_1.342697_g157298_i0 | PRJNA752572 | 157805 | 213 | 1.342697 | 2.85994461 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 47.4 | 6.24e-4 | NR | XP_033116850.1 | 1529436 | g157298 | i0 | 40 | 0.845070422535211 | 60 | 36 | 84.5 | 0 | 180 | 1 | 1678 | 1737 | XP_033116850.1 midasin-like [Anneissia japonica] | diamond | 180 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29021011 | 29021011 | PRJNA752572_P_NODE_162068_length_210_cov_1.502857_g161561_i0 | PRJNA752572 | 162068 | 210 | 1.502857 | 3.1559997 | Valvatida | 41166 | Echinodermata | other_Eukaryota | 57.4 | 1.26e-7 | NR | XP_038070208.1 | 46514 | g161561 | i0 | 51 | 1.45714285714286 | 51 | 23 | 70 | 1 | 208 | 62 | 208 | 258 | XP_038070208.1 deoxynucleoside kinase-like [Patiria miniata] | diamond | 306 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 29462401 | 29462401 | PRJNA752572_P_NODE_146950_length_221_cov_1.290323_g146443_i0 | PRJNA752572 | 146950 | 221 | 1.290323 | 2.85161383 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 86.3 | 8.08e-18 | NR | XP_071501803.1 | 105358 | g146443 | i0 | 53.4 | 3.96380090497738 | 73 | 34 | 99.1 | 0 | 3 | 221 | 62 | 134 | XP_071501803.1 actin, cytoplasmic-like [Diadema antillarum] | diamond | 876 | 87 | 0.991954022988506 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30115937 | 30115937 | PRJNA752572_P_NODE_13172_length_725_cov_2.305797_g12790_i0 | PRJNA752572 | 13172 | 725 | 2.305797 | 16.71702825 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 107 | 4.539999999999999e-23 | NR | XP_033101535.1 | 1529436 | g12790 | i0 | 29.6 | 1.92827586206897 | 233 | 147 | 92.7 | 7 | 674 | 3 | 79 | 303 | XP_033101535.1 acid phosphatase type 7-like isoform X2 [Anneissia japonica] | diamond | 1398 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31126746 | 31126746 | PRJNA752572_P_NODE_252555_length_168_cov_1.203008_g252048_i0 | PRJNA752572 | 252555 | 168 | 1.203008 | 2.02105344 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 77 | 4.26e-16 | NR | XP_038059478.1 | 46514 | g252048 | i0 | 60 | 2.96428571428571 | 55 | 22 | 98.2 | 0 | 2 | 166 | 6 | 60 | XP_038059478.1 superoxide dismutase [Cu-Zn]-like [Patiria miniata] | diamond | 498 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 31475077 | 31475077 | PRJNA752572_P_NODE_181256_length_198_cov_1.668712_g180749_i0 | PRJNA752572 | 181256 | 198 | 1.668712 | 3.30404976 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 47.8 | 3.4e-4 | NR | XP_071508977.1 | 105358 | g180749 | i0 | 36.4 | 1 | 66 | 40 | 97 | 1 | 192 | 1 | 7 | 72 | XP_071508977.1 cathepsin Z-like [Diadema antillarum] | diamond | 198 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 31769454 | 31769454 | PRJNA752572_P_NODE_268417_length_164_cov_1.031008_g267910_i0 | PRJNA752572 | 268417 | 164 | 1.031008 | 1.69085312 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 50.4 | 2.44e-5 | NR | KAJ8029689.1 | 206669 | g267910 | i0 | 50 | 2.6890243902439 | 46 | 21 | 84.1 | 1 | 13 | 150 | 1039 | 1082 | KAJ8029689.1 Proprotein convertase subtilisin/kexin type 5 [Holothuria leucospilota] | diamond | 441 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32780751 | 32780751 | PRJNA752572_P_NODE_158100_length_213_cov_0.893258_g157593_i0 | PRJNA752572 | 158100 | 213 | 0.893258 | 1.90263954 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 50.8 | 3.51e-5 | NR | XP_038067210.1 | 46514 | g157593 | i0 | 36.9 | 3.28169014084507 | 65 | 41 | 91.5 | 0 | 212 | 18 | 798 | 862 | XP_038067210.1 LOW QUALITY PROTEIN: polynucleotide 5'-hydroxyl-kinase grc3-like [Patiria miniata] | diamond | 699 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata |
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);;