contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA615351" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1871906 | 1871906 | PRJNA615351_P_NODE_6662_length_2408_cov_3.036662_g4707_i1 | PRJNA615351 | 6662 | 2408 | 3.036662 | 73.12282096 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 56.5 | 0.019 | NTclustered | gi|1826614671|ref|XM_033244361.1| | 1529436 | g4707 | i1 | 90.476 | 0.0174418604651163 | 42 | 4 | 2 | 0 | 2295 | 2336 | 1802 | 1761 | PREDICTED: Anneissia japonica uncharacterized LOC117103748 (LOC117103748), mRNA | blastn | 42 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 3146491 | 3146491 | PRJNA615351_P_NODE_180723_length_155_cov_1.775000_g166623_i0 | PRJNA615351 | 180723 | 155 | 1.775 | 2.75125 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|1826641092|ref|XM_033252730.1| | 1529436 | g166623 | i0 | 100 | 0.180645161290323 | 28 | 0 | 18 | 0 | 11 | 38 | 14417 | 14390 | PREDICTED: Anneissia japonica uncharacterized LOC117110129 (LOC117110129), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 4978158 | 4978158 | PRJNA615351_P_NODE_20204_length_1456_cov_2.992963_g14668_i0 | PRJNA615351 | 20204 | 1456 | 2.992963 | 43.57754128 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.012 | NTclustered | gi|161517|gb|M16033.1|SUSHISHA1G | 7668 | g14668 | i0 | 100 | 0.0837912087912088 | 30 | 0 | 2 | 0 | 725 | 754 | 909 | 880 | Sea urchin (S.purpuratus) late histone H1-gamma gene, complete cds | blastn | 122 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 5699329 | 5699329 | PRJNA615351_P_NODE_32805_length_1059_cov_12.622070_g4106_i3 | PRJNA615351 | 32805 | 1059 | 12.62207 | 133.6677213 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 56.5 | 0.008 | NTclustered | gi|1944863915|ref|XM_038197383.1| | 46514 | g4106 | i3 | 100 | 0.028328611898017 | 30 | 0 | 3 | 0 | 985 | 1014 | 519 | 490 | PREDICTED: Patiria miniata uncharacterized LOC119725803 (LOC119725803), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 8248688 | 8248688 | PRJNA615351_P_NODE_135147_length_215_cov_1.966667_g121047_i0 | PRJNA615351 | 135147 | 215 | 1.966667 | 4.22833405 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 169 | 1.8e-37 | NTclustered | gi|1826614128|ref|XM_033241691.1| | 1529436 | g121047 | i0 | 82.723 | 16.1674418604651 | 191 | 31 | 88 | 2 | 12 | 201 | 881 | 1070 | PREDICTED: Anneissia japonica ATP synthase subunit beta, mitochondrial-like (LOC117101653), mRNA | blastn | 3476 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 9523986 | 9523986 | PRJNA615351_P_NODE_153008_length_186_cov_1.059603_g138908_i0 | PRJNA615351 | 153008 | 186 | 1.059603 | 1.97086158 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 122 | 1.19e-23 | NTclustered | gi|2919356780|ref|XM_071622435.1| | 105358 | g138908 | i0 | 81.633 | 26.1881720430108 | 147 | 27 | 79 | 0 | 9 | 155 | 404 | 258 | PREDICTED: Diadema antillarum rRNA 2'-O-methyltransferase fibrillarin-like (LOC139710480), mRNA | blastn | 4871 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 9524276 | 9524276 | PRJNA615351_P_NODE_60208_length_594_cov_11.046512_g4106_i4 | PRJNA615351 | 60208 | 594 | 11.046512 | 65.61628128 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 56.5 | 0.005 | NTclustered | gi|1944863915|ref|XM_038197383.1| | 46514 | g4106 | i4 | 100 | 0.0505050505050505 | 30 | 0 | 5 | 0 | 267 | 296 | 519 | 490 | PREDICTED: Patiria miniata uncharacterized LOC119725803 (LOC119725803), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 10800107 | 10800107 | PRJNA615351_P_NODE_60209_length_594_cov_10.305903_g4106_i5 | PRJNA615351 | 60209 | 594 | 10.305903 | 61.21706382 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 56.5 | 0.005 | NTclustered | gi|1944863915|ref|XM_038197383.1| | 46514 | g4106 | i5 | 100 | 0.0505050505050505 | 30 | 0 | 5 | 0 | 267 | 296 | 519 | 490 | PREDICTED: Patiria miniata uncharacterized LOC119725803 (LOC119725803), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 17173760 | 17173760 | PRJNA615351_P_NODE_6634_length_2413_cov_3.087889_g4707_i0 | PRJNA615351 | 6634 | 2413 | 3.087889 | 74.51076157 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 56.5 | 0.019 | NTclustered | gi|1826614671|ref|XM_033244361.1| | 1529436 | g4707 | i0 | 90.476 | 0.0174057190219644 | 42 | 4 | 2 | 0 | 73 | 114 | 1761 | 1802 | PREDICTED: Anneissia japonica uncharacterized LOC117103748 (LOC117103748), mRNA | blastn | 42 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 22273010 | 22273010 | PRJNA615351_P_NODE_5818_length_2532_cov_18.343612_g4106_i0 | PRJNA615351 | 5818 | 2532 | 18.343612 | 464.46025584 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 56.5 | 0.02 | NTclustered | gi|1944863915|ref|XM_038197383.1| | 46514 | g4106 | i0 | 100 | 0.0118483412322275 | 30 | 0 | 1 | 0 | 2458 | 2487 | 519 | 490 | PREDICTED: Patiria miniata uncharacterized LOC119725803 (LOC119725803), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 23548384 | 23548384 | PRJNA615351_P_NODE_5819_length_2532_cov_17.914698_g4106_i1 | PRJNA615351 | 5819 | 2532 | 17.914698 | 453.60015336 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 56.5 | 0.02 | NTclustered | gi|1944863915|ref|XM_038197383.1| | 46514 | g4106 | i1 | 100 | 0.0118483412322275 | 30 | 0 | 1 | 0 | 2458 | 2487 | 519 | 490 | PREDICTED: Patiria miniata uncharacterized LOC119725803 (LOC119725803), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 24821986 | 24821986 | PRJNA615351_P_NODE_41500_length_871_cov_4.545455_g30897_i0 | PRJNA615351 | 41500 | 871 | 4.545455 | 39.59091305 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 54.7 | 0.024 | NTclustered | gi|1944827637|ref|XM_038210608.1| | 46514 | g30897 | i0 | 100 | 0.0332950631458094 | 29 | 0 | 3 | 0 | 589 | 617 | 2108 | 2080 | PREDICTED: Patiria miniata cyclin-dependent kinase-like 1 (LOC119736588), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata |
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);;