RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA274362" and tax_phylum = "Nematoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nematoda · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA274362 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
4198010 4198010 PRJNA274362_S_NODE_5764_length_351_cov_1.549669_g5644_i0 PRJNA274362 5764 351 1.549669 5.43933819 Rhabditida 6236 Nematoda Nematoda 178 1.17e-53   NR VDM44095.1 6265 g5644 i0 76.7 10.9059829059829 116 27 99.1 0 349 2 23 138 VDM44095.1 unnamed protein product [Toxocara canis] diamond 3828 179 0.994413407821229 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Toxocaridae Toxocara Toxocara canis
13124434 13124434 PRJNA274362_S_NODE_25351_length_187_cov_1.297101_g25231_i0 PRJNA274362 25351 187 1.297101 2.42557887 Rhabditida 6236 Nematoda Nematoda 100 5.88e-25   NR KHN80928.1 6265 g25231 i0 74.2 5.90374331550802 62 16 99.5 0 186 1 40 101 KHN80928.1 60S ribosomal protein L23a [Toxocara canis] diamond 1104 101 0.99009900990099 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Toxocaridae Toxocara Toxocara canis
15673616 15673616 PRJNA274362_S_NODE_633_length_901_cov_2.893192_g569_i0 PRJNA274362 633 901 2.893192 26.06765992 Heterodera glycines 51029 Nematoda Nematoda 331 5.499999999999998e-111   NR CAA74205.1 51029 g569 i0 70 0.822419533851276 247 73 82.2 1 888 148 1 246 CAA74205.1 serine proteinase [Heterodera glycines] diamond 741 331 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Heteroderidae Heterodera Heterodera glycines
23322850 23322850 PRJNA274362_S_NODE_36359_length_163_cov_1.368421_g36239_i0 PRJNA274362 36359 163 1.368421 2.23052623 Opisthokonta 33154 Nematoda Nematoda 102 1.82e-24   NR CAD5212871.1 465554 g36239 i0 88.7 18.478527607362 53 6 97.5 0 161 3 122 174 CAD5212871.1 unnamed protein product [Bursaphelenchus okinawaensis] diamond 3012 102 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Aphelenchoididae Bursaphelenchus Bursaphelenchus okinawaensis
27042461 27042461 PRJNA274362_S_NODE_28702_length_177_cov_1.218750_g28582_i0 PRJNA274362 28702 177 1.21875 2.1571875 Brugia malayi 6279 Nematoda Nematoda 61.6 2.56e-9   NR CDQ06246.1 6279 g28582 i0 65 5.55932203389831 40 14 67.8 0 121 2 173 212 CDQ06246.1 Bm7681 [Brugia malayi] diamond 984 61.6 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Onchocercidae Brugia Brugia malayi
27313247 27313247 PRJNA274362_S_NODE_27583_length_180_cov_1.541985_g27463_i0 PRJNA274362 27583 180 1.541985 2.775573 Metazoa 33208 Nematoda Nematoda 83.2 3.5e-18   NR KJH46816.1 29172 g27463 i0 76.5 11.7166666666667 51 12 85 0 155 3 36 86 KJH46816.1 ribosomal protein L14p/L23e [Dictyocaulus viviparus] diamond 2109 83.6 0.995215311004785 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Metastrongylidae Dictyocaulus Dictyocaulus viviparus
27737769 27737769 PRJNA274362_S_NODE_25964_length_185_cov_1.455882_g25844_i0 PRJNA274362 25964 185 1.455882 2.6933817 Bursaphelenchus okinawaensis 465554 Nematoda Nematoda 61.2 2.05e-9   NR CAD5217367.1 465554 g25844 i0 56.6 1.88108108108108 53 19 85.9 1 2 160 25 73 CAD5217367.1 unnamed protein product [Bursaphelenchus okinawaensis] diamond 348 61.2 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Aphelenchoididae Bursaphelenchus Bursaphelenchus okinawaensis
29049821 29049821 PRJNA274362_S_NODE_30368_length_173_cov_0.975806_g30248_i0 PRJNA274362 30368 173 0.975806 1.68814438 Rhabditida 6236 Nematoda Nematoda 52.4 1.12e-6   NR CAD5234496.1 6326 g30248 i0 48.3 4.04046242774566 60 27 97.1 1 169 2 16 75 CAD5234496.1 unnamed protein product [Bursaphelenchus xylophilus] diamond 699 52.4 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Aphelenchoididae Bursaphelenchus Bursaphelenchus xylophilus
29428326 29428326 PRJNA274362_S_NODE_16249_length_224_cov_1.720000_g16129_i0 PRJNA274362 16249 224 1.72 3.8528 Metazoa 33208 Nematoda Nematoda 55.1 5.53e-8   NR VDK79327.1 637853 g16129 i0 80 3.61607142857143 30 6 40.2 0 2 91 41 70 VDK79327.1 unnamed protein product [Gongylonema pulchrum] diamond 810 55.1 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Gongylonematidae Gongylonema Gongylonema pulchrum
29631598 29631598 PRJNA274362_S_NODE_22130_length_198_cov_1.046980_g22010_i0 PRJNA274362 22130 198 1.04698 2.0730204 Mesorhabditis spiculigera 96644 Nematoda Nematoda 65.9 1.51e-10   NR CAJ0578448.1 96644 g22010 i0 62.9 1.87878787878788 62 23 93.9 0 195 10 2365 2426 CAJ0578448.1 unnamed protein product, partial [Mesorhabditis spiculigera] diamond 372 65.9 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Mesorhabditis Mesorhabditis spiculigera
29821090 29821090 PRJNA274362_S_NODE_35291_length_165_cov_0.879310_g35171_i0 PRJNA274362 35291 165 0.87931 1.4508615 Soboliphyme baturini 241478 Nematoda Nematoda 71.6 5.95e-14   NR VDP39418.1 241478 g35171 i0 73.6 0.963636363636364 53 12 96.4 1 3 161 23 73 VDP39418.1 unnamed protein product [Soboliphyme baturini] diamond 159 71.6 1 Eukaryota Opisthokonta Metazoa Nematoda Enoplea Dioctophymatida Soboliphymatidae Soboliphyme Soboliphyme baturini
30042433 30042433 PRJNA274362_S_NODE_19551_length_208_cov_1.264151_g19431_i0 PRJNA274362 19551 208 1.264151 2.62943408 Caenorhabditis auriculariae 2777116 Nematoda Nematoda 42.4 0.0173   NR CAD6187414.1 2777116 g19431 i0 67.9 1.93269230769231 28 9 40.4 0 69 152 19 46 CAD6187414.1 unnamed protein product [Caenorhabditis auriculariae] diamond 402 42.4 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis auriculariae
30502551 30502551 PRJNA274362_S_NODE_31133_length_171_cov_1.131148_g31013_i0 PRJNA274362 31133 171 1.131148 1.93426308 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 64.7 1.18e-11   NR KAH7719822.1 70226 g31013 i0 72.7 14.859649122807 44 12 77.2 0 133 2 4 47 KAH7719822.1 60S ribosomal protein L30 [Aphelenchoides avenae] diamond 2541 65.1 0.993855606758833 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Aphelenchoididae Aphelenchoides Aphelenchoides avenae
30723612 30723612 PRJNA274362_S_NODE_19174_length_210_cov_0.906832_g19054_i0 PRJNA274362 19174 210 0.906832 1.9043472 Opisthokonta 33154 Nematoda Nematoda 42.4 0.0341   NR EGT51786.1 135651 g19054 i0 38.5 3.54285714285714 52 22 60 1 79 204 291 342 EGT51786.1 hypothetical protein CAEBREN_02681 [Caenorhabditis brenneri] diamond 744 42.4 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis brenneri
30976581 30976581 PRJNA274362_S_NODE_13694_length_241_cov_1.250000_g13574_i0 PRJNA274362 13694 241 1.25 3.0125 Steinernema 34507 Nematoda Nematoda 93.6 1.72e-21   NR TKR81205.1 34508 g13574 i0 62.5 2.67634854771784 72 27 89.6 0 1 216 136 207 TKR81205.1 hypothetical protein L596_015117 [Steinernema carpocapsae] diamond 645 93.6 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Steinernematidae Steinernema Steinernema carpocapsae
31147888 31147888 PRJNA274362_S_NODE_31095_length_171_cov_1.237705_g30975_i0 PRJNA274362 31095 171 1.237705 2.11647555 Caenorhabditis auriculariae 2777116 Nematoda Nematoda 42.4 0.0109   NR CAD6187414.1 2777116 g30975 i0 72.4 1.08771929824561 29 8 50.9 0 128 42 19 47 CAD6187414.1 unnamed protein product [Caenorhabditis auriculariae] diamond 186 42.4 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis auriculariae
31527905 31527905 PRJNA274362_S_NODE_28376_length_178_cov_1.186047_g28256_i0 PRJNA274362 28376 178 1.186047 2.11116366 Aphelenchoides bicaudatus 293665 Nematoda Nematoda 67.8 2.29e-11   NR KAI6170541.1 293665 g28256 i0 48.3 2.35955056179775 58 30 97.8 0 175 2 249 306 KAI6170541.1 4-aminobutyrate aminotransferase, mitochondrial [Aphelenchoides bicaudatus] diamond 420 67.8 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Aphelenchoididae Aphelenchoides Aphelenchoides bicaudatus

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