contig_metadata
10 rows where bioproject = "PRJNA407886", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22759245 | 22759245 | PRJNA407886_P_NODE_48818_length_308_cov_4.761702_g47124_i0 | PRJNA407886 | 48818 | 308 | 4.761702 | 14.66604216 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.002 | NTclustered | gi|2037963976|ref|XM_041627509.1| | 7654 | g47124 | i0 | 96.97 | 1.88961038961039 | 33 | 1 | 11 | 0 | 78 | 110 | 2100 | 2132 | PREDICTED: Lytechinus variegatus translation initiation factor IF-2-like (LOC121430233), mRNA | blastn | 582 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 27597869 | 27597869 | PRJNA407886_P_NODE_72244_length_249_cov_0.875000_g70550_i0 | PRJNA407886 | 72244 | 249 | 0.875 | 2.17875 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 51.6 | 3.16e-5 | NR | XP_071508840.1 | 105358 | g70550 | i0 | 66.7 | 1.72289156626506 | 33 | 11 | 39.8 | 0 | 237 | 139 | 776 | 808 | XP_071508840.1 ankyrin repeat domain-containing protein 27-like [Diadema antillarum] | diamond | 429 | 52 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27770701 | 27770701 | PRJNA407886_P_NODE_81684_length_241_cov_0.916667_g79990_i0 | PRJNA407886 | 81684 | 241 | 0.916667 | 2.20916747 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 47 | 2.26e-4 | NR | XP_033111477.1 | 1529436 | g79990 | i0 | 58.3 | 0.896265560165975 | 36 | 14 | 43.6 | 1 | 107 | 3 | 28 | 63 | XP_033111477.1 dipeptidyl peptidase 2-like, partial [Anneissia japonica] | diamond | 216 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28370328 | 28370328 | PRJNA407886_P_NODE_70406_length_250_cov_2.463277_g68712_i0 | PRJNA407886 | 70406 | 250 | 2.463277 | 6.1581925 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 75.1 | 9.52e-15 | NR | XP_033110940.1 | 1529436 | g68712 | i0 | 63.1 | 1.56 | 65 | 22 | 75.6 | 1 | 250 | 62 | 90 | 154 | XP_033110940.1 60S ribosomal protein L21-like [Anneissia japonica] | diamond | 390 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28955621 | 28955621 | PRJNA407886_P_NODE_72488_length_249_cov_0.875000_g70794_i0 | PRJNA407886 | 72488 | 249 | 0.875 | 2.17875 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 86.3 | 4.61e-18 | NR | XP_022104145.1 | 133434 | g70794 | i0 | 52.5 | 12.1566265060241 | 80 | 38 | 96.4 | 0 | 10 | 249 | 101 | 180 | XP_022104145.1 COP9 signalosome complex subunit 7b-like [Acanthaster planci] | diamond | 3027 | 86.7 | 0.995386389850058 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 29443663 | 29443663 | PRJNA407886_P_NODE_77830_length_244_cov_0.900585_g76136_i0 | PRJNA407886 | 77830 | 244 | 0.900585 | 2.1974274 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 68.2 | 3.62e-11 | NR | XP_030835141.1 | 7668 | g76136 | i0 | 57.6 | 3.62704918032787 | 59 | 25 | 72.5 | 0 | 68 | 244 | 237 | 295 | XP_030835141.1 ATPase family AAA domain-containing protein 1 [Strongylocentrotus purpuratus] | diamond | 885 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 29538531 | 29538531 | PRJNA407886_P_NODE_73590_length_248_cov_0.880000_g71896_i0 | PRJNA407886 | 73590 | 248 | 0.88 | 2.1824 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 48.1 | 5.11e-4 | NR | XP_030852847.1 | 7668 | g71896 | i0 | 54.8 | 0.508064516129032 | 42 | 19 | 50.8 | 0 | 238 | 113 | 513 | 554 | XP_030852847.1 transcription activator BRG1 isoform X2 [Strongylocentrotus purpuratus] | diamond | 126 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30107015 | 30107015 | PRJNA407886_P_NODE_78552_length_243_cov_2.205882_g76858_i0 | PRJNA407886 | 78552 | 243 | 2.205882 | 5.36029326 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 57 | 3.56e-7 | NR | XP_030853598.1 | 7668 | g76858 | i0 | 35.5 | 0.938271604938272 | 76 | 49 | 93.8 | 0 | 233 | 6 | 2137 | 2212 | XP_030853598.1 spectrin alpha chain, non-erythrocytic 1 isoform X9 [Strongylocentrotus purpuratus] | diamond | 228 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32856565 | 32856565 | PRJNA407886_P_NODE_68140_length_254_cov_1.701657_g66446_i0 | PRJNA407886 | 68140 | 254 | 1.701657 | 4.32220878 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 92 | 1.63e-19 | NR | XP_033121739.1 | 1529436 | g66446 | i0 | 51.3 | 1.91338582677165 | 80 | 39 | 94.5 | 0 | 249 | 10 | 188 | 267 | XP_033121739.1 mitochondrial-processing peptidase subunit beta-like [Anneissia japonica] | diamond | 486 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 32887960 | 32887960 | PRJNA407886_P_NODE_79000_length_243_cov_0.905882_g77306_i0 | PRJNA407886 | 79000 | 243 | 0.905882 | 2.20129326 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 76.3 | 5.8e-14 | NR | XP_030840498.1 | 7668 | g77306 | i0 | 50 | 1.87654320987654 | 78 | 39 | 96.3 | 0 | 236 | 3 | 575 | 652 | XP_030840498.1 telomere length regulation protein TEL2 homolog [Strongylocentrotus purpuratus] | diamond | 456 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus |
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);;