contig_metadata
14 rows where bioproject = "PRJNA1111077", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2765577 | 2765577 | PRJNA1111077_P_NODE_32723_length_247_cov_1.137931_g32502_i0 | PRJNA1111077 | 32723 | 247 | 1.137931 | 2.81068957 | Metazoa | 33208 | Mollusca | Mollusca | 122 | 4.82e-31 | NR | XP_063427957.1 | 6551 | g32502 | i0 | 76.3 | 25.1902834008097 | 80 | 19 | 97.2 | 0 | 6 | 245 | 172 | 251 | XP_063427957.1 methylmalonate-semialdehyde/malonate-semialdehyde dehydrogenase [acylating], mitochondrial-like isoform X2 [Mytilus trossulus] | diamond | 6222 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 5317797 | 5317797 | PRJNA1111077_P_NODE_33725_length_246_cov_0.890173_g33504_i0 | PRJNA1111077 | 33725 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 137 | 3.68e-37 | NR | XP_064616951.1 | 13599 | g33504 | i0 | 80.2 | 13.8292682926829 | 81 | 16 | 98.8 | 0 | 245 | 3 | 227 | 307 | XP_064616951.1 deoxyhypusine synthase-like [Liolophura japonica] | diamond | 3402 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 9142577 | 9142577 | PRJNA1111077_P_NODE_35908_length_242_cov_0.911243_g35687_i0 | PRJNA1111077 | 35908 | 242 | 0.911243 | 2.20520806 | Mytilus californianus | 6549 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2334724280|ref|XR_007999694.1| | 6549 | g35687 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 130 | 157 | 87 | 60 | PREDICTED: Mytilus californianus uncharacterized LOC127737575 (LOC127737575), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 10418305 | 10418305 | PRJNA1111077_P_NODE_31169_length_249_cov_2.863636_g30948_i0 | PRJNA1111077 | 31169 | 249 | 2.863636 | 7.13045364 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2364391502|ref|XR_008043068.1| | 45954 | g30948 | i0 | 94.595 | 0.14859437751004 | 37 | 0 | 15 | 1 | 107 | 143 | 1412 | 1446 | PREDICTED: Dreissena polymorpha uncharacterized LOC127866694 (LOC127866694), ncRNA | blastn | 37 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 15048837 | 15048837 | PRJNA1111077_P_NODE_29712_length_252_cov_1.720670_g29491_i0 | PRJNA1111077 | 29712 | 252 | 1.72067 | 4.3360884 | Metazoa | 33208 | Mollusca | Mollusca | 122 | 1.7199999999999995e-23 | NTclustered | gi|1397688525|ref|XR_003099086.1| | 400727 | g29491 | i0 | 79.121 | 92.8015873015873 | 182 | 34 | 72 | 4 | 71 | 251 | 1716 | 1894 | PREDICTED: Pomacea canaliculata uncharacterized LOC112563628 (LOC112563628), ncRNA | blastn | 23386 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 20615823 | 20615823 | PRJNA1111077_P_NODE_23337_length_276_cov_1.216749_g23116_i0 | PRJNA1111077 | 23337 | 276 | 1.216749 | 3.35822724 | Argopecten irradians | 31199 | Mollusca | Mollusca | 52.8 | 0.025 | NTclustered | gi|2835348096|ref|XR_011205747.1| | 31199 | g23116 | i0 | 100 | 0.101449275362319 | 28 | 0 | 10 | 0 | 207 | 234 | 2910 | 2937 | PREDICTED: Argopecten irradians uncharacterized lncRNA (LOC138305976), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 27194092 | 27194092 | PRJNA1111077_P_NODE_37902_length_228_cov_4.883871_g37681_i0 | PRJNA1111077 | 37902 | 228 | 4.883871 | 11.13522588 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 80.1 | 4.39e-17 | NR | XP_060563191.1 | 129788 | g37681 | i0 | 72.7 | 2.97368421052632 | 55 | 14 | 72.4 | 1 | 166 | 2 | 7 | 60 | XP_060563191.1 small ribosomal subunit protein eS12-like [Ruditapes philippinarum] | diamond | 678 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 28330999 | 28330999 | PRJNA1111077_P_NODE_34106_length_245_cov_0.895349_g33885_i0 | PRJNA1111077 | 34106 | 245 | 0.895349 | 2.19360505 | Haliotis asinina | 109174 | Mollusca | Mollusca | 77.8 | 1.11e-14 | NR | XP_067661214.1 | 109174 | g33885 | i0 | 56.9 | 1.44489795918367 | 58 | 25 | 71 | 0 | 67 | 240 | 176 | 233 | XP_067661214.1 uncharacterized protein [Haliotis asinina] | diamond | 354 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 30067695 | 30067695 | PRJNA1111077_P_NODE_24372_length_272_cov_1.547739_g24151_i0 | PRJNA1111077 | 24372 | 272 | 1.547739 | 4.20985008 | Elysia marginata | 1093978 | Mollusca | Mollusca | 107 | 2.2000000000000004e-28 | NR | GFS19501.1 | 1093978 | g24151 | i0 | 77.8 | 4.16911764705882 | 54 | 12 | 59.6 | 0 | 236 | 75 | 1 | 54 | GFS19501.1 40S ribosomal protein S29 [Elysia marginata] | diamond | 1134 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 30573032 | 30573032 | PRJNA1111077_P_NODE_26573_length_264_cov_2.078534_g26352_i0 | PRJNA1111077 | 26573 | 264 | 2.078534 | 5.48732976 | Plakobranchus ocellatus | 259542 | Mollusca | Mollusca | 121 | 8.39e-32 | NR | GFO28288.1 | 259542 | g26352 | i0 | 67 | 2 | 88 | 29 | 100 | 0 | 1 | 264 | 160 | 247 | GFO28288.1 40S ribosomal protein s4 [Plakobranchus ocellatus] | diamond | 528 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 31047518 | 31047518 | PRJNA1111077_P_NODE_33135_length_247_cov_0.862069_g32914_i0 | PRJNA1111077 | 33135 | 247 | 0.862069 | 2.12931043 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 62 | 5.7e-9 | NR | XP_025098906.1 | 400727 | g32914 | i0 | 51.9 | 2.55060728744939 | 54 | 25 | 65.6 | 1 | 36 | 197 | 227 | 279 | XP_025098906.1 uncharacterized protein LOC112566770 [Pomacea canaliculata] | diamond | 630 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 31490102 | 31490102 | PRJNA1111077_P_NODE_15216_length_310_cov_3.493671_g14995_i0 | PRJNA1111077 | 15216 | 310 | 3.493671 | 10.8303801 | Elysia marginata | 1093978 | Mollusca | Mollusca | 42.7 | 0.0193 | NR | GFR89773.1 | 1093978 | g14995 | i0 | 56.3 | 0.309677419354839 | 32 | 13 | 30 | 1 | 56 | 148 | 71 | 102 | GFR89773.1 endonuclease domain of the non-LTR retrotransposon LINE-1 [Elysia marginata] | diamond | 96 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 31521642 | 31521642 | PRJNA1111077_P_NODE_26896_length_263_cov_1.621053_g26675_i0 | PRJNA1111077 | 26896 | 263 | 1.621053 | 4.26336939 | Liolophura japonica | 13599 | Mollusca | Mollusca | 56.6 | 6.26e-7 | NR | XP_064594452.1 | 13599 | g26675 | i0 | 42.4 | 1.57414448669202 | 66 | 38 | 75.3 | 0 | 40 | 237 | 760 | 825 | XP_064594452.1 EF-hand calcium-binding domain-containing protein 6-like isoform X2 [Liolophura japonica] | diamond | 414 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 32597128 | 32597128 | PRJNA1111077_P_NODE_18900_length_290_cov_2.036866_g18679_i0 | PRJNA1111077 | 18900 | 290 | 2.036866 | 5.9069114 | Lottia gigantea | 225164 | Mollusca | Mollusca | 44.3 | 0.0177 | NR | XP_009060892.1 | 225164 | g18679 | i0 | 52.6 | 0.76551724137931 | 38 | 13 | 37.2 | 2 | 1 | 108 | 24 | 58 | XP_009060892.1 hypothetical protein LOTGIDRAFT_219211 [Lottia gigantea] | diamond | 222 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea |
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);;