contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA293022" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22049762 | 22049762 | PRJNA293022_P_NODE_46358_length_205_cov_1.307692_g45621_i0 | PRJNA293022 | 46358 | 205 | 1.307692 | 2.6807686 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 113 | 3.64e-29 | NR | XP_052279311.1 | 45954 | g45621 | i0 | 89.1 | 4.68292682926829 | 64 | 7 | 93.7 | 0 | 4 | 195 | 120 | 183 | XP_052279311.1 40S ribosomal protein S6-like [Dreissena polymorpha] | diamond | 960 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 27136972 | 27136972 | PRJNA293022_P_NODE_75702_length_164_cov_0.904348_g74965_i0 | PRJNA293022 | 75702 | 164 | 0.904348 | 1.48313072 | Liolophura japonica | 13599 | Mollusca | Mollusca | 43.9 | 0.00505 | NR | XP_064612331.1 | 13599 | g74965 | i0 | 59.5 | 0.676829268292683 | 37 | 15 | 67.7 | 0 | 112 | 2 | 288 | 324 | XP_064612331.1 LOW QUALITY PROTEIN: eukaryotic translation initiation factor 3 subunit C-like [Liolophura japonica] | diamond | 111 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 27358841 | 27358841 | PRJNA293022_P_NODE_37923_length_227_cov_1.117978_g37186_i0 | PRJNA293022 | 37923 | 227 | 1.117978 | 2.53781006 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 47.4 | 6.71e-4 | NR | XP_062599881.1 | 36930 | g37186 | i0 | 32.2 | 1.70484581497797 | 59 | 40 | 78 | 0 | 24 | 200 | 21 | 79 | XP_062599881.1 uncharacterized protein LOC134261454 [Saccostrea cuccullata] | diamond | 387 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 28368978 | 28368978 | PRJNA293022_P_NODE_59306_length_180_cov_3.129771_g58569_i0 | PRJNA293022 | 59306 | 180 | 3.129771 | 5.6335878 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 41.2 | 0.0496 | NR | CAE1281722.1 | 158019 | g58569 | i0 | 51 | 0.85 | 51 | 16 | 75 | 3 | 44 | 178 | 4 | 51 | CAE1281722.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 153 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 31102715 | 31102715 | PRJNA293022_P_NODE_81415_length_157_cov_2.833333_g80678_i0 | PRJNA293022 | 81415 | 157 | 2.833333 | 4.44833281 | Metazoa | 33208 | Mollusca | Mollusca | 44.7 | 0.00246 | NR | XP_052103364.1 | 6549 | g80678 | i0 | 81 | 34.9108280254777 | 21 | 4 | 40.1 | 0 | 50 | 112 | 652 | 672 | XP_052103364.1 uncharacterized protein LOC127736809 [Mytilus californianus] | diamond | 5481 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 31211171 | 31211171 | PRJNA293022_P_NODE_38155_length_226_cov_1.768362_g37418_i0 | PRJNA293022 | 38155 | 226 | 1.768362 | 3.99649812 | Liolophura japonica | 13599 | Mollusca | Mollusca | 52.4 | 1.25e-5 | NR | XP_064599930.1 | 13599 | g37418 | i0 | 38.2 | 0.902654867256637 | 68 | 42 | 90.3 | 0 | 226 | 23 | 288 | 355 | XP_064599930.1 LOW QUALITY PROTEIN: spectrin beta chain-like [Liolophura japonica] | diamond | 204 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 31464900 | 31464900 | PRJNA293022_P_NODE_43876_length_210_cov_7.819876_g43139_i0 | PRJNA293022 | 43876 | 210 | 7.819876 | 16.4217396 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 42.4 | 0.0335 | NR | CAE1162969.1 | 158019 | g43139 | i0 | 52.2 | 0.957142857142857 | 67 | 16 | 92.9 | 5 | 2 | 196 | 606 | 658 | CAE1162969.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 201 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 32002443 | 32002443 | PRJNA293022_P_NODE_30378_length_254_cov_5.790244_g29641_i0 | PRJNA293022 | 30378 | 254 | 5.790244 | 14.70721976 | Haliotis asinina | 109174 | Mollusca | Mollusca | 43.9 | 0.0159 | NR | XP_067657806.1 | 109174 | g29641 | i0 | 35.4 | 1.51181102362205 | 65 | 36 | 75.6 | 2 | 19 | 210 | 144 | 203 | XP_067657806.1 uncharacterized protein [Haliotis asinina] | diamond | 384 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina |
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);;