contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA657343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1899419 | 1899419 | PRJNA657343_P_NODE_782_length_653_cov_9.513245_g765_i0 | PRJNA657343 | 782 | 653 | 9.513245 | 62.12148985 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 293 | 2.83e-98 | NR | CAJ0586563.1 | 96644 | g765 | i0 | 81 | 6.19754977029096 | 168 | 32 | 77.2 | 0 | 6 | 509 | 4 | 171 | CAJ0586563.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 4047 | 293 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 11363810 | 11363810 | PRJNA657343_P_NODE_20449_length_206_cov_1.229299_g20425_i0 | PRJNA657343 | 20449 | 206 | 1.229299 | 2.53235594 | Opisthokonta | 33154 | Nematoda | Nematoda | 84.3 | 6.95e-18 | NR | KHN80245.1 | 6265 | g20425 | i0 | 77.8 | 106.179611650485 | 45 | 10 | 65.5 | 0 | 3 | 137 | 199 | 243 | KHN80245.1 ADP-ribosylation factor 1-like 2 [Toxocara canis] | diamond | 21873 | 85.1 | 0.990599294947121 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 18475182 | 18475182 | PRJNA657343_P_NODE_20595_length_205_cov_2.128205_g20571_i0 | PRJNA657343 | 20595 | 205 | 2.128205 | 4.36282025 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 105 | 4.6800000000000005e-27 | NR | XP_024505625.1 | 34506 | g20571 | i0 | 84.6 | 303.512195121951 | 65 | 10 | 95.1 | 0 | 195 | 1 | 45 | 109 | XP_024505625.1 Histone H2A.v [Strongyloides ratti] | diamond | 62220 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 23575696 | 23575696 | PRJNA657343_P_NODE_29439_length_180_cov_1.793893_g29415_i0 | PRJNA657343 | 29439 | 180 | 1.793893 | 3.2290074 | Caenorhabditis sp. 36 PRJEB53466 | 2970133 | Nematoda | Nematoda | 101 | 2.45e-23 | NR | CAI2356785.1 | 2970133 | g29415 | i0 | 80.7 | 6.81666666666667 | 57 | 11 | 95 | 0 | 174 | 4 | 388 | 444 | CAI2356785.1 unnamed protein product [Caenorhabditis sp. 36 PRJEB53466] | diamond | 1227 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis sp. 36 PRJEB53466 | |
| 26764827 | 26764827 | PRJNA657343_P_NODE_37061_length_167_cov_3.449153_g37037_i0 | PRJNA657343 | 37061 | 167 | 3.449153 | 5.76008551 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 72.4 | 1.26e-13 | NR | CAJ0575478.1 | 96644 | g37037 | i0 | 66.7 | 3.88023952095808 | 54 | 18 | 97 | 0 | 166 | 5 | 115 | 168 | CAJ0575478.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 648 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 27314999 | 27314999 | PRJNA657343_P_NODE_25263_length_190_cov_1.780142_g25239_i0 | PRJNA657343 | 25263 | 190 | 1.780142 | 3.3822698 | Metazoa | 33208 | Nematoda | Nematoda | 46.2 | 9.88e-4 | NR | KAI1694708.1 | 166010 | g25239 | i0 | 40 | 2.35263157894737 | 50 | 28 | 78.9 | 1 | 189 | 40 | 103 | 150 | KAI1694708.1 arrestin domain-containing protein 17 [Ditylenchus destructor] | diamond | 447 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 27883190 | 27883190 | PRJNA657343_P_NODE_10445_length_264_cov_0.916279_g10421_i0 | PRJNA657343 | 10445 | 264 | 0.916279 | 2.41897656 | Caenorhabditis | 6237 | Nematoda | Nematoda | 54.3 | 4.16e-6 | NR | XP_003094480.2 | 31234 | g10421 | i0 | 40.2 | 3.875 | 92 | 39 | 95.5 | 4 | 252 | 1 | 220 | 303 | XP_003094480.2 hypothetical protein GCK72_003644 [Caenorhabditis remanei] | diamond | 1023 | 54.7 | 0.992687385740402 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 28249781 | 28249781 | PRJNA657343_P_NODE_15346_length_229_cov_1.377778_g15322_i0 | PRJNA657343 | 15346 | 229 | 1.377778 | 3.15511162 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 48.9 | 2e-4 | NR | CAK5044631.1 | 390850 | g15322 | i0 | 43.4 | 2.77729257641921 | 53 | 27 | 68.1 | 2 | 209 | 54 | 269 | 319 | CAK5044631.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 636 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 28249784 | 28249784 | PRJNA657343_P_NODE_21586_length_201_cov_4.335526_g21562_i0 | PRJNA657343 | 21586 | 201 | 4.335526 | 8.71440726 | Mesorhabditis belari | 2138241 | Nematoda | Nematoda | 43.1 | 0.00522 | NR | CAJ0963498.1 | 2138241 | g21562 | i0 | 54.3 | 0.522388059701492 | 35 | 14 | 52.2 | 2 | 175 | 71 | 25 | 57 | CAJ0963498.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 105 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari | |
| 28420219 | 28420219 | PRJNA657343_P_NODE_27406_length_185_cov_1.485294_g27382_i0 | PRJNA657343 | 27406 | 185 | 1.485294 | 2.7477939 | Metazoa | 33208 | Nematoda | Nematoda | 92 | 7.4e-20 | NR | XP_002632601.2 | 6238 | g27382 | i0 | 80.7 | 8.65945945945946 | 57 | 11 | 92.4 | 0 | 3 | 173 | 930 | 986 | XP_002632601.2 Protein CBR-HHAT-2 [Caenorhabditis briggsae] | diamond | 1602 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 28534273 | 28534273 | PRJNA657343_P_NODE_19887_length_208_cov_1.257862_g19863_i0 | PRJNA657343 | 19887 | 208 | 1.257862 | 2.61635296 | Steinernema hermaphroditum | 289476 | Nematoda | Nematoda | 46.6 | 0.00106 | NR | KAK0403087.1 | 289476 | g19863 | i0 | 38.2 | 2.94230769230769 | 68 | 24 | 98.1 | 1 | 205 | 2 | 980 | 1029 | KAK0403087.1 hypothetical protein QR680_016712 [Steinernema hermaphroditum] | diamond | 612 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema hermaphroditum | |
| 28565629 | 28565629 | PRJNA657343_P_NODE_22647_length_198_cov_1.322148_g22623_i0 | PRJNA657343 | 22647 | 198 | 1.322148 | 2.61785304 | Cercopithifilaria johnstoni | 2874296 | Nematoda | Nematoda | 47 | 6.88e-4 | NR | CAG9537242.1 | 2874296 | g22623 | i0 | 38.7 | 1.90909090909091 | 62 | 38 | 93.9 | 0 | 192 | 7 | 496 | 557 | CAG9537242.1 unnamed protein product [Cercopithifilaria johnstoni] | diamond | 378 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Cercopithifilaria | Cercopithifilaria johnstoni | |
| 28704318 | 28704318 | PRJNA657343_P_NODE_32887_length_173_cov_1.225806_g32863_i0 | PRJNA657343 | 32887 | 173 | 1.225806 | 2.12064438 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62 | 2.31e-9 | NR | KAL3107838.1 | 157864 | g32863 | i0 | 51.8 | 4.85549132947977 | 56 | 27 | 97.1 | 0 | 4 | 171 | 581 | 636 | KAL3107838.1 hypothetical protein niasHT_017070 [Heterodera trifolii] | diamond | 840 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii | |
| 28786479 | 28786479 | PRJNA657343_P_NODE_25087_length_191_cov_0.964789_g25063_i0 | PRJNA657343 | 25087 | 191 | 0.964789 | 1.84274699 | Necator americanus | 51031 | Nematoda | Nematoda | 72 | 4.98e-13 | NR | XP_064061713.1 | 51031 | g25063 | i0 | 59.4 | 4.71204188481675 | 64 | 20 | 91.1 | 1 | 191 | 18 | 203 | 266 | XP_064061713.1 hypothetical protein RB195_015223 [Necator americanus] | diamond | 900 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 29355132 | 29355132 | PRJNA657343_P_NODE_37669_length_167_cov_0.881356_g37645_i0 | PRJNA657343 | 37669 | 167 | 0.881356 | 1.47186452 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 41.2 | 0.0469 | NR | GMT33618.1 | 1538716 | g37645 | i0 | 47.4 | 0.682634730538922 | 38 | 20 | 68.3 | 0 | 121 | 8 | 347 | 384 | GMT33618.1 hypothetical protein PFISCL1PPCAC_24915, partial [Pristionchus fissidentatus] | diamond | 114 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 30492153 | 30492153 | PRJNA657343_P_NODE_38193_length_167_cov_0.881356_g38169_i0 | PRJNA657343 | 38193 | 167 | 0.881356 | 1.47186452 | Dracunculus medinensis | 318479 | Nematoda | Nematoda | 47.4 | 3.09e-4 | NR | VDN56231.1 | 318479 | g38169 | i0 | 50 | 8.47904191616766 | 48 | 22 | 84.4 | 2 | 23 | 163 | 1 | 47 | VDN56231.1 unnamed protein product [Dracunculus medinensis] | diamond | 1416 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Dracunculidae | Dracunculus | Dracunculus medinensis | |
| 30523656 | 30523656 | PRJNA657343_P_NODE_10093_length_267_cov_1.834862_g10069_i0 | PRJNA657343 | 10093 | 267 | 1.834862 | 4.89908154 | Mesorhabditis belari | 2138241 | Nematoda | Nematoda | 100 | 1.81e-22 | NR | CAJ0941995.1 | 2138241 | g10069 | i0 | 57.1 | 0.943820224719101 | 84 | 35 | 94.4 | 1 | 14 | 265 | 429 | 511 | CAJ0941995.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 252 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari | |
| 31250371 | 31250371 | PRJNA657343_P_NODE_2415_length_453_cov_2.259901_g2392_i0 | PRJNA657343 | 2415 | 453 | 2.259901 | 10.23735153 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 115 | 6.33e-29 | NR | CAD5222505.1 | 6326 | g2392 | i0 | 52.1 | 2.42384105960265 | 119 | 52 | 78.8 | 1 | 387 | 31 | 7 | 120 | CAD5222505.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 1098 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 31357663 | 31357663 | PRJNA657343_P_NODE_42196_length_163_cov_4.263158_g42172_i0 | PRJNA657343 | 42196 | 163 | 4.263158 | 6.94894754 | Metazoa | 33208 | Nematoda | Nematoda | 60.5 | 6.73e-9 | NR | CAD5234365.1 | 6326 | g42172 | i0 | 54.2 | 7.95092024539877 | 48 | 22 | 88.3 | 0 | 149 | 6 | 348 | 395 | CAD5234365.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 1296 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 31579058 | 31579058 | PRJNA657343_P_NODE_13516_length_240_cov_1.298429_g13492_i0 | PRJNA657343 | 13516 | 240 | 1.298429 | 3.1162296 | Rhabditida | 6236 | Nematoda | Nematoda | 95.9 | 6.620000000000001e-21 | NR | KAL3112975.1 | 157864 | g13492 | i0 | 56.4 | 39 | 78 | 34 | 97.5 | 0 | 3 | 236 | 323 | 400 | KAL3112975.1 hypothetical protein niasHT_013440 [Heterodera trifolii] | diamond | 9360 | 96.3 | 0.995846313603323 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii | |
| 31673720 | 31673720 | PRJNA657343_P_NODE_3857_length_382_cov_1.756757_g3834_i0 | PRJNA657343 | 3857 | 382 | 1.756757 | 6.71081174 | Opisthokonta | 33154 | Nematoda | Nematoda | 130 | 4.27e-33 | NR | KRX89142.1 | 6337 | g3834 | i0 | 52.1 | 10.1073298429319 | 121 | 58 | 95 | 0 | 17 | 379 | 115 | 235 | KRX89142.1 Stress-induced-phosphoprotein 1, partial [Trichinella pseudospiralis] | diamond | 3861 | 131 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis | |
| 31705476 | 31705476 | PRJNA657343_P_NODE_13637_length_239_cov_2.057895_g13613_i0 | PRJNA657343 | 13637 | 239 | 2.057895 | 4.91836905 | Caenorhabditis | 6237 | Nematoda | Nematoda | 110 | 1.9000000000000003e-28 | NR | PIC47414.1 | 1611254 | g13613 | i0 | 66.7 | 9.58995815899582 | 75 | 25 | 94.1 | 0 | 228 | 4 | 20 | 94 | PIC47414.1 hypothetical protein B9Z55_006783 [Caenorhabditis nigoni] | diamond | 2292 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis nigoni | |
| 32685597 | 32685597 | PRJNA657343_P_NODE_42140_length_164_cov_0.860870_g42116_i0 | PRJNA657343 | 42140 | 164 | 0.86087 | 1.4118268 | Caenorhabditis | 6237 | Nematoda | Nematoda | 70.5 | 1.11e-12 | NR | ULT95350.1 | 6238 | g42116 | i0 | 52.9 | 1.86585365853659 | 51 | 24 | 93.3 | 0 | 10 | 162 | 161 | 211 | ULT95350.1 hypothetical protein L3Y34_004225, partial [Caenorhabditis briggsae] | diamond | 306 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae |
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);;