contig_metadata
15 rows where bioproject = "PRJNA643700" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 618042 | 618042 | PRJNA643700_P_NODE_184901_length_293_cov_1.278689_g183345_i0 | PRJNA643700 | 184901 | 293 | 1.278689 | 3.74655877 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|2707409892|ref|XM_064115662.1| | 7653 | g183345 | i0 | 100 | 0.191126279863481 | 28 | 0 | 10 | 0 | 245 | 272 | 2349 | 2322 | PREDICTED: Lytechinus pictus UDP-glucuronosyltransferase 1-2-like (LOC129272151), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 5721582 | 5721582 | PRJNA643700_P_NODE_134845_length_354_cov_1.701639_g133290_i0 | PRJNA643700 | 134845 | 354 | 1.701639 | 6.02380206 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.033 | NTclustered | gi|1826614903|ref|XM_033245514.1| | 1529436 | g133290 | i0 | 100 | 0.0790960451977401 | 28 | 0 | 8 | 0 | 284 | 311 | 1699 | 1672 | PREDICTED: Anneissia japonica zinc finger protein AEBP2-like (LOC117104637), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 5721717 | 5721717 | PRJNA643700_P_NODE_346185_length_187_cov_1.507246_g344629_i0 | PRJNA643700 | 346185 | 187 | 1.507246 | 2.81855002 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|1229158999|ref|XM_022236658.1| | 133434 | g344629 | i0 | 100 | 0.299465240641711 | 28 | 0 | 15 | 0 | 138 | 165 | 2522 | 2495 | PREDICTED: Acanthaster planci probable G-protein coupled receptor 52 (LOC110980209), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 6996921 | 6996921 | PRJNA643700_P_NODE_65646_length_516_cov_2.237687_g64123_i0 | PRJNA643700 | 65646 | 516 | 2.237687 | 11.54646492 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 67.6 | 1.8e-6 | NTclustered | gi|2919468252|ref|XM_071643726.1| | 105358 | g64123 | i0 | 91.667 | 0.186046511627907 | 48 | 4 | 9 | 0 | 26 | 73 | 3719 | 3672 | PREDICTED: Diadema antillarum uncharacterized protein (LOC139732890), mRNA | blastn | 96 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 14647225 | 14647225 | PRJNA643700_P_NODE_425172_length_162_cov_0.920354_g423616_i0 | PRJNA643700 | 425172 | 162 | 0.920354 | 1.49097348 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 200 | 4.549999999999998e-47 | NTclustered | gi|1229128602|ref|XM_022231094.1| | 133434 | g423616 | i0 | 88.889 | 84.9567901234568 | 162 | 18 | 100 | 0 | 1 | 162 | 857 | 696 | PREDICTED: Acanthaster planci ATP synthase subunit beta, mitochondrial (LOC110977189), mRNA | blastn | 13763 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 15187115 | 15187115 | PRJNA643700_P_NODE_300252_length_209_cov_5.468750_g298696_i0 | PRJNA643700 | 300252 | 209 | 5.46875 | 11.4296875 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 52.8 | 0.018 | NTclustered | gi|1834271362|ref|XM_033781777.1| | 7604 | g298696 | i0 | 96.875 | 3.33014354066986 | 32 | 0 | 15 | 1 | 178 | 209 | 3698 | 3668 | PREDICTED: Asterias rubens multidrug resistance-associated protein 5-like (LOC117298494), mRNA | blastn | 696 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 15920903 | 15920903 | PRJNA643700_P_NODE_144373_length_340_cov_2.302405_g142818_i0 | PRJNA643700 | 144373 | 340 | 2.302405 | 7.828177 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|1826650628|ref|XM_033257304.1| | 1529436 | g142818 | i0 | 100 | 0.164705882352941 | 28 | 0 | 8 | 0 | 273 | 300 | 1679 | 1652 | PREDICTED: Anneissia japonica uncharacterized LOC117113851 (LOC117113851), transcript variant X2, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 15921175 | 15921175 | PRJNA643700_P_NODE_428673_length_158_cov_3.119266_g427117_i0 | PRJNA643700 | 428673 | 158 | 3.119266 | 4.92844028 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|2707423589|ref|XM_054893992.2| | 7653 | g427117 | i0 | 100 | 0.177215189873418 | 28 | 0 | 18 | 0 | 34 | 61 | 30 | 3 | PREDICTED: Lytechinus pictus F-box only protein 16-like (LOC129255646), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 17195990 | 17195990 | PRJNA643700_P_NODE_172594_length_306_cov_1.011673_g171038_i0 | PRJNA643700 | 172594 | 306 | 1.011673 | 3.09571938 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2037979265|ref|XM_041602125.1| | 7654 | g171038 | i0 | 100 | 0.0947712418300654 | 29 | 0 | 9 | 0 | 54 | 82 | 3886 | 3914 | PREDICTED: Lytechinus variegatus UDP-glucuronosyltransferase 2B23-like (LOC121410198), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 23570926 | 23570926 | PRJNA643700_P_NODE_365399_length_178_cov_1.612403_g363843_i0 | PRJNA643700 | 365399 | 178 | 1.612403 | 2.87007734 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|1826616115|ref|XM_033240948.1| | 1529436 | g363843 | i0 | 100 | 0.629213483146067 | 28 | 0 | 16 | 0 | 4 | 31 | 3771 | 3798 | PREDICTED: Anneissia japonica coiled-coil domain-containing protein 50-like (LOC117101080), transcript variant X3, mRNA | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29039433 | 29039433 | PRJNA643700_P_NODE_289368_length_215_cov_2.548193_g287812_i0 | PRJNA643700 | 289368 | 215 | 2.548193 | 5.47861495 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 44.3 | 0.00735 | NR | XP_033124182.1 | 1529436 | g287812 | i0 | 41.9 | 0.6 | 43 | 20 | 53 | 1 | 163 | 50 | 287 | 329 | XP_033124182.1 ETS translocation variant 1-like [Anneissia japonica] | diamond | 129 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29039437 | 29039437 | PRJNA643700_P_NODE_42968_length_626_cov_4.939341_g41556_i0 | PRJNA643700 | 42968 | 626 | 4.939341 | 30.92027466 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 47 | 0.0223 | NR | KAJ8050204.1 | 206669 | g41556 | i0 | 38.6 | 0.546325878594249 | 57 | 35 | 27.3 | 0 | 300 | 130 | 141 | 197 | KAJ8050204.1 hypothetical protein HOLleu_03311 [Holothuria leucospilota] | diamond | 342 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30175937 | 30175937 | PRJNA643700_P_NODE_127052_length_366_cov_1.905363_g125497_i0 | PRJNA643700 | 127052 | 366 | 1.905363 | 6.97362858 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 51.2 | 2.76e-5 | NR | XP_033110181.1 | 1529436 | g125497 | i0 | 52.1 | 0.39344262295082 | 48 | 20 | 36.9 | 1 | 47 | 181 | 76 | 123 | XP_033110181.1 uncharacterized protein LOC117111377 [Anneissia japonica] | diamond | 144 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 32767820 | 32767820 | PRJNA643700_P_NODE_182780_length_295_cov_1.479675_g181224_i0 | PRJNA643700 | 182780 | 295 | 1.479675 | 4.36504125 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 43.5 | 0.0349 | NR | XP_033639347.1 | 7604 | g181224 | i0 | 36.8 | 0.579661016949153 | 57 | 33 | 54.9 | 1 | 59 | 220 | 287 | 343 | XP_033639347.1 G-protein coupled receptor 54-like [Asterias rubens] | diamond | 171 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32830925 | 32830925 | PRJNA643700_P_NODE_245700_length_242_cov_2.647668_g244144_i0 | PRJNA643700 | 245700 | 242 | 2.647668 | 6.40735656 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 50.8 | 5.29e-5 | NR | KAJ8046041.1 | 206669 | g244144 | i0 | 40 | 0.805785123966942 | 65 | 32 | 71.9 | 1 | 222 | 49 | 859 | 923 | KAJ8046041.1 Transcriptional-regulating factor 1 [Holothuria leucospilota] | diamond | 195 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota |
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);;