contig_metadata
13 rows where bioproject = "PRJNA1174234", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1040949 | 1040949 | PRJNA1174234_P_NODE_34521_length_243_cov_0.905882_g34325_i0 | PRJNA1174234 | 34521 | 243 | 0.905882 | 2.20129326 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 102 | 4.839999999999999e-24 | NR | XP_054773758.1 | 7653 | g34325 | i0 | 58 | 5.95061728395062 | 81 | 33 | 98.8 | 1 | 3 | 242 | 51 | 131 | XP_054773758.1 cyclin-dependent kinase 1-like [Lytechinus pictus] | diamond | 1446 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 7969393 | 7969393 | PRJNA1174234_P_NODE_25667_length_271_cov_1.166667_g25471_i0 | PRJNA1174234 | 25667 | 271 | 1.166667 | 3.16166757 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|1752386050|ref|XM_030995953.1| | 7668 | g25471 | i0 | 96.875 | 0.811808118081181 | 32 | 1 | 12 | 0 | 52 | 83 | 1444 | 1413 | PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC115918970 (LOC115918970), transcript variant X2, mRNA | blastn | 220 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 13069691 | 13069691 | PRJNA1174234_P_NODE_21471_length_298_cov_1.342222_g21275_i0 | PRJNA1174234 | 21471 | 298 | 1.342222 | 3.99982156 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2707365989|ref|XM_064112355.1| | 7653 | g21275 | i0 | 100 | 0.288590604026846 | 29 | 0 | 10 | 0 | 160 | 188 | 2114 | 2086 | PREDICTED: Lytechinus pictus lactadherin-like (LOC129280151), mRNA | blastn | 86 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 20717499 | 20717499 | PRJNA1174234_P_NODE_27597_length_259_cov_1.327957_g27401_i0 | PRJNA1174234 | 27597 | 259 | 1.327957 | 3.43940863 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|1944916156|ref|XM_038214918.1| | 46514 | g27401 | i0 | 96.97 | 0.50965250965251 | 33 | 0 | 13 | 1 | 15 | 47 | 1962 | 1993 | PREDICTED: Patiria miniata beta-1,2-xylosyltransferase RCN11-like (LOC119739830), transcript variant X1, mRNA | blastn | 132 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 24542067 | 24542067 | PRJNA1174234_P_NODE_20340_length_306_cov_1.321888_g20144_i0 | PRJNA1174234 | 20340 | 306 | 1.321888 | 4.04497728 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 148 | 1.49e-41 | NR | XP_071487048.1 | 105358 | g20144 | i0 | 70.2 | 2.04901960784314 | 104 | 27 | 98 | 2 | 5 | 304 | 59 | 162 | XP_071487048.1 ADP,ATP carrier protein-like [Diadema antillarum] | diamond | 627 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27672597 | 27672597 | PRJNA1174234_P_NODE_34484_length_243_cov_0.905882_g34288_i0 | PRJNA1174234 | 34484 | 243 | 0.905882 | 2.20129326 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 118 | 3.61e-29 | NR | XP_033626140.1 | 7604 | g34288 | i0 | 65.8 | 3.92592592592593 | 79 | 26 | 97.5 | 1 | 240 | 4 | 36 | 113 | XP_033626140.1 lysosomal protective protein-like isoform X1 [Asterias rubens] | diamond | 954 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27830226 | 27830226 | PRJNA1174234_P_NODE_19224_length_315_cov_0.971074_g19028_i0 | PRJNA1174234 | 19224 | 315 | 0.971074 | 3.0588831 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 49.3 | 4.27e-4 | NR | XP_030852948.1 | 7668 | g19028 | i0 | 43.6 | 0.523809523809524 | 55 | 30 | 52.4 | 1 | 102 | 266 | 264 | 317 | XP_030852948.1 choline transporter-like protein 2 [Strongylocentrotus purpuratus] | diamond | 165 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 28859697 | 28859697 | PRJNA1174234_P_NODE_14468_length_362_cov_1.332180_g14272_i0 | PRJNA1174234 | 14468 | 362 | 1.33218 | 4.8224916 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 173 | 1.87e-50 | NR | XP_022081367.1 | 133434 | g14272 | i0 | 65.3 | 13.7900552486188 | 118 | 41 | 97.8 | 0 | 361 | 8 | 123 | 240 | XP_022081367.1 mannose-1-phosphate guanyltransferase beta-A-like [Acanthaster planci] | diamond | 4992 | 174 | 0.994252873563218 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30325473 | 30325473 | PRJNA1174234_P_NODE_30712_length_249_cov_0.869318_g30516_i0 | PRJNA1174234 | 30712 | 249 | 0.869318 | 2.16460182 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 73.6 | 5.58e-13 | NR | KAJ8043531.1 | 206669 | g30516 | i0 | 53.1 | 3.79518072289157 | 81 | 38 | 97.6 | 0 | 247 | 5 | 734 | 814 | KAJ8043531.1 Major vault protein [Holothuria leucospilota] | diamond | 945 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30957024 | 30957024 | PRJNA1174234_P_NODE_28774_length_252_cov_1.636872_g28578_i0 | PRJNA1174234 | 28774 | 252 | 1.636872 | 4.12491744 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 89.4 | 5.99e-19 | NR | XP_041480248.1 | 7654 | g28578 | i0 | 54.3 | 1.92857142857143 | 81 | 37 | 96.4 | 0 | 5 | 247 | 190 | 270 | XP_041480248.1 inositol 2-dehydrogenase-like isoform X1 [Lytechinus variegatus] | diamond | 486 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31241080 | 31241080 | PRJNA1174234_P_NODE_21955_length_295_cov_0.851351_g21759_i0 | PRJNA1174234 | 21955 | 295 | 0.851351 | 2.51148545 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 90.1 | 1.48e-18 | NR | XP_038056848.1 | 46514 | g21759 | i0 | 44.2 | 5.89830508474576 | 95 | 52 | 95.6 | 1 | 294 | 13 | 224 | 318 | XP_038056848.1 cell division cycle protein 20 homolog [Patiria miniata] | diamond | 1740 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 31797896 | 31797896 | PRJNA1174234_P_NODE_19897_length_309_cov_2.148305_g19701_i0 | PRJNA1174234 | 19897 | 309 | 2.148305 | 6.63826245 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 103 | 2.65e-26 | NR | KAJ8043769.1 | 206669 | g19701 | i0 | 75.7 | 4.19417475728155 | 70 | 17 | 68 | 0 | 21 | 230 | 1 | 70 | KAJ8043769.1 60S acidic ribosomal protein P2 [Holothuria leucospilota] | diamond | 1296 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32632660 | 32632660 | PRJNA1174234_P_NODE_33360_length_244_cov_1.795322_g33164_i0 | PRJNA1174234 | 33360 | 244 | 1.795322 | 4.38058568 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 58.5 | 1.33e-8 | NR | XP_033638051.1 | 7604 | g33164 | i0 | 45.9 | 0.75 | 61 | 31 | 73.8 | 2 | 244 | 65 | 60 | 119 | XP_033638051.1 rhodanese domain-containing protein CG4456-like [Asterias rubens] | diamond | 183 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens |
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);;