contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA699078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3233759 | 3233759 | PRJNA699078_S_NODE_78583_length_189_cov_3.071429_g77634_i0 | PRJNA699078 | 78583 | 189 | 3.071429 | 5.80500081 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 63.9 | 7.49e-6 | NTclustered | gi|1229186445|ref|XM_022251296.1| | 133434 | g77634 | i0 | 82.432 | 0.783068783068783 | 74 | 11 | 39 | 2 | 113 | 185 | 995 | 923 | PREDICTED: Acanthaster planci delta(3,5)-Delta(2,4)-dienoyl-CoA isomerase, mitochondrial-like (LOC110988065), transcript variant X2, mRNA | blastn | 148 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 5012393 | 5012393 | PRJNA699078_S_NODE_38924_length_277_cov_2.175439_g37975_i0 | PRJNA699078 | 38924 | 277 | 2.175439 | 6.02596603 | Valvatida | 41166 | Echinodermata | other_Eukaryota | 222 | 1.84e-53 | NTclustered | gi|1944827247|ref|XM_038209516.1| | 46514 | g37975 | i0 | 82.375 | 18.3646209386282 | 261 | 40 | 93 | 3 | 1 | 258 | 411 | 668 | PREDICTED: Patiria miniata structural maintenance of chromosomes protein 3-like (LOC119735678), mRNA | blastn | 5087 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 5786050 | 5786050 | PRJNA699078_S_NODE_65285_length_209_cov_1.375000_g64336_i0 | PRJNA699078 | 65285 | 209 | 1.375 | 2.87375 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 95.3 | 3e-15 | NTclustered | gi|1826618869|ref|XM_033242417.1| | 1529436 | g64336 | i0 | 95 | 1.86602870813397 | 60 | 3 | 29 | 0 | 57 | 116 | 261 | 320 | PREDICTED: Anneissia japonica dolichyl-phosphate beta-glucosyltransferase-like (LOC117102198), transcript variant X2, mRNA | blastn | 390 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 7561986 | 7561986 | PRJNA699078_S_NODE_34946_length_292_cov_18.341564_g33997_i0 | PRJNA699078 | 34946 | 292 | 18.341564 | 53.55736688 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 89.8 | 2.06e-13 | NTclustered | gi|322366561|gb|HM449818.1| | 7656 | g33997 | i0 | 90 | 4.68150684931507 | 70 | 6 | 24 | 1 | 1 | 70 | 1252 | 1320 | Paracentrotus lividus beta-tubulin mRNA, partial cds | blastn | 1367 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Echinidae | Paracentrotus | Paracentrotus lividus | |
| 8336111 | 8336111 | PRJNA699078_S_NODE_88127_length_178_cov_1.705426_g87178_i0 | PRJNA699078 | 88127 | 178 | 1.705426 | 3.03565828 | Hemicentrotus pulcherrimus | 7650 | Echinodermata | other_Eukaryota | 63.9 | 6.96e-6 | NTclustered | gi|1276317365|dbj|LC275143.1| | 7650 | g87178 | i0 | 97.368 | 1.02247191011236 | 38 | 0 | 21 | 1 | 18 | 54 | 5771 | 5734 | Hemicentrotus pulcherrimus H4, H2B, H3, H2A, H1 genes for early histone H4, early histone H2B, early histone H3, early histone H2A, early histone H1, partial and complete cds | blastn | 182 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Hemicentrotus | Hemicentrotus pulcherrimus | |
| 8336152 | 8336152 | PRJNA699078_S_NODE_90887_length_175_cov_1.746032_g89938_i0 | PRJNA699078 | 90887 | 175 | 1.746032 | 3.055556 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 126 | 8.56e-25 | NTclustered | gi|2707392286|ref|XM_064101025.1| | 7653 | g89938 | i0 | 82.313 | 10.6742857142857 | 147 | 24 | 83 | 2 | 3 | 148 | 250 | 395 | PREDICTED: Lytechinus pictus U1 small nuclear ribonucleoprotein A-like (LOC129263757), transcript variant X2, mRNA | blastn | 1868 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 19809608 | 19809608 | PRJNA699078_S_NODE_74156_length_195_cov_3.308219_g73207_i0 | PRJNA699078 | 74156 | 195 | 3.308219 | 6.45102705 | Paracentrotus lividus | 7656 | Echinodermata | other_Eukaryota | 102 | 1.65e-17 | NTclustered | gi|322366561|gb|HM449818.1| | 7656 | g73207 | i0 | 91.892 | 12.7692307692308 | 74 | 5 | 38 | 1 | 1 | 74 | 1248 | 1320 | Paracentrotus lividus beta-tubulin mRNA, partial cds | blastn | 2490 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Echinidae | Paracentrotus | Paracentrotus lividus | |
| 24908462 | 24908462 | PRJNA699078_S_NODE_37140_length_284_cov_1.774468_g36191_i0 | PRJNA699078 | 37140 | 284 | 1.774468 | 5.03948912 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 58.4 | 5.64e-4 | NTclustered | gi|1752381937|ref|XM_030994157.1| | 7668 | g36191 | i0 | 90.909 | 0.154929577464789 | 44 | 3 | 15 | 1 | 237 | 279 | 1083 | 1126 | PREDICTED: Strongylocentrotus purpuratus cylicin-2 (LOC753846), mRNA | blastn | 44 | 58.4 | 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);;