RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA380416" 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

  • PRJNA380416 · 4 ✖

analysis 1

  • diamond · 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
26933816 26933816 PRJNA380416_P_NODE_11842_length_166_cov_0.871795_g11695_i0 PRJNA380416 11842 166 0.871795 1.4471797 Eukaryota 2759 Fungi Fungi 42 0.025   NR TKX22715.1 40998 g11695 i0 42 6.72289156626506 50 29 90.4 0 17 166 309 358 TKX22715.1 actin-related protein 2/3 complex subunit 1 [Elsinoe australis] diamond 1116 42.4 0.990566037735849 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Myriangiales Elsinoaceae Elsinoe Elsinoe australis
29853947 29853947 PRJNA380416_P_NODE_2571_length_378_cov_1.650456_g2424_i0 PRJNA380416 2571 378 1.650456 6.23872368 Friedmanniomyces endolithicus 329885 Fungi Fungi 219 1.77e-71   NR KAK0340137.1 329885 g2424 i0 100 0.888888888888889 112 0 88.9 0 35 370 1 112 KAK0340137.1 hypothetical protein LTR94_031749, partial [Friedmanniomyces endolithicus] diamond 336 219 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Mycosphaerellales Teratosphaeriaceae Friedmanniomyces Friedmanniomyces endolithicus
30770254 30770254 PRJNA380416_P_NODE_6674_length_222_cov_1.751445_g6527_i0 PRJNA380416 6674 222 1.751445 3.8882079 Friedmanniomyces endolithicus 329885 Fungi Fungi 105 1.05e-25   NR KAK0360406.1 329885 g6527 i0 71.6 1.09459459459459 81 15 98.6 1 219 1 55 135 KAK0360406.1 hypothetical protein LTR94_027428, partial [Friedmanniomyces endolithicus] diamond 243 105 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Mycosphaerellales Teratosphaeriaceae Friedmanniomyces Friedmanniomyces endolithicus
30991393 30991393 PRJNA380416_P_NODE_4654_length_272_cov_1.659193_g4507_i0 PRJNA380416 4654 272 1.659193 4.51300496 Friedmanniomyces endolithicus 329885 Fungi Fungi 125 3.37e-33   NR KAK0360406.1 329885 g4507 i0 95.2 0.694852941176471 63 3 69.5 0 271 83 191 253 KAK0360406.1 hypothetical protein LTR94_027428, partial [Friedmanniomyces endolithicus] diamond 189 125 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Mycosphaerellales Teratosphaeriaceae Friedmanniomyces Friedmanniomyces endolithicus

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