RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB75017" and tax_phylum = "Discosea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Discosea · 6 ✖

tax_clade 1

bioproject 1

  • PRJEB75017 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
7787807 7787807 PRJEB75017_P_NODE_7187_length_333_cov_1.188462_g7058_i0 PRJEB75017 7187 333 1.188462 3.95757846 Platyamoeba placida 3454475 Discosea other_Eukaryota 455 2.05e-123   NTclustered gi|33946348|gb|AY294153.1| 197527 g7058 i0 91.291 99.0960960960961 333 29 100 0 1 333 538 870 Platyamoeba placida actin mRNA, partial cds blastn 32999 455 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Platyamoeba Platyamoeba placida
12888903 12888903 PRJEB75017_P_NODE_151_length_1736_cov_6.110643_g121_i0 PRJEB75017 151 1736 6.110643 106.08076248 Cochliopodium actinophorum 703021 Discosea other_Eukaryota 2741 0   NTclustered gi|330902846|gb|JF298250.1| 703021 g121 i0 97.979 48.3945852534562 1583 25 91 7 159 1736 2176 596 Cochliopodium actinophorum clone 1201 18S ribosomal RNA gene, partial sequence blastn 84013 2741 1 Eukaryota Amoebozoa   Discosea   Himatismenida Cochliopodiidae Cochliopodium Cochliopodium actinophorum
12888987 12888987 PRJEB75017_P_NODE_9691_length_292_cov_1.301370_g9562_i0 PRJEB75017 9691 292 1.30137 3.8000004 Paravannella minima 1443144 Discosea other_Eukaryota 139 2.02e-28   NTclustered gi|1583105587|ref|NC_040955.1| 1443144 g9562 i0 86.26 0.448630136986301 131 14 44 4 1 128 31909 32038 Paravannella minima mitochondrion, complete genome blastn 131 139 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Paravannella Paravannella minima
15437903 15437903 PRJEB75017_P_NODE_7913_length_319_cov_1.292683_g7784_i0 PRJEB75017 7913 319 1.292683 4.12365877 Vannella persistens 303303 Discosea other_Eukaryota 579 1.1099999999999996e-160   NTclustered gi|165968549|gb|EU377589.1| 303303 g7784 i0 99.373 99.3699059561129 319 2 100 0 1 319 331 649 Vannella persistens strain CRIB49 18S ribosomal RNA gene, partial sequence blastn 31699 579 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Vannella Vannella persistens
16712013 16712013 PRJEB75017_P_NODE_1394_length_732_cov_6.836115_g1273_i0 PRJEB75017 1394 732 6.836115 50.0403618 Cochliopodium actinophorum 703021 Discosea other_Eukaryota 1059 0   NTclustered gi|330902845|gb|JF298249.1| 703021 g1273 i0 98.505 50.655737704918 602 6 82 3 131 732 4 602 Cochliopodium actinophorum clone 1202 18S ribosomal RNA gene, partial sequence blastn 37080 1059 1 Eukaryota Amoebozoa   Discosea   Himatismenida Cochliopodiidae Cochliopodium Cochliopodium actinophorum
24361242 24361242 PRJEB75017_P_NODE_800_length_937_cov_6.237269_g707_i0 PRJEB75017 800 937 6.237269 58.44321053 Platyamoeba placida 3454475 Discosea other_Eukaryota 1238 0   NTclustered gi|33946348|gb|AY294153.1| 197527 g707 i0 90.502 99.0640341515475 937 89 100 0 1 937 1024 88 Platyamoeba placida actin mRNA, partial cds blastn 92823 1238 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Platyamoeba Platyamoeba placida

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