contig_metadata
13 rows where bioproject = "PRJEB75017", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6513529 | 6513529 | PRJEB75017_P_NODE_6486_length_348_cov_1.418182_g6357_i0 | PRJEB75017 | 6486 | 348 | 1.418182 | 4.93527336 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 255 | 2.34e-63 | NTclustered | gi|2037989810|ref|XM_041607735.1| | 7654 | g6357 | i0 | 80.781 | 91.7988505747126 | 333 | 58 | 95 | 5 | 13 | 342 | 476 | 147 | PREDICTED: Lytechinus variegatus tubulin alpha-1D chain (LOC121414526), mRNA | blastn | 31946 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 27248192 | 27248192 | PRJEB75017_P_NODE_11363_length_275_cov_3.445545_g11234_i0 | PRJEB75017 | 11363 | 275 | 3.445545 | 9.47524875 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 49.3 | 8.61e-5 | NR | XP_038053469.1 | 46514 | g11234 | i0 | 36.8 | 4.68 | 76 | 39 | 79.6 | 2 | 228 | 10 | 25 | 94 | XP_038053469.1 ly6/PLAUR domain-containing protein 2-like [Patiria miniata] | diamond | 1287 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27824055 | 27824055 | PRJEB75017_P_NODE_5884_length_364_cov_0.986254_g5755_i0 | PRJEB75017 | 5884 | 364 | 0.986254 | 3.58996456 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 91.3 | 1.43e-18 | NR | PIK57751.1 | 307972 | g5755 | i0 | 49 | 2.22527472527473 | 98 | 50 | 80.8 | 0 | 60 | 353 | 178 | 275 | PIK57751.1 hypothetical protein BSL78_05359 [Apostichopus japonicus] | diamond | 810 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 28234061 | 28234061 | PRJEB75017_P_NODE_11786_length_271_cov_1.575758_g11657_i0 | PRJEB75017 | 11786 | 271 | 1.575758 | 4.27030418 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 123 | 1.03e-32 | NR | XP_033118288.1 | 1529436 | g11657 | i0 | 66.3 | 1.97047970479705 | 89 | 30 | 98.5 | 0 | 5 | 271 | 42 | 130 | XP_033118288.1 60S ribosomal protein L7-like isoform X2 [Anneissia japonica] | diamond | 534 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29181740 | 29181740 | PRJEB75017_P_NODE_16689_length_246_cov_0.901734_g16560_i0 | PRJEB75017 | 16689 | 246 | 0.901734 | 2.21826564 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 53.1 | 8.33e-6 | NR | XP_022081481.1 | 133434 | g16560 | i0 | 47.1 | 0.621951219512195 | 51 | 24 | 58.5 | 1 | 244 | 101 | 413 | 463 | XP_022081481.1 fibropellin-1-like isoform X2 [Acanthaster planci] | diamond | 153 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 29276148 | 29276148 | PRJEB75017_P_NODE_16349_length_247_cov_0.896552_g16220_i0 | PRJEB75017 | 16349 | 247 | 0.896552 | 2.21448344 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 62.8 | 3.55e-9 | NR | XP_033100199.1 | 1529436 | g16220 | i0 | 44.6 | 1.0080971659919 | 83 | 41 | 96 | 4 | 10 | 246 | 541 | 622 | XP_033100199.1 sortilin-related receptor-like [Anneissia japonica] | diamond | 249 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29552979 | 29552979 | PRJEB75017_P_NODE_16130_length_247_cov_1.482759_g16001_i0 | PRJEB75017 | 16130 | 247 | 1.482759 | 3.66241473 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.9 | 0.00717 | NR | XP_041481456.1 | 7654 | g16001 | i0 | 48.8 | 2.46558704453441 | 41 | 21 | 49.8 | 0 | 125 | 247 | 58 | 98 | XP_041481456.1 vesicle-associated membrane protein 4-like [Lytechinus variegatus] | diamond | 609 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30287340 | 30287340 | PRJEB75017_P_NODE_13012_length_259_cov_2.096774_g12883_i0 | PRJEB75017 | 13012 | 259 | 2.096774 | 5.43064466 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 89 | 9.38e-19 | NR | XP_041480248.1 | 7654 | g12883 | i0 | 52.4 | 3.88030888030888 | 84 | 40 | 97.3 | 0 | 256 | 5 | 193 | 276 | XP_041480248.1 inositol 2-dehydrogenase-like isoform X1 [Lytechinus variegatus] | diamond | 1005 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31329666 | 31329666 | PRJEB75017_P_NODE_17116_length_245_cov_0.906977_g16987_i0 | PRJEB75017 | 17116 | 245 | 0.906977 | 2.22209365 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 49.3 | 1.86e-4 | NR | PIK44991.1 | 307972 | g16987 | i0 | 65.6 | 0.808163265306122 | 32 | 11 | 39.2 | 0 | 19 | 114 | 114 | 145 | PIK44991.1 hypothetical protein BSL78_18126 [Apostichopus japonicus] | diamond | 198 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 31551354 | 31551354 | PRJEB75017_P_NODE_10436_length_284_cov_2.701422_g10307_i0 | PRJEB75017 | 10436 | 284 | 2.701422 | 7.67203848 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 107 | 6.81e-26 | NR | XP_033105668.1 | 1529436 | g10307 | i0 | 57 | 1.90140845070423 | 93 | 40 | 98.2 | 0 | 281 | 3 | 191 | 283 | XP_033105668.1 60S ribosomal protein L5-like [Anneissia japonica] | diamond | 540 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 32532085 | 32532085 | PRJEB75017_P_NODE_18059_length_243_cov_0.917647_g17930_i0 | PRJEB75017 | 18059 | 243 | 0.917647 | 2.22988221 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 42.7 | 0.0191 | NR | XP_038045312.1 | 46514 | g17930 | i0 | 33.9 | 0.765432098765432 | 62 | 41 | 76.5 | 0 | 58 | 243 | 38 | 99 | XP_038045312.1 actin-related protein 2/3 complex subunit 5-B-like [Patiria miniata] | diamond | 186 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 32626394 | 32626394 | PRJEB75017_P_NODE_10980_length_279_cov_1.514563_g10851_i0 | PRJEB75017 | 10980 | 279 | 1.514563 | 4.22563077 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 90.9 | 4.19e-19 | NR | QCY50088.1 | 307972 | g10851 | i0 | 50 | 6.65591397849462 | 88 | 42 | 94.6 | 1 | 6 | 269 | 244 | 329 | QCY50088.1 DNAJA2A [Apostichopus japonicus] | diamond | 1857 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 32745352 | 32745352 | PRJEB75017_P_NODE_14380_length_252_cov_0.871508_g14251_i0 | PRJEB75017 | 14380 | 252 | 0.871508 | 2.19620016 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67.8 | 6.58e-11 | NR | XP_071482980.1 | 105358 | g14251 | i0 | 45.7 | 22.1666666666667 | 81 | 41 | 96.4 | 1 | 10 | 252 | 825 | 902 | XP_071482980.1 ribosome biogenesis protein BMS1 homolog [Diadema antillarum] | diamond | 5586 | 68.2 | 0.994134897360704 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum |
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);;