RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA986547" and tax_phylum = "Nematoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nematoda · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA986547 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
13727705 13727705 PRJNA986547_P_NODE_13371_length_232_cov_6.805031_g13289_i0 PRJNA986547 13371 232 6.805031 15.78767192 Trichinella spiralis 6334 Nematoda Nematoda 54.7 0.006   NTclustered gi|339262803|ref|XM_003367173.1| 6334 g13289 i0 88 0.939655172413793 50 1 21 4 51 99 259 214 Trichinella spiralis conserved hypothetical protein (Tsp_13564) mRNA, complete cds blastn 218 54.7 1 Eukaryota Opisthokonta Metazoa Nematoda Enoplea Trichinellida Trichinellidae Trichinella Trichinella spiralis
15002016 15002016 PRJNA986547_P_NODE_1192_length_409_cov_3.547619_g1110_i0 PRJNA986547 1192 409 3.547619 14.50976171 Pristionchus sp. 11 RS5228 452806 Nematoda Nematoda 344 5.79e-90   NTclustered gi|150984487|gb|EF634886.1| 452806 g1110 i0 85.455 82.4254278728606 330 48 81 0 16 345 387 58 Pristionchus sp. 11 RS5228 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds blastn 33712 344 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Neodiplogasteridae Pristionchus Pristionchus sp. 11 RS5228
23926730 23926730 PRJNA986547_P_NODE_2659_length_310_cov_5.527426_g2577_i0 PRJNA986547 2659 310 5.527426 17.1350206 Caenorhabditis briggsae 6238 Nematoda Nematoda 152 2.7799999999999996e-32   NTclustered gi|11094915|gb|AC084465.1|AC084465 6238 g2577 i0 77.5 20.8838709677419 280 46 89 7 34 310 37012 37277 Caenorhabditis briggsae cosmid CB039B01, complete sequence blastn 6474 152 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis briggsae
24223920 24223920 PRJNA986547_P_NODE_17199_length_199_cov_4.277778_g17117_i0 PRJNA986547 17199 199 4.277778 8.51277822 Metazoa 33208 Nematoda Nematoda 222 1.24e-53   NTclustered gi|268537031|ref|XM_002633606.1| 6238 g17117 i0 87.179 92.3115577889447 195 25 98 0 2 196 299 105 Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA blastn 18370 222 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis briggsae

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