contig_metadata
24 rows where bioproject = "PRJNA274362", tax_clade = "Opisthokonta" and tax_phylum = "Nematoda"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4197561 | 4197561 | PRJNA274362_S_NODE_18604_length_212_cov_1.533742_g18484_i0 | PRJNA274362 | 18604 | 212 | 1.533742 | 3.25153304 | Levipalatum texanum | 1486449 | Nematoda | Nematoda | 187 | 4.9e-43 | NTclustered | gi|610559467|gb|KJ395558.1| | 1486449 | g18484 | i0 | 82.87 | 4.83018867924528 | 216 | 29 | 100 | 6 | 1 | 212 | 384 | 173 | Levipalatum texanum ribosomal protein (rpl-23) gene, partial cds | blastn | 1024 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Levipalatum | Levipalatum texanum | |
| 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 | |
| 6748284 | 6748284 | PRJNA274362_S_NODE_24946_length_188_cov_2.215827_g24826_i0 | PRJNA274362 | 24946 | 188 | 2.215827 | 4.16575476 | Micoletzkya masseyi | 1250333 | Nematoda | Nematoda | 126 | 9.36e-25 | NTclustered | gi|953064426|gb|KT188926.1| | 1250333 | g24826 | i0 | 79.33 | 75.0797872340426 | 179 | 37 | 95 | 0 | 9 | 187 | 266 | 88 | Micoletzkya masseyi small subunit ribosomal protein 14 (rps-14) mRNA, partial cds | blastn | 14115 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Micoletzkya | Micoletzkya masseyi | |
| 6748497 | 6748497 | PRJNA274362_S_NODE_34986_length_165_cov_0.896552_g34866_i0 | PRJNA274362 | 34986 | 165 | 0.896552 | 1.4793108 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 111 | 2.24e-20 | NTclustered | gi|2445365262|ref|XM_003113149.2| | 31234 | g34866 | i0 | 81.481 | 5.14545454545455 | 135 | 25 | 82 | 0 | 18 | 152 | 410 | 276 | Caenorhabditis remanei uncharacterized protein (GCK72_009834), partial mRNA | blastn | 849 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 10574852 | 10574852 | PRJNA274362_S_NODE_37969_length_159_cov_2.727273_g37849_i0 | PRJNA274362 | 37969 | 159 | 2.727273 | 4.33636407 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 110 | 7.7e-20 | NTclustered | gi|268531565|ref|XM_002630863.1| | 6238 | g37849 | i0 | 82.171 | 3.73584905660377 | 129 | 21 | 81 | 2 | 30 | 157 | 275 | 148 | Caenorhabditis briggsae Protein CBR-LGG-1 (Cbr-lgg-1), partial mRNA | blastn | 594 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 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 | |
| 18222126 | 18222126 | PRJNA274362_S_NODE_18015_length_215_cov_1.240964_g17895_i0 | PRJNA274362 | 18015 | 215 | 1.240964 | 2.6680726 | Pristionchus sp. 10 RS5133 | 452805 | Nematoda | Nematoda | 62.1 | 3.15e-5 | NTclustered | gi|150984447|gb|EF634866.1| | 452805 | g17895 | i0 | 85.965 | 0.265116279069767 | 57 | 8 | 27 | 0 | 3 | 59 | 541 | 597 | Pristionchus sp. 10 RS5133 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds | blastn | 57 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 10 RS5133 | |
| 18222256 | 18222256 | PRJNA274362_S_NODE_24055_length_191_cov_1.443662_g23935_i0 | PRJNA274362 | 24055 | 191 | 1.443662 | 2.75739442 | Pristionchus bucculentus | 1317126 | Nematoda | Nematoda | 106 | 1.24e-18 | NTclustered | gi|479330840|gb|KC463841.1| | 1317126 | g23935 | i0 | 82.114 | 2.59162303664921 | 123 | 22 | 64 | 0 | 2 | 124 | 150 | 28 | Pristionchus bucculentus strain RS5596 large subunit ribosomal protein 27a (rpl27a) gene, partial cds | blastn | 495 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus bucculentus | |
| 22046822 | 22046822 | PRJNA274362_S_NODE_10958_length_265_cov_1.166667_g10838_i0 | PRJNA274362 | 10958 | 265 | 1.166667 | 3.09166755 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 228 | 3.7499999999999994e-55 | NTclustered | gi|687865697|emb|LK927572.1| | 6239 | g10838 | i0 | 82.197 | 195.803773584906 | 264 | 47 | 99 | 0 | 2 | 265 | 119817 | 120080 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000039 | blastn | 51888 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 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
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);;