contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA520845" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 492196 | 492196 | PRJNA520845_P_NODE_50721_length_525_cov_1.568584_g49229_i0 | PRJNA520845 | 50721 | 525 | 1.568584 | 8.235066 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 76.8 | 3.06e-9 | NTclustered | gi|1752389142|ref|XM_030997266.1| | 7668 | g49229 | i0 | 97.727 | 7.89333333333333 | 44 | 1 | 8 | 0 | 41 | 84 | 429 | 386 | PREDICTED: Strongylocentrotus purpuratus receptor-type tyrosine-protein phosphatase O-like (LOC105441908), mRNA | blastn | 4144 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 4316572 | 4316572 | PRJNA520845_P_NODE_193124_length_267_cov_1.587629_g191625_i0 | PRJNA520845 | 193124 | 267 | 1.587629 | 4.23896943 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|2919418345|ref|XM_071634807.1| | 105358 | g191625 | i0 | 100 | 0.524344569288389 | 28 | 0 | 10 | 0 | 235 | 262 | 2796 | 2769 | PREDICTED: Diadema antillarum pleckstrin homology domain-containing family G member 5-like (LOC139723562), transcript variant X4, mRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 6869850 | 6869850 | PRJNA520845_P_NODE_43826_length_568_cov_2.212121_g42344_i0 | PRJNA520845 | 43826 | 568 | 2.212121 | 12.56484728 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 87.9 | 1.54e-12 | NTclustered | gi|1229184102|ref|XM_022250047.1| | 133434 | g42344 | i0 | 80.909 | 0.538732394366197 | 110 | 21 | 19 | 0 | 459 | 568 | 756 | 865 | PREDICTED: Acanthaster planci homeodomain-interacting protein kinase 2-like (LOC110987363), transcript variant X1, mRNA | blastn | 306 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 9415516 | 9415516 | PRJNA520845_P_NODE_109268_length_356_cov_1.275618_g107769_i0 | PRJNA520845 | 109268 | 356 | 1.275618 | 4.54120008 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 159 | 1.93e-34 | NTclustered | gi|1944933246|ref|XM_038222229.1| | 46514 | g107769 | i0 | 80.189 | 2.97752808988764 | 212 | 42 | 60 | 0 | 145 | 356 | 1409 | 1198 | PREDICTED: Patiria miniata 26S proteasome regulatory subunit 7 (LOC119745691), mRNA | blastn | 1060 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 9420999 | 9420999 | PRJNA520845_P_NODE_71728_length_439_cov_1.092896_g70229_i0 | PRJNA520845 | 71728 | 439 | 1.092896 | 4.79781344 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 52.8 | 0.042 | NTclustered | gi|1944919046|ref|XM_038216390.1| | 46514 | g70229 | i0 | 100 | 0.0637813211845103 | 28 | 0 | 6 | 0 | 314 | 341 | 2388 | 2415 | PREDICTED: Patiria miniata AT-rich interactive domain-containing protein 4A-like (LOC119740911), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 10695888 | 10695888 | PRJNA520845_P_NODE_40609_length_592_cov_1.460501_g39134_i0 | PRJNA520845 | 40609 | 592 | 1.460501 | 8.64616592 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 178 | 9.26e-40 | NTclustered | gi|1752399365|ref|XM_011667624.2| | 7668 | g39134 | i0 | 83.077 | 38.1655405405405 | 195 | 33 | 33 | 0 | 253 | 447 | 389 | 583 | PREDICTED: Strongylocentrotus purpuratus ATP synthase F(0) complex subunit C2, mitochondrial (LOC583818), mRNA | blastn | 22594 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 13244395 | 13244395 | PRJNA520845_P_NODE_223271_length_249_cov_1.312500_g221772_i0 | PRJNA520845 | 223271 | 249 | 1.3125 | 3.268125 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 141 | 4.68e-29 | NTclustered | gi|1229145579|ref|XM_022229421.1| | 133434 | g221772 | i0 | 80.749 | 3.6144578313253 | 187 | 30 | 74 | 6 | 1 | 184 | 720 | 537 | PREDICTED: Acanthaster planci 60S ribosomal protein L7a-like (LOC110976290), mRNA | blastn | 900 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 13864861 | 13864861 | PRJNA520845_P_NODE_102871_length_367_cov_1.044218_g101372_i0 | PRJNA520845 | 102871 | 367 | 1.044218 | 3.83228006 | Patiria | 35076 | Echinodermata | other_Eukaryota | 213 | 1.51e-50 | NTclustered | gi|2581071022|dbj|LC779629.1| | 7594 | g101372 | i0 | 79.538 | 21.7384196185286 | 303 | 58 | 82 | 4 | 8 | 308 | 446 | 146 | Patiria pectinifera mRNA for clathrin heavy chain, complete cds | blastn | 7978 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria pectinifera | |
| 14519032 | 14519032 | PRJNA520845_P_NODE_208592_length_255_cov_0.802198_g207093_i0 | PRJNA520845 | 208592 | 255 | 0.802198 | 2.0456049 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 62.1 | 3.85e-5 | NTclustered | gi|1752351196|ref|XM_784065.5| | 7668 | g207093 | i0 | 87.037 | 0.572549019607843 | 54 | 7 | 21 | 0 | 200 | 253 | 993 | 940 | PREDICTED: Strongylocentrotus purpuratus caudal type homeobox 1 (LOC584191), mRNA | blastn | 146 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 15796125 | 15796125 | PRJNA520845_P_NODE_97993_length_375_cov_1.993377_g96494_i0 | PRJNA520845 | 97993 | 375 | 1.993377 | 7.47516375 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 178 | 5.6399999999999996e-40 | NTclustered | gi|2037976119|ref|XM_041600467.1| | 7654 | g96494 | i0 | 89.928 | 14.0826666666667 | 139 | 13 | 37 | 1 | 238 | 375 | 450 | 312 | PREDICTED: Lytechinus variegatus dynein light chain 2, cytoplasmic-like (LOC121408813), mRNA | blastn | 5281 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 18344838 | 18344838 | PRJNA520845_P_NODE_90395_length_390_cov_7.324921_g88896_i0 | PRJNA520845 | 90395 | 390 | 7.324921 | 28.5671919 | Stichopus monotuberculatus | 576894 | Echinodermata | other_Eukaryota | 315 | 4.31e-81 | NTclustered | gi|656991663|gb|KJ624993.1| | 576894 | g88896 | i0 | 81.818 | 57.7564102564103 | 374 | 68 | 96 | 0 | 1 | 374 | 487 | 114 | Stichopus monotuberculatus calmodulin mRNA, complete cds | blastn | 22525 | 315 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Stichopus | Stichopus monotuberculatus |
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);;