RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJEB2925" and tax_phylum = "Basidiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Basidiomycota · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB2925 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
26113 26113 PRJEB2925_P_NODE_6581_length_505_cov_3.972340_g5442_i0 PRJEB2925 6581 505 3.97234 20.060317 Opisthokonta 33154 Fungi Fungi 173 1.34e-51   NR KAH9967157.1 258981 g5442 i0 57.6 30.6237623762376 139 59 82.6 0 58 474 48 186 KAH9967157.1 40S ribosomal protein S15 [Russula dissimulans] diamond 15465 174 0.994252873563218 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Russulales Russulaceae Russula Russula dissimulans
5128527 5128527 PRJEB2925_P_NODE_6745_length_497_cov_5.209957_g5594_i0 PRJEB2925 6745 497 5.209957 25.89348629 Eukaryota 2759 Fungi Fungi 212 5.34e-67   NR SCZ87837.1 289078 g5594 i0 76.4 18.8148893360161 148 31 86.9 3 21 452 14 161 SCZ87837.1 BZ3500_MvSof-1268-A1-R1_Chr2-3g05305 [Microbotryum saponariae] diamond 9351 213 0.995305164319249 Eukaryota Opisthokonta Fungi Basidiomycota Microbotryomycetes Microbotryales Microbotryaceae Microbotryum Microbotryum saponariae
9916240 9916240 PRJEB2925_P_NODE_13728_length_279_cov_2.840164_g12450_i0 PRJEB2925 13728 279 2.840164 7.92405756 Opisthokonta 33154 Fungi Fungi 141 2.9e-41   NR XP_003332938.1 418459 g12450 i0 80.5 1.74193548387097 82 16 88.2 0 248 3 28 109 XP_003332938.1 40S ribosomal protein S27 [Puccinia graminis f. sp. tritici CRL 75-36-700-3] diamond 486 142 0.992957746478873 Eukaryota Opisthokonta Fungi Basidiomycota Pucciniomycetes Pucciniales Pucciniaceae Puccinia Puccinia graminis
20426770 20426770 PRJEB2925_P_NODE_12497_length_302_cov_1.970037_g11220_i0 PRJEB2925 12497 302 1.970037 5.94951174 Eukaryota 2759 Fungi Fungi 106 3.59e-24   NR KAG9225523.1 5321 g11220 i0 69.2 14.4933774834437 78 24 77.5 0 296 63 610 687 KAG9225523.1 hypothetical protein CCMSSC00406_0003026 [Pleurotus cornucopiae] diamond 4377 107 0.990654205607477 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Agaricales Pleurotaceae Pleurotus Pleurotus cornucopiae
26684930 26684930 PRJEB2925_P_NODE_5361_length_580_cov_2.220183_g4325_i0 PRJEB2925 5361 580 2.220183 12.8770614 Schizophyllum commune Loenen D 1314666 Fungi Fungi 55.5 3e-5   NR KAI4527770.1 1314666 g4325 i0 35.1 2.73103448275862 94 53 47.1 3 301 573 336 424 KAI4527770.1 hypothetical protein K525DRAFT_185950, partial [Schizophyllum commune Loenen D] diamond 1584 55.5 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Agaricales Schizophyllaceae Schizophyllum Schizophyllum commune
27026681 27026681 PRJEB2925_P_NODE_9962_length_368_cov_1.528529_g8690_i0 PRJEB2925 9962 368 1.528529 5.62498672 Schizophyllum 5333 Fungi Fungi 100 1.06e-21   NR KAL1665935.1 5334 g8690 i0 44.8 1.89130434782609 116 64 94.6 0 350 3 412 527 KAL1665935.1 hypothetical protein GGF50DRAFT_87702 [Schizophyllum commune] diamond 696 100 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Agaricales Schizophyllaceae Schizophyllum Schizophyllum commune
27816678 27816678 PRJEB2925_P_NODE_6164_length_529_cov_1.578947_g5060_i0 PRJEB2925 6164 529 1.578947 8.35262963 Basidiomycota 5204 Fungi Fungi 123 4.7999999999999997e-32   NR XP_007862414.1 670483 g5060 i0 42 12.4536862003781 169 90 95.8 3 508 2 1 161 XP_007862414.1 translationally-controlled tumor protein [Gloeophyllum trabeum ATCC 11539] diamond 6588 124 0.991935483870968 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Gloeophyllales Gloeophyllaceae Gloeophyllum Gloeophyllum trabeum
28328023 28328023 PRJEB2925_P_NODE_9726_length_375_cov_5.114706_g8455_i0 PRJEB2925 9726 375 5.114706 19.1801475 Malassezia equina 1381935 Fungi Fungi 43.1 0.00944   NR WFD24263.1 1381935 g8455 i0 51.1 0.36 45 22 36 0 187 53 16 60 WFD24263.1 60S ribosomal protein L38 [Malassezia equina] diamond 135 43.1 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia equina
29086101 29086101 PRJEB2925_P_NODE_1968_length_1205_cov_4.613675_g1462_i0 PRJEB2925 1968 1205 4.613675 55.59478375 Phakopsora pachyrhizi 170000 Fungi Fungi 308 1.29e-98   NR KAI8461260.1 170000 g1462 i0 56.7 8.39751037344398 275 117 68.2 2 146 967 59 332 KAI8461260.1 ribosomal protein L4 domain-containing protein [Phakopsora pachyrhizi] diamond 10119 308 1 Eukaryota Opisthokonta Fungi Basidiomycota Pucciniomycetes Pucciniales Phakopsoraceae Phakopsora Phakopsora pachyrhizi
29111125 29111125 PRJEB2925_P_NODE_3848_length_722_cov_2.937409_g2976_i0 PRJEB2925 3848 722 2.937409 21.20809298 Fungi 4751 Fungi Fungi 108 5.75e-23   NR TCD68200.1 92696 g2976 i0 51.8 13.6869806094183 139 60 55.7 2 151 552 15 151 TCD68200.1 hypothetical protein EIP91_011372 [Steccherinum ochraceum] diamond 9882 109 0.990825688073395 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Polyporales Steccherinaceae Steccherinum Steccherinum ochraceum
29907028 29907028 PRJEB2925_P_NODE_7451_length_463_cov_5.189252_g6264_i0 PRJEB2925 7451 463 5.189252 24.02623676 Tulasnella sp. 417 2600225 Fungi Fungi 115 6.47e-30   NR KAG8920536.1 2600225 g6264 i0 49.2 0.842332613390929 130 62 81.6 1 7 384 6 135 KAG8920536.1 ribosomal protein S24A [Tulasnella sp. 417] diamond 390 115 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Cantharellales Tulasnellaceae Tulasnella Tulasnella sp. 417
31891615 31891615 PRJEB2925_P_NODE_10737_length_345_cov_2.209677_g9464_i0 PRJEB2925 10737 345 2.209677 7.62338565 Fungi 4751 Fungi Fungi 166 2.0499999999999998e-47   NR KAI0034513.1 1314806 g9464 i0 71.2 9.6 111 31 95.7 1 2 331 279 389 KAI0034513.1 S-adenosylmethionine synthetase [Vararia minispora EC-137] diamond 3312 167 0.994011976047904 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Russulales Lachnocladiaceae Vararia Vararia minispora

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