RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA217180" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA217180 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
7433949 7433949 PRJNA217180_P_NODE_7846_length_211_cov_1.259259_g7746_i0 PRJNA217180 7846 211 1.259259 2.65703649 root 1 Root_unresolved Root_unresolved 52.8 0.019   NTclustered gi|2608287065|ref|XM_060502650.1| 27357 g7746 i0 94.286 1.45971563981043 35 0 16 1 113 145 501 467 Colletotrichum acutatum vesicle transport V-SNARE protein (BDZ83DRAFT_372571), mRNA blastn 308 52.8 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Glomerellales Glomerellaceae Colletotrichum Colletotrichum acutatum
9984140 9984140 PRJNA217180_P_NODE_14328_length_163_cov_0.894737_g14228_i0 PRJNA217180 14328 163 0.894737 1.45842131 Ascomycota 4890 Fungi Fungi 130 6.1e-26   NTclustered gi|589098162|ref|XM_006961042.1| 431241 g14228 i0 98.63 43.7668711656442 73 1 45 0 1 73 1224 1296 Trichoderma reesei QM6a uncharacterized protein (TRIREDRAFT_44504), mRNA blastn 7134 130 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Hypocreaceae Trichoderma Trichoderma reesei
9984143 9984143 PRJNA217180_P_NODE_14948_length_162_cov_0.902655_g14848_i0 PRJNA217180 14948 162 0.902655 1.4623011 Ascomycota 4890 Fungi Fungi 261 2.06e-65   NTclustered gi|1868548615|ref|XM_035508391.1| 45133 g14848 i0 95.679 99.1913580246914 162 7 100 0 1 162 1443 1282 Lasiodiplodia theobromae ATP synthase (LTHEOB_11615), partial mRNA blastn 16069 261 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Botryosphaeriales Botryosphaeriaceae Lasiodiplodia Lasiodiplodia theobromae
14396149 14396149 PRJNA217180_P_NODE_2352_length_376_cov_1.247706_g2252_i0 PRJNA217180 2352 376 1.247706 4.69137456 Candida pseudojiufengensis 497109 Fungi Fungi 337 8.83e-88   NTclustered gi|2325083994|ref|XM_051758127.1| 497109 g2252 i0 83.558 67.7367021276596 371 49 97 11 12 376 28 392 Candida pseudojiufengensis actin (KGF55_003344), partial mRNA blastn 25469 337 1 Eukaryota Opisthokonta Fungi Ascomycota Pichiomycetes Serinales Debaryomycetaceae Candida Candida pseudojiufengensis

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