contig_metadata
9 rows where bioproject = "PRJNA1012699", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9085564 | 9085564 | PRJNA1012699_P_NODE_1168_length_343_cov_2.859259_g1136_i0 | PRJNA1012699 | 1168 | 343 | 2.859259 | 9.80725837 | Metazoa | 33208 | Mollusca | Mollusca | 148 | 2.6399999999999992e-43 | NR | XP_022313313.1 | 6565 | g1136 | i0 | 70.4 | 25.8454810495627 | 98 | 29 | 85.7 | 0 | 48 | 341 | 5 | 102 | XP_022313313.1 40S ribosomal protein S12-like [Crassostrea virginica] | diamond | 8865 | 149 | 0.993288590604027 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 15030168 | 15030168 | PRJNA1012699_P_NODE_1832_length_288_cov_1.437209_g1800_i0 | PRJNA1012699 | 1832 | 288 | 1.437209 | 4.13916192 | Magallana gigas | 29159 | Mollusca | Mollusca | 158 | 1.0899999999999999e-43 | NR | XP_011413946.3 | 29159 | g1800 | i0 | 74.2 | 5.79166666666667 | 93 | 24 | 96.9 | 0 | 279 | 1 | 416 | 508 | XP_011413946.3 aspartate--tRNA ligase, cytoplasmic isoform X2 [Magallana gigas] | diamond | 1668 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 24384107 | 24384107 | PRJNA1012699_P_NODE_2140_length_273_cov_3.025000_g2108_i0 | PRJNA1012699 | 2140 | 273 | 3.025 | 8.25825 | Metazoa | 33208 | Mollusca | Mollusca | 147 | 4.0599999999999986e-43 | NR | XP_034334635.1 | 29159 | g2108 | i0 | 73.3 | 5.95604395604396 | 90 | 24 | 98.9 | 0 | 271 | 2 | 27 | 116 | XP_034334635.1 large ribosomal subunit protein uL15 [Magallana gigas] | diamond | 1626 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 28771744 | 28771744 | PRJNA1012699_P_NODE_1047_length_358_cov_2.614035_g1015_i0 | PRJNA1012699 | 1047 | 358 | 2.614035 | 9.3582453 | Plakobranchus ocellatus | 259542 | Mollusca | Mollusca | 149 | 1.13e-42 | NR | GFO47253.1 | 259542 | g1015 | i0 | 65.8 | 11.8491620111732 | 117 | 40 | 98 | 0 | 6 | 356 | 66 | 182 | GFO47253.1 60S ribosomal protein l13a [Plakobranchus ocellatus] | diamond | 4242 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 29056102 | 29056102 | PRJNA1012699_P_NODE_3248_length_248_cov_0.891429_g3216_i0 | PRJNA1012699 | 3248 | 248 | 0.891429 | 2.21074392 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 67 | 1.13e-10 | NR | XP_062619219.1 | 36930 | g3216 | i0 | 57.4 | 1.28225806451613 | 47 | 19 | 56.9 | 1 | 38 | 178 | 33 | 78 | XP_062619219.1 LOW QUALITY PROTEIN: uncharacterized protein LOC134280779 [Saccostrea cuccullata] | diamond | 318 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 29592344 | 29592344 | PRJNA1012699_P_NODE_3890_length_243_cov_0.917647_g3858_i0 | PRJNA1012699 | 3890 | 243 | 0.917647 | 2.22988221 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 59.7 | 1.94e-8 | NR | XP_061174678.1 | 191078 | g3858 | i0 | 37.8 | 0.91358024691358 | 74 | 46 | 91.4 | 0 | 5 | 226 | 82 | 155 | XP_061174678.1 phosphatidylinositol-glycan biosynthesis class F protein-like [Saccostrea echinata] | diamond | 222 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 30501048 | 30501048 | PRJNA1012699_P_NODE_1473_length_311_cov_3.861345_g1441_i0 | PRJNA1012699 | 1473 | 311 | 3.861345 | 12.00878295 | Haliotis | 6452 | Mollusca | Mollusca | 43.9 | 0.034 | NR | XP_048245439.1 | 6454 | g1441 | i0 | 40.8 | 2.7395498392283 | 71 | 34 | 65.6 | 3 | 73 | 276 | 2802 | 2867 | XP_048245439.1 uncharacterized protein LOC124135118 [Haliotis rufescens] | diamond | 852 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 30508804 | 30508804 | PRJNA1012699_P_NODE_2253_length_268_cov_3.625641_g2221_i0 | PRJNA1012699 | 2253 | 268 | 3.625641 | 9.71671788 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 63.9 | 2e-10 | NR | XP_046340433.2 | 6454 | g2221 | i0 | 48.4 | 2.95522388059702 | 62 | 32 | 69.4 | 0 | 4 | 189 | 87 | 148 | XP_046340433.2 60S ribosomal protein L14-like, partial [Haliotis rufescens] | diamond | 792 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 32145195 | 32145195 | PRJNA1012699_P_NODE_2278_length_267_cov_1.597938_g2246_i0 | PRJNA1012699 | 2278 | 267 | 1.597938 | 4.26649446 | Metazoa | 33208 | Mollusca | Mollusca | 80.9 | 1.81e-15 | NR | XP_048253471.1 | 6454 | g2246 | i0 | 43.5 | 11.438202247191 | 85 | 48 | 95.5 | 0 | 9 | 263 | 338 | 422 | XP_048253471.1 cytochrome P450 3A5-like [Haliotis rufescens] | diamond | 3054 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens |
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);;