contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA289590" and tax_clade = "Opisthokonta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11850903 | 11850903 | PRJNA289590_P_NODE_10050_length_292_cov_1.497942_g9826_i0 | PRJNA289590 | 10050 | 292 | 1.497942 | 4.37399064 | Fungi | 4751 | Fungi | Fungi | 146 | 2.66e-41 | NR | KAH9993630.1 | 517384 | g9826 | i0 | 73 | 7.97260273972603 | 89 | 24 | 91.4 | 0 | 290 | 24 | 23 | 111 | KAH9993630.1 guanine nucleotide binding protein beta subunit [Russula vinacea] | diamond | 2328 | 147 | 0.993197278911565 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Russula | Russula vinacea | |
| 26807018 | 26807018 | PRJNA289590_P_NODE_14721_length_235_cov_3.053763_g14497_i0 | PRJNA289590 | 14721 | 235 | 3.053763 | 7.17634305 | Mammalia | 40674 | Chordata | Chordata | 98.6 | 4.279999999999999e-23 | NR | XP_058990340.1 | 9666 | g14497 | i0 | 63.6 | 34.3914893617021 | 77 | 26 | 95.7 | 1 | 10 | 234 | 119 | 195 | XP_058990340.1 large ribosomal subunit protein eL22-like [Mustela lutreola] | diamond | 8082 | 99.4 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Mustela | Mustela lutreola | |
| 26821172 | 26821172 | PRJNA289590_P_NODE_15821_length_227_cov_1.168539_g15597_i0 | PRJNA289590 | 15821 | 227 | 1.168539 | 2.65258353 | Tigriopus californicus | 6832 | Arthropoda | Arthropoda | 90.5 | 3.4e-19 | NR | XP_059090583.1 | 6832 | g15597 | i0 | 67.1 | 4.16299559471366 | 70 | 21 | 92.5 | 1 | 16 | 225 | 1 | 68 | XP_059090583.1 eukaryotic peptide chain release factor subunit 1 [Tigriopus californicus] | diamond | 945 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Hexanauplia | Harpacticoida | Harpacticidae | Tigriopus | Tigriopus californicus | |
| 27611382 | 27611382 | PRJNA289590_P_NODE_22144_length_188_cov_0.820144_g21920_i0 | PRJNA289590 | 22144 | 188 | 0.820144 | 1.54187072 | Bufotes viridis | 30338 | Chordata | Chordata | 46.2 | 0.00106 | NR | CAK8609802.1 | 30338 | g21920 | i0 | 55.9 | 1.6595744680851101 | 34 | 15 | 54.3 | 0 | 80 | 181 | 1 | 34 | CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis] | diamond | 312 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 28905575 | 28905575 | PRJNA289590_P_NODE_22148_length_187_cov_7.166667_g21924_i0 | PRJNA289590 | 22148 | 187 | 7.166667 | 13.40166729 | Lonchura striata | 40157 | Chordata | Chordata | 41.6 | 0.0473 | NR | XP_031362561.1 | 40157 | g21924 | i0 | 44.2 | 0.689839572192513 | 43 | 24 | 69 | 0 | 163 | 35 | 78 | 120 | XP_031362561.1 LOW QUALITY PROTEIN: lysine-specific demethylase hairless [Lonchura striata] | diamond | 129 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Estrildidae | Lonchura | Lonchura striata | |
| 29000867 | 29000867 | PRJNA289590_P_NODE_15308_length_231_cov_0.857143_g15084_i0 | PRJNA289590 | 15308 | 231 | 0.857143 | 1.98000033 | Staurois parvus | 386267 | Chordata | Chordata | 60.1 | 4.84e-10 | NR | CAI9620946.1 | 386267 | g15084 | i0 | 70.3 | 0.480519480519481 | 37 | 11 | 48.1 | 0 | 21 | 131 | 23 | 59 | CAI9620946.1 unnamed protein product [Staurois parvus] | diamond | 111 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 29176187 | 29176187 | PRJNA289590_P_NODE_16349_length_223_cov_1.097701_g16125_i0 | PRJNA289590 | 16349 | 223 | 1.097701 | 2.44787323 | Eukaryota | 2759 | Fungi | Fungi | 54.7 | 1.82e-6 | NR | KAJ1912152.1 | 417184 | g16125 | i0 | 59.2 | 2.94618834080717 | 49 | 18 | 65.9 | 1 | 77 | 223 | 140 | 186 | KAJ1912152.1 Myosin type-2 heavy chain 1 [Mycoemilia scoparia] | diamond | 657 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Mycoemilia | Mycoemilia scoparia | |
| 29365529 | 29365529 | PRJNA289590_P_NODE_27469_length_167_cov_0.881356_g27245_i0 | PRJNA289590 | 27469 | 167 | 0.881356 | 1.47186452 | Insecta | 50557 | Arthropoda | Arthropoda | 73.6 | 2.94e-14 | NR | KAE8742951.1 | 133901 | g27245 | i0 | 73.2 | 9.64670658682635 | 41 | 11 | 73.7 | 0 | 6 | 128 | 167 | 207 | KAE8742951.1 Peroxiredoxin-1-like [Frankliniella occidentalis] | diamond | 1611 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Thysanoptera | Thripidae | Frankliniella | Frankliniella occidentalis | |
| 29410878 | 29410878 | PRJNA289590_P_NODE_27809_length_167_cov_0.881356_g27585_i0 | PRJNA289590 | 27809 | 167 | 0.881356 | 1.47186452 | Nephila pilipes | 299642 | Arthropoda | Arthropoda | 97.1 | 1.2999999999999998e-24 | NR | GFS40972.1 | 299642 | g27585 | i0 | 84.9 | 3.82634730538922 | 53 | 8 | 95.2 | 0 | 162 | 4 | 18 | 70 | GFS40972.1 uncharacterized protein NPIL_596231 [Nephila pilipes] | diamond | 639 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Nephilidae | Nephila | Nephila pilipes | |
| 29617701 | 29617701 | PRJNA289590_P_NODE_13910_length_244_cov_1.066667_g13686_i0 | PRJNA289590 | 13910 | 244 | 1.066667 | 2.60266748 | root | 1 | Root_unresolved | Root_unresolved | 98.6 | 8.200000000000001e-22 | NR | KAK6089148.1 | 40135 | g13686 | i0 | 75 | 1.67213114754098 | 68 | 17 | 83.6 | 0 | 24 | 227 | 42 | 109 | KAK6089148.1 hypothetical protein P3W45_001868, partial [Vairimorpha bombi] | diamond | 408 | 98.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha bombi | |||
| 29807376 | 29807376 | PRJNA289590_P_NODE_17211_length_216_cov_3.053892_g16987_i0 | PRJNA289590 | 17211 | 216 | 3.053892 | 6.59640672 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 72.8 | 4.95e-15 | NR | ALS04207.1 | 335913 | g16987 | i0 | 67.3 | 2.15277777777778 | 52 | 17 | 72.2 | 0 | 2 | 157 | 19 | 70 | ALS04207.1 60S ribosomal protein L38 [Acartia pacifica] | diamond | 465 | 73.2 | 0.994535519125683 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Hexanauplia | Calanoida | Acartiidae | Acartia | Acartia pacifica | |
| 30471136 | 30471136 | PRJNA289590_P_NODE_28913_length_165_cov_0.896552_g28689_i0 | PRJNA289590 | 28913 | 165 | 0.896552 | 1.4793108 | Beauveria | 5581 | Fungi | Fungi | 58.9 | 6.44e-9 | NR | KAF1736020.1 | 176275 | g28689 | i0 | 60 | 1.81818181818182 | 50 | 19 | 90.9 | 1 | 12 | 161 | 49 | 97 | KAF1736020.1 hypothetical protein CRV24_004954 [Beauveria bassiana] | diamond | 300 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Beauveria | Beauveria bassiana | |
| 31022056 | 31022056 | PRJNA289590_P_NODE_14735_length_235_cov_2.010753_g14511_i0 | PRJNA289590 | 14735 | 235 | 2.010753 | 4.72526955 | Zosterops borbonicus | 364589 | Chordata | Chordata | 44.3 | 0.00425 | NR | TRZ17703.1 | 364589 | g14511 | i0 | 34.4 | 0.778723404255319 | 61 | 37 | 74 | 1 | 211 | 38 | 32 | 92 | TRZ17703.1 hypothetical protein HGM15179_009421 [Zosterops borbonicus] | diamond | 183 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Zosteropidae | Zosterops | Zosterops borbonicus | |
| 31179662 | 31179662 | PRJNA289590_P_NODE_12335_length_260_cov_2.194313_g12111_i0 | PRJNA289590 | 12335 | 260 | 2.194313 | 5.7052138 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 124 | 3.1599999999999997e-32 | NR | XP_051791274.1 | 27687 | g12111 | i0 | 77.4 | 7.76538461538462 | 84 | 18 | 95.8 | 1 | 4 | 252 | 121 | 204 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 2019 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 31608816 | 31608816 | PRJNA289590_P_NODE_29536_length_164_cov_1.321739_g29312_i0 | PRJNA289590 | 29536 | 164 | 1.321739 | 2.16765196 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 55.1 | 5.65e-7 | NR | WAQ96474.1 | 6604 | g29312 | i0 | 44.4 | 13.7743902439024 | 54 | 30 | 98.8 | 0 | 162 | 1 | 340 | 393 | WAQ96474.1 VWA5A-like protein [Mya arenaria] | diamond | 2259 | 55.5 | 0.992792792792793 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 32729384 | 32729384 | PRJNA289590_P_NODE_26120_length_169_cov_0.866667_g25896_i0 | PRJNA289590 | 26120 | 169 | 0.866667 | 1.46466723 | Fomitiporia mediterranea MF3/22 | 694068 | Fungi | Fungi | 75.1 | 5.03e-14 | NR | XP_007265867.1 | 694068 | g25896 | i0 | 79.6 | 0.869822485207101 | 49 | 8 | 83.4 | 1 | 143 | 3 | 44 | 92 | XP_007265867.1 uncharacterized protein FOMMEDRAFT_167489 [Fomitiporia mediterranea MF3/22] | diamond | 147 | 75.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Fomitiporia | Fomitiporia mediterranea |
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);;