contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA915212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3445966 | 3445966 | PRJNA915212_P_NODE_10843_length_174_cov_1.632000_g10805_i0 | PRJNA915212 | 10843 | 174 | 1.632 | 2.83968 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 62.1 | 2.43e-5 | NTclustered | gi|2245718872|ref|XM_048388532.1| | 6454 | g10805 | i0 | 100 | 9.39080459770115 | 33 | 0 | 19 | 0 | 9 | 41 | 300 | 268 | PREDICTED: Haliotis rufescens aspartate and glycine-rich protein-like (LOC125376744), transcript variant X1, mRNA | blastn | 1634 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 3446000 | 3446000 | PRJNA915212_P_NODE_2583_length_403_cov_1.282486_g2547_i0 | PRJNA915212 | 2583 | 403 | 1.282486 | 5.16841858 | Aplysia californica | 6500 | Mollusca | Mollusca | 52.8 | 0.039 | NTclustered | gi|871207438|ref|XM_005089794.2| | 6500 | g2547 | i0 | 100 | 0.208436724565757 | 28 | 0 | 7 | 0 | 221 | 248 | 783 | 756 | PREDICTED: Aplysia californica dr1-associated corepressor homolog (LOC101850686), transcript variant X2, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 5998397 | 5998397 | PRJNA915212_P_NODE_4945_length_269_cov_1.390909_g4907_i0 | PRJNA915212 | 4945 | 269 | 1.390909 | 3.74154521 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 69.4 | 2.45e-7 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g4907 | i0 | 97.5 | 0.438661710037175 | 40 | 1 | 19 | 0 | 36 | 75 | 14470297 | 14470258 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 118 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11098695 | 11098695 | PRJNA915212_P_NODE_7409_length_215_cov_1.060241_g7371_i0 | PRJNA915212 | 7409 | 215 | 1.060241 | 2.27951815 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2912984370|dbj|AP039589.1| | 145626 | g7371 | i0 | 100 | 0.274418604651163 | 30 | 0 | 14 | 0 | 94 | 123 | 59120155 | 59120184 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence | blastn | 59 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12374274 | 12374274 | PRJNA915212_P_NODE_2210_length_443_cov_1.012690_g2174_i0 | PRJNA915212 | 2210 | 443 | 1.01269 | 4.4862167 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 361 | 6.27e-95 | NTclustered | gi|2868696388|ref|XM_070339116.1| | 31220 | g2174 | i0 | 83.042 | 90.8645598194131 | 401 | 64 | 90 | 4 | 44 | 442 | 813 | 415 | PREDICTED: Littorina saxatilis actin, cytoplasmic (LOC138966779), mRNA | blastn | 40253 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 13648814 | 13648814 | PRJNA915212_P_NODE_9831_length_185_cov_1.125000_g9793_i0 | PRJNA915212 | 9831 | 185 | 1.125 | 2.08125 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g9793 | i0 | 100 | 4.52972972972973 | 30 | 0 | 16 | 0 | 141 | 170 | 49253822 | 49253851 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 838 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15278990 | 15278990 | PRJNA915212_P_NODE_1272_length_593_cov_1.198529_g1240_i0 | PRJNA915212 | 1272 | 593 | 1.198529 | 7.10727697 | Mollusca | 6447 | Mollusca | Mollusca | 303 | 1.47e-77 | NTclustered | gi|2364298220|ref|XM_052405025.1| | 45954 | g1240 | i0 | 79.241 | 71.5210792580101 | 448 | 83 | 74 | 8 | 26 | 465 | 577 | 132 | PREDICTED: Dreissena polymorpha tubulin alpha-1A chain-like (LOC127865116), mRNA | blastn | 42412 | 305 | 0.99344262295082 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 17473361 | 17473361 | PRJNA915212_P_NODE_6074_length_239_cov_1.342105_g6036_i0 | PRJNA915212 | 6074 | 239 | 1.342105 | 3.20763095 | Haliotis rubra | 36100 | Mollusca | Mollusca | 78.7 | 3.54e-10 | NTclustered | gi|2194101406|ref|XM_046706881.1| | 36100 | g6036 | i0 | 89.231 | 0.552301255230126 | 65 | 3 | 28 | 4 | 121 | 183 | 111 | 173 | PREDICTED: Haliotis rubra transcription initiation factor TFIID subunit 11-like (LOC124271720), partial mRNA | blastn | 132 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 17828558 | 17828558 | PRJNA915212_P_NODE_3214_length_353_cov_1.894737_g3177_i0 | PRJNA915212 | 3214 | 353 | 1.894737 | 6.68842161 | Metazoa | 33208 | Mollusca | Mollusca | 56.5 | 0.003 | NTclustered | gi|2694097628|ref|XM_063586004.1| | 6551 | g3177 | i0 | 100 | 1.08215297450425 | 30 | 0 | 8 | 0 | 214 | 243 | 512 | 483 | PREDICTED: Mytilus trossulus uncharacterized LOC134722385 (LOC134722385), mRNA | blastn | 382 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 22572183 | 22572183 | PRJNA915212_P_NODE_11218_length_171_cov_1.254098_g11180_i0 | PRJNA915212 | 11218 | 171 | 1.254098 | 2.14450758 | Pecten maximus | 6579 | Mollusca | Mollusca | 60.2 | 8.56e-5 | NTclustered | gi|1835551814|ref|XM_033872522.1| | 6579 | g11180 | i0 | 100 | 0.187134502923977 | 32 | 0 | 19 | 0 | 116 | 147 | 177 | 208 | PREDICTED: Pecten maximus actin-related protein 3 (LOC117317656), transcript variant X1, mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 25121208 | 25121208 | PRJNA915212_P_NODE_14820_length_161_cov_0.910714_g14782_i0 | PRJNA915212 | 14820 | 161 | 0.910714 | 1.46624954 | Patella vulgata | 6465 | Mollusca | Mollusca | 82.4 | 1.71e-11 | NTclustered | gi|2506343322|ref|XM_050562954.2| | 6465 | g14782 | i0 | 89.231 | 1.60248447204969 | 65 | 7 | 40 | 0 | 87 | 151 | 2079 | 2143 | PREDICTED: Patella vulgata splicing factor 3B subunit 1 (LOC126832243), transcript variant X1, mRNA | blastn | 258 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 25121247 | 25121247 | PRJNA915212_P_NODE_5260_length_260_cov_1.127962_g5222_i0 | PRJNA915212 | 5260 | 260 | 1.127962 | 2.9327012 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 67.6 | 8.46e-7 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g5222 | i0 | 95.349 | 13.0846153846154 | 43 | 1 | 16 | 1 | 46 | 87 | 30798773 | 30798815 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 3402 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris |
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);;