contig_metadata
11 rows where bioproject = "PRJNA340009", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4897914 | 4897914 | PRJNA340009_P_NODE_52524_length_179_cov_5.207692_g52217_i0 | PRJNA340009 | 52524 | 179 | 5.207692 | 9.32176868 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2707375869|ref|XM_064108679.1| | 7653 | g52217 | i0 | 94.444 | 3.67597765363128 | 36 | 2 | 20 | 0 | 24 | 59 | 2959 | 2994 | PREDICTED: Lytechinus pictus PDF receptor-like (LOC129275066), transcript variant X1, mRNA | blastn | 658 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 8045892 | 8045892 | PRJNA340009_P_NODE_81227_length_150_cov_24.920792_g80920_i0 | PRJNA340009 | 81227 | 150 | 24.920792 | 37.381188 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 80.5 | 5.6e-11 | NTclustered | gi|1826672285|ref|XM_033267934.1| | 1529436 | g80920 | i0 | 92.857 | 0.773333333333333 | 56 | 2 | 37 | 2 | 7 | 61 | 1525 | 1579 | PREDICTED: Anneissia japonica actin-2-like (LOC117122384), mRNA | blastn | 116 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 9320269 | 9320269 | PRJNA340009_P_NODE_45488_length_190_cov_3.546099_g45181_i0 | PRJNA340009 | 45488 | 190 | 3.546099 | 6.7375881 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|2037980962|ref|XR_005969370.1| | 7654 | g45181 | i0 | 100 | 0.442105263157895 | 28 | 0 | 15 | 0 | 163 | 190 | 2646 | 2673 | PREDICTED: Lytechinus variegatus 3-galactosyl-N-acetylglucosaminide 4-alpha-L-fucosyltransferase FUT3-like (LOC121410738), transcript variant X3, misc_RNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 15694621 | 15694621 | PRJNA340009_P_NODE_23233_length_253_cov_1.705882_g22926_i0 | PRJNA340009 | 23233 | 253 | 1.705882 | 4.31588146 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2919474418|ref|XM_071644746.1| | 105358 | g22926 | i0 | 100 | 0.110671936758893 | 28 | 0 | 11 | 0 | 84 | 111 | 846 | 819 | PREDICTED: Diadema antillarum uncharacterized protein (LOC139733933), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 19517950 | 19517950 | PRJNA340009_P_NODE_35476_length_211_cov_7.469136_g35169_i0 | PRJNA340009 | 35476 | 211 | 7.469136 | 15.75987696 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 62.1 | 3.08e-5 | NTclustered | gi|1229127278|ref|XM_022223935.1| | 133434 | g35169 | i0 | 91.111 | 2.55450236966825 | 45 | 4 | 21 | 0 | 102 | 146 | 401 | 357 | PREDICTED: Acanthaster planci 60S ribosomal protein L34-B-like (LOC110973249), transcript variant X1, mRNA | blastn | 539 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 19518238 | 19518238 | PRJNA340009_P_NODE_616_length_1163_cov_4.469479_g411_i0 | PRJNA340009 | 616 | 1163 | 4.469479 | 51.98004077 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 58.4 | 0.003 | NTclustered | gi|2707362118|ref|XM_054910384.2| | 7653 | g411 | i0 | 97.059 | 0.0292347377472055 | 34 | 1 | 3 | 0 | 584 | 617 | 3842 | 3809 | PREDICTED: Lytechinus pictus serine/threonine-protein kinase 32B-like (LOC129273360), mRNA | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 20793645 | 20793645 | PRJNA340009_P_NODE_44917_length_191_cov_3.894366_g44610_i0 | PRJNA340009 | 44917 | 191 | 3.894366 | 7.43823906 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|1826679452|ref|XM_033271614.1| | 1529436 | g44610 | i0 | 100 | 0.151832460732984 | 29 | 0 | 15 | 0 | 1 | 29 | 250 | 222 | PREDICTED: Anneissia japonica histone PARylation factor 1-like (LOC117125190), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28085349 | 28085349 | PRJNA340009_P_NODE_71665_length_163_cov_0.894737_g71358_i0 | PRJNA340009 | 71665 | 163 | 0.894737 | 1.45842131 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 42 | 0.0183 | NR | KAJ8040522.1 | 206669 | g71358 | i0 | 43.9 | 2.33742331288344 | 41 | 21 | 75.5 | 1 | 132 | 10 | 14 | 52 | KAJ8040522.1 hypothetical protein HOLleu_14837 [Holothuria leucospilota] | diamond | 381 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29348459 | 29348459 | PRJNA340009_P_NODE_28749_length_231_cov_2.236264_g28442_i0 | PRJNA340009 | 28749 | 231 | 2.236264 | 5.16576984 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 46.2 | 6.83e-4 | NR | XP_041472159.1 | 7654 | g28442 | i0 | 38.9 | 3.66233766233766 | 72 | 35 | 83.1 | 3 | 230 | 39 | 69 | 139 | XP_041472159.1 ubiquitin-conjugating enzyme E2 variant 2-like [Lytechinus variegatus] | diamond | 846 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 29569291 | 29569291 | PRJNA340009_P_NODE_12890_length_326_cov_1.870036_g12583_i0 | PRJNA340009 | 12890 | 326 | 1.870036 | 6.09631736 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 52.8 | 2.64e-5 | NR | PIK56948.1 | 307972 | g12583 | i0 | 34.1 | 2.13496932515337 | 82 | 51 | 72.7 | 1 | 81 | 317 | 172 | 253 | PIK56948.1 hypothetical protein BSL78_06149 [Apostichopus japonicus] | diamond | 696 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 31844619 | 31844619 | PRJNA340009_P_NODE_34697_length_213_cov_8.536585_g34390_i0 | PRJNA340009 | 34697 | 213 | 8.536585 | 18.18292605 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 43.1 | 0.0175 | NR | XP_030840376.1 | 7668 | g34390 | i0 | 58.1 | 3.09859154929577 | 31 | 13 | 43.7 | 0 | 203 | 111 | 273 | 303 | XP_030840376.1 mitochondrial glycine transporter B [Strongylocentrotus purpuratus] | diamond | 660 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus |
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);;