RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA1158727" and tax_phylum = "Nematoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nematoda · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1158727 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
1578740 1578740 PRJNA1158727_P_NODE_148022_length_246_cov_1.537572_g140560_i0 PRJNA1158727 148022 246 1.537572 3.78242712 Caenorhabditis elegans 6239 Nematoda Nematoda 52.8 0.022   NTclustered gi|687865899|emb|LK927846.1| 6239 g140560 i0 100 0.227642276422764 28 0 11 0 50 77 80350 80323 Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000274 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis elegans
6681821 6681821 PRJNA1158727_P_NODE_139746_length_249_cov_1.738636_g132284_i0 PRJNA1158727 139746 249 1.738636 4.32920364 Pristionchus sp. 15 RS5229 452809 Nematoda Nematoda 128 3.64e-25   NTclustered gi|150984457|gb|EF634871.1| 452809 g132284 i0 76.096 5.10441767068273 251 56 100 3 1 249 266 18 Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds blastn 1271 128 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Neodiplogasteridae Pristionchus Pristionchus sp. 15 RS5229
10507311 10507311 PRJNA1158727_P_NODE_120849_length_266_cov_1.632124_g113388_i0 PRJNA1158727 120849 266 1.632124 4.34144984 Pristionchus hoplostomus 1355913 Nematoda Nematoda 167 8.33e-37   NTclustered gi|524845312|gb|KC819366.1| 1355913 g113388 i0 81.166 46.4285714285714 223 28 81 11 32 247 49 264 Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds blastn 12350 167 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Neodiplogasteridae Pristionchus Pristionchus hoplostomus
12516291 12516291 PRJNA1158727_P_NODE_156850_length_243_cov_0.905882_g149388_i0 PRJNA1158727 156850 243 0.905882 2.20129326 Pristionchus 54125 Nematoda Nematoda 130 9.84e-26   NTclustered gi|150984517|gb|EF634901.1| 376546 g149388 i0 80.769 4.54320987654321 182 21 72 13 10 184 264 90 Pristionchus marianneae small subunit ribosomal protein 20 (rps-20) mRNA, complete cds blastn 1104 130 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Neodiplogasteridae Pristionchus Pristionchus marianneae
18157554 18157554 PRJNA1158727_P_NODE_55995_length_451_cov_3.161376_g48535_i0 PRJNA1158727 55995 451 3.161376 14.25780576 Caenorhabditis briggsae 6238 Nematoda Nematoda 348 4.980000000000001e-91   NTclustered gi|268559799|ref|XM_002646027.1| 6238 g48535 i0 85.801 72.9778270509978 331 43 73 4 2 330 979 1307 Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA blastn 32913 348 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis briggsae
19429940 19429940 PRJNA1158727_P_NODE_136976_length_250_cov_1.740113_g129514_i0 PRJNA1158727 136976 250 1.740113 4.3502825 Panagrolaimus sp. 2726203 Nematoda Nematoda 211 3.53e-50   NTclustered gi|2491200846|gb|OQ842736.1| 2726203 g129514 i0 82.308 63.556 260 31 99 14 1 249 873 1128 Panagrolaimus sp. isolate NJdiseased small subunit ribosomal RNA gene, partial sequence blastn 15889 211 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Panagrolaimidae Panagrolaimus Panagrolaimus sp.
19432580 19432580 PRJNA1158727_P_NODE_84016_length_328_cov_1.925490_g76555_i0 PRJNA1158727 84016 328 1.92549 6.3156072 Globodera rostochiensis 31243 Nematoda Nematoda 54.7 0.009   NTclustered gi|44843528|gb|AY426767.1| 31243 g76555 i0 100 0.0884146341463415 29 0 9 0 107 135 1866 1894 Globodera rostochiensis matrix metalloproteinase mRNA, complete cds blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Heteroderidae Globodera Globodera rostochiensis
23255372 23255372 PRJNA1158727_P_NODE_102219_length_289_cov_1.620370_g94758_i0 PRJNA1158727 102219 289 1.62037 4.6828693 Levipalatum texanum 1486449 Nematoda Nematoda 200 9.03e-47   NTclustered gi|610559467|gb|KJ395558.1| 1486449 g94758 i0 82.158 3.62975778546713 241 35 82 6 24 260 148 384 Levipalatum texanum ribosomal protein (rpl-23) gene, partial cds blastn 1049 200 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Diplogasteridae Levipalatum Levipalatum texanum

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