RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA785164" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA785164 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
7591568 7591568 PRJNA785164_P_NODE_25626_length_366_cov_2.051195_g25161_i0 PRJNA785164 25626 366 2.051195 7.5073737 Exophiala dermatitidis 5970 Fungi Fungi 209 3.7400000000000002e-65   NR KAJ4611568.1 5970 g25161 i0 100 5.13934426229508 105 0 86.1 0 50 364 1 105 KAJ4611568.1 hypothetical protein HRR88_008734 [Exophiala dermatitidis] diamond 1881 209 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Chaetothyriales Herpotrichiellaceae Exophiala Exophiala dermatitidis
12693234 12693234 PRJNA785164_P_NODE_44730_length_269_cov_1.571429_g44265_i0 PRJNA785164 44730 269 1.571429 4.22714401 Taphrina deformans PYCC 571 5011 Fungi Fungi 183 4.5299999999999985e-56   NR CCG83035.1 1097556 g44265 i0 96.6 0.992565055762082 89 3 99.3 0 267 1 121 209 CCG83035.1 40S ribosomal protein S4 [Taphrina deformans PYCC 5710] diamond 267 183 1 Eukaryota Opisthokonta Fungi Ascomycota Taphrinomycetes Taphrinales Taphrinaceae Taphrina Taphrina deformans
24992357 24992357 PRJNA785164_P_NODE_26940_length_355_cov_2.003546_g26475_i0 PRJNA785164 26940 355 2.003546 7.1125883 Lojkania enalia 147567 Fungi Fungi 102 2.2700000000000003e-22   NR KAF2262761.1 147567 g26475 i0 69.8 0.53239436619718306 63 19 53.2 0 354 166 104 166 KAF2262761.1 hypothetical protein CC78DRAFT_497829 [Lojkania enalia] diamond 189 102 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Pleosporales   Lojkania Lojkania enalia
27179836 27179836 PRJNA785164_P_NODE_54842_length_248_cov_0.880000_g54377_i0 PRJNA785164 54842 248 0.88 2.1824 Exophiala bonariae 1690606 Fungi Fungi 150 2.78e-41   NR XP_064707563.1 1690606 g54377 i0 95.1 0.991935483870968 82 4 99.2 0 247 2 278 359 XP_064707563.1 uncharacterized protein LTR84_012880 [Exophiala bonariae] diamond 246 150 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Chaetothyriales Herpotrichiellaceae Exophiala Exophiala bonariae
27843181 27843181 PRJNA785164_P_NODE_39884_length_285_cov_2.179245_g39419_i0 PRJNA785164 39884 285 2.179245 6.21084825 Taphrina deformans PYCC 571 5011 Fungi Fungi 86.3 2.32e-17   NR CCG81474.1 1097556 g39419 i0 55.1 0.936842105263158 89 40 93.7 0 283 17 146 234 CCG81474.1 Putative uncharacterized protein [Taphrina deformans PYCC 5710] diamond 267 86.3 1 Eukaryota Opisthokonta Fungi Ascomycota Taphrinomycetes Taphrinales Taphrinaceae Taphrina Taphrina deformans
27938184 27938184 PRJNA785164_P_NODE_51905_length_250_cov_1.632768_g51440_i0 PRJNA785164 51905 250 1.632768 4.08192 Taphrina deformans PYCC 571 5011 Fungi Fungi 146 9.7e-42   NR CCG82469.1 1097556 g51440 i0 94.9 0.948 79 4 94.8 0 250 14 164 242 CCG82469.1 37S ribosomal protein S7 [Taphrina deformans PYCC 5710] diamond 237 146 1 Eukaryota Opisthokonta Fungi Ascomycota Taphrinomycetes Taphrinales Taphrinaceae Taphrina Taphrina deformans
28348521 28348521 PRJNA785164_P_NODE_16846_length_480_cov_2.196560_g16381_i0 PRJNA785164 16846 480 2.19656 10.543488 Cladosporium halotolerans 1052096 Fungi Fungi 183 3.2599999999999992e-55   NR XP_069234071.1 1052096 g16381 i0 63.5 0.85625 137 48 84.4 2 407 3 1 137 XP_069234071.1 uncharacterized protein WHR41_00321 [Cladosporium halotolerans] diamond 411 183 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Cladosporiales Cladosporiaceae Cladosporium Cladosporium halotolerans
28642121 28642121 PRJNA785164_P_NODE_50227_length_253_cov_1.444444_g49762_i0 PRJNA785164 50227 253 1.444444 3.65444332 Dothideomycetes 147541 Fungi Fungi 134 3.47e-34   NR KAI7140984.1 91943 g49762 i0 75.9 12.7944664031621 83 20 98.4 0 3 251 526 608 KAI7140984.1 hypothetical protein KC324_g16176, partial [Hortaea werneckii] diamond 3237 135 0.992592592592593 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Mycosphaerellales Teratosphaeriaceae Hortaea Hortaea werneckii
29737545 29737545 PRJNA785164_P_NODE_47910_length_260_cov_1.074866_g47445_i0 PRJNA785164 47910 260 1.074866 2.7946516 Camillea tinctor 110548 Fungi Fungi 49.7 1.62e-4   NR KAI5921705.1 110548 g47445 i0 40.7 0.680769230769231 59 34 66.9 1 28 201 159 217 KAI5921705.1 hypothetical protein F4810DRAFT_722051 [Camillea tinctor] diamond 177 49.7 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Xylariales Xylariaceae Camillea Camillea tinctor
29895814 29895814 PRJNA785164_P_NODE_61911_length_241_cov_0.916667_g61446_i0 PRJNA785164 61911 241 0.916667 2.20916747 Taphrina deformans PYCC 571 5011 Fungi Fungi 77.4 1.31e-14   NR CCG81155.1 1097556 g61446 i0 58.7 0.784232365145228 63 26 78.4 0 191 3 241 303 CCG81155.1 protein of unknown function [Taphrina deformans PYCC 5710] diamond 189 77.4 1 Eukaryota Opisthokonta Fungi Ascomycota Taphrinomycetes Taphrinales Taphrinaceae Taphrina Taphrina deformans
30275110 30275110 PRJNA785164_P_NODE_56132_length_246_cov_1.641618_g55667_i0 PRJNA785164 56132 246 1.641618 4.03838028 Capronia coronata CBS 617.96 1182541 Fungi Fungi 59.3 8.32e-9   NR XP_007723579.1 1182541 g55667 i0 70.7 0.5 41 10 50 1 246 124 103 141 XP_007723579.1 uncharacterized protein A1O1_04497 [Capronia coronata CBS 617.96] diamond 123 59.3 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Chaetothyriales Herpotrichiellaceae Capronia Capronia coronata
31159144 31159144 PRJNA785164_P_NODE_54315_length_248_cov_0.880000_g53850_i0 PRJNA785164 54315 248 0.88 2.1824 Tuber magnatum 42249 Fungi Fungi 69.3 1.59e-11   NR PWW74576.1 42249 g53850 i0 48.8 1.01612903225806 84 35 96.8 3 8 247 230 309 PWW74576.1 kinase-like protein [Tuber magnatum] diamond 252 69.3 1 Eukaryota Opisthokonta Fungi Ascomycota Pezizomycetes Pezizales Tuberaceae Tuber Tuber magnatum
31317572 31317572 PRJNA785164_P_NODE_46415_length_264_cov_1.465969_g45950_i0 PRJNA785164 46415 264 1.465969 3.87015816 Taphrina deformans PYCC 571 5011 Fungi Fungi 112 8.13e-30   NR CCG80645.1 1097556 g45950 i0 88.9 0.715909090909091 63 7 71.6 0 262 74 59 121 CCG80645.1 protein of unknown function [Taphrina deformans PYCC 5710] diamond 189 112 1 Eukaryota Opisthokonta Fungi Ascomycota Taphrinomycetes Taphrinales Taphrinaceae Taphrina Taphrina deformans
31412511 31412511 PRJNA785164_P_NODE_41076_length_281_cov_1.850962_g40611_i0 PRJNA785164 41076 281 1.850962 5.20120322 Gnomoniopsis smithogilvyi 1191159 Fungi Fungi 79.3 8.21e-15   NR KAJ4386363.1 1191159 g40611 i0 59.1 0.99288256227758 93 30 90.7 3 11 265 1349 1441 KAJ4386363.1 hypothetical protein N0V93_009258 [Gnomoniopsis smithogilvyi] diamond 279 79.3 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Diaporthales Gnomoniaceae Gnomoniopsis Gnomoniopsis smithogilvyi
31728687 31728687 PRJNA785164_P_NODE_46957_length_262_cov_2.142857_g46492_i0 PRJNA785164 46957 262 2.142857 5.61428534 Protomyces lactucae-debilis 2754530 Fungi Fungi 90.9 5.51e-19   NR XP_040725777.1 2754530 g46492 i0 50 0.984732824427481 86 43 98.5 0 262 5 139 224 XP_040725777.1 uncharacterized protein BCR37DRAFT_392539 [Protomyces lactucae-debilis] diamond 258 90.9 1 Eukaryota Opisthokonta Fungi Ascomycota Taphrinomycetes Taphrinales Protomycetaceae Protomyces Protomyces lactucae-debilis
32371007 32371007 PRJNA785164_P_NODE_46179_length_265_cov_1.125000_g45714_i0 PRJNA785164 46179 265 1.125 2.98125 Aspergillaceae 1131492 Fungi Fungi 103 7.62e-25   NR GLA56141.1 5061 g45714 i0 57 12.7471698113208 86 37 97.4 0 265 8 142 227 GLA56141.1 hypothetical protein AnigIFM63604_004781 [Aspergillus niger] diamond 3378 103 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Aspergillus Aspergillus niger

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