RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA534016" and tax_clade = "Metamonada"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Metamonada · 5 ✖

bioproject 1

  • PRJNA534016 · 5 ✖

analysis 1

  • blastn · 5 ✖

tax_kingdom 0

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
1782812 1782812 PRJNA534016_P_NODE_13922_length_250_cov_3.316384_g13832_i0 PRJNA534016 13922 250 3.316384 8.29096 Spironucleus salmonis 373374 Fornicata other_Eukaryota 143 1.31e-29   NTclustered gi|88810109|gb|DQ394704.1| 373374 g13832 i0 81.564 17.476 179 27 70 4 77 250 667 844 Spironucleus salmonis small subunit ribosomal RNA gene, partial sequence blastn 4369 143 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Spironucleus Spironucleus salmonis
8160369 8160369 PRJNA534016_P_NODE_7107_length_317_cov_1.262295_g7017_i0 PRJNA534016 7107 317 1.262295 4.00147515 Spironucleus vortens 58336 Fornicata other_Eukaryota 392 1.54e-104   NTclustered gi|158973894|gb|EU099373.1| 58336 g7017 i0 88.994 16.2302839116719 318 33 100 2 1 317 497 181 Spironucleus vortens alpha-tubulin gene, complete cds blastn 5145 392 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Spironucleus Spironucleus vortens
9435809 9435809 PRJNA534016_P_NODE_1708_length_627_cov_1.676895_g1621_i0 PRJNA534016 1708 627 1.676895 10.51413165 Spironucleus vortens 58336 Fornicata other_Eukaryota 832 0   NTclustered gi|158973894|gb|EU099373.1| 58336 g1621 i0 90.59 96.8915470494418 627 59 100 0 1 627 456 1082 Spironucleus vortens alpha-tubulin gene, complete cds blastn 60751 832 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Spironucleus Spironucleus vortens
13261430 13261430 PRJNA534016_P_NODE_7531_length_309_cov_1.262712_g7441_i0 PRJNA534016 7531 309 1.262712 3.90178008 Spironucleus salmonicida 348837 Fornicata other_Eukaryota 148 3.5799999999999995e-31   NTclustered gi|2794886949|ref|XM_067907490.1| 348837 g7441 i0 80 0.679611650485437 210 34 66 8 93 297 168 374 Spironucleus salmonicida Ribosomal protein S23 (SS50377_23626), partial mRNA blastn 210 148 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Spironucleus Spironucleus salmonicida
18359109 18359109 PRJNA534016_P_NODE_815_length_914_cov_1.500595_g741_i0 PRJNA534016 815 914 1.500595 13.7154383 Spironucleus vortens 58336 Fornicata other_Eukaryota 1040 0   NTclustered gi|2522341|gb|U94406.1|SVU94406 58336 g741 i0 88.082 37.5568927789934 881 100 96 3 1 877 324 1203 Spironucleus vortens elongation factor-1 alpha gene, partial cds blastn 34327 1040 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Spironucleus Spironucleus vortens

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