RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1186363" and tax_phylum = "Chytridiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chytridiomycota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1186363 · 3 ✖

analysis 1

  • blastn · 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
2870652 2870652 PRJNA1186363_P_NODE_7703_length_760_cov_1.267831_g6891_i0 PRJNA1186363 7703 760 1.267831 9.6355156 Fimicolochytrium jonesii 1396493 Fungi Fungi 56.5 0.006   NTclustered gi|2432063027|ref|XM_053073854.1| 1396493 g6891 i0 100 0.0394736842105263 30 0 4 0 662 691 1651 1622 Fimicolochytrium jonesii DNA mismatch repair protein Mlh1 (EV422DRAFT_610004), mRNA blastn 30 56.5 1 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Spizellomycetales Powellomycetaceae Fimicolochytrium Fimicolochytrium jonesii
7973040 7973040 PRJNA1186363_P_NODE_36427_length_266_cov_1.212435_g35539_i0 PRJNA1186363 36427 266 1.212435 3.2250771 Fimicolochytrium jonesii 1396493 Fungi Fungi 56.5 0.002   NTclustered gi|2432100133|ref|XM_053072958.1| 1396493 g35539 i0 94.595 0.270676691729323 37 1 14 1 221 256 279 243 Fimicolochytrium jonesii RIO1 family-domain-containing protein (EV422DRAFT_571151), partial mRNA blastn 72 56.5 1 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Spizellomycetales Powellomycetaceae Fimicolochytrium Fimicolochytrium jonesii
20721074 20721074 PRJNA1186363_P_NODE_23517_length_379_cov_21.964052_g22629_i0 PRJNA1186363 23517 379 21.964052 83.24375708 Fimicolochytrium jonesii 1396493 Fungi Fungi 128 5.83e-25   NTclustered gi|2432058563|ref|XM_053065718.1| 1396493 g22629 i0 79.558 2.18469656992084 181 35 47 2 97 276 259 80 Fimicolochytrium jonesii 40S ribosomal protein S28 (EV422DRAFT_248144), mRNA blastn 828 128 1 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Spizellomycetales Powellomycetaceae Fimicolochytrium Fimicolochytrium jonesii

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