contig_metadata
19 rows where bioproject = "PRJNA382357", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5508143 | 5508143 | PRJNA382357_P_NODE_8005_length_723_cov_1.925982_g7331_i0 | PRJNA382357 | 8005 | 723 | 1.925982 | 13.92484986 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 58.4 | 0.002 | NTclustered | gi|1229169275|ref|XM_022242169.1| | 133434 | g7331 | i0 | 100 | 0.0428769017980636 | 31 | 0 | 4 | 0 | 409 | 439 | 1284 | 1314 | PREDICTED: Acanthaster planci echinoidin-like (LOC110983166), mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 7453418 | 7453418 | PRJNA382357_P_NODE_75706_length_273_cov_24.721698_g74967_i0 | PRJNA382357 | 75706 | 273 | 24.721698 | 67.49023554 | root | 1 | Root_unresolved | Root_unresolved | 320 | 6.22e-83 | NTclustered | gi|12964767|gb|AF322373.1| | 7668 | g74967 | i0 | 100 | 91.5677655677656 | 173 | 0 | 98 | 0 | 101 | 273 | 462 | 290 | Strongylocentrotus purpuratus transposase helper protein-like protein mRNA, partial cds | blastn | 24998 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 16980789 | 16980789 | PRJNA382357_P_NODE_20674_length_486_cov_1.136471_g19940_i0 | PRJNA382357 | 20674 | 486 | 1.136471 | 5.52324906 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 52.8 | 0.047 | NTclustered | gi|2707360967|ref|XM_064107191.1| | 7653 | g19940 | i0 | 100 | 0.691358024691358 | 28 | 0 | 12 | 0 | 204 | 231 | 2040 | 2067 | PREDICTED: Lytechinus pictus phospholysine phosphohistidine inorganic pyrophosphate phosphatase-like (LOC129273112), transcript variant X6, mRNA | blastn | 336 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 18926493 | 18926493 | PRJNA382357_P_NODE_22335_length_470_cov_0.953545_g21599_i0 | PRJNA382357 | 22335 | 470 | 0.953545 | 4.4816615 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 54.7 | 0.013 | NTclustered | gi|2707411279|ref|XM_054892322.2| | 7653 | g21599 | i0 | 94.286 | 0.714893617021277 | 35 | 2 | 7 | 0 | 414 | 448 | 3085 | 3119 | PREDICTED: Lytechinus pictus NFX1-type zinc finger-containing protein 1-like (LOC129253888), transcript variant X2, mRNA | blastn | 336 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 27391284 | 27391284 | PRJNA382357_P_NODE_127123_length_217_cov_1.153846_g126384_i0 | PRJNA382357 | 127123 | 217 | 1.153846 | 2.50384582 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 55.1 | 1.2e-6 | NR | XP_033111197.1 | 1529436 | g126384 | i0 | 43.4 | 2.32258064516129 | 53 | 30 | 73.3 | 0 | 214 | 56 | 736 | 788 | XP_033111197.1 zinc finger protein Xfin-like [Anneissia japonica] | diamond | 504 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28622746 | 28622746 | PRJNA382357_P_NODE_92947_length_250_cov_1.412698_g92208_i0 | PRJNA382357 | 92947 | 250 | 1.412698 | 3.531745 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 42.7 | 0.0414 | NR | XP_011679674.2 | 7668 | g92208 | i0 | 39.3 | 0.672 | 56 | 32 | 67.2 | 1 | 208 | 41 | 159 | 212 | XP_011679674.2 toll-like receptor 3 [Strongylocentrotus purpuratus] | diamond | 168 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 28843384 | 28843384 | PRJNA382357_P_NODE_21568_length_477_cov_1.718750_g20833_i0 | PRJNA382357 | 21568 | 477 | 1.71875 | 8.1984375 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 105 | 7.409999999999999e-23 | NR | XP_033126365.1 | 1529436 | g20833 | i0 | 38.8 | 3.0314465408805 | 160 | 95 | 98.7 | 1 | 473 | 3 | 24 | 183 | XP_033126365.1 heat shock 70 kDa protein IV-like [Anneissia japonica] | diamond | 1446 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28938402 | 28938402 | PRJNA382357_P_NODE_29668_length_414_cov_2.059490_g28930_i0 | PRJNA382357 | 29668 | 414 | 2.05949 | 8.5262886 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 75.9 | 7.18e-13 | NR | KAJ8030095.1 | 206669 | g28930 | i0 | 37.3 | 0.739130434782609 | 102 | 53 | 65.9 | 4 | 13 | 285 | 1987 | 2088 | KAJ8030095.1 Macrophage mannose receptor 1 [Holothuria leucospilota] | diamond | 306 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29270804 | 29270804 | PRJNA382357_P_NODE_78489_length_269_cov_1.639423_g77750_i0 | PRJNA382357 | 78489 | 269 | 1.639423 | 4.41004787 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 56.2 | 9.46e-7 | NR | XP_038069842.1 | 46514 | g77750 | i0 | 56.1 | 2.45353159851301 | 41 | 18 | 45.7 | 0 | 268 | 146 | 1729 | 1769 | XP_038069842.1 NFX1-type zinc finger-containing protein 1-like [Patiria miniata] | diamond | 660 | 56.6 | 0.992932862190813 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 29317213 | 29317213 | PRJNA382357_P_NODE_96309_length_246_cov_1.756757_g95570_i0 | PRJNA382357 | 96309 | 246 | 1.756757 | 4.32162222 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 47.4 | 8.76e-4 | NR | XP_071501769.1 | 105358 | g95570 | i0 | 42.9 | 1.5 | 42 | 24 | 51.2 | 0 | 120 | 245 | 224 | 265 | XP_071501769.1 macrophage mannose receptor 1-like [Diadema antillarum] | diamond | 369 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 29727397 | 29727397 | PRJNA382357_P_NODE_77270_length_271_cov_1.538095_g76531_i0 | PRJNA382357 | 77270 | 271 | 1.538095 | 4.16823745 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 47.8 | 4.51e-4 | NR | KAJ8048781.1 | 206669 | g76531 | i0 | 32.9 | 0.907749077490775 | 82 | 43 | 79.7 | 3 | 54 | 269 | 2 | 81 | KAJ8048781.1 hypothetical protein HOLleu_01234 [Holothuria leucospilota] | diamond | 246 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29790570 | 29790570 | PRJNA382357_P_NODE_2911_length_1091_cov_12.048544_g2397_i0 | PRJNA382357 | 2911 | 1091 | 12.048544 | 131.44961504 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 63.5 | 2.29e-7 | NR | XP_054767173.2 | 7653 | g2397 | i0 | 26.9 | 0.593950504124656 | 216 | 136 | 58.6 | 5 | 800 | 162 | 57 | 253 | XP_054767173.2 uncharacterized protein LOC129274380 [Lytechinus pictus] | diamond | 648 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 29948769 | 29948769 | PRJNA382357_P_NODE_40171_length_362_cov_0.897010_g39432_i0 | PRJNA382357 | 40171 | 362 | 0.89701 | 3.2471762 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 51.2 | 1.41e-4 | NR | XP_033108564.1 | 1529436 | g39432 | i0 | 41.3 | 0.38121546961326 | 46 | 25 | 38.1 | 1 | 143 | 280 | 11 | 54 | XP_033108564.1 photoreceptor-specific nuclear receptor-like [Anneissia japonica] | diamond | 138 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 30296723 | 30296723 | PRJNA382357_P_NODE_46112_length_341_cov_0.900000_g45373_i0 | PRJNA382357 | 46112 | 341 | 0.9 | 3.069 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 65.5 | 1.3e-9 | NR | XP_022089495.1 | 133434 | g45373 | i0 | 55.8 | 0.844574780058651 | 52 | 21 | 45.7 | 1 | 337 | 182 | 1222 | 1271 | XP_022089495.1 zinc finger C3H1 domain-containing protein-like isoform X2 [Acanthaster planci] | diamond | 288 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30296765 | 30296765 | PRJNA382357_P_NODE_97292_length_245_cov_1.478261_g96553_i0 | PRJNA382357 | 97292 | 245 | 1.478261 | 3.62173945 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 53.1 | 8.34e-6 | NR | XP_033126279.1 | 1529436 | g96553 | i0 | 35.6 | 2.19183673469388 | 90 | 49 | 99.2 | 2 | 244 | 2 | 1092 | 1181 | XP_033126279.1 unconventional myosin-VI-like [Anneissia japonica] | diamond | 537 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31338928 | 31338928 | PRJNA382357_P_NODE_140896_length_208_cov_1.530612_g140157_i0 | PRJNA382357 | 140896 | 208 | 1.530612 | 3.18367296 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 42 | 0.0444 | NR | XP_041479605.1 | 7654 | g140157 | i0 | 40 | 0.504807692307692 | 35 | 21 | 50.5 | 0 | 86 | 190 | 15 | 49 | XP_041479605.1 E3 ubiquitin-protein ligase TRAIP-like [Lytechinus variegatus] | diamond | 105 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31402480 | 31402480 | PRJNA382357_P_NODE_336_length_2888_cov_14.458790_g77_i0 | PRJNA382357 | 336 | 2888 | 14.45879 | 417.5698552 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 306 | 4.7999999999999994e-83 | NR | XP_030828887.1 | 7668 | g77 | i0 | 28.1 | 1.00969529085873 | 972 | 455 | 91.4 | 34 | 2719 | 80 | 408 | 1227 | XP_030828887.1 fibrillin-1 isoform X2 [Strongylocentrotus purpuratus] | diamond | 2916 | 306 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31971636 | 31971636 | PRJNA382357_P_NODE_74238_length_276_cov_1.288372_g73499_i0 | PRJNA382357 | 74238 | 276 | 1.288372 | 3.55590672 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 43.9 | 0.0222 | NR | XP_033631641.1 | 7604 | g73499 | i0 | 92 | 0.271739130434783 | 25 | 2 | 27.2 | 0 | 201 | 275 | 1371 | 1395 | XP_033631641.1 copper-transporting ATPase 1-like isoform X2 [Asterias rubens] | diamond | 75 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32778470 | 32778470 | PRJNA382357_P_NODE_28960_length_419_cov_1.491667_g28222_i0 | PRJNA382357 | 28960 | 419 | 1.491667 | 6.25008473 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 72.8 | 7.81e-12 | NR | XP_063959663.1 | 7653 | g28222 | i0 | 29.2 | 4.86157517899761 | 137 | 93 | 95.9 | 3 | 16 | 417 | 26 | 161 | XP_063959663.1 heat shock 70 kDa protein IV-like [Lytechinus pictus] | diamond | 2037 | 73.2 | 0.994535519125683 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus |
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);;