contig_metadata
9 rows where bioproject = "PRJNA1097627", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 202958 | 202958 | PRJNA1097627_P_NODE_119661_length_262_cov_0.835979_g119368_i0 | PRJNA1097627 | 119661 | 262 | 0.835979 | 2.19026498 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.024 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g119368 | i0 | 100 | 0.106870229007634 | 28 | 0 | 11 | 0 | 202 | 229 | 65001139 | 65001166 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11683926 | 11683926 | PRJNA1097627_P_NODE_164690_length_247_cov_0.885057_g164397_i0 | PRJNA1097627 | 164690 | 247 | 0.885057 | 2.18609079 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|1207981855|ref|XR_002461893.1| | 6573 | g164397 | i0 | 94.286 | 0.1417004048583 | 35 | 0 | 13 | 2 | 147 | 179 | 2964 | 2998 | PREDICTED: Mizuhopecten yessoensis uncharacterized LOC110441628 (LOC110441628), ncRNA | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 20607964 | 20607964 | PRJNA1097627_P_NODE_197937_length_242_cov_0.911243_g197644_i0 | PRJNA1097627 | 197937 | 242 | 0.911243 | 2.20520806 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 65.8 | 2.8e-6 | NTclustered | gi|2912996298|dbj|AP039601.1| | 145626 | g197644 | i0 | 88.889 | 0.223140495867769 | 54 | 4 | 22 | 2 | 103 | 156 | 52027274 | 52027223 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 20, sequence | blastn | 54 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 26972651 | 26972651 | PRJNA1097627_P_NODE_195842_length_242_cov_0.911243_g195549_i0 | PRJNA1097627 | 195842 | 242 | 0.911243 | 2.20520806 | Plakobranchus ocellatus | 259542 | Mollusca | Mollusca | 43.1 | 0.0245 | NR | GFN92605.1 | 259542 | g195549 | i0 | 45.3 | 0.65702479338843 | 53 | 29 | 65.7 | 0 | 230 | 72 | 121 | 173 | GFN92605.1 hypothetical protein PoB_001911100 [Plakobranchus ocellatus] | diamond | 159 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 28922022 | 28922022 | PRJNA1097627_P_NODE_159688_length_248_cov_0.880000_g159395_i0 | PRJNA1097627 | 159688 | 248 | 0.88 | 2.1824 | Bivalvia | 6544 | Mollusca | Mollusca | 56.2 | 4.93e-7 | NR | XP_062616134.1 | 36930 | g159395 | i0 | 38.6 | 1.97177419354839 | 83 | 50 | 99.2 | 1 | 247 | 2 | 24 | 106 | XP_062616134.1 uncharacterized protein LOC134277851 [Saccostrea cuccullata] | diamond | 489 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 29467276 | 29467276 | PRJNA1097627_P_NODE_203470_length_241_cov_0.916667_g203177_i0 | PRJNA1097627 | 203470 | 241 | 0.916667 | 2.20916747 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 72 | 1.64e-13 | NR | BFZ00183.1 | 145626 | g203177 | i0 | 50 | 2.14107883817427 | 64 | 32 | 79.7 | 0 | 196 | 5 | 88 | 151 | BFZ00183.1 hypothetical protein BsWGS_03222 [Bradybaena similaris] | diamond | 516 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 31426451 | 31426451 | PRJNA1097627_P_NODE_177316_length_245_cov_0.895349_g177023_i0 | PRJNA1097627 | 177316 | 245 | 0.895349 | 2.19360505 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 45.8 | 6.79e-4 | NR | PVD24866.1 | 400727 | g177023 | i0 | 46.5 | 0.52653061224489806 | 43 | 23 | 52.7 | 0 | 1 | 129 | 49 | 91 | PVD24866.1 hypothetical protein C0Q70_15355 [Pomacea canaliculata] | diamond | 129 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 32557011 | 32557011 | PRJNA1097627_P_NODE_200959_length_241_cov_0.916667_g200666_i0 | PRJNA1097627 | 200959 | 241 | 0.916667 | 2.20916747 | Metazoa | 33208 | Mollusca | Mollusca | 43.1 | 0.0221 | NR | XP_071137227.1 | 6550 | g200666 | i0 | 51.3 | 1.45643153526971 | 39 | 19 | 48.5 | 0 | 1 | 117 | 179 | 217 | XP_071137227.1 uncharacterized protein [Mytilus edulis] | diamond | 351 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 32880233 | 32880233 | PRJNA1097627_P_NODE_209360_length_217_cov_4.125000_g209067_i0 | PRJNA1097627 | 209360 | 217 | 4.125 | 8.95125 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 42.4 | 0.00504 | NR | KAI8727607.1 | 6526 | g209067 | i0 | 51.7 | 0.400921658986175 | 29 | 14 | 40.1 | 0 | 214 | 128 | 41 | 69 | KAI8727607.1 hypothetical protein BgiBS90_038149 [Biomphalaria glabrata] | diamond | 87 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata |
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);;