RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA752572" and tax_clade = "Apusozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Apusozoa · 4 ✖

bioproject 1

  • PRJNA752572 · 4 ✖

analysis 1

  • diamond · 4 ✖

tax_phylum 0

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
27369273 27369273 PRJNA752572_P_NODE_202203_length_187_cov_1.578947_g201696_i0 PRJNA752572 202203 187 1.578947 2.95263089 Thecamonas trahens ATCC 5 529818 Root_unresolved Root_unresolved 62.8 1.46e-9   NR XP_013754710.1 461836 g201696 i0 47.5 0.978609625668449 61 26 94.7 2 185 9 558 614 XP_013754710.1 uncharacterized protein AMSG_09324 [Thecamonas trahens ATCC 50062] diamond 183 62.8 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
32107596 32107596 PRJNA752572_P_NODE_17958_length_633_cov_3.727425_g17528_i0 PRJNA752572 17958 633 3.727425 23.59460025 Thecamonas trahens ATCC 5 529818 Root_unresolved Root_unresolved 169 3.21e-45   NR XP_013754710.1 461836 g17528 i0 42.4 0.962085308056872 203 104 91.9 6 619 38 464 662 XP_013754710.1 uncharacterized protein AMSG_09324 [Thecamonas trahens ATCC 50062] diamond 609 169 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
32339239 32339239 PRJNA752572_P_NODE_272119_length_163_cov_1.250000_g271612_i0 PRJNA752572 272119 163 1.25 2.0375 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 43.9 0.00503   NR XP_013754710.1 461836 g271612 i0 38.8 2.74233128834356 49 29 90.2 1 162 16 574 621 XP_013754710.1 uncharacterized protein AMSG_09324 [Thecamonas trahens ATCC 50062] diamond 447 43.9 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
32392400 32392400 PRJNA752572_P_NODE_205979_length_185_cov_1.880000_g205472_i0 PRJNA752572 205979 185 1.88 3.478 Thecamonas trahens ATCC 5 529818 Root_unresolved Root_unresolved 97.4 9.42e-22   NR XP_013756469.1 461836 g205472 i0 80.3 1.97837837837838 61 12 98.9 0 183 1 379 439 XP_013756469.1 prolifera [Thecamonas trahens ATCC 50062] diamond 366 97.4 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens

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