contig_metadata
21 rows where bioproject = "PRJEB55122", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6499555 | 6499555 | PRJEB55122_P_NODE_4146_length_750_cov_1.770328_g3814_i0 | PRJEB55122 | 4146 | 750 | 1.770328 | 13.27746 | Metazoa | 33208 | Mollusca | Mollusca | 194 | 2.4199999999999997e-56 | NR | XP_064616763.1 | 13599 | g3814 | i0 | 46.3 | 19.068 | 227 | 100 | 87.6 | 8 | 750 | 94 | 143 | 355 | XP_064616763.1 procathepsin L-like [Liolophura japonica] | diamond | 14301 | 194 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 9048248 | 9048248 | PRJEB55122_P_NODE_29748_length_193_cov_0.888889_g29351_i0 | PRJEB55122 | 29748 | 193 | 0.888889 | 1.71555577 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 63.9 | 7.69e-6 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g29351 | i0 | 97.297 | 13.3212435233161 | 37 | 1 | 19 | 0 | 21 | 57 | 5279422 | 5279458 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence | blastn | 2571 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11195109 | 11195109 | PRJEB55122_P_NODE_13149_length_333_cov_1.056338_g12752_i0 | PRJEB55122 | 13149 | 333 | 1.056338 | 3.51760554 | Metazoa | 33208 | Mollusca | Mollusca | 276 | 1.71e-69 | NTclustered | gi|2572439903|ref|XM_059287523.1| | 109671 | g12752 | i0 | 83.793 | 87.7207207207207 | 290 | 47 | 87 | 0 | 4 | 293 | 731 | 1020 | PREDICTED: Physella acuta endoplasmic reticulum chaperone BiP (LOC131930863), mRNA | blastn | 29211 | 278 | 0.992805755395683 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 12874506 | 12874506 | PRJEB55122_P_NODE_28471_length_198_cov_1.355705_g28074_i0 | PRJEB55122 | 28471 | 198 | 1.355705 | 2.6842959 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 128 | 2.77e-25 | NTclustered | gi|2592068471|ref|XM_060214011.1| | 509963 | g28074 | i0 | 78.836 | 9.76262626262626 | 189 | 40 | 95 | 0 | 10 | 198 | 98 | 286 | PREDICTED: Ylistrum balloti large ribosomal subunit protein eL30 (LOC132550014), mRNA | blastn | 1933 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 18843340 | 18843340 | PRJEB55122_P_NODE_11475_length_368_cov_1.222571_g11078_i0 | PRJEB55122 | 11475 | 368 | 1.222571 | 4.49906128 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 174 | 2.11e-53 | NR | XP_025086345.1 | 400727 | g11078 | i0 | 68.7 | 7.6304347826087 | 115 | 36 | 93.8 | 0 | 356 | 12 | 1 | 115 | XP_025086345.1 LOW QUALITY PROTEIN: 40S ribosomal protein S11-like [Pomacea canaliculata] | diamond | 2808 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 21797962 | 21797962 | PRJEB55122_P_NODE_38098_length_167_cov_2.203390_g37701_i0 | PRJEB55122 | 38098 | 167 | 2.20339 | 3.6796613 | Physella acuta | 109671 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|2572411827|ref|XM_059320587.1| | 109671 | g37701 | i0 | 96.774 | 0.18562874251497 | 31 | 1 | 19 | 0 | 7 | 37 | 2135 | 2165 | PREDICTED: Physella acuta uncharacterized LOC131956164 (LOC131956164), mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 24346886 | 24346886 | PRJEB55122_P_NODE_30280_length_191_cov_1.098592_g29883_i0 | PRJEB55122 | 30280 | 191 | 1.098592 | 2.09831072 | Sypharochiton sinclairi | 1117399 | Mollusca | Mollusca | 115 | 2.07e-21 | NTclustered | gi|642276541|ref|NC_024173.1| | 1117399 | g29883 | i0 | 89.13 | 50.0314136125654 | 92 | 10 | 48 | 0 | 2 | 93 | 9475 | 9384 | Sypharochiton sinclairi mitochondrion, complete genome | blastn | 9556 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Sypharochiton | Sypharochiton sinclairi | |
| 28044289 | 28044289 | PRJEB55122_P_NODE_42345_length_163_cov_0.912281_g41948_i0 | PRJEB55122 | 42345 | 163 | 0.912281 | 1.48701803 | Solemya velum | 13268 | Mollusca | Mollusca | 59.7 | 1.33e-8 | NR | KAL5020892.1 | 13268 | g41948 | i0 | 52.2 | 2.5398773006135 | 46 | 22 | 84.7 | 0 | 25 | 162 | 937 | 982 | KAL5020892.1 hypothetical protein ScPMuIL_000047 [Solemya velum] | diamond | 414 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 28328363 | 28328363 | PRJEB55122_P_NODE_35986_length_170_cov_2.396694_g35589_i0 | PRJEB55122 | 35986 | 170 | 2.396694 | 4.0743798 | Patella caerulea | 87958 | Mollusca | Mollusca | 42 | 0.0253 | NR | KAK6167844.1 | 87958 | g35589 | i0 | 53.8 | 2.06470588235294 | 39 | 16 | 68.8 | 1 | 131 | 15 | 174 | 210 | KAK6167844.1 hypothetical protein SNE40_021781 [Patella caerulea] | diamond | 351 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 28960206 | 28960206 | PRJEB55122_P_NODE_36168_length_170_cov_1.355372_g35771_i0 | PRJEB55122 | 36168 | 170 | 1.355372 | 2.3041324 | Mya arenaria | 6604 | Mollusca | Mollusca | 44.7 | 0.00246 | NR | WAR10781.1 | 6604 | g35771 | i0 | 58.8 | 1.2 | 34 | 14 | 60 | 0 | 38 | 139 | 171 | 204 | WAR10781.1 hypothetical protein MAR_035857, partial [Mya arenaria] | diamond | 204 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 30002125 | 30002125 | PRJEB55122_P_NODE_21571_length_236_cov_1.641711_g21174_i0 | PRJEB55122 | 21571 | 236 | 1.641711 | 3.87443796 | Mya arenaria | 6604 | Mollusca | Mollusca | 88.2 | 3.38e-18 | NR | WAR03769.1 | 6604 | g21174 | i0 | 50 | 1.93220338983051 | 76 | 37 | 96.6 | 1 | 9 | 236 | 204 | 278 | WAR03769.1 hypothetical protein MAR_010327 [Mya arenaria] | diamond | 456 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 30033679 | 30033679 | PRJEB55122_P_NODE_43731_length_162_cov_0.920354_g43334_i0 | PRJEB55122 | 43731 | 162 | 0.920354 | 1.49097348 | Elysia marginata | 1093978 | Mollusca | Mollusca | 44.7 | 8.82e-4 | NR | GFR68823.1 | 1093978 | g43334 | i0 | 51.4 | 1.90740740740741 | 37 | 18 | 68.5 | 0 | 2 | 112 | 48 | 84 | GFR68823.1 hypothetical protein ElyMa_003743900 [Elysia marginata] | diamond | 309 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 30065040 | 30065040 | PRJEB55122_P_NODE_22152_length_232_cov_1.469945_g21755_i0 | PRJEB55122 | 22152 | 232 | 1.469945 | 3.4102724 | Bulinus truncatus | 55810 | Mollusca | Mollusca | 42.7 | 0.0292 | NR | KAH9494694.1 | 55810 | g21755 | i0 | 45.5 | 0.568965517241379 | 44 | 20 | 51.7 | 1 | 105 | 224 | 113 | 156 | KAH9494694.1 hypothetical protein Btru_020264 [Bulinus truncatus] | diamond | 132 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 30159714 | 30159714 | PRJEB55122_P_NODE_8652_length_451_cov_1.492537_g8258_i0 | PRJEB55122 | 8652 | 451 | 1.492537 | 6.73134187 | Liolophura japonica | 13599 | Mollusca | Mollusca | 80.1 | 2.35e-14 | NR | XP_064600905.1 | 13599 | g8258 | i0 | 38.9 | 0.87139689578714 | 131 | 74 | 85.1 | 2 | 61 | 444 | 214 | 341 | XP_064600905.1 mannan endo-1,4-beta-mannosidase-like [Liolophura japonica] | diamond | 393 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 30602144 | 30602144 | PRJEB55122_P_NODE_40113_length_165_cov_1.793103_g39716_i0 | PRJEB55122 | 40113 | 165 | 1.793103 | 2.95861995 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 64.3 | 3.03e-10 | NR | XP_041366930.1 | 1735272 | g39716 | i0 | 58.5 | 0.963636363636364 | 53 | 20 | 92.7 | 1 | 155 | 3 | 170 | 222 | XP_041366930.1 phospholipase B1, membrane-associated-like [Gigantopelta aegis] | diamond | 159 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 31360898 | 31360898 | PRJEB55122_P_NODE_16836_length_278_cov_3.117904_g16439_i0 | PRJEB55122 | 16836 | 278 | 3.117904 | 8.66777312 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 105 | 1.39e-24 | NR | XP_052270304.1 | 45954 | g16439 | i0 | 56.5 | 2.97841726618705 | 92 | 35 | 98.2 | 2 | 1 | 273 | 170 | 257 | XP_052270304.1 GPN-loop GTPase 1-like [Dreissena polymorpha] | diamond | 828 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 32144889 | 32144889 | PRJEB55122_P_NODE_41398_length_164_cov_0.904348_g41001_i0 | PRJEB55122 | 41398 | 164 | 0.904348 | 1.48313072 | Stylommatophora | 6527 | Mollusca | Mollusca | 86.7 | 3.97e-18 | NR | CAG5115485.1 | 100452 | g41001 | i0 | 72.2 | 4.9390243902439 | 54 | 15 | 98.8 | 0 | 162 | 1 | 412 | 465 | CAG5115485.1 unnamed protein product [Candidula unifasciata] | diamond | 810 | 87.4 | 0.991990846681922 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 32531473 | 32531473 | PRJEB55122_P_NODE_26999_length_205_cov_0.948718_g26602_i0 | PRJEB55122 | 26999 | 205 | 0.948718 | 1.9448719 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 90.1 | 1.24e-19 | NR | CAE1152357.1 | 158019 | g26602 | i0 | 55.9 | 12.9365853658537 | 68 | 30 | 99.5 | 0 | 205 | 2 | 35 | 102 | CAE1152357.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 2652 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 32814802 | 32814802 | PRJEB55122_P_NODE_27600_length_202_cov_1.071895_g27203_i0 | PRJEB55122 | 27600 | 202 | 1.071895 | 2.1652279 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 58.9 | 4.23e-8 | NR | XP_053398538.1 | 6596 | g27203 | i0 | 44.8 | 0.995049504950495 | 67 | 37 | 99.5 | 0 | 202 | 2 | 271 | 337 | XP_053398538.1 uncharacterized protein LOC123550611 [Mercenaria mercenaria] | diamond | 201 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 32839471 | 32839471 | PRJEB55122_P_NODE_25220_length_213_cov_2.286585_g24823_i0 | PRJEB55122 | 25220 | 213 | 2.286585 | 4.87042605 | Metazoa | 33208 | Mollusca | Mollusca | 141 | 4.359999999999999e-41 | NR | XP_060589897.1 | 129788 | g24823 | i0 | 88.7 | 86.8169014084507 | 71 | 8 | 100 | 0 | 1 | 213 | 5 | 75 | XP_060589897.1 eukaryotic translation initiation factor 5A-1-like [Ruditapes philippinarum] | diamond | 18492 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 32839472 | 32839472 | PRJEB55122_P_NODE_31260_length_187_cov_1.384058_g30863_i0 | PRJEB55122 | 31260 | 187 | 1.384058 | 2.58818846 | Metazoa | 33208 | Mollusca | Mollusca | 42.4 | 0.025 | NR | XP_069139124.1 | 31199 | g30863 | i0 | 40.7 | 1.74866310160428 | 54 | 32 | 86.6 | 0 | 2 | 163 | 60 | 113 | XP_069139124.1 toll-like receptor 4 [Argopecten irradians] | diamond | 327 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians |
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);;