RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Apusozoa · 4 ✖

bioproject 1

  • PRJEB14803 · 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
5123980 5123980 PRJEB14803_P_NODE_6585_length_527_cov_225.128049_g6139_i0 PRJEB14803 6585 527 225.128049 1186.42481823 Cavaliersmithia chaoae 3003318 Root_unresolved Root_unresolved 195 8.119999999999999e-45   NTclustered gi|2206682172|gb|OM966645.1| 3003318 g6139 i0 89.172 35.0170777988615 157 16 36 1 60 216 6453 6608 Cavaliersmithia chaoae strain FABANU 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 18454 195 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Cavaliersmithia Cavaliersmithia chaoae
6399476 6399476 PRJEB14803_P_NODE_11506_length_372_cov_2.949555_g11041_i0 PRJEB14803 11506 372 2.949555 10.9723446 Catacumbia lutetiensis 2925415 Root_unresolved Root_unresolved 165 4.36e-36   NTclustered gi|2206682166|gb|OM966639.1| 2925415 g11041 i0 90.4 30.8037634408602 125 12 34 0 165 289 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 11459 165 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Catacumbia Catacumbia lutetiensis
20422134 20422134 PRJEB14803_P_NODE_23317_length_233_cov_2.015152_g22851_i0 PRJEB14803 23317 233 2.015152 4.69530416 Thecamonas trahens 529818 Root_unresolved Root_unresolved 54.7 0.006   NTclustered gi|923123446|ref|XM_013899738.1| 461836 g22851 i0 96.875 0.137339055793991 32 1 14 0 77 108 720 751 Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_08508), partial mRNA blastn 32 54.7 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
24247410 24247410 PRJEB14803_P_NODE_7860_length_474_cov_2.642369_g7403_i0 PRJEB14803 7860 474 2.642369 12.52482906 Thecamonas trahens 529818 Root_unresolved Root_unresolved 283 1.5e-71   NTclustered gi|923124038|ref|XM_013900034.1| 461836 g7403 i0 77.824 37.0717299578059 478 92 99 10 2 472 1214 744 Thecamonas trahens ATCC 50062 seryl-tRNA synthetase (AMSG_08432), mRNA blastn 17572 283 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);;