RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA715462" and tax_clade = "Apusozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Apusozoa · 3 ✖

bioproject 1

  • PRJNA715462 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
8358541 8358541 PRJNA715462_P_NODE_11747_length_599_cov_5.150190_g10962_i0 PRJNA715462 11747 599 5.15019 30.8496381 Thecamonas trahens 529818 Root_unresolved Root_unresolved 224 1.19e-53   NTclustered gi|923125359|ref|XM_013900694.1| 461836 g10962 i0 82.879 10.8113522537563 257 36 42 6 204 456 277 529 Thecamonas trahens ATCC 50062 calmodulin (AMSG_07687), mRNA blastn 6476 224 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
16008398 16008398 PRJNA715462_P_NODE_34573_length_301_cov_0.991228_g33777_i0 PRJNA715462 34573 301 0.991228 2.98359628 Catacumbia lutetiensis 2925415 Root_unresolved Root_unresolved 154 7.46e-33   NTclustered gi|2206682166|gb|OM966639.1| 2925415 g33777 i0 88.8 37.0232558139535 125 14 42 0 157 281 5302 5178 Catacumbia lutetiensis strain ORSAYFEB19APU2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 11144 154 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Catacumbia Catacumbia lutetiensis
21108580 21108580 PRJNA715462_P_NODE_4857_length_1123_cov_9.987619_g4295_i0 PRJNA715462 4857 1123 9.987619 112.16096137 Thecamonas trahens 529818 Root_unresolved Root_unresolved 409 5.889999999999999e-109   NTclustered gi|923134252|ref|XM_013905138.1| 461836 g4295 i0 76.549 16.9768477292965 823 147 71 33 114 913 198 997 Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA blastn 19065 409 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);;