contig_metadata
8 rows where bioproject = "PRJEB81463", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2690693 | 2690693 | PRJEB81463_P_NODE_30543_length_207_cov_6.164179_g30271_i0 | PRJEB81463 | 30543 | 207 | 6.164179 | 12.75985053 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 52.8 | 0.018 | NTclustered | gi|2919357134|ref|XM_071627365.1| | 105358 | g30271 | i0 | 100 | 0.135265700483092 | 28 | 0 | 14 | 0 | 57 | 84 | 28 | 1 | PREDICTED: Diadema antillarum uncharacterized protein (LOC139715823), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 24366271 | 24366271 | PRJEB81463_P_NODE_20960_length_252_cov_0.871508_g20688_i0 | PRJEB81463 | 20960 | 252 | 0.871508 | 2.19620016 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 63.9 | 6.25e-10 | NR | XP_033647472.1 | 7604 | g20688 | i0 | 62 | 9.57142857142857 | 50 | 19 | 59.5 | 0 | 235 | 86 | 81 | 130 | XP_033647472.1 B-cell receptor-associated protein 31-like [Asterias rubens] | diamond | 2412 | 64.3 | 0.993779160186625 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27152948 | 27152948 | PRJEB81463_P_NODE_2242_length_675_cov_1.985050_g1979_i0 | PRJEB81463 | 2242 | 675 | 1.98505 | 13.3990875 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 252 | 4.18e-81 | NR | XP_038051326.1 | 46514 | g1979 | i0 | 56.3 | 7.70666666666667 | 215 | 94 | 95.6 | 0 | 646 | 2 | 13 | 227 | XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata] | diamond | 5202 | 254 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 29332273 | 29332273 | PRJEB81463_P_NODE_16689_length_268_cov_1.702564_g16417_i0 | PRJEB81463 | 16689 | 268 | 1.702564 | 4.56287152 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 125 | 8.099999999999999e-33 | NR | XP_071489045.1 | 105358 | g16417 | i0 | 65.9 | 7.86940298507463 | 88 | 30 | 98.5 | 0 | 5 | 268 | 94 | 181 | XP_071489045.1 large ribosomal subunit protein uL18-like [Diadema antillarum] | diamond | 2109 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30508238 | 30508238 | PRJEB81463_P_NODE_19413_length_255_cov_5.071429_g19141_i0 | PRJEB81463 | 19413 | 255 | 5.071429 | 12.93214395 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 90.9 | 5.03e-19 | NR | PIK47873.1 | 307972 | g19141 | i0 | 52.2 | 3.29411764705882 | 90 | 34 | 95.3 | 4 | 245 | 3 | 1368 | 1457 | PIK47873.1 putative kielin/chordin-like protein isoform X1 [Apostichopus japonicus] | diamond | 840 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 30761069 | 30761069 | PRJEB81463_P_NODE_15054_length_277_cov_1.372549_g14782_i0 | PRJEB81463 | 15054 | 277 | 1.372549 | 3.80196073 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 48.5 | 5.37e-4 | NR | XP_038049131.1 | 46514 | g14782 | i0 | 33.3 | 1.7978339350180499 | 84 | 46 | 85.6 | 4 | 265 | 29 | 523 | 601 | XP_038049131.1 neurogenic locus notch homolog protein 1-like [Patiria miniata] | diamond | 498 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30887378 | 30887378 | PRJEB81463_P_NODE_19314_length_256_cov_1.672131_g19042_i0 | PRJEB81463 | 19314 | 256 | 1.672131 | 4.28065536 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 74.7 | 2.51e-13 | NR | XP_033638385.1 | 7604 | g19042 | i0 | 48.9 | 1.078125 | 92 | 30 | 94.9 | 5 | 247 | 5 | 694 | 779 | XP_033638385.1 uncharacterized protein LOC117299078, partial [Asterias rubens] | diamond | 276 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31804141 | 31804141 | PRJEB81463_P_NODE_24777_length_246_cov_2.421965_g24505_i0 | PRJEB81463 | 24777 | 246 | 2.421965 | 5.9580339 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 92.8 | 9.33e-20 | NR | XP_033115342.1 | 1529436 | g24505 | i0 | 54.1 | 1.03658536585366 | 85 | 35 | 98.8 | 1 | 245 | 3 | 138 | 222 | XP_033115342.1 clathrin heavy chain 1 isoform X2 [Anneissia japonica] | diamond | 255 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica |
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);;