contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJEB8827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25530200 | 25530200 | PRJEB8827g_S_NODE_1337_length_265_cov_1.186957_g1316_i0 | PRJEB8827 | 1337 | 265 | 1.186957 | 3.14543605 | Patella vulgata | 6465 | Mollusca | Mollusca | 52.8 | 0.024 | NTclustered | gi|2506320687|ref|XM_050541306.2| | 6465 | g1316 | i0 | 100 | 0.105660377358491 | 28 | 0 | 11 | 0 | 214 | 241 | 2900 | 2873 | PREDICTED: Patella vulgata multidrug and toxin extrusion protein 1 (LOC126815593), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 25530253 | 25530253 | PRJEB8827g_S_NODE_4201_length_182_cov_4.034014_g4180_i0 | PRJEB8827 | 4201 | 182 | 4.034014 | 7.34190548 | Argopecten irradians | 31199 | Mollusca | Mollusca | 110 | 9.06e-20 | NTclustered | gi|2835350600|ref|XM_069247595.1| | 31199 | g4180 | i0 | 95.588 | 38.8626373626374 | 68 | 3 | 37 | 0 | 115 | 182 | 1442 | 1375 | PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA | blastn | 7073 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 25665494 | 25665494 | PRJEB8827d_S_NODE_14610_length_166_cov_2.122137_g14606_i0 | PRJEB8827 | 14610 | 166 | 2.122137 | 3.52274742 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g14606 | i0 | 100 | 0.168674698795181 | 28 | 0 | 17 | 0 | 113 | 140 | 8953149 | 8953122 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25666150 | 25666150 | PRJEB8827g_S_NODE_1090_length_284_cov_104.626506_g1069_i0 | PRJEB8827 | 1090 | 284 | 104.626506 | 297.13927704 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 135 | 2.53e-27 | NTclustered | gi|2034271035|ref|XR_005960499.1| | 1735272 | g1069 | i0 | 81.111 | 12.6056338028169 | 180 | 24 | 62 | 8 | 77 | 251 | 3686 | 3512 | PREDICTED: Gigantopelta aegis large subunit ribosomal RNA (LOC121392465), rRNA | blastn | 3580 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 26074646 | 26074646 | PRJEB8827h_S_NODE_1845_length_239_cov_2.107843_g1826_i0 | PRJEB8827 | 1845 | 239 | 2.107843 | 5.03774477 | Physella acuta | 109671 | Mollusca | Mollusca | 76.8 | 1.27e-9 | NTclustered | gi|2572310488|ref|XM_059295099.1| | 109671 | g1826 | i0 | 84.416 | 1.35983263598326 | 77 | 12 | 32 | 0 | 163 | 239 | 1513 | 1437 | PREDICTED: Physella acuta protein transport protein Sec61 subunit alpha (LOC131937566), mRNA | blastn | 325 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 26210856 | 26210856 | PRJEB8827h_S_NODE_1054_length_288_cov_9.458498_g1035_i0 | PRJEB8827 | 1054 | 288 | 9.458498 | 27.24047424 | Argopecten irradians | 31199 | Mollusca | Mollusca | 143 | 1.54e-29 | NTclustered | gi|2835350600|ref|XM_069247595.1| | 31199 | g1035 | i0 | 93.684 | 35.0868055555556 | 95 | 6 | 33 | 0 | 3 | 97 | 1348 | 1442 | PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA | blastn | 10105 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 26210879 | 26210879 | PRJEB8827h_S_NODE_2054_length_232_cov_5.548223_g2035_i0 | PRJEB8827 | 2054 | 232 | 5.548223 | 12.87187736 | Aplysia californica | 6500 | Mollusca | Mollusca | 145 | 3.33e-30 | NTclustered | gi|1897919841|ref|XM_013080763.2| | 6500 | g2035 | i0 | 80.749 | 5.56896551724138 | 187 | 34 | 80 | 2 | 1 | 186 | 317 | 502 | PREDICTED: Aplysia californica 40S ribosomal protein S18 (LOC101863011), mRNA | blastn | 1292 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 26345939 | 26345939 | PRJEB8827c_S_NODE_2959_length_153_cov_2.864407_g2946_i0 | PRJEB8827 | 2959 | 153 | 2.864407 | 4.38254271 | Argopecten irradians | 31199 | Mollusca | Mollusca | 128 | 2.02e-25 | NTclustered | gi|2835350600|ref|XM_069247595.1| | 31199 | g2946 | i0 | 93.103 | 59.0980392156863 | 87 | 6 | 57 | 0 | 67 | 153 | 1442 | 1356 | PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA | blastn | 9042 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 26346729 | 26346729 | PRJEB8827h_S_NODE_2247_length_227_cov_2.536458_g2228_i0 | PRJEB8827 | 2247 | 227 | 2.536458 | 5.75775966 | Mytilus californianus | 6549 | Mollusca | Mollusca | 132 | 2.52e-26 | NTclustered | gi|2334663290|ref|XM_052233325.1| | 6549 | g2228 | i0 | 79.275 | 0.850220264317181 | 193 | 36 | 85 | 4 | 36 | 227 | 745 | 556 | PREDICTED: Mytilus californianus 33 kDa inner dynein arm light chain, axonemal-like (LOC127726028), mRNA | blastn | 193 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 26434152 | 26434152 | PRJEB8827h_S_NODE_719_length_329_cov_306.244898_g700_i0 | PRJEB8827 | 719 | 329 | 306.244898 | 1007.54571442 | root | 1 | Root_unresolved | Root_unresolved | 137 | 8.31e-28 | NTclustered | gi|2913002568|dbj|AP039611.1| | 145626 | g700 | i0 | 97.5 | 58.9787234042553 | 80 | 2 | 24 | 0 | 149 | 228 | 1432579 | 1432500 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence | blastn | 19404 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 26483025 | 26483025 | PRJEB8827h_S_NODE_968_length_296_cov_2.942529_g949_i0 | PRJEB8827 | 968 | 296 | 2.942529 | 8.70988584 | Patella vulgata | 6465 | Mollusca | Mollusca | 52.8 | 0.027 | NTclustered | gi|2506320687|ref|XM_050541306.2| | 6465 | g949 | i0 | 100 | 0.0945945945945946 | 28 | 0 | 9 | 0 | 176 | 203 | 2900 | 2873 | PREDICTED: Patella vulgata multidrug and toxin extrusion protein 1 (LOC126815593), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata |
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);;