contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA994052" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27095529 | 27095529 | PRJNA994052_P_NODE_22202_length_303_cov_45.513043_g20974_i0 | PRJNA994052 | 22202 | 303 | 45.513043 | 137.90452029 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 69.7 | 6.39e-13 | NR | KAH9509250.1 | 55810 | g20974 | i0 | 97.1 | 7.97029702970297 | 35 | 1 | 34.7 | 0 | 139 | 35 | 70 | 104 | KAH9509250.1 mRNA splicing protein [Bulinus truncatus] | diamond | 2415 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 29148606 | 29148606 | PRJNA994052_P_NODE_33589_length_272_cov_155.542714_g32345_i0 | PRJNA994052 | 33589 | 272 | 155.542714 | 423.07618208 | Mollusca | 6447 | Mollusca | Mollusca | 45.4 | 0.00578 | NR | XP_046374336.1 | 6454 | g32345 | i0 | 33.3 | 3.13235294117647 | 69 | 46 | 76.1 | 0 | 59 | 265 | 150 | 218 | XP_046374336.1 uncharacterized protein LOC124147669 isoform X2 [Haliotis rufescens] | diamond | 852 | 45.8 | 0.991266375545852 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 29331752 | 29331752 | PRJNA994052_P_NODE_15749_length_312_cov_30.535565_g14528_i0 | PRJNA994052 | 15749 | 312 | 30.535565 | 95.2709628 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 50.4 | 1.62e-4 | NR | RUS87449.1 | 188477 | g14528 | i0 | 47.6 | 0.403846153846154 | 42 | 22 | 40.4 | 0 | 24 | 149 | 486 | 527 | RUS87449.1 hypothetical protein EGW08_004765 [Elysia chlorotica] | diamond | 126 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 30215908 | 30215908 | PRJNA994052_P_NODE_75512_length_206_cov_6.406015_g74256_i0 | PRJNA994052 | 75512 | 206 | 6.406015 | 13.1963909 | Physella acuta | 109671 | Mollusca | Mollusca | 74.7 | 1.23e-13 | NR | XP_059169210.1 | 109671 | g74256 | i0 | 50.7 | 2.78155339805825 | 69 | 28 | 91.7 | 2 | 190 | 2 | 470 | 538 | XP_059169210.1 cell division cycle protein 27 homolog [Physella acuta] | diamond | 573 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 31075099 | 31075099 | PRJNA994052_P_NODE_61755_length_223_cov_50.900000_g60499_i0 | PRJNA994052 | 61755 | 223 | 50.9 | 113.507 | Gastropoda | 6448 | Mollusca | Mollusca | 42.4 | 0.0401 | NR | XP_048241665.1 | 6454 | g60499 | i0 | 67.7 | 1.25112107623318 | 31 | 10 | 41.7 | 0 | 175 | 83 | 279 | 309 | XP_048241665.1 cleavage and polyadenylation specificity factor subunit 3-like isoform X2 [Haliotis rufescens] | diamond | 279 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 31195120 | 31195120 | PRJNA994052_P_NODE_25655_length_293_cov_24.268182_g24417_i0 | PRJNA994052 | 25655 | 293 | 24.268182 | 71.10577326 | Lottia gigantea | 225164 | Mollusca | Mollusca | 45.4 | 0.00763 | NR | XP_009063477.1 | 225164 | g24417 | i0 | 29.9 | 0.890784982935154 | 87 | 53 | 80.9 | 1 | 34 | 270 | 656 | 742 | XP_009063477.1 hypothetical protein LOTGIDRAFT_235712 [Lottia gigantea] | diamond | 261 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 32239674 | 32239674 | PRJNA994052_P_NODE_15958_length_312_cov_22.677824_g14737_i0 | PRJNA994052 | 15958 | 312 | 22.677824 | 70.75481088 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 107 | 2.31e-24 | NR | CAC5379564.1 | 42192 | g14737 | i0 | 87.9 | 107.288461538462 | 58 | 7 | 55.8 | 0 | 139 | 312 | 207 | 264 | CAC5379564.1 VCP [Mytilus coruscus] | diamond | 33474 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus |
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);;