RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJEB56699", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 3 ✖

tax_clade 1

bioproject 1

  • PRJEB56699 · 3 ✖

analysis 1

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
6502838 6502838 PRJEB56699_P_NODE_2226_length_377_cov_6.833333_g1998_i0 PRJEB56699 2226 377 6.833333 25.76166541 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 359 1.89e-94   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g1998 i0 84.293 33.7082228116711 382 44 100 12 1 377 2203 2573 Rosculus vulgaris isolate CCA sequence blastn 12708 359 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
7777053 7777053 PRJEB56699_P_NODE_187_length_1300_cov_5.153423_g128_i0 PRJEB56699 187 1300 5.153423 66.994499 Rosculus philanguis 2231163 SAR_Eukaryotes SAR_Eukaryotes 1024 0   NTclustered gi|1402550480|gb|MH488766.1| 2231163 g128 i0 82.941 18.61 1190 150 89 41 1 1155 16 1187 Rosculus philanguis isolate HAS small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 24193 1024 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus philanguis
10327643 10327643 PRJEB56699_P_NODE_209_length_1242_cov_8.654575_g145_i0 PRJEB56699 209 1242 8.654575 107.4898215 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 2047 0   NTclustered gi|1402550477|gb|MH488763.1| 2231161 g145 i0 98.116 16.9186795491143 1168 15 94 3 80 1242 1176 11 Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence blastn 21013 2047 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi

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