RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA975724" and tax_clade = "Apusozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Apusozoa · 4 ✖

bioproject 1

  • PRJNA975724 · 4 ✖

analysis 1

  • blastn · 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
2220770 2220770 PRJNA975724_S_NODE_13602_length_421_cov_102.600575_g13421_i0 PRJNA975724 13602 421 102.600575 431.94842075 Apusomonas proboscidea 41120 Root_unresolved Root_unresolved 475 2.03e-129   NTclustered gi|116222182|gb|DQ980467.1| 41120 g13421 i0 87.99 97.7624703087886 408 42 96 7 17 421 2546 2949 Apusomonas proboscidea clone aplsu large subunit ribosomal RNA gene, partial sequence blastn 41158 475 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Apusomonas Apusomonas proboscidea
6048580 6048580 PRJNA975724_S_NODE_11585_length_436_cov_18.443526_g11404_i0 PRJNA975724 11585 436 18.443526 80.41377336 Thecamonas trahens 529818 Root_unresolved Root_unresolved 69.4 4.18e-7   NTclustered gi|923135822|ref|XM_013905923.1| 461836 g11404 i0 97.5 0.172018348623853 40 1 9 0 234 273 1513 1474 Thecamonas trahens ATCC 50062 phosphatidylinositol 3-and 4-kinase (AMSG_01873), partial mRNA blastn 75 69.4 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
8598932 8598932 PRJNA975724_S_NODE_3587_length_565_cov_139.288618_g3410_i0 PRJNA975724 3587 565 139.288618 786.9806917 Podomonas magna 2925398 Root_unresolved Root_unresolved 211 8.68e-50   NTclustered gi|2206682163|gb|OM966636.1| 2925398 g3410 i0 87.5 37.4902654867257 184 21 33 2 359 542 5988 5807 Podomonas magna strain CCAP19014 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 21182 211 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Podomonas Podomonas magna
22622784 22622784 PRJNA975724_S_NODE_23578_length_371_cov_1.949664_g23397_i0 PRJNA975724 23578 371 1.949664 7.23325344 Thecamonas trahens 529818 Root_unresolved Root_unresolved 67.6 1.26e-6   NTclustered gi|923136249|ref|XM_013906136.1| 461836 g23397 i0 97.436 1.73045822102426 39 1 11 0 140 178 863 825 Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_01539), partial mRNA blastn 642 67.6 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);;