contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA1233465" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25557997 | 25557997 | PRJNA1233465f_S_NODE_259801_length_162_cov_1.557522_g257521_i0 | PRJNA1233465 | 259801 | 162 | 1.557522 | 2.52318564 | Patiria pectinifera | 7594 | Echinodermata | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|343175108|gb|JN375541.1| | 7594 | g257521 | i0 | 96.875 | 0.197530864197531 | 32 | 1 | 20 | 0 | 70 | 101 | 1426 | 1395 | Patiria pectinifera cathepsin X (CtX) mRNA, complete cds | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria pectinifera | |
| 25622805 | 25622805 | PRJNA1233465f_S_NODE_130985_length_212_cov_3.355828_g128705_i0 | PRJNA1233465 | 130985 | 212 | 3.355828 | 7.11435536 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 52.8 | 0.019 | NTclustered | gi|2707422408|ref|XM_054902275.2| | 7653 | g128705 | i0 | 100 | 0.264150943396226 | 28 | 0 | 13 | 0 | 84 | 111 | 3089 | 3062 | PREDICTED: Lytechinus pictus homeobox protein goosecoid-like (LOC129264401), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 25687534 | 25687534 | PRJNA1233465f_S_NODE_108170_length_231_cov_1.478022_g105890_i0 | PRJNA1233465 | 108170 | 231 | 1.478022 | 3.4142308200000002 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2037971935|ref|XM_041598236.1| | 7654 | g105890 | i0 | 100 | 0.251082251082251 | 29 | 0 | 13 | 0 | 8 | 36 | 1301 | 1273 | PREDICTED: Lytechinus variegatus mitochondrial import inner membrane translocase subunit Tim21-like (LOC121407259), transcript variant X1, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 25691775 | 25691775 | PRJNA1233465f_S_NODE_203698_length_176_cov_3.464567_g201418_i0 | PRJNA1233465 | 203698 | 176 | 3.464567 | 6.09763792 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|1040842650|gb|KU512189.1| | 46514 | g201418 | i0 | 100 | 0.159090909090909 | 28 | 0 | 16 | 0 | 55 | 82 | 65 | 38 | Patiria miniata isolate c35673_g1_i1 Plk4 mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 25755946 | 25755946 | PRJNA1233465b_S_NODE_143906_length_239_cov_20.763158_g142221_i0 | PRJNA1233465 | 143906 | 239 | 20.763158 | 49.62394762 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|2707422408|ref|XM_054902275.2| | 7653 | g142221 | i0 | 100 | 0.234309623430962 | 28 | 0 | 12 | 0 | 91 | 118 | 3089 | 3062 | PREDICTED: Lytechinus pictus homeobox protein goosecoid-like (LOC129264401), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 25891311 | 25891311 | PRJNA1233465a_S_NODE_86123_length_242_cov_17.388601_g84849_i0 | PRJNA1233465 | 86123 | 242 | 17.388601 | 42.08041442 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2707422408|ref|XM_054902275.2| | 7653 | g84849 | i0 | 100 | 0.231404958677686 | 28 | 0 | 12 | 0 | 126 | 153 | 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 | |
| 26026910 | 26026910 | PRJNA1233465a_S_NODE_210012_length_170_cov_0.842975_g208738_i0 | PRJNA1233465 | 210012 | 170 | 0.842975 | 1.4330575 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|1125813433|ref|NC_032365.1| | 31907 | g208738 | i0 | 92.105 | 0.564705882352941 | 38 | 3 | 22 | 0 | 1 | 38 | 4929 | 4892 | Glyptocidaris crenularis mitochondrion, complete genome | blastn | 96 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Phymosomatoida | Phymosomatidae | Glyptocidaris | Glyptocidaris crenularis | |
| 26030170 | 26030170 | PRJNA1233465e_S_NODE_103268_length_190_cov_1.730496_g101958_i0 | PRJNA1233465 | 103268 | 190 | 1.730496 | 3.2879424 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|2707422408|ref|XM_054902275.2| | 7653 | g101958 | i0 | 100 | 0.294736842105263 | 28 | 0 | 15 | 0 | 81 | 108 | 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 | |
| 26221430 | 26221430 | PRJNA1233465d_S_NODE_100110_length_182_cov_2.315789_g98999_i0 | PRJNA1233465 | 100110 | 182 | 2.315789 | 4.21473598 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|1040842650|gb|KU512189.1| | 46514 | g98999 | i0 | 100 | 0.153846153846154 | 28 | 0 | 15 | 0 | 55 | 82 | 65 | 38 | Patiria miniata isolate c35673_g1_i1 Plk4 mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 26352680 | 26352680 | PRJNA1233465b_S_NODE_110279_length_265_cov_4.143519_g108594_i0 | PRJNA1233465 | 110279 | 265 | 4.143519 | 10.98032535 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|1752383177|ref|XM_030994723.1| | 7668 | g108594 | i0 | 100 | 0.105660377358491 | 28 | 0 | 11 | 0 | 136 | 163 | 2205 | 2232 | PREDICTED: Strongylocentrotus purpuratus trophoblast glycoprotein (LOC100890978), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 26362941 | 26362941 | PRJNA1233465e_S_NODE_124599_length_176_cov_1.763780_g123289_i0 | PRJNA1233465 | 124599 | 176 | 1.76378 | 3.1042528 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|1040842650|gb|KU512189.1| | 46514 | g123289 | i0 | 100 | 0.159090909090909 | 28 | 0 | 16 | 0 | 55 | 82 | 65 | 38 | Patiria miniata isolate c35673_g1_i1 Plk4 mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 26436974 | 26436974 | PRJNA1233465b_S_NODE_380503_length_156_cov_12.626168_g378818_i0 | PRJNA1233465 | 380503 | 156 | 12.626168 | 19.69682208 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|1752354527|ref|XM_030982582.1| | 7668 | g378818 | i0 | 100 | 0.583333333333333 | 28 | 0 | 18 | 0 | 4 | 31 | 440 | 413 | PREDICTED: Strongylocentrotus purpuratus probable E3 ubiquitin-protein ligase HERC6 (LOC115922850), mRNA | blastn | 91 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 26489324 | 26489324 | PRJNA1233465b_S_NODE_139632_length_242_cov_4.782383_g137947_i0 | PRJNA1233465 | 139632 | 242 | 4.782383 | 11.57336686 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 58.4 | 4.69e-4 | NTclustered | gi|1834286521|ref|XM_033768550.1| | 7604 | g137947 | i0 | 94.595 | 0.45867768595041303 | 37 | 2 | 15 | 0 | 206 | 242 | 1137 | 1173 | PREDICTED: Asterias rubens mitochondrial coenzyme A transporter SLC25A42-like (LOC117287919), transcript variant X3, mRNA | blastn | 111 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 26510869 | 26510869 | PRJNA1233465f_S_NODE_263544_length_162_cov_0.884956_g261264_i0 | PRJNA1233465 | 263544 | 162 | 0.884956 | 1.43362872 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|1752353583|ref|XM_011682767.2| | 7668 | g261264 | i0 | 100 | 0.345679012345679 | 28 | 0 | 17 | 0 | 71 | 98 | 7767 | 7740 | PREDICTED: Strongylocentrotus purpuratus multidrug resistance-associated protein 4 (LOC591982), transcript variant X1, mRNA | blastn | 56 | 52.8 | 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);;