RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1008049" and tax_clade = "Opisthokonta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

tax_clade 1

  • Opisthokonta · 17 ✖

bioproject 1

  • PRJNA1008049 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
26812992 26812992 PRJNA1008049_S_NODE_2401_length_177_cov_3.851351_g2383_i0 PRJNA1008049 2401 177 3.851351 6.81689127 Malassezia globosa CBS 7966 425265 Fungi Fungi 62 2.39e-9   NR XP_001731550.1 425265 g2383 i0 100 0.406779661016949 24 0 40.7 0 3 74 488 511 XP_001731550.1 uncharacterized protein MGL_1733 [Malassezia globosa CBS 7966] diamond 72 62 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia globosa
26907925 26907925 PRJNA1008049_S_NODE_3902_length_159_cov_8.676923_g3884_i0 PRJNA1008049 3902 159 8.676923 13.79630757 Thrips palmi 161013 Arthropoda Arthropoda 102 8.159999999999999e-24   NR XP_034243901.1 161013 g3884 i0 90.4 0.981132075471698 52 5 98.1 0 158 3 66 117 XP_034243901.1 THO complex subunit 2 isoform X1 [Thrips palmi] diamond 156 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
27666530 27666530 PRJNA1008049_S_NODE_3804_length_160_cov_6.717557_g3786_i0 PRJNA1008049 3804 160 6.717557 10.7480912 Dissoconium aciculare CBS 342.82 1314786 Fungi Fungi 87 1.65e-18   NR XP_033463268.1 1314786 g3786 i0 82.4 0.95625 51 9 95.6 0 3 155 277 327 XP_033463268.1 S-adenosyl-L-methionine-dependent methyltransferase [Dissoconium aciculare CBS 342.82] diamond 153 87 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Mycosphaerellales Dissoconiaceae Dissoconium Dissoconium aciculare
27918867 27918867 PRJNA1008049_S_NODE_605_length_235_cov_4.606796_g587_i0 PRJNA1008049 605 235 4.606796 10.8259706 Thrips palmi 161013 Arthropoda Arthropoda 93.2 1.19e-22   NR XP_034234331.1 161013 g587 i0 60 0.957446808510638 75 30 95.7 0 235 11 7 81 XP_034234331.1 uncharacterized protein LOC117641269 [Thrips palmi] diamond 225 93.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
27982131 27982131 PRJNA1008049_S_NODE_1025_length_208_cov_5.804469_g1007_i0 PRJNA1008049 1025 208 5.804469 12.07329552 Malassezia restricta CBS 7877 425264 Fungi Fungi 97.4 8.65e-24   NR AYO42766.1 425264 g1007 i0 76.3 1.70192307692308 59 14 85.1 0 206 30 100 158 AYO42766.1 hypothetical protein DNF11_1816 [Malassezia restricta CBS 7877] diamond 354 97.4 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
28392536 28392536 PRJNA1008049_S_NODE_1766_length_186_cov_2.484076_g1748_i0 PRJNA1008049 1766 186 2.484076 4.62038136 Malassezia caprae 1381934 Fungi Fungi 89.4 2.32e-21   NR WFD21081.1 1381934 g1748 i0 68.9 0.983870967741935 61 19 98.4 0 2 184 23 83 WFD21081.1 hypothetical protein MCAP1_003338 [Malassezia caprae] diamond 183 89.4 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia caprae
28645254 28645254 PRJNA1008049_S_NODE_1867_length_184_cov_4.374194_g1849_i0 PRJNA1008049 1867 184 4.374194 8.04851696 Malassezia globosa CBS 7966 425265 Fungi Fungi 91.3 6.98e-20   NR XP_001729783.1 425265 g1849 i0 68.3 0.978260869565217 60 19 97.8 0 181 2 214 273 XP_001729783.1 putative aspartyl protease [Malassezia globosa CBS 7966] diamond 180 91.3 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia globosa
28645255 28645255 PRJNA1008049_S_NODE_287_length_285_cov_5.027344_g269_i0 PRJNA1008049 287 285 5.027344 14.3279304 Malassezia restricta 76775 Fungi Fungi 46.2 8.26e-4   NR XP_027485494.1 76775 g269 i0 88.5 0.536842105263158 26 3 27.4 0 8 85 89 114 XP_027485494.1 large subunit ribosomal protein L34e [Malassezia restricta] diamond 153 46.2 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
29434175 29434175 PRJNA1008049_S_NODE_430_length_255_cov_14.287611_g412_i0 PRJNA1008049 430 255 14.287611 36.43340805 Thrips palmi 161013 Arthropoda Arthropoda 53.1 7.95e-6   NR XP_034232277.1 161013 g412 i0 60 0.647058823529412 55 17 63.5 2 3 164 240 290 XP_034232277.1 circadian clock-controlled protein-like [Thrips palmi] diamond 165 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
29781771 29781771 PRJNA1008049_S_NODE_871_length_215_cov_20.865591_g853_i0 PRJNA1008049 871 215 20.865591 44.86102065 Malassezia arunalokei 1514897 Fungi Fungi 71.2 2.35e-12   NR WFD16437.1 1514897 g853 i0 100 0.488372093023256 35 0 48.8 0 51 155 2838 2872 WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei] diamond 105 71.2 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia arunalokei
30216476 30216476 PRJNA1008049_S_NODE_3012_length_168_cov_10.345324_g2994_i0 PRJNA1008049 3012 168 10.345324 17.38014432 root 1 Root_unresolved Root_unresolved 120 7.43e-30   NR XP_030109804.2 10090 g2994 i0 100 10.8035714285714 55 0 98.2 0 167 3 89 143 XP_030109804.2 uncharacterized protein Gm52666 [Mus musculus] diamond 1815 120 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
30343511 30343511 PRJNA1008049_S_NODE_1252_length_199_cov_8.994118_g1234_i0 PRJNA1008049 1252 199 8.994118 17.89829482 root 1 Root_unresolved Root_unresolved 133 9.439999999999999e-35   NR XP_030110853.2 10090 g1234 i0 100 14.6984924623116 65 0 98 0 3 197 122 186 XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] diamond 2925 133 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
30406535 30406535 PRJNA1008049_S_NODE_213_length_311_cov_4.234043_g195_i0 PRJNA1008049 213 311 4.234043 13.16787373 root 1 Root_unresolved Root_unresolved 152 2.51e-42   NR XP_036010302.1 10090 g195 i0 97.3 9.27974276527331 74 2 71.4 0 3 224 40 113 XP_036010302.1 uncharacterized protein Gm53410 [Mus musculus] diamond 2886 152 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
30634644 30634644 PRJNA1008049_S_NODE_3513_length_163_cov_7.932836_g3495_i0 PRJNA1008049 3513 163 7.932836 12.93052268 Malassezia globosa CBS 7966 425265 Fungi Fungi 101 6.88e-24   NR XP_001729783.1 425265 g3495 i0 83 0.975460122699387 53 9 97.5 0 3 161 306 358 XP_001729783.1 putative aspartyl protease [Malassezia globosa CBS 7966] diamond 159 101 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia globosa
30982528 30982528 PRJNA1008049_S_NODE_2734_length_172_cov_4.167832_g2716_i0 PRJNA1008049 2734 172 4.167832 7.16867104 Macrobrachium rosenbergii 79674 Arthropoda Arthropoda 69.7 4.45e-12   NR XP_066964347.1 79674 g2716 i0 61.1 0.941860465116279 54 21 94.2 0 2 163 553 606 XP_066964347.1 LOW QUALITY PROTEIN: piggyBac transposable element-derived protein 4-like [Macrobrachium rosenbergii] diamond 162 69.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii
31195670 31195670 PRJNA1008049_S_NODE_395_length_262_cov_6.669528_g377_i0 PRJNA1008049 395 262 6.669528 17.47416336 root 1 Root_unresolved Root_unresolved 183 6.25e-53   NR XP_030110853.2 10090 g377 i0 100 14.8969465648855 87 0 99.6 0 1 261 236 322 XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] diamond 3903 183 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
32469155 32469155 PRJNA1008049_S_NODE_5099_length_151_cov_2.508197_g5081_i0 PRJNA1008049 5099 151 2.508197 3.78737747 Thrips palmi 161013 Arthropoda Arthropoda 95.9 4.76e-24   NR XP_034253031.1 161013 g5081 i0 93.9 0.973509933774834 49 3 97.4 0 149 3 19 67 XP_034253031.1 60S ribosomal protein L36 [Thrips palmi] diamond 147 95.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;