contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA986481" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16276538 | 16276538 | PRJNA986481_P_NODE_41153_length_262_cov_0.948357_g40628_i0 | PRJNA986481 | 41153 | 262 | 0.948357 | 2.48469534 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 213 | 1.04e-50 | NTclustered | gi|1834291358|ref|XM_033783991.1| | 7604 | g40628 | i0 | 84.234 | 78.1717557251908 | 222 | 32 | 85 | 2 | 28 | 249 | 1658 | 1876 | PREDICTED: Asterias rubens uncharacterized LOC117300260 (LOC117300260), mRNA | blastn | 20481 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 21375550 | 21375550 | PRJNA986481_P_NODE_25197_length_327_cov_1.539568_g24672_i0 | PRJNA986481 | 25197 | 327 | 1.539568 | 5.03438736 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 69.4 | 3.05e-7 | NTclustered | gi|1944819460|ref|XM_038194088.1| | 46514 | g24672 | i0 | 87.931 | 0.807339449541284 | 58 | 7 | 18 | 0 | 268 | 325 | 1302 | 1245 | PREDICTED: Patiria miniata nucleosome assembly protein 1-like 1 (LOC119723430), transcript variant X2, mRNA | blastn | 264 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 22650825 | 22650825 | PRJNA986481_P_NODE_46378_length_256_cov_1.004831_g45853_i0 | PRJNA986481 | 46378 | 256 | 1.004831 | 2.57236736 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2037971383|ref|XM_041597947.1| | 7654 | g45853 | i0 | 97.059 | 0.265625 | 34 | 0 | 13 | 1 | 135 | 168 | 2623 | 2655 | PREDICTED: Lytechinus variegatus tonsoku-like protein (LOC121407040), transcript variant X2, mRNA | blastn | 68 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 25199363 | 25199363 | PRJNA986481_P_NODE_10680_length_501_cov_3.349558_g10159_i0 | PRJNA986481 | 10680 | 501 | 3.349558 | 16.78128558 | Psammechinus miliaris | 7660 | Echinodermata | other_Eukaryota | 200 | 1.6499999999999999e-46 | NTclustered | gi|1036032539|gb|AH001093.2| | 7660 | g10159 | i0 | 79.322 | 30.3812375249501 | 295 | 53 | 58 | 8 | 103 | 393 | 527 | 817 | Psammechinus miliaris histone H2B-2.1 and histone H2A-2.1 genes, complete cds | blastn | 15221 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Parechinidae | Psammechinus | Psammechinus miliaris |
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);;