contig_metadata
6 rows where bioproject = "PRJNA416866", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6797401 | 6797401 | PRJNA416866_P_NODE_10046_length_207_cov_0.876712_g9902_i0 | PRJNA416866 | 10046 | 207 | 0.876712 | 1.81479384 | Peronella japonica | 262331 | Echinodermata | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|606211636|dbj|AB779702.1| | 262331 | g9902 | i0 | 100 | 0.140096618357488 | 29 | 0 | 14 | 0 | 94 | 122 | 1162 | 1190 | Peronella japonica PjHox11/13b mRNA for transcription factor Hox11/13b, complete cds | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Clypeasteroida | Laganidae | Peronella | Peronella japonica | |
| 19545501 | 19545501 | PRJNA416866_P_NODE_7616_length_234_cov_2.173410_g7472_i0 | PRJNA416866 | 7616 | 234 | 2.17341 | 5.0857794 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|2707444759|ref|XM_064105764.1| | 7653 | g7472 | i0 | 100 | 0.358974358974359 | 28 | 0 | 12 | 0 | 94 | 121 | 4021 | 4048 | PREDICTED: Lytechinus pictus nuclear protein localization protein 4 homolog (LOC129269441), transcript variant X1, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 26632434 | 26632434 | PRJNA416866_P_NODE_6061_length_265_cov_1.254902_g5917_i0 | PRJNA416866 | 6061 | 265 | 1.254902 | 3.3254903 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 66.2 | 2.61e-10 | NR | XP_030848995.1 | 7668 | g5917 | i0 | 47.1 | 1.53962264150943 | 68 | 29 | 75.8 | 2 | 201 | 1 | 419 | 480 | XP_030848995.1 uncharacterized protein LOC100894123 [Strongylocentrotus purpuratus] | diamond | 408 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 26822582 | 26822582 | PRJNA416866_P_NODE_11561_length_202_cov_0.907801_g11417_i0 | PRJNA416866 | 11561 | 202 | 0.907801 | 1.83375802 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 47 | 6.75e-4 | NR | XP_071499744.1 | 105358 | g11417 | i0 | 41.1 | 3.60891089108911 | 56 | 31 | 80.2 | 2 | 3 | 164 | 246 | 301 | XP_071499744.1 adhesion G-protein coupled receptor G2-like [Diadema antillarum] | diamond | 729 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30328868 | 30328868 | PRJNA416866_P_NODE_10372_length_206_cov_0.882759_g10228_i0 | PRJNA416866 | 10372 | 206 | 0.882759 | 1.81848354 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 77.8 | 7.9e-15 | NR | XP_033108310.1 | 1529436 | g10228 | i0 | 51.4 | 9.81553398058252 | 70 | 28 | 94.7 | 3 | 9 | 203 | 12 | 80 | XP_033108310.1 methionine aminopeptidase 1-like isoform X1 [Anneissia japonica] | diamond | 2022 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31624163 | 31624163 | PRJNA416866_P_NODE_9916_length_208_cov_0.870748_g9772_i0 | PRJNA416866 | 9916 | 208 | 0.870748 | 1.81115584 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 56.6 | 2.9e-7 | NR | XP_033126247.1 | 1529436 | g9772 | i0 | 58.3 | 1.81730769230769 | 36 | 15 | 51.9 | 0 | 118 | 11 | 154 | 189 | XP_033126247.1 3'-5' exoribonuclease 1-like [Anneissia japonica] | diamond | 378 | 56.6 | 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);;