contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA540466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1783720 | 1783720 | PRJNA540466_S_NODE_7302_length_598_cov_5.236190_g6827_i0 | PRJNA540466 | 7302 | 598 | 5.23619 | 31.3124162 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 291 | 1.1499999999999998e-73 | NTclustered | gi|2707444401|ref|XM_064105648.1| | 7653 | g6827 | i0 | 82.675 | 54.9046822742475 | 329 | 55 | 55 | 2 | 16 | 343 | 876 | 1203 | PREDICTED: Lytechinus pictus small ribosomal subunit protein uS5 (LOC129269342), mRNA | blastn | 32833 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 5611638 | 5611638 | PRJNA540466_S_NODE_17485_length_421_cov_1.212644_g16936_i0 | PRJNA540466 | 17485 | 421 | 1.212644 | 5.10523124 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 122 | 3.049999999999999e-23 | NTclustered | gi|2919496863|ref|XM_071648857.1| | 105358 | g16936 | i0 | 83.333 | 1.90736342042755 | 132 | 22 | 31 | 0 | 20 | 151 | 256 | 387 | PREDICTED: Diadema antillarum U6 snRNA-associated Sm-like protein LSm6 (LOC139738197), mRNA | blastn | 803 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 8160919 | 8160919 | PRJNA540466_S_NODE_44907_length_276_cov_1.896552_g44358_i0 | PRJNA540466 | 44907 | 276 | 1.896552 | 5.23448352 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 63.9 | 1.17e-5 | NTclustered | gi|1229160970|ref|XM_022237704.1| | 133434 | g44358 | i0 | 100 | 0.550724637681159 | 34 | 0 | 12 | 0 | 143 | 176 | 81 | 114 | PREDICTED: Acanthaster planci 60S ribosomal protein L8 (LOC110980756), mRNA | blastn | 152 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 9436122 | 9436122 | PRJNA540466_S_NODE_13848_length_466_cov_21.117048_g13302_i0 | PRJNA540466 | 13848 | 466 | 21.117048 | 98.40544368 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 207 | 9.13e-49 | NTclustered | gi|1834261769|ref|XM_033773906.1| | 7604 | g13302 | i0 | 80 | 14.5321888412017 | 280 | 56 | 60 | 0 | 111 | 390 | 119 | 398 | PREDICTED: Asterias rubens 60S ribosomal protein L44-like (LOC117291900), mRNA | blastn | 6772 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 13261766 | 13261766 | PRJNA540466_S_NODE_28811_length_334_cov_4.045977_g28262_i0 | PRJNA540466 | 28811 | 334 | 4.045977 | 13.51356318 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 104 | 8.57e-18 | NTclustered | gi|2919456096|ref|XM_071641670.1| | 105358 | g28262 | i0 | 87.097 | 0.55688622754491 | 93 | 10 | 28 | 2 | 1 | 92 | 1225 | 1316 | PREDICTED: Diadema antillarum long-chain specific acyl-CoA dehydrogenase, mitochondrial-like (LOC139730801), mRNA | blastn | 186 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 20909970 | 20909970 | PRJNA540466_S_NODE_25597_length_353_cov_1.825000_g25048_i0 | PRJNA540466 | 25597 | 353 | 1.825 | 6.44225 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 226 | 1.86e-54 | NTclustered | gi|1834254684|ref|XM_033773412.1| | 7604 | g25048 | i0 | 80.836 | 31.4872521246459 | 287 | 55 | 81 | 0 | 59 | 345 | 541 | 255 | PREDICTED: Asterias rubens ubiquitin-40S ribosomal protein S27a (LOC117291593), mRNA | blastn | 11115 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 22185096 | 22185096 | PRJNA540466_S_NODE_7878_length_583_cov_36.496078_g7388_i0 | PRJNA540466 | 7878 | 583 | 36.496078 | 212.77213474 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 259 | 3.1600000000000004e-64 | NTclustered | gi|2919420483|ref|XM_071635166.1| | 105358 | g7388 | i0 | 77.828 | 44.0943396226415 | 442 | 82 | 74 | 12 | 97 | 530 | 505 | 72 | PREDICTED: Diadema antillarum large ribosomal subunit protein uL15-like (LOC139723966), mRNA | blastn | 25707 | 259 | 1 | 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);;