RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB7799 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
25889285 25889285 PRJEB7799p_S_NODE_1259_length_369_cov_597.419162_g1236_i0 PRJEB7799 1259 369 597.419162 2204.47670778 Eukaryota 2759 Fungi Fungi 134 2.74e-34   NR KLO80480.1 5127 g1236 i0 88.6 185.552845528455 70 8 56.9 0 368 159 405 474 KLO80480.1 Uncharacterized protein LW93_6696 [Fusarium fujikuroi] diamond 68469 135 0.992592592592593 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Nectriaceae Fusarium Fusarium fujikuroi
32930549 32930549 PRJEB7799m_S_NODE_1633_length_171_cov_6.698529_g1628_i0 PRJEB7799 1633 171 6.698529 11.45448459 Aspergillus wentii DTO 134E9 1073089 Fungi Fungi 44.7 7.71e-4   NR XP_040684837.1 1073089 g1628 i0 75 6.85964912280702 28 7 49.1 0 3 86 43 70 XP_040684837.1 ribosomal protein P2 [Aspergillus wentii DTO 134E9] diamond 1173 44.7 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Aspergillus Aspergillus wentii
32930857 32930857 PRJEB7799p_S_NODE_2041_length_318_cov_3.968198_g2018_i0 PRJEB7799 2041 318 3.968198 12.61886964 Scedosporium apiospermum 563466 Fungi Fungi 43.9 0.0363   NR XP_016641652.1 563466 g2018 i0 42.2 0.424528301886792 45 24 42.5 1 25 159 740 782 XP_016641652.1 WD repeat protein [Scedosporium apiospermum] diamond 135 43.9 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Microascales Microascaceae Scedosporium Scedosporium apiospermum
32947806 32947806 PRJEB7799n_S_NODE_12426_length_151_cov_3.612069_g12389_i0 PRJEB7799 12426 151 3.612069 5.45422419 Pichia kudriavzevii 4909 Fungi Fungi 73.2 2.37e-14   NR OUT19920.1 4909 g12389 i0 86.8 0.754966887417219 38 5 75.5 0 2 115 151 188 OUT19920.1 fumarate hydratase, mitochondrial [Pichia kudriavzevii] diamond 114 73.2 1 Eukaryota Opisthokonta Fungi Ascomycota Pichiomycetes Pichiales Pichiaceae Pichia Pichia kudriavzevii
32947900 32947900 PRJEB7799n_S_NODE_5450_length_201_cov_9.379518_g5413_i0 PRJEB7799 5450 201 9.379518 18.85283118 Pichia californica 460514 Fungi Fungi 40.4 0.047   NR KAG0683259.1 460514 g5413 i0 60 0.447761194029851 30 12 44.8 0 197 108 73 102 KAG0683259.1 ribosomal 40S subunit protein S25A [Pichia californica] diamond 90 40.4 1 Eukaryota Opisthokonta Fungi Ascomycota Pichiomycetes Pichiales Pichiaceae Pichia Pichia californica
32965356 32965356 PRJEB7799p_S_NODE_6618_length_214_cov_3.916201_g6595_i0 PRJEB7799 6618 214 3.916201 8.38067014 Fusarium solani 169388 Fungi Fungi 90.5 8.790000000000001e-21   NR KAH7253306.1 169388 g6595 i0 100 0.560747663551402 40 0 56.1 0 214 95 141 180 KAH7253306.1 hypothetical protein B0J15DRAFT_39125 [Fusarium solani] diamond 120 90.5 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Nectriaceae Fusarium Fusarium solani
33042817 33042817 PRJEB7799h_S_NODE_676_length_219_cov_1.869565_g673_i0 PRJEB7799 676 219 1.869565 4.09434735 Fungi 4751 Fungi Fungi 46.2 5.69e-4   NR KAE8323835.1 1034303 g673 i0 72 1.04109589041096 25 7 34.2 0 19 93 110 134 KAE8323835.1 hypothetical protein BDV39DRAFT_208501 [Aspergillus sergii] diamond 228 46.2 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Aspergillus Aspergillus sergii
33059896 33059896 PRJEB7799p_S_NODE_3373_length_268_cov_15.682403_g3350_i0 PRJEB7799 3373 268 15.682403 42.02884004 Ascomycota 4890 Fungi Fungi 45.8 3.31e-4   NR KAF1948084.1 147558 g3350 i0 59.5 1.75746268656716 37 15 41.4 0 105 215 9 45 KAF1948084.1 hypothetical protein CC80DRAFT_57283 [Byssothecium circinans] diamond 471 45.8 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Pleosporales Massarinaceae Byssothecium Byssothecium circinans
33076953 33076953 PRJEB7799p_S_NODE_9877_length_193_cov_3.291139_g9854_i0 PRJEB7799 9877 193 3.291139 6.35189827 Hypocreales 5125 Fungi Fungi 40 0.0305   NR KAH7312388.1 80388 g9854 i0 62.5 0.963730569948187 32 12 49.7 0 1 96 38 69 KAH7312388.1 glucose-repressible protein Grg1 [Stachybotrys elegans] diamond 186 40 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Stachybotryaceae Stachybotrys Stachybotrys elegans
33084531 33084531 PRJEB7799p_S_NODE_20598_length_163_cov_1.875000_g20575_i0 PRJEB7799 20598 163 1.875 3.05625 Myotisia sp. PD_48 2135911 Fungi Fungi 44.3 0.00269   NR KAK2739774.1 2135911 g20575 i0 50 1.56441717791411 42 21 77.3 0 162 37 137 178 KAK2739774.1 40S ribosomal protein S9 [Myotisia sp. PD_48] diamond 255 44.3 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Onygenales   Myotisia Myotisia sp. PD_48
33128153 33128153 PRJEB7799n_S_NODE_4047_length_227_cov_3.218750_g4010_i0 PRJEB7799 4047 227 3.21875 7.3065625 Ascomycota 4890 Fungi Fungi 47.4 5.28e-5   NR KAF1948084.1 147558 g4010 i0 59.5 2.12775330396476 37 15 48.9 0 99 209 9 45 KAF1948084.1 hypothetical protein CC80DRAFT_57283 [Byssothecium circinans] diamond 483 47.8 0.99163179916318 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Pleosporales Massarinaceae Byssothecium Byssothecium circinans
33135026 33135026 PRJEB7799h_S_NODE_527_length_236_cov_1658.746269_g524_i0 PRJEB7799 527 236 1658.746269 3914.64119484 Byssothecium circinans 147558 Fungi Fungi 46.6 1.18e-4   NR KAF1948084.1 147558 g524 i0 59.5 1.70338983050847 37 15 47 0 83 193 9 45 KAF1948084.1 hypothetical protein CC80DRAFT_57283 [Byssothecium circinans] diamond 402 46.6 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Pleosporales Massarinaceae Byssothecium Byssothecium circinans
33145276 33145276 PRJEB7799p_S_NODE_19279_length_166_cov_2.312977_g19256_i0 PRJEB7799 19279 166 2.312977 3.83954182 Opisthokonta 33154 Fungi Fungi 76.3 5.73e-16   NR OEJ91080.1 211096 g19256 i0 86.4 103.373493975904 44 5 79.5 1 161 30 94 136 OEJ91080.1 40S ribosomal protein S14 [Hanseniaspora opuntiae] diamond 17160 77 0.990909090909091 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes Saccharomycodales Saccharomycodaceae Hanseniaspora Hanseniaspora opuntiae

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