contig_metadata
10 rows where bioproject = "PRJNA1089179", tax_clade = "Opisthokonta" and tax_phylum = "Mollusca"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4845627 | 4845627 | PRJNA1089179_P_NODE_384_length_905_cov_3.598558_g373_i0 | PRJNA1089179 | 384 | 905 | 3.598558 | 32.5669499 | root | 1 | Root_unresolved | Root_unresolved | 71.3 | 2.52e-7 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g373 | i0 | 89.655 | 9.48066298342541 | 58 | 3 | 6 | 2 | 434 | 490 | 75150129 | 75150074 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 8580 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11673489 | 11673489 | PRJNA1089179_P_NODE_2690_length_482_cov_1.870416_g2672_i0 | PRJNA1089179 | 2690 | 482 | 1.870416 | 9.01540512 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.013 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g2672 | i0 | 100 | 0.0601659751037344 | 29 | 0 | 6 | 0 | 445 | 473 | 18504795 | 18504767 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12948498 | 12948498 | PRJNA1089179_P_NODE_6451_length_347_cov_1.189781_g6433_i0 | PRJNA1089179 | 6451 | 347 | 1.189781 | 4.12854007 | root | 1 | Root_unresolved | Root_unresolved | 204 | 7.16e-63 | NR | XP_046343609.1 | 6454 | g6433 | i0 | 84.3 | 112.348703170029 | 115 | 18 | 99.4 | 0 | 2 | 346 | 119 | 233 | XP_046343609.1 glyceraldehyde-3-phosphate dehydrogenase [Haliotis rufescens] | diamond | 38985 | 205 | 0.995121951219512 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 15497395 | 15497395 | PRJNA1089179_P_NODE_11113_length_281_cov_1.038462_g11095_i0 | PRJNA1089179 | 11113 | 281 | 1.038462 | 2.91807822 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g11095 | i0 | 100 | 0.206405693950178 | 29 | 0 | 10 | 0 | 253 | 281 | 2490447 | 2490419 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16771778 | 16771778 | PRJNA1089179_P_NODE_10214_length_289_cov_109.657407_g10196_i0 | PRJNA1089179 | 10214 | 289 | 109.657407 | 316.90990623 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 165 | 3.29e-36 | NTclustered | gi|2693983665|ref|XM_063553461.1| | 6551 | g10196 | i0 | 81.132 | 57.5051903114187 | 212 | 34 | 72 | 6 | 58 | 266 | 1241 | 1033 | PREDICTED: Mytilus trossulus actin, adductor muscle (LOC134692851), mRNA | blastn | 16619 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 20595869 | 20595869 | PRJNA1089179_P_NODE_16177_length_245_cov_0.877907_g16159_i0 | PRJNA1089179 | 16177 | 245 | 0.877907 | 2.15087215 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2616662691|ref|XM_060749585.1| | 129788 | g16159 | i0 | 100 | 0.118367346938776 | 29 | 0 | 12 | 0 | 195 | 223 | 2102 | 2130 | PREDICTED: Ruditapes philippinarum neuroligin-4, X-linked-like (LOC132758072), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 23969943 | 23969943 | PRJNA1089179_P_NODE_8999_length_305_cov_1.288793_g8981_i0 | PRJNA1089179 | 8999 | 305 | 1.288793 | 3.93081865 | Ostreidae | 6563 | Mollusca | Mollusca | 65.8 | 3.65e-6 | NTclustered | gi|2751263807|ref|XM_034459676.2| | 29159 | g8981 | i0 | 84.286 | 1.10819672131148 | 70 | 8 | 22 | 3 | 148 | 215 | 712 | 644 | PREDICTED: Magallana gigas ADP-ribosylation factor 4 (LOC117685344), mRNA | blastn | 338 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 24420701 | 24420701 | PRJNA1089179_P_NODE_8840_length_307_cov_1.316239_g8822_i0 | PRJNA1089179 | 8840 | 307 | 1.316239 | 4.04085373 | Liolophura japonica | 13599 | Mollusca | Mollusca | 58.4 | 6.16e-4 | NTclustered | gi|2724240653|ref|XM_064745539.1| | 13599 | g8822 | i0 | 100 | 0.192182410423453 | 31 | 0 | 10 | 0 | 204 | 234 | 1792 | 1762 | PREDICTED: Liolophura japonica transmembrane protein 127-like (LOC135467718), mRNA | blastn | 59 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 32407164 | 32407164 | PRJNA1089179_P_NODE_7199_length_332_cov_56.949807_g7181_i0 | PRJNA1089179 | 7199 | 332 | 56.949807 | 189.07335924 | Patella caerulea | 87958 | Mollusca | Mollusca | 80.9 | 2.15e-17 | NR | KAK6180397.1 | 87958 | g7181 | i0 | 45.7 | 1.34638554216867 | 70 | 38 | 63.3 | 0 | 265 | 56 | 18 | 87 | KAK6180397.1 hypothetical protein SNE40_012562 [Patella caerulea] | diamond | 447 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 32754207 | 32754207 | PRJNA1089179_P_NODE_10400_length_287_cov_50.780374_g10382_i0 | PRJNA1089179 | 10400 | 287 | 50.780374 | 145.73967338 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 60.1 | 1.08e-9 | NR | KAK3596709.1 | 2493646 | g10382 | i0 | 51.7 | 2.60278745644599 | 60 | 25 | 58.5 | 1 | 46 | 213 | 1 | 60 | KAK3596709.1 hypothetical protein CHS0354_025007 [Potamilus streckersoni] | diamond | 747 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni |
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);;