contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA285816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6749648 | 6749648 | PRJNA285816_S_NODE_18086_length_187_cov_1.282609_g17984_i0 | PRJNA285816 | 18086 | 187 | 1.282609 | 2.39847883 | Haliotis rubra | 36100 | Mollusca | Mollusca | 52.8 | 0.016 | NTclustered | gi|2194138492|ref|XM_046725257.1| | 36100 | g17984 | i0 | 100 | 0.149732620320856 | 28 | 0 | 15 | 0 | 74 | 101 | 1630 | 1603 | PREDICTED: Haliotis rubra tRNA:m(4)X modification enzyme TRM13 homolog (LOC124288689), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 6749686 | 6749686 | PRJNA285816_S_NODE_20786_length_178_cov_1.193798_g20684_i0 | PRJNA285816 | 20786 | 178 | 1.193798 | 2.12496044 | Mytilus edulis | 6550 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2912365750|ref|XM_071293913.1| | 6550 | g20684 | i0 | 92.105 | 0.426966292134831 | 38 | 3 | 21 | 0 | 129 | 166 | 2458 | 2421 | PREDICTED: Mytilus edulis uncharacterized protein (LOC139503905), transcript variant X1, mRNA | blastn | 76 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 9300130 | 9300130 | PRJNA285816_S_NODE_26508_length_166_cov_0.863248_g26406_i0 | PRJNA285816 | 26508 | 166 | 0.863248 | 1.43299168 | Pecten maximus | 6579 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|1835541798|ref|XM_033877950.1| | 6579 | g26406 | i0 | 100 | 0.168674698795181 | 28 | 0 | 17 | 0 | 23 | 50 | 232 | 205 | PREDICTED: Pecten maximus ribosomal protein S6 kinase delta-1-like (LOC117322978), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 10576094 | 10576094 | PRJNA285816_S_NODE_7889_length_253_cov_5.720588_g7787_i0 | PRJNA285816 | 7889 | 253 | 5.720588 | 14.47308764 | Argopecten irradians | 31199 | Mollusca | Mollusca | 135 | 2.22e-27 | NTclustered | gi|2835350600|ref|XM_069247595.1| | 31199 | g7787 | i0 | 94.318 | 35.098814229249 | 88 | 5 | 35 | 0 | 166 | 253 | 1442 | 1355 | PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA | blastn | 8880 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 13125677 | 13125677 | PRJNA285816_S_NODE_10091_length_230_cov_1.414365_g9989_i0 | PRJNA285816 | 10091 | 230 | 1.414365 | 3.2530395 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 154 | 5.47e-33 | NTclustered | gi|2034310820|ref|XM_041496923.1| | 1735272 | g9989 | i0 | 79.204 | 12.004347826087 | 226 | 43 | 97 | 3 | 5 | 228 | 797 | 574 | PREDICTED: Gigantopelta aegis eukaryotic initiation factor 4A-III (LOC121371205), mRNA | blastn | 2761 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 13812526 | 13812526 | PRJNA285816_S_NODE_23431_length_170_cov_1.429752_g23329_i0 | PRJNA285816 | 23431 | 170 | 1.429752 | 2.4305784 | Haliotis | 6452 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2194141056|ref|XM_046726558.1| | 36100 | g23329 | i0 | 100 | 0.529411764705882 | 30 | 0 | 18 | 0 | 33 | 62 | 2165 | 2136 | PREDICTED: Haliotis rubra circularly permutated Ras protein 1-like (LOC124289886), mRNA | blastn | 90 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 15674586 | 15674586 | PRJNA285816_S_NODE_1193_length_598_cov_3.535519_g1102_i0 | PRJNA285816 | 1193 | 598 | 3.535519 | 21.14240362 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.016 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g1102 | i0 | 96.875 | 0.0535117056856187 | 32 | 1 | 5 | 0 | 201 | 232 | 32731178 | 32731209 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16949264 | 16949264 | PRJNA285816_S_NODE_13854_length_205_cov_3.070513_g13752_i0 | PRJNA285816 | 13854 | 205 | 3.070513 | 6.29455165 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 84.2 | 6.35e-12 | NTclustered | gi|2628519802|ref|XM_061333501.1| | 191078 | g13752 | i0 | 89.394 | 5.47317073170732 | 66 | 7 | 32 | 0 | 132 | 197 | 373 | 438 | PREDICTED: Saccostrea echinata serine/threonine-protein kinase 25-like (LOC133197455), transcript variant X1, mRNA | blastn | 1122 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 16949291 | 16949291 | PRJNA285816_S_NODE_16014_length_195_cov_1.561644_g15912_i0 | PRJNA285816 | 16014 | 195 | 1.561644 | 3.0452058 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 89.8 | 1.28e-13 | NTclustered | gi|2034325316|ref|XM_041504595.1| | 1735272 | g15912 | i0 | 77.711 | 2.55384615384615 | 166 | 24 | 82 | 11 | 6 | 164 | 2441 | 2600 | PREDICTED: Gigantopelta aegis pumilio homolog 1-like (LOC121376823), transcript variant X1, mRNA | blastn | 498 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 19497802 | 19497802 | PRJNA285816_S_NODE_10216_length_229_cov_1.372222_g10114_i0 | PRJNA285816 | 10216 | 229 | 1.372222 | 3.14238838 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.02 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g10114 | i0 | 100 | 0.122270742358079 | 28 | 0 | 12 | 0 | 130 | 157 | 2800684 | 2800657 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20185191 | 20185191 | PRJNA285816_S_NODE_25916_length_166_cov_1.743590_g25814_i0 | PRJNA285816 | 25916 | 166 | 1.74359 | 2.8943594 | Metazoa | 33208 | Mollusca | Mollusca | 154 | 3.699999999999999e-33 | NTclustered | gi|2694137160|ref|XM_063544444.1| | 6551 | g25814 | i0 | 85.235 | 22.4879518072289 | 149 | 22 | 90 | 0 | 3 | 151 | 899 | 1047 | PREDICTED: Mytilus trossulus ruvB-like 2 (LOC134685059), transcript variant X1, mRNA | blastn | 3733 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 23323955 | 23323955 | PRJNA285816_S_NODE_15979_length_195_cov_2.089041_g15877_i0 | PRJNA285816 | 15979 | 195 | 2.089041 | 4.07362995 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 1.01e-4 | NTclustered | gi|2912985489|dbj|AP039590.1| | 145626 | g15877 | i0 | 100 | 0.476923076923077 | 32 | 0 | 16 | 0 | 27 | 58 | 22953607 | 22953638 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence | blastn | 93 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24598175 | 24598175 | PRJNA285816_S_NODE_26120_length_166_cov_1.111111_g26018_i0 | PRJNA285816 | 26120 | 166 | 1.111111 | 1.84444426 | Mytilisepta virgata | 2547956 | Mollusca | Mollusca | 150 | 4.79e-32 | NTclustered | gi|1000231775|dbj|LC075727.1| | 2547956 | g26018 | i0 | 84.667 | 29.855421686747 | 150 | 23 | 90 | 0 | 17 | 166 | 170 | 21 | Mytilisepta virgata mRNA for actin, partial cds | blastn | 4956 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilisepta | Mytilisepta virgata |
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);;