RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA473201" and tax_phylum = "Zoopagomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Zoopagomycota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA473201 · 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
4270318 4270318 PRJNA473201_P_NODE_15484_length_507_cov_1.504608_g14743_i0 PRJNA473201 15484 507 1.504608 7.62836256 Linderina pennispora 61395 Fungi Fungi 411 7.1e-110   NTclustered gi|2028311994|ref|XM_040883102.1| 61395 g14743 i0 83.945 83.258382642998 436 63 86 7 1 434 748 1178 Linderina pennispora uncharacterized protein (DL89DRAFT_11075), mRNA blastn 42212 411 1 Eukaryota Opisthokonta Fungi Zoopagomycota Kickxellomycetes Kickxellales Kickxellaceae Linderina Linderina pennispora
23396102 23396102 PRJNA473201_P_NODE_45819_length_302_cov_1.004367_g45077_i0 PRJNA473201 45819 302 1.004367 3.03318834 Linderina pennispora 61395 Fungi Fungi 124 5.87e-24   NTclustered gi|2028317388|ref|XM_040891296.1| 61395 g45077 i0 82.517 4.32119205298013 143 23 47 2 15 156 207 348 Linderina pennispora light chain 3 (DL89DRAFT_321675), partial mRNA blastn 1305 124 1 Eukaryota Opisthokonta Fungi Zoopagomycota Kickxellomycetes Kickxellales Kickxellaceae Linderina Linderina pennispora
23396507 23396507 PRJNA473201_P_NODE_67619_length_250_cov_1.000000_g66877_i0 PRJNA473201 67619 250 1 2.5 Linderina pennispora 61395 Fungi Fungi 156 1.68e-33   NTclustered gi|2028311014|ref|XM_040889407.1| 61395 g66877 i0 80.693 6.72 202 37 80 2 50 250 596 396 Linderina pennispora ribosomal protein S6e (DL89DRAFT_276961), partial mRNA blastn 1680 156 1 Eukaryota Opisthokonta Fungi Zoopagomycota Kickxellomycetes Kickxellales Kickxellaceae Linderina Linderina pennispora

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