contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA635397" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6257340 | 6257340 | PRJNA635397_P_NODE_23865_length_327_cov_2.685039_g23411_i0 | PRJNA635397 | 23865 | 327 | 2.685039 | 8.78007753 | Metazoa | 33208 | Mollusca | Mollusca | 135 | 3.909999999999999e-35 | NR | XP_011445708.2 | 29159 | g23411 | i0 | 66.7 | 9.14678899082569 | 96 | 30 | 86.2 | 1 | 284 | 3 | 16 | 111 | XP_011445708.2 protein disulfide-isomerase [Magallana gigas] | diamond | 2991 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 10809869 | 10809869 | PRJNA635397_P_NODE_24089_length_326_cov_1.090909_g23635_i0 | PRJNA635397 | 24089 | 326 | 1.090909 | 3.55636334 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 62.8 | 8.03e-9 | NR | XP_045181693.2 | 6596 | g23635 | i0 | 54.2 | 0.837423312883436 | 48 | 22 | 44.2 | 0 | 326 | 183 | 320 | 367 | XP_045181693.2 uncharacterized protein LOC123540587 isoform X43 [Mercenaria mercenaria] | diamond | 273 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 26637716 | 26637716 | PRJNA635397_P_NODE_44181_length_245_cov_0.906977_g43727_i0 | PRJNA635397 | 44181 | 245 | 0.906977 | 2.22209365 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 95.9 | 5.33e-23 | NR | XP_036357561.1 | 2607531 | g43727 | i0 | 70 | 0.857142857142857 | 70 | 20 | 84.5 | 1 | 35 | 241 | 65 | 134 | XP_036357561.1 uncharacterized protein LOC118762690 [Octopus sinensis] | diamond | 210 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 26935212 | 26935212 | PRJNA635397_P_NODE_36402_length_262_cov_1.576720_g35948_i0 | PRJNA635397 | 36402 | 262 | 1.57672 | 4.1310064 | Metazoa | 33208 | Mollusca | Mollusca | 56.2 | 3.81e-7 | NR | XP_048248900.1 | 6454 | g35948 | i0 | 42 | 4.78625954198473 | 69 | 39 | 77.9 | 1 | 2 | 205 | 8 | 76 | XP_048248900.1 histone-lysine N-methyltransferase SETMAR-like [Haliotis rufescens] | diamond | 1254 | 56.6 | 0.992932862190813 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 28470661 | 28470661 | PRJNA635397_P_NODE_34286_length_270_cov_2.649746_g33832_i0 | PRJNA635397 | 34286 | 270 | 2.649746 | 7.1543142 | Octopus vulgaris | 6645 | Mollusca | Mollusca | 45.8 | 0.00128 | NR | CAI9738083.1 | 6645 | g33832 | i0 | 60 | 0.444444444444444 | 40 | 13 | 44.4 | 1 | 65 | 184 | 8 | 44 | CAI9738083.1 Hypothetical predicted protein [Octopus vulgaris] | diamond | 120 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 28691786 | 28691786 | PRJNA635397_P_NODE_47947_length_229_cov_2.314103_g47493_i0 | PRJNA635397 | 47947 | 229 | 2.314103 | 5.29929587 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 43.1 | 0.0233 | NR | XP_048258469.1 | 6454 | g47493 | i0 | 68.2 | 3.75982532751092 | 22 | 7 | 28.8 | 0 | 204 | 139 | 667 | 688 | XP_048258469.1 prestalk protein-like isoform X2 [Haliotis rufescens] | diamond | 861 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 29512314 | 29512314 | PRJNA635397_P_NODE_34030_length_271_cov_2.823232_g33576_i0 | PRJNA635397 | 34030 | 271 | 2.823232 | 7.65095872 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 43.1 | 0.0273 | NR | KAK7107423.1 | 31220 | g33576 | i0 | 63.3 | 0.664206642066421 | 30 | 11 | 33.2 | 0 | 219 | 130 | 164 | 193 | KAK7107423.1 hypothetical protein V1264_015357 [Littorina saxatilis] | diamond | 180 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 30175648 | 30175648 | PRJNA635397_P_NODE_44672_length_244_cov_1.929825_g44218_i0 | PRJNA635397 | 44672 | 244 | 1.929825 | 4.708773 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 68.2 | 3.4e-12 | NR | XP_029653509.1 | 2607531 | g44218 | i0 | 59.3 | 0.725409836065574 | 59 | 24 | 72.5 | 0 | 224 | 48 | 1 | 59 | XP_029653509.1 uncharacterized protein LOC115226637 [Octopus sinensis] | diamond | 177 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 30219762 | 30219762 | PRJNA635397_P_NODE_47212_length_237_cov_2.689024_g46758_i0 | PRJNA635397 | 47212 | 237 | 2.689024 | 6.37298688 | Metazoa | 33208 | Mollusca | Mollusca | 85.5 | 1.29e-17 | NR | XP_065936763.1 | 29159 | g46758 | i0 | 61.5 | 4.21518987341772 | 65 | 25 | 82.3 | 0 | 219 | 25 | 211 | 275 | XP_065936763.1 nucleoredoxin isoform X2 [Magallana gigas] | diamond | 999 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 30365723 | 30365723 | PRJNA635397_P_NODE_20732_length_354_cov_1.177936_g20278_i0 | PRJNA635397 | 20732 | 354 | 1.177936 | 4.16989344 | Elysia marginata | 1093978 | Mollusca | Mollusca | 97.4 | 2.54e-22 | NR | GFR70878.1 | 1093978 | g20278 | i0 | 64.7 | 0.576271186440678 | 68 | 24 | 57.6 | 0 | 353 | 150 | 150 | 217 | GFR70878.1 PiggyBac transposase Uribo2 [Elysia marginata] | diamond | 204 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 31610554 | 31610554 | PRJNA635397_P_NODE_32356_length_279_cov_1.339806_g31902_i0 | PRJNA635397 | 32356 | 279 | 1.339806 | 3.73805874 | Octopus | 6643 | Mollusca | Mollusca | 134 | 3.8199999999999997e-34 | NR | CAI9720287.1 | 6645 | g31902 | i0 | 66.3 | 1.97849462365591 | 92 | 31 | 98.9 | 0 | 277 | 2 | 518 | 609 | CAI9720287.1 and LDL-receptor class A domain-containing 2-like [Octopus vulgaris] | diamond | 552 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 31819265 | 31819265 | PRJNA635397_P_NODE_47537_length_233_cov_3.487500_g47083_i0 | PRJNA635397 | 47537 | 233 | 3.4875 | 8.125875 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 77.8 | 5.1e-16 | NR | XP_041364231.1 | 1735272 | g47083 | i0 | 47.6 | 1.08154506437768 | 84 | 37 | 99.1 | 2 | 231 | 1 | 16 | 99 | XP_041364231.1 histone-lysine N-methyltransferase SETMAR-like [Gigantopelta aegis] | diamond | 252 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 32388874 | 32388874 | PRJNA635397_P_NODE_11499_length_507_cov_1.082949_g11046_i0 | PRJNA635397 | 11499 | 507 | 1.082949 | 5.49055143 | Haliotis rubra | 36100 | Mollusca | Mollusca | 53.1 | 1.39e-4 | NR | XP_046584638.1 | 36100 | g11046 | i0 | 61.8 | 1.2189349112426 | 34 | 13 | 20.1 | 0 | 504 | 403 | 1312 | 1345 | XP_046584638.1 uncharacterized protein LOC124291626 [Haliotis rubra] | diamond | 618 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra |
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);;