contig_metadata
20 rows where bioproject = "PRJNA685607", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1942213 | 1942213 | PRJNA685607_P_NODE_10062_length_491_cov_1.837321_g9706_i0 | PRJNA685607 | 10062 | 491 | 1.837321 | 9.02124611 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 240 | 1.59e-74 | NR | KAE9556733.1 | 2598192 | g9706 | i0 | 65.6 | 55.9368635437882 | 163 | 54 | 98.4 | 1 | 483 | 1 | 2 | 164 | KAE9556733.1 hypothetical protein FO519_000139 [Halicephalobus sp. NKZ332] | diamond | 27465 | 240 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 8319647 | 8319647 | PRJNA685607_P_NODE_9387_length_507_cov_2.131336_g9031_i0 | PRJNA685607 | 9387 | 507 | 2.131336 | 10.80587352 | Opisthokonta | 33154 | Nematoda | Nematoda | 215 | 5.74e-68 | NR | KFD50978.1 | 68888 | g9031 | i0 | 72.4 | 27.7159763313609 | 145 | 40 | 85.8 | 0 | 504 | 70 | 54 | 198 | KFD50978.1 hypothetical protein M513_08161, partial [Trichuris suis] | diamond | 14052 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 9594844 | 9594844 | PRJNA685607_P_NODE_14548_length_423_cov_1.788571_g14190_i0 | PRJNA685607 | 14548 | 423 | 1.788571 | 7.56565533 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 278 | 6.180000000000001e-70 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g14190 | i0 | 81.197 | 5.3096926713948 | 351 | 60 | 82 | 6 | 10 | 357 | 384 | 37 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 2246 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 10870273 | 10870273 | PRJNA685607_P_NODE_18729_length_385_cov_1.320513_g18371_i0 | PRJNA685607 | 18729 | 385 | 1.320513 | 5.08397505 | Metazoa | 33208 | Nematoda | Nematoda | 181 | 9.6e-55 | NR | KAK6031123.1 | 6317 | g18371 | i0 | 78.9 | 56.4467532467532 | 114 | 24 | 88.8 | 0 | 343 | 2 | 46 | 159 | KAK6031123.1 ribosomal protein L5 [Ostertagia ostertagi] | diamond | 21732 | 182 | 0.994505494505495 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi | |
| 13930207 | 13930207 | PRJNA685607_P_NODE_2911_length_922_cov_2.702002_g2636_i0 | PRJNA685607 | 2911 | 922 | 2.702002 | 24.91245844 | Globodera pallida | 36090 | Nematoda | Nematoda | 239 | 1.98e-72 | NR | KAI3413796.1 | 36090 | g2636 | i0 | 61.2 | 11.9577006507592 | 196 | 73 | 63.4 | 2 | 921 | 337 | 212 | 405 | KAI3413796.1 translation elongation factor 2 [Globodera pallida] | diamond | 11025 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Globodera | Globodera pallida | |
| 17244224 | 17244224 | PRJNA685607_P_NODE_21174_length_369_cov_1.560811_g20815_i0 | PRJNA685607 | 21174 | 369 | 1.560811 | 5.75939259 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 300 | 1.13e-76 | NTclustered | gi|1376147859|ref|XM_024654603.1| | 34506 | g20815 | i0 | 82.456 | 125.859078590786 | 342 | 60 | 93 | 0 | 1 | 342 | 342 | 1 | Strongyloides ratti Polyubiquitin-C (SRAE_2000341300), partial mRNA | blastn | 46442 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 23619221 | 23619221 | PRJNA685607_P_NODE_59879_length_259_cov_4.451613_g59520_i0 | PRJNA685607 | 59879 | 259 | 4.451613 | 11.52967767 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 224 | 4.72e-54 | NTclustered | gi|268537031|ref|XM_002633606.1| | 6238 | g59520 | i0 | 87.565 | 69.046332046332 | 193 | 24 | 75 | 0 | 1 | 193 | 247 | 55 | Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA | blastn | 17883 | 224 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 27113635 | 27113635 | PRJNA685607_P_NODE_23722_length_355_cov_1.092199_g23363_i0 | PRJNA685607 | 23722 | 355 | 1.092199 | 3.87730645 | Ditylenchus destructor | 166010 | Nematoda | Nematoda | 130 | 2.9899999999999997e-35 | NR | KAI1731507.1 | 166010 | g23363 | i0 | 60 | 0.971830985915493 | 115 | 39 | 97.2 | 1 | 347 | 3 | 42 | 149 | KAI1731507.1 ribosomal protein l13e domain-containing protein [Ditylenchus destructor] | diamond | 345 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 27271855 | 27271855 | PRJNA685607_P_NODE_39143_length_302_cov_1.707424_g38784_i0 | PRJNA685607 | 39143 | 302 | 1.707424 | 5.15642048 | Caenorhabditis auriculariae | 2777116 | Nematoda | Nematoda | 84 | 2.51e-16 | NR | CAD6191919.1 | 2777116 | g38784 | i0 | 50.5 | 4.71854304635762 | 101 | 38 | 88.4 | 3 | 302 | 36 | 676 | 776 | CAD6191919.1 unnamed protein product [Caenorhabditis auriculariae] | diamond | 1425 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis auriculariae | |
| 28230533 | 28230533 | PRJNA685607_P_NODE_79946_length_246_cov_0.890173_g79587_i0 | PRJNA685607 | 79946 | 246 | 0.890173 | 2.18982558 | Caenorhabditis | 6237 | Nematoda | Nematoda | 89 | 1.64e-18 | NR | UMM11641.1 | 6238 | g79587 | i0 | 57.8 | 7.8780487804878 | 64 | 27 | 78 | 0 | 13 | 204 | 145 | 208 | UMM11641.1 hypothetical protein L5515_000827 [Caenorhabditis briggsae] | diamond | 1938 | 89.4 | 0.995525727069351 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 28830570 | 28830570 | PRJNA685607_P_NODE_48208_length_282_cov_1.095694_g47849_i0 | PRJNA685607 | 48208 | 282 | 1.095694 | 3.08985708 | Trichinella | 6333 | Nematoda | Nematoda | 130 | 4.84e-33 | NR | KRY35830.1 | 6334 | g47849 | i0 | 58.1 | 19.6170212765957 | 93 | 39 | 98.9 | 0 | 281 | 3 | 206 | 298 | KRY35830.1 60S ribosomal protein L5 [Trichinella spiralis] | diamond | 5532 | 131 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 29260961 | 29260961 | PRJNA685607_P_NODE_67169_length_250_cov_2.954802_g66810_i0 | PRJNA685607 | 67169 | 250 | 2.954802 | 7.387005 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 94.4 | 1.09e-21 | NR | CAD2170439.1 | 390850 | g66810 | i0 | 59.3 | 4.872 | 81 | 32 | 97.2 | 1 | 8 | 250 | 5 | 84 | CAD2170439.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 1218 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 29430367 | 29430367 | PRJNA685607_P_NODE_13229_length_439_cov_2.877049_g12871_i0 | PRJNA685607 | 13229 | 439 | 2.877049 | 12.63024511 | Metazoa | 33208 | Nematoda | Nematoda | 170 | 2.31e-51 | NR | KHN76788.1 | 6265 | g12871 | i0 | 57.7 | 40.6332574031891 | 142 | 60 | 97 | 0 | 427 | 2 | 9 | 150 | KHN76788.1 40S ribosomal protein S15 [Toxocara canis] | diamond | 17838 | 171 | 0.994152046783626 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 29608093 | 29608093 | PRJNA685607_P_NODE_63330_length_253_cov_1.883333_g62971_i0 | PRJNA685607 | 63330 | 253 | 1.883333 | 4.76483249 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 44.3 | 0.0119 | NR | KAF7633550.1 | 189291 | g62971 | i0 | 38.6 | 3.3201581027668 | 70 | 38 | 83 | 2 | 218 | 9 | 694 | 758 | KAF7633550.1 SSD domain-containing protein [Meloidogyne graminicola] | diamond | 840 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 31042000 | 31042000 | PRJNA685607_P_NODE_45755_length_287_cov_1.051402_g45396_i0 | PRJNA685607 | 45755 | 287 | 1.051402 | 3.01752374 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 120 | 6.03e-32 | NR | CDW52717.1 | 36087 | g45396 | i0 | 65.3 | 18.8675958188153 | 95 | 33 | 99.3 | 0 | 3 | 287 | 17 | 111 | CDW52717.1 60S ribosomal protein L19 [Trichuris trichiura] | diamond | 5415 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 31219322 | 31219322 | PRJNA685607_P_NODE_45375_length_288_cov_0.762791_g45016_i0 | PRJNA685607 | 45375 | 288 | 0.762791 | 2.19683808 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 44.3 | 0.0189 | NR | CAK5069761.1 | 390850 | g45016 | i0 | 37 | 2.4375 | 81 | 45 | 83.3 | 3 | 49 | 288 | 726 | 801 | CAK5069761.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 702 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 31820505 | 31820505 | PRJNA685607_P_NODE_80077_length_246_cov_0.890173_g79718_i0 | PRJNA685607 | 80077 | 246 | 0.890173 | 2.18982558 | Toxocara canis | 6265 | Nematoda | Nematoda | 73.2 | 5.17e-13 | NR | KHN85935.1 | 6265 | g79718 | i0 | 45 | 5.42682926829268 | 80 | 40 | 92.7 | 2 | 239 | 12 | 125 | 204 | KHN85935.1 Membrane-associated tyrosine- and threonine-specific cdc2-inhibitory kinase wee-1.3, partial [Toxocara canis] | diamond | 1335 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 32528521 | 32528521 | PRJNA685607_P_NODE_46359_length_286_cov_0.793427_g46000_i0 | PRJNA685607 | 46359 | 286 | 0.793427 | 2.26920122 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.9 | 2.84e-4 | NR | VDL79671.1 | 27835 | g46000 | i0 | 77.4 | 0.65034965034965 | 31 | 7 | 32.5 | 0 | 2 | 94 | 146 | 176 | VDL79671.1 unnamed protein product [Nippostrongylus brasiliensis] | diamond | 186 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heligmosomidae | Nippostrongylus | Nippostrongylus brasiliensis | |
| 32705765 | 32705765 | PRJNA685607_P_NODE_83360_length_245_cov_0.895349_g83001_i0 | PRJNA685607 | 83360 | 245 | 0.895349 | 2.19360505 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 108 | 2.65e-25 | NR | CAD5209251.1 | 6326 | g83001 | i0 | 63.2 | 7.00408163265306 | 76 | 28 | 93.1 | 0 | 9 | 236 | 164 | 239 | CAD5209251.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 1716 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 32737554 | 32737554 | PRJNA685607_P_NODE_89700_length_243_cov_0.905882_g89341_i0 | PRJNA685607 | 89700 | 243 | 0.905882 | 2.20129326 | Heterodera trifolii | 157864 | Nematoda | Nematoda | 92 | 1.79e-20 | NR | KAL3119325.1 | 157864 | g89341 | i0 | 64.8 | 2.7283950617284 | 71 | 25 | 87.7 | 0 | 26 | 238 | 7 | 77 | KAL3119325.1 hypothetical protein niasHT_001085 [Heterodera trifolii] | diamond | 663 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii |
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);;