contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA565584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3685716 | 3685716 | PRJNA565584_P_NODE_17463_length_770_cov_11.560976_g16384_i0 | PRJNA565584 | 17463 | 770 | 11.560976 | 89.0195152 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 195 | 1.21e-44 | NTclustered | gi|2707408381|ref|XM_054893204.2| | 7653 | g16384 | i0 | 80.545 | 29.038961038961 | 257 | 46 | 33 | 4 | 367 | 621 | 597 | 343 | PREDICTED: Lytechinus pictus dynein light chain 2, cytoplasmic-like (LOC129254696), mRNA | blastn | 22360 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 5658156 | 5658156 | PRJNA565584_P_NODE_106685_length_290_cov_1.566820_g105533_i0 | PRJNA565584 | 106685 | 290 | 1.56682 | 4.543778 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2707415582|ref|XM_064099402.1| | 7653 | g105533 | i0 | 94.444 | 0.344827586206897 | 36 | 1 | 12 | 1 | 184 | 218 | 609 | 574 | PREDICTED: Lytechinus pictus late histone H1 (LOC129260346), mRNA | blastn | 100 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 6934124 | 6934124 | PRJNA565584_P_NODE_199286_length_244_cov_1.286550_g198134_i0 | PRJNA565584 | 199286 | 244 | 1.28655 | 3.139182 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 207 | 4.44e-49 | NTclustered | gi|2919373928|ref|XM_071624062.1| | 105358 | g198134 | i0 | 82.833 | 94.1762295081967 | 233 | 38 | 95 | 2 | 1 | 232 | 403 | 172 | PREDICTED: Diadema antillarum dynein light chain 2, cytoplasmic (LOC139712222), mRNA | blastn | 22979 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 7513294 | 7513294 | PRJNA565584_P_NODE_75546_length_342_cov_0.933086_g74395_i0 | PRJNA565584 | 75546 | 342 | 0.933086 | 3.19115412 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 60.2 | 1.93e-4 | NTclustered | gi|1944911567|ref|XM_038212659.1| | 46514 | g74395 | i0 | 97.222 | 5.20760233918129 | 36 | 0 | 11 | 1 | 235 | 270 | 4224 | 4190 | PREDICTED: Patiria miniata nuclear factor of activated T-cells 5-like (LOC119737976), mRNA | blastn | 1781 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 14583199 | 14583199 | PRJNA565584_P_NODE_105472_length_291_cov_2.045872_g104320_i0 | PRJNA565584 | 105472 | 291 | 2.045872 | 5.95348752 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|1229151169|ref|XR_002598004.1| | 133434 | g104320 | i0 | 94.286 | 0.120274914089347 | 35 | 1 | 12 | 1 | 252 | 285 | 1594 | 1560 | PREDICTED: Acanthaster planci uncharacterized LOC110977910 (LOC110977910), ncRNA | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 14584900 | 14584900 | PRJNA565584_P_NODE_200072_length_244_cov_0.900585_g198920_i0 | PRJNA565584 | 200072 | 244 | 0.900585 | 2.1974274 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 126 | 1.28e-24 | NTclustered | gi|1944923555|ref|XM_038218481.1| | 46514 | g198920 | i0 | 80.864 | 35.7663934426229 | 162 | 29 | 66 | 2 | 82 | 242 | 2258 | 2098 | PREDICTED: Patiria miniata major vault protein-like (LOC119742522), mRNA | blastn | 8727 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 19682036 | 19682036 | PRJNA565584_P_NODE_169176_length_251_cov_0.865169_g168024_i0 | PRJNA565584 | 169176 | 251 | 0.865169 | 2.17157419 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|1944881371|ref|XM_038202473.1| | 46514 | g168024 | i0 | 96.875 | 0.127490039840637 | 32 | 0 | 12 | 1 | 30 | 60 | 788 | 819 | PREDICTED: Patiria miniata uncharacterized LOC119729751 (LOC119729751), mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 20261822 | 20261822 | PRJNA565584_P_NODE_65696_length_366_cov_2.764505_g64545_i0 | PRJNA565584 | 65696 | 366 | 2.764505 | 10.1180883 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 191 | 7.06e-44 | NTclustered | gi|1834282072|ref|XM_033782857.1| | 7604 | g64545 | i0 | 79.004 | 40.948087431694 | 281 | 57 | 77 | 2 | 11 | 290 | 272 | 551 | PREDICTED: Asterias rubens 60S ribosomal protein L12-like (LOC117299337), mRNA | blastn | 14987 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 21536915 | 21536915 | PRJNA565584_P_NODE_38137_length_487_cov_2.787440_g36986_i0 | PRJNA565584 | 38137 | 487 | 2.78744 | 13.5748328 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 303 | 1.1900000000000001e-77 | NTclustered | gi|1834254684|ref|XM_033773412.1| | 7604 | g36986 | i0 | 78.603 | 65.1663244353183 | 458 | 98 | 94 | 0 | 1 | 458 | 541 | 84 | PREDICTED: Asterias rubens ubiquitin-40S ribosomal protein S27a (LOC117291593), mRNA | blastn | 31736 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 23507481 | 23507481 | PRJNA565584_P_NODE_146299_length_264_cov_3.057592_g145147_i0 | PRJNA565584 | 146299 | 264 | 3.057592 | 8.07204288 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|1752359900|ref|XM_030984830.1| | 7668 | g145147 | i0 | 100 | 0.106060606060606 | 28 | 0 | 11 | 0 | 164 | 191 | 847 | 874 | PREDICTED: Strongylocentrotus purpuratus COP9 signalosome complex subunit 3 (LOC588733), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 25361034 | 25361034 | PRJNA565584_P_NODE_215000_length_241_cov_0.916667_g213848_i0 | PRJNA565584 | 215000 | 241 | 0.916667 | 2.20916747 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 99 | 2.75e-16 | NTclustered | gi|6681667|dbj|AB016821.1| | 7650 | g213848 | i0 | 83.81 | 3.17427385892116 | 105 | 15 | 43 | 2 | 136 | 239 | 1182 | 1079 | Hemicentrotus pulcherrimus mRNA for sea urchin Arp2 (SUArp2), complete cds | blastn | 765 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Hemicentrotus | Hemicentrotus pulcherrimus |
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);;