contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA667863" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 633984 | 633984 | PRJNA667863_P_NODE_11061_length_252_cov_1.396648_g11027_i0 | PRJNA667863 | 11061 | 252 | 1.396648 | 3.51955296 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 180 | 1e-40 | NTclustered | gi|2919507701|ref|XM_071650991.1| | 105358 | g11027 | i0 | 80.081 | 23.9642857142857 | 246 | 45 | 97 | 4 | 6 | 249 | 11311 | 11554 | PREDICTED: Diadema antillarum dynein axonemal heavy chain 2-like (LOC139740398), mRNA | blastn | 6039 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 1910306 | 1910306 | PRJNA667863_P_NODE_9662_length_259_cov_5.440860_g9628_i0 | PRJNA667863 | 9662 | 259 | 5.44086 | 14.0918274 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 178 | 3.73e-40 | NTclustered | gi|1944897900|ref|XM_038206757.1| | 46514 | g9628 | i0 | 79.231 | 9.08108108108108 | 260 | 50 | 99 | 4 | 1 | 258 | 542 | 799 | PREDICTED: Patiria miniata rRNA 2'-O-methyltransferase fibrillarin-like (LOC119733178), transcript variant X1, mRNA | blastn | 2352 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 4461867 | 4461867 | PRJNA667863_P_NODE_15804_length_243_cov_0.905882_g15770_i0 | PRJNA667863 | 15804 | 243 | 0.905882 | 2.20129326 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 84.2 | 7.77e-12 | NTclustered | gi|1834264232|ref|XM_033771074.1| | 7604 | g15770 | i0 | 83.908 | 0.358024691358025 | 87 | 14 | 36 | 0 | 8 | 94 | 362 | 448 | PREDICTED: Asterias rubens transmembrane emp24 domain-containing protein 2-like (LOC117289885), mRNA | blastn | 87 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 7012626 | 7012626 | PRJNA667863_P_NODE_8106_length_270_cov_1.177665_g8072_i0 | PRJNA667863 | 8106 | 270 | 1.177665 | 3.1796955 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 268 | 2.2599999999999994e-67 | NTclustered | gi|2037943933|ref|XM_041618991.1| | 7654 | g8072 | i0 | 84.926 | 55.7074074074074 | 272 | 33 | 99 | 6 | 1 | 268 | 2237 | 2504 | PREDICTED: Lytechinus variegatus cilia- and flagella-associated protein 57-like (LOC121423609), mRNA | blastn | 15041 | 268 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 9562528 | 9562528 | PRJNA667863_P_NODE_6168_length_286_cov_2.145540_g6134_i0 | PRJNA667863 | 6168 | 286 | 2.14554 | 6.1362444 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 169 | 2.52e-37 | NTclustered | gi|1229160721|ref|XM_022237579.1| | 133434 | g6134 | i0 | 82.234 | 25.8146853146853 | 197 | 33 | 69 | 2 | 1 | 196 | 4830 | 4635 | PREDICTED: Acanthaster planci clathrin heavy chain 1 (LOC110980684), mRNA | blastn | 7383 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 19760969 | 19760969 | PRJNA667863_P_NODE_5516_length_294_cov_1.162896_g5482_i0 | PRJNA667863 | 5516 | 294 | 1.162896 | 3.41891424 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 71.3 | 7.53e-8 | NTclustered | gi|1752352510|ref|XM_030981733.1| | 7668 | g5482 | i0 | 90.741 | 0.36734693877551 | 54 | 4 | 18 | 1 | 24 | 77 | 5504 | 5452 | PREDICTED: Strongylocentrotus purpuratus DNA-directed RNA polymerase II subunit RPB1-like (LOC105446803), mRNA | blastn | 108 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 21036538 | 21036538 | PRJNA667863_P_NODE_5477_length_294_cov_2.194570_g5443_i0 | PRJNA667863 | 5477 | 294 | 2.19457 | 6.4520358 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 255 | 1.94e-63 | NTclustered | gi|1229148110|ref|XM_022230790.1| | 133434 | g5443 | i0 | 82.699 | 16.1258503401361 | 289 | 49 | 98 | 1 | 1 | 289 | 1579 | 1292 | PREDICTED: Acanthaster planci cilia- and flagella-associated protein 58-like (LOC110977030), mRNA | blastn | 4741 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci |
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);;