RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA603943" and tax_phylum = "Nematoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nematoda · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA603943 · 2 ✖

analysis 1

  • blastn · 2 ✖
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
18994426 18994426 PRJNA603943_P_NODE_10235_length_500_cov_2.517564_g10044_i0 PRJNA603943 10235 500 2.517564 12.58782 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 375 2.5499999999999995e-99   NTclustered gi|268559799|ref|XM_002646027.1| 6238 g10044 i0 85.135 74.978 370 51 74 4 5 372 940 1307 Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA blastn 37489 377 0.994694960212202 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis briggsae
24803120 24803120 PRJNA603943_P_NODE_28840_length_334_cov_1.180077_g28648_i0 PRJNA603943 28840 334 1.180077 3.94145718 Pristionchus americanus 376549 Nematoda Nematoda 224 6.31e-54   NTclustered gi|150982255|gb|EF634716.1| 376549 g28648 i0 81.522 64.8263473053892 276 47 82 4 32 305 30 303 Pristionchus americanus large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds blastn 21652 224 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Neodiplogasteridae Pristionchus Pristionchus americanus

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