contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA379145" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 400759 | 400759 | PRJNA379145_P_NODE_24081_length_512_cov_2.127349_g22079_i0 | PRJNA379145 | 24081 | 512 | 2.127349 | 10.89202688 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 182 | 6.13e-41 | NTclustered | gi|1826617272|ref|XM_033241562.1| | 1529436 | g22079 | i0 | 79.767 | 37.404296875 | 257 | 46 | 50 | 5 | 100 | 353 | 371 | 118 | PREDICTED: Anneissia japonica histone H2B, gonadal-like (LOC117101580), mRNA | blastn | 19151 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 5504691 | 5504691 | PRJNA379145_P_NODE_61325_length_184_cov_1.754967_g59171_i0 | PRJNA379145 | 61325 | 184 | 1.754967 | 3.22913928 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 174 | 3.21e-39 | NTclustered | gi|2037995275|ref|XM_041610581.1| | 7654 | g59171 | i0 | 90.226 | 24.7391304347826 | 133 | 13 | 72 | 0 | 1 | 133 | 344 | 212 | PREDICTED: Lytechinus variegatus dynein light chain 2, cytoplasmic-like (LOC121417029), mRNA | blastn | 4552 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 9329248 | 9329248 | PRJNA379145_P_NODE_74188_length_150_cov_1.504274_g72033_i0 | PRJNA379145 | 74188 | 150 | 1.5042739999999999 | 2.256411 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 84.2 | 4.33e-12 | NTclustered | gi|1752341932|ref|XM_030975762.1| | 7668 | g72033 | i0 | 88.406 | 0.46 | 69 | 8 | 46 | 0 | 15 | 83 | 159 | 91 | PREDICTED: Strongylocentrotus purpuratus dynein light chain LC6, flagellar outer arm (LOC591043), mRNA | blastn | 69 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 10604464 | 10604464 | PRJNA379145_P_NODE_24149_length_511_cov_1.663180_g22143_i0 | PRJNA379145 | 24149 | 511 | 1.66318 | 8.4988498 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 65.8 | 6.42e-6 | NTclustered | gi|1752365610|ref|XM_030987174.1| | 7668 | g22143 | i0 | 89.091 | 1.56555772994129 | 55 | 3 | 11 | 1 | 157 | 211 | 1441 | 1390 | PREDICTED: Strongylocentrotus purpuratus ribosome biogenesis protein BMS1 homolog (LOC587885), mRNA | blastn | 800 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 11277281 | 11277281 | PRJNA379145_P_NODE_66789_length_167_cov_3.074627_g64635_i0 | PRJNA379145 | 66789 | 167 | 3.074627 | 5.13462709 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 172 | 1.0299999999999999e-38 | NTclustered | gi|1752341932|ref|XM_030975762.1| | 7668 | g64635 | i0 | 86.538 | 91.5748502994012 | 156 | 21 | 93 | 0 | 12 | 167 | 97 | 252 | PREDICTED: Strongylocentrotus purpuratus dynein light chain LC6, flagellar outer arm (LOC591043), mRNA | blastn | 15293 | 172 | 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);;