contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA940501" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3470533 | 3470533 | PRJNA940501_S_NODE_24643_length_342_cov_2.869565_g23825_i0 | PRJNA940501 | 24643 | 342 | 2.869565 | 9.8139123 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 54.7 | 0.009 | NTclustered | gi|2037949781|ref|XM_041619873.1| | 7654 | g23825 | i0 | 96.97 | 0.385964912280702 | 33 | 0 | 9 | 1 | 100 | 131 | 5147 | 5115 | PREDICTED: Lytechinus variegatus rho GTPase-activating protein 29-like (LOC121424255), transcript variant X2, mRNA | blastn | 132 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 7299685 | 7299685 | PRJNA940501_S_NODE_54606_length_279_cov_0.995763_g53788_i0 | PRJNA940501 | 54606 | 279 | 0.995763 | 2.77817877 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 217 | 8.61e-52 | NTclustered | gi|1826615520|ref|XM_033240640.1| | 1529436 | g53788 | i0 | 83.55 | 123.996415770609 | 231 | 38 | 83 | 0 | 36 | 266 | 70 | 300 | PREDICTED: Anneissia japonica ubiquitin-40S ribosomal protein S27a (LOC117100817), transcript variant X2, mRNA | blastn | 34595 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 8574005 | 8574005 | PRJNA940501_S_NODE_374027_length_153_cov_1.709091_g373209_i0 | PRJNA940501 | 374027 | 153 | 1.709091 | 2.61490923 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|161545|gb|M30606.1|SUSMTA | 7668 | g373209 | i0 | 100 | 0.366013071895425 | 28 | 0 | 18 | 0 | 122 | 149 | 1140 | 1113 | Strongylocentrotus purpuratus (clone lambda-MT206) metallothionein-A (MTA) gene, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 8910239 | 8910239 | PRJNA940501_S_NODE_162247_length_206_cov_1.963190_g161429_i0 | PRJNA940501 | 162247 | 206 | 1.96319 | 4.0441714 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 52.8 | 0.018 | NTclustered | gi|2707422408|ref|XM_054902275.2| | 7653 | g161429 | i0 | 100 | 0.271844660194175 | 28 | 0 | 14 | 0 | 119 | 146 | 3062 | 3089 | PREDICTED: Lytechinus pictus homeobox protein goosecoid-like (LOC129264401), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 8910460 | 8910460 | PRJNA940501_S_NODE_206347_length_191_cov_1.270270_g205529_i0 | PRJNA940501 | 206347 | 191 | 1.27027 | 2.4262157 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|1944901264|ref|XM_038207519.1| | 46514 | g205529 | i0 | 100 | 1.0261780104712 | 28 | 0 | 15 | 0 | 76 | 103 | 543 | 516 | PREDICTED: Patiria miniata cdc42-interacting protein 4 homolog (LOC119734169), transcript variant X4, mRNA | blastn | 196 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 9848531 | 9848531 | PRJNA940501_S_NODE_312968_length_164_cov_11.008264_g312150_i0 | PRJNA940501 | 312968 | 164 | 11.008264 | 18.05355296 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|1826637910|ref|XM_033251062.1| | 1529436 | g312150 | i0 | 100 | 0.170731707317073 | 28 | 0 | 17 | 0 | 42 | 69 | 770 | 797 | PREDICTED: Anneissia japonica cyclin-dependent kinase 2-associated protein 1-like (LOC117108889), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 17500041 | 17500041 | PRJNA940501_S_NODE_67834_length_264_cov_1.108597_g67016_i0 | PRJNA940501 | 67834 | 264 | 1.108597 | 2.92669608 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|1826616444|ref|XM_033241115.1| | 1529436 | g67016 | i0 | 100 | 0.53030303030303 | 28 | 0 | 11 | 0 | 108 | 135 | 1705 | 1678 | PREDICTED: Anneissia japonica GPI mannosyltransferase 3-like (LOC117101204), transcript variant X4, mRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 18772934 | 18772934 | PRJNA940501_S_NODE_391075_length_151_cov_0.870370_g390257_i0 | PRJNA940501 | 391075 | 151 | 0.87037 | 1.3142587 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 52.8 | 0.012 | NTclustered | gi|1752377924|ref|XM_030992418.1| | 7668 | g390257 | i0 | 100 | 0.185430463576159 | 28 | 0 | 19 | 0 | 103 | 130 | 3210 | 3183 | PREDICTED: Strongylocentrotus purpuratus calpain-A (LOC100888469), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 20046367 | 20046367 | PRJNA940501_S_NODE_244636_length_180_cov_1.503650_g243818_i0 | PRJNA940501 | 244636 | 180 | 1.50365 | 2.70657 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|1752358083|ref|XM_781716.5| | 7668 | g243818 | i0 | 100 | 0.155555555555556 | 28 | 0 | 16 | 0 | 95 | 122 | 2992 | 2965 | PREDICTED: Strongylocentrotus purpuratus transcription factor Sox-10 (LOC581729), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 21660147 | 21660147 | PRJNA940501_S_NODE_279017_length_172_cov_1.093023_g278199_i0 | PRJNA940501 | 279017 | 172 | 1.093023 | 1.87999956 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2038006305|ref|XM_041616417.1| | 7654 | g278199 | i0 | 94.444 | 0.569767441860465 | 36 | 2 | 21 | 0 | 123 | 158 | 2645 | 2680 | PREDICTED: Lytechinus variegatus purine nucleoside phosphorylase-like (LOC121421649), mRNA | blastn | 98 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 23870812 | 23870812 | PRJNA940501_S_NODE_159239_length_207_cov_2.786585_g158421_i0 | PRJNA940501 | 159239 | 207 | 2.786585 | 5.76823095 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|1752399591|ref|XR_004061782.1| | 7668 | g158421 | i0 | 100 | 0.140096618357488 | 29 | 0 | 14 | 0 | 12 | 40 | 1941 | 1913 | PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC115919287 (LOC115919287), ncRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 23874359 | 23874359 | PRJNA940501_S_NODE_72519_length_259_cov_1.958333_g71701_i0 | PRJNA940501 | 72519 | 259 | 1.958333 | 5.07208247 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2037998016|ref|XM_041612056.1| | 7654 | g71701 | i0 | 96.97 | 0.127413127413127 | 33 | 0 | 13 | 1 | 53 | 85 | 3116 | 3085 | PREDICTED: Lytechinus variegatus protein PRRC2C-like (LOC121418277), mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus |
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);;