RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA688931" and tax_phylum = "Nematoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nematoda · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA688931 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
1944712 1944712 PRJNA688931_P_NODE_8482_length_368_cov_2.188088_g8269_i0 PRJNA688931 8482 368 2.188088 8.05216384 Pristionchus pauli 376545 Nematoda Nematoda 259 1.92e-64   NTclustered gi|150982019|gb|EF634598.1| 376545 g8269 i0 80.769 4.00815217391304 338 59 91 6 34 368 395 61 Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds blastn 1475 259 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Neodiplogasteridae Pristionchus Pristionchus pauli
10872544 10872544 PRJNA688931_P_NODE_26449_length_198_cov_1.885906_g26236_i0 PRJNA688931 26449 198 1.885906 3.73409388 Caenorhabditis briggsae 6238 Nematoda Nematoda 117 6e-22   NTclustered gi|268534941|ref|XM_002632558.1| 6238 g26236 i0 87.379 50.7575757575758 103 12 52 1 6 107 1164 1062 Caenorhabditis briggsae Protein CBG21508 (CBG21508), partial mRNA blastn 10050 117 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis briggsae
13422343 13422343 PRJNA688931_P_NODE_19211_length_234_cov_1.108108_g18998_i0 PRJNA688931 19211 234 1.108108 2.59297272 Necator americanus 51031 Nematoda Nematoda 56.5 0.002   NTclustered gi|2707579968|ref|XM_064196305.1| 51031 g18998 i0 100 0.256410256410256 30 0 13 0 57 86 461 490 Necator americanus uncharacterized protein (RB195_000134), partial mRNA blastn 60 56.5 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Ancylostomatidae Necator Necator americanus
18520523 18520523 PRJNA688931_P_NODE_23495_length_211_cov_1.271605_g23282_i0 PRJNA688931 23495 211 1.271605 2.68308655 Caenorhabditis briggsae 6238 Nematoda Nematoda 163 8.21e-36   NTclustered gi|268553132|ref|XM_002634504.1| 6238 g23282 i0 80.569 30.5308056872038 211 41 100 0 1 211 307 97 Caenorhabditis briggsae Protein CBR-RPS-14 (Cbr-rps-14), partial mRNA blastn 6442 163 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis briggsae
23621294 23621294 PRJNA688931_P_NODE_14579_length_270_cov_3.375566_g14366_i0 PRJNA688931 14579 270 3.375566 9.1140282 Pristionchus hoplostomus 1355913 Nematoda Nematoda 156 1.83e-33   NTclustered gi|524845312|gb|KC819366.1| 1355913 g14366 i0 90.678 42.4555555555556 118 9 43 2 99 215 264 148 Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds blastn 11463 156 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Neodiplogasteridae Pristionchus Pristionchus hoplostomus
23621454 23621454 PRJNA688931_P_NODE_38319_length_166_cov_0.888889_g38106_i0 PRJNA688931 38319 166 0.888889 1.47555574 Strongyloides ratti 34506 Nematoda Nematoda 174 2.84e-39   NTclustered gi|1376156759|ref|XM_024645793.1| 34506 g38106 i0 86.624 90.7650602409639 157 21 95 0 2 158 280 124 Strongyloides ratti Ras-like protein 3 (SRAE_X000250800), partial mRNA blastn 15067 174 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Strongyloididae Strongyloides Strongyloides ratti

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