RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA680334" 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

  • PRJNA680334 · 6 ✖

analysis 1

  • diamond · 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
27461308 27461308 PRJNA680334_S_NODE_61263_length_180_cov_1.986395_g60777_i0 PRJNA680334 61263 180 1.986395 3.575511 Trichinella pseudospiralis 6337 Nematoda Nematoda 50.4 1.83e-6   NR KRY63622.1 6337 g60777 i0 49 0.85 51 24 81.7 1 180 34 13 63 KRY63622.1 hypothetical protein T4D_13828 [Trichinella pseudospiralis] diamond 153 50.4 1 Eukaryota Opisthokonta Metazoa Nematoda Enoplea Trichinellida Trichinellidae Trichinella Trichinella pseudospiralis
28566211 28566211 PRJNA680334_S_NODE_43607_length_200_cov_3.718563_g43121_i0 PRJNA680334 43607 200 3.718563 7.437126 Litomosoides sigmodontis 42156 Nematoda Nematoda 43.5 0.0048   NR VDK74438.1 42156 g43121 i0 70.8 3.24 24 7 36 0 1 72 112 135 VDK74438.1 unnamed protein product [Litomosoides sigmodontis] diamond 648 43.5 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Onchocercidae Litomosoides Litomosoides sigmodontis
29008637 29008637 PRJNA680334_S_NODE_77588_length_166_cov_611.300752_g77102_i0 PRJNA680334 77588 166 611.300752 1014.75924832 Trichinella pseudospiralis 6337 Nematoda Nematoda 66.2 8.11e-13   NR KRY63622.1 6337 g77102 i0 76.7 3.21686746987952 43 10 77.7 0 21 149 7 49 KRY63622.1 hypothetical protein T4D_13828 [Trichinella pseudospiralis] diamond 534 66.2 1 Eukaryota Opisthokonta Metazoa Nematoda Enoplea Trichinellida Trichinellidae Trichinella Trichinella pseudospiralis
30410055 30410055 PRJNA680334_S_NODE_15193_length_277_cov_1.922131_g14707_i0 PRJNA680334 15193 277 1.922131 5.32430287 Rhabditida 6236 Nematoda Nematoda 67 1.94e-11   NR VDD87213.1 51028 g14707 i0 70.2 5.09025270758123 47 14 50.9 0 142 2 76 122 VDD87213.1 unnamed protein product [Enterobius vermicularis] diamond 1410 67 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Oxyuridae Enterobius Enterobius vermicularis
31788495 31788495 PRJNA680334_S_NODE_30897_length_222_cov_61.518519_g30411_i0 PRJNA680334 30897 222 61.518519 136.57111218 Trichinella sp. T9 181606 Nematoda Nematoda 45.8 1.24e-4   NR KRX29073.1 181606 g30411 i0 90.5 0.283783783783784 21 2 28.4 0 206 144 8 28 KRX29073.1 hypothetical protein T09_10341 [Trichinella sp. T9] diamond 63 45.8 1 Eukaryota Opisthokonta Metazoa Nematoda Enoplea Trichinellida Trichinellidae Trichinella Trichinella sp. T9
32579867 32579867 PRJNA680334_S_NODE_95659_length_156_cov_1.463415_g95173_i0 PRJNA680334 95659 156 1.463415 2.2829274 Trichinella sp. T6 92179 Nematoda Nematoda 42.7 8.56e-4   NR KRX29138.1 92179 g95173 i0 56.8 0.711538461538462 37 12 63.5 1 38 136 1 37 KRX29138.1 hypothetical protein T06_9644 [Trichinella sp. T6] diamond 111 42.7 1 Eukaryota Opisthokonta Metazoa Nematoda Enoplea Trichinellida Trichinellidae Trichinella Trichinella sp. T6

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