RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1111448" and tax_phylum = "Basidiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Basidiomycota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1111448 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
18069193 18069193 PRJNA1111448_S_NODE_131055_length_245_cov_1.343023_g130232_i0 PRJNA1111448 131055 245 1.343023 3.29040635 Amylostereum chailletii 55340 Fungi Fungi 132 5.34e-38   NR KAI0315037.1 55340 g130232 i0 84.9 8.04489795918367 73 11 89.4 0 242 24 24 96 KAI0315037.1 60S ribosomal protein L37, partial [Amylostereum chailletii] diamond 1971 132 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Russulales Stereaceae Amylostereum Amylostereum chailletii
29278195 29278195 PRJNA1111448_S_NODE_130789_length_245_cov_1.546512_g129966_i0 PRJNA1111448 130789 245 1.546512 3.7889544 Mycena galopus ATCC 62 41248 Fungi Fungi 42 0.047   NR KAF8200597.1 1314675 g129966 i0 40.5 0.514285714285714 42 25 51.4 0 54 179 19 60 KAF8200597.1 hypothetical protein K438DRAFT_1758801 [Mycena galopus ATCC 62051] diamond 126 42 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Agaricales Mycenaceae Mycena Mycena galopus
29341586 29341586 PRJNA1111448_S_NODE_36689_length_384_cov_5.247588_g35866_i0 PRJNA1111448 36689 384 5.247588 20.15073792 Rhizoctonia solani 456999 Fungi Fungi 124 2.98e-33   NR KAF8709163.1 456999 g35866 i0 51.7 6.421875 116 56 90.6 0 16 363 51 166 KAF8709163.1 TCTP family, partial [Rhizoctonia solani] diamond 2466 124 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Cantharellales Ceratobasidiaceae Rhizoctonia Rhizoctonia solani

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