RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1082072" and tax_phylum = "Evosea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Evosea · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA1082072 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
1467748 1467748 PRJNA1082072_P_NODE_1262_length_308_cov_0.982979_g1255_i0 PRJNA1082072 1262 308 0.982979 3.02757532 Dictyostelium purpureum 5786 Evosea other_Eukaryota 204 7.499999999999998e-48   NTclustered gi|330790679|ref|XM_003283376.1| 5786 g1255 i0 81.25 72.1428571428571 256 44 82 4 16 269 467 720 Dictyostelium purpureum 60S ribosomal protein L8 (DICPUDRAFT_91096), mRNA blastn 22220 204 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Dictyosteliaceae Dictyostelium Dictyostelium purpureum
8670424 8670424 PRJNA1082072_P_NODE_527_length_430_cov_0.862745_g520_i0 PRJNA1082072 527 430 0.862745 3.7098035 Dictyostelium 5782 Evosea other_Eukaryota 219 3.869999999999999e-52   NTclustered gi|167679|gb|M25131.1|DDICAP32A 44689 g520 i0 78.824 1.58139534883721 340 61 77 8 97 429 745 410 D.discoideum CAP32 protein, complete cds blastn 680 219 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Dictyosteliaceae Dictyostelium Dictyostelium discoideum
18044932 18044932 PRJNA1082072_P_NODE_1955_length_258_cov_1.243243_g1948_i0 PRJNA1082072 1955 258 1.243243 3.20756694 Dictyostelium purpureum 5786 Evosea other_Eukaryota 233 7.809999999999999e-57   NTclustered gi|330842214|ref|XM_003293030.1| 5786 g1948 i0 83.137 57.2558139534884 255 43 99 0 4 258 440 186 Dictyostelium purpureum uncharacterized protein (rac1A), mRNA blastn 14772 233 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Dictyosteliaceae Dictyostelium Dictyostelium purpureum

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