contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA841653" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5933345 | 5933345 | PRJNA841653_P_NODE_19565_length_369_cov_1.496622_g18893_i0 | PRJNA841653 | 19565 | 369 | 1.496622 | 5.52253518 | Opisthokonta | 33154 | Mollusca | Mollusca | 145 | 1.03e-42 | NR | XP_046335941.1 | 6454 | g18893 | i0 | 72 | 16.609756097561 | 93 | 26 | 75.6 | 0 | 49 | 327 | 1 | 93 | XP_046335941.1 60S ribosomal protein L37-like [Haliotis rufescens] | diamond | 6129 | 146 | 0.993150684931507 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 26643012 | 26643012 | PRJNA841653_P_NODE_29161_length_302_cov_0.991266_g28487_i0 | PRJNA841653 | 29161 | 302 | 0.991266 | 2.99362332 | Liolophura japonica | 13599 | Mollusca | Mollusca | 47.8 | 0.00135 | NR | XP_064605195.1 | 13599 | g28487 | i0 | 62.1 | 2.25496688741722 | 29 | 11 | 28.8 | 0 | 216 | 302 | 802 | 830 | XP_064605195.1 neurogenic locus notch homolog protein 1-like [Liolophura japonica] | diamond | 681 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 26936524 | 26936524 | PRJNA841653_P_NODE_56962_length_244_cov_0.900585_g56288_i0 | PRJNA841653 | 56962 | 244 | 0.900585 | 2.1974274 | Ostreidae | 6563 | Mollusca | Mollusca | 55.1 | 1.61e-6 | NR | XP_011437841.3 | 29159 | g56288 | i0 | 54.2 | 3.57786885245902 | 48 | 22 | 59 | 0 | 215 | 72 | 311 | 358 | XP_011437841.3 hydroxyproline dehydrogenase [Magallana gigas] | diamond | 873 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 26959610 | 26959610 | PRJNA841653_P_NODE_46582_length_249_cov_1.397727_g45908_i0 | PRJNA841653 | 46582 | 249 | 1.397727 | 3.48034023 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 73.2 | 7.64e-13 | NR | CAC5424730.1 | 42192 | g45908 | i0 | 52.4 | 16.6987951807229 | 63 | 30 | 75.9 | 0 | 54 | 242 | 816 | 878 | CAC5424730.1 Retrovirus-related Pol polyprotein from transposon 297 [Mytilus coruscus] | diamond | 4158 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 27434175 | 27434175 | PRJNA841653_P_NODE_49683_length_248_cov_0.880000_g49009_i0 | PRJNA841653 | 49683 | 248 | 0.88 | 2.1824 | Magallana angulata | 2784310 | Mollusca | Mollusca | 42.7 | 0.0402 | NR | XP_052699955.1 | 2784310 | g49009 | i0 | 38.1 | 0.762096774193548 | 63 | 39 | 76.2 | 0 | 211 | 23 | 12 | 74 | XP_052699955.1 CWF19-like protein 2 [Magallana angulata] | diamond | 189 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana angulata | |
| 27497164 | 27497164 | PRJNA841653_P_NODE_30583_length_294_cov_3.167421_g29909_i0 | PRJNA841653 | 30583 | 294 | 3.167421 | 9.31221774 | Haliotis asinina | 109174 | Mollusca | Mollusca | 43.5 | 0.0348 | NR | XP_067657806.1 | 109174 | g29909 | i0 | 35.4 | 1.30612244897959 | 65 | 36 | 65.3 | 2 | 237 | 46 | 144 | 203 | XP_067657806.1 uncharacterized protein [Haliotis asinina] | diamond | 384 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 28294835 | 28294835 | PRJNA841653_P_NODE_52026_length_246_cov_0.890173_g51352_i0 | PRJNA841653 | 52026 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Mollusca | Mollusca | 67.4 | 8.21e-11 | NR | XP_052815901.1 | 6604 | g51352 | i0 | 45.7 | 19.6707317073171 | 70 | 35 | 81.7 | 1 | 19 | 219 | 23 | 92 | XP_052815901.1 TBC domain-containing protein kinase-like protein [Mya arenaria] | diamond | 4839 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 29242139 | 29242139 | PRJNA841653_P_NODE_49969_length_247_cov_1.431034_g49295_i0 | PRJNA841653 | 49969 | 247 | 1.431034 | 3.53465398 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 84.7 | 6.38e-17 | NR | KAH3730688.1 | 45954 | g49295 | i0 | 57.6 | 10.2753036437247 | 66 | 27 | 78.9 | 1 | 209 | 15 | 774 | 839 | KAH3730688.1 hypothetical protein DPMN_056680 [Dreissena polymorpha] | diamond | 2538 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 29336873 | 29336873 | PRJNA841653_P_NODE_45329_length_250_cov_0.870056_g44655_i0 | PRJNA841653 | 45329 | 250 | 0.870056 | 2.17514 | Metazoa | 33208 | Mollusca | Mollusca | 112 | 1.62e-26 | NR | XP_033763152.1 | 6579 | g44655 | i0 | 56.8 | 5.82 | 81 | 35 | 97.2 | 0 | 244 | 2 | 521 | 601 | XP_033763152.1 methylenetetrahydrofolate reductase-like [Pecten maximus] | diamond | 1455 | 113 | 0.991150442477876 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 30789821 | 30789821 | PRJNA841653_P_NODE_38254_length_266_cov_1.958549_g37580_i0 | PRJNA841653 | 38254 | 266 | 1.958549 | 5.20974034 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 81.3 | 1.39e-15 | NR | KAK6169422.1 | 87958 | g37580 | i0 | 50.6 | 6.68796992481203 | 85 | 40 | 94.7 | 2 | 13 | 264 | 683 | 766 | KAK6169422.1 hypothetical protein SNE40_020482 [Patella caerulea] | diamond | 1779 | 82 | 0.991463414634146 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 30916405 | 30916405 | PRJNA841653_P_NODE_41854_length_255_cov_1.390110_g41180_i0 | PRJNA841653 | 41854 | 255 | 1.39011 | 3.5447805 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 64.3 | 1.08e-9 | NR | CAC5424730.1 | 42192 | g41180 | i0 | 60.9 | 16.8235294117647 | 46 | 18 | 54.1 | 0 | 62 | 199 | 854 | 899 | CAC5424730.1 Retrovirus-related Pol polyprotein from transposon 297 [Mytilus coruscus] | diamond | 4290 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 31286869 | 31286869 | PRJNA841653_P_NODE_43535_length_251_cov_0.865169_g42861_i0 | PRJNA841653 | 43535 | 251 | 0.865169 | 2.17157419 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 55.8 | 3.95e-7 | NR | RUS88897.1 | 188477 | g42861 | i0 | 43.7 | 0.848605577689243 | 71 | 28 | 84.9 | 2 | 247 | 35 | 57 | 115 | RUS88897.1 hypothetical protein EGW08_003336 [Elysia chlorotica] | diamond | 213 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica |
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);;