RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1005695" and tax_phylum = "Evosea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Evosea · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA1005695 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
153676 153676 PRJNA1005695_P_NODE_4821_length_725_cov_32.984663_g4050_i0 PRJNA1005695 4821 725 32.984663 239.13880675 Endolimax piscium 1284676 Evosea other_Eukaryota 990 0   NTclustered gi|443299290|gb|JX101955.1| 1284676 g4050 i0 91.153 28.2537931034483 746 42 99 23 1 724 744 1 Endolimax piscium clone PM2 18S ribosomal RNA gene, partial sequence blastn 20484 990 1 Eukaryota Amoebozoa   Evosea   Mastigamoebida Entamoebidae Endolimax Endolimax piscium
7806214 7806214 PRJNA1005695_P_NODE_42447_length_206_cov_4.654135_g41595_i0 PRJNA1005695 42447 206 4.654135 9.5875181 Didymium iridis 5793 Evosea other_Eukaryota 215 2.17e-51   NTclustered gi|2687|emb|X60210.1| 5793 g41595 i0 87.568 10.2184466019417 185 23 90 0 21 205 1946 1762 D.iridis LSU rRNA gene blastn 2105 215 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Physariida Didymiaceae Didymium Didymium iridis
18005415 18005415 PRJNA1005695_P_NODE_5915_length_650_cov_3.140381_g5091_i0 PRJNA1005695 5915 650 3.140381 20.4124765 Mastigamoeba balamuthi 108607 Evosea other_Eukaryota 335 5.729999999999999e-87   NTclustered gi|23452830|gb|AF543583.1| 108607 g5091 i0 76.352 26.5784615384615 647 139 98 9 1 640 2728 2089 Mastigamoeba balamuthi putative pyruvate phosphate dikinase (ppdk) gene, complete cds blastn 17276 335 1 Eukaryota Amoebozoa   Evosea   Mastigamoebida Mastigamoebidae Mastigamoeba Mastigamoeba balamuthi
23105742 23105742 PRJNA1005695_P_NODE_2539_length_999_cov_25.580994_g1982_i0 PRJNA1005695 2539 999 25.580994 255.55413006 Endolimax piscium 1284676 Evosea other_Eukaryota 1090 0   NTclustered gi|443299289|gb|JX101954.1| 1284676 g1982 i0 86.5 26.2572572572573 1037 87 99 35 1 996 925 1949 Endolimax piscium clone PM1 18S ribosomal RNA gene, partial sequence blastn 26231 1090 1 Eukaryota Amoebozoa   Evosea   Mastigamoebida Entamoebidae Endolimax Endolimax piscium

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