contig_metadata
20 rows where bioproject = "PRJNA541476", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1118445 | 1118445 | PRJNA541476_P_NODE_36821_length_244_cov_2.087719_g36615_i0 | PRJNA541476 | 36821 | 244 | 2.087719 | 5.09403436 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 118 | 8.14e-29 | NR | PAV64766.1 | 2018661 | g36615 | i0 | 72.8 | 3.98360655737705 | 81 | 22 | 99.6 | 0 | 243 | 1 | 688 | 768 | PAV64766.1 hypothetical protein WR25_26254 [Diploscapter pachys] | diamond | 972 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 1118462 | 1118462 | PRJNA541476_P_NODE_7841_length_404_cov_1.861027_g7637_i0 | PRJNA541476 | 7841 | 404 | 1.861027 | 7.51854908 | Bursaphelenchus cocophilus | 269710 | Nematoda | Nematoda | 189 | 4.42e-58 | NR | AAS90523.1 | 269710 | g7637 | i0 | 72 | 10.7524752475248 | 132 | 37 | 98 | 0 | 3 | 398 | 70 | 201 | AAS90523.1 cytochrome oxidase subunit I, partial [Bursaphelenchus cocophilus] | diamond | 4344 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus cocophilus | |
| 8162079 | 8162079 | PRJNA541476_P_NODE_687_length_1357_cov_12.161215_g588_i0 | PRJNA541476 | 687 | 1357 | 12.161215 | 165.02768755 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 113 | 2.84e-24 | NR | AVZ46778.1 | 189291 | g588 | i0 | 51.5 | 0.287398673544584 | 130 | 62 | 28.5 | 1 | 1027 | 641 | 117 | 246 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 390 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 9437561 | 9437561 | PRJNA541476_P_NODE_8048_length_398_cov_3.350769_g7844_i0 | PRJNA541476 | 8048 | 398 | 3.350769 | 13.33606062 | Oigolaimella attenuata | 669116 | Nematoda | Nematoda | 303 | 9.53e-78 | NTclustered | gi|256709322|gb|GQ422336.1| | 669116 | g7844 | i0 | 83.962 | 46.8391959798995 | 318 | 49 | 80 | 2 | 79 | 395 | 42 | 358 | Oigolaimella attenuata large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 18642 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Oigolaimella | Oigolaimella attenuata | |
| 14538079 | 14538079 | PRJNA541476_P_NODE_8952_length_379_cov_1.869281_g8746_i0 | PRJNA541476 | 8952 | 379 | 1.869281 | 7.08457499 | root | 1 | Root_unresolved | Root_unresolved | 78.6 | 5.26e-14 | NR | KAI6222442.1 | 1052528 | g8746 | i0 | 47.6 | 4.27440633245383 | 105 | 49 | 79.2 | 3 | 355 | 56 | 20 | 123 | KAI6222442.1 ATP synthase subunit gamma, mitochondrial [Aphelenchoides fujianensis] | diamond | 1620 | 79.3 | 0.991172761664565 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides fujianensis | |
| 22795762 | 22795762 | PRJNA541476_P_NODE_558_length_1479_cov_12.586060_g472_i0 | PRJNA541476 | 558 | 1479 | 12.58606 | 186.1478274 | Bursaphelenchus okinawaensis | 465554 | Nematoda | Nematoda | 148 | 1.9e-37 | NR | CAD5214079.1 | 465554 | g472 | i0 | 40.3 | 1.00202839756592 | 248 | 137 | 49.1 | 6 | 1232 | 507 | 7 | 249 | CAD5214079.1 unnamed protein product [Bursaphelenchus okinawaensis] | diamond | 1482 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus okinawaensis | |
| 26744172 | 26744172 | PRJNA541476_P_NODE_41161_length_234_cov_3.229814_g40955_i0 | PRJNA541476 | 41161 | 234 | 3.229814 | 7.55776476 | Metazoa | 33208 | Nematoda | Nematoda | 90.9 | 3.84e-19 | NR | XP_003378563.1 | 6334 | g40955 | i0 | 58.3 | 9.43589743589744 | 72 | 30 | 92.3 | 0 | 216 | 1 | 605 | 676 | XP_003378563.1 methylmalonyl-CoA mutase [Trichinella spiralis] | diamond | 2208 | 91.3 | 0.995618838992333 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 27109273 | 27109273 | PRJNA541476_P_NODE_10702_length_351_cov_1.298561_g10496_i0 | PRJNA541476 | 10702 | 351 | 1.298561 | 4.55794911 | Heterodera trifolii | 157864 | Nematoda | Nematoda | 51.6 | 9.67e-5 | NR | KAL3088297.1 | 157864 | g10496 | i0 | 37.3 | 1.34188034188034 | 83 | 39 | 65 | 4 | 270 | 43 | 397 | 473 | KAL3088297.1 hypothetical protein niasHT_023857 [Heterodera trifolii] | diamond | 471 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii | |
| 27330844 | 27330844 | PRJNA541476_P_NODE_16643_length_299_cov_1.362832_g16437_i0 | PRJNA541476 | 16643 | 299 | 1.362832 | 4.07486768 | Caenorhabditis angaria | 860376 | Nematoda | Nematoda | 101 | 5.5e-23 | NR | CAI5448275.1 | 860376 | g16437 | i0 | 68.9 | 4.39464882943144 | 74 | 23 | 74.2 | 0 | 76 | 297 | 5 | 78 | CAI5448275.1 unnamed protein product [Caenorhabditis angaria] | diamond | 1314 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis angaria | |
| 28309675 | 28309675 | PRJNA541476_P_NODE_746_length_1309_cov_14.932848_g642_i0 | PRJNA541476 | 746 | 1309 | 14.932848 | 195.47098032 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 61.6 | 1.71e-6 | NR | AVZ46778.1 | 189291 | g642 | i0 | 33.1 | 0.297937356760886 | 130 | 87 | 29.8 | 0 | 877 | 488 | 117 | 246 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 390 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 28846168 | 28846168 | PRJNA541476_P_NODE_20588_length_280_cov_1.009662_g20382_i0 | PRJNA541476 | 20588 | 280 | 1.009662 | 2.8270536 | Soboliphyme baturini | 241478 | Nematoda | Nematoda | 144 | 2.56e-39 | NR | VDP15114.1 | 241478 | g20382 | i0 | 71.7 | 4.92857142857143 | 92 | 26 | 98.6 | 0 | 3 | 278 | 42 | 133 | VDP15114.1 unnamed protein product [Soboliphyme baturini] | diamond | 1380 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 28956168 | 28956168 | PRJNA541476_P_NODE_6968_length_428_cov_1.709859_g6764_i0 | PRJNA541476 | 6968 | 428 | 1.709859 | 7.31819652 | Metazoa | 33208 | Nematoda | Nematoda | 151 | 7.899999999999999e-43 | NR | KAI6182696.1 | 293665 | g6764 | i0 | 58.1 | 2.64953271028037 | 129 | 54 | 90.4 | 0 | 40 | 426 | 11 | 139 | KAI6182696.1 Ribosomal protein L1 domain containing protein [Aphelenchoides bicaudatus] | diamond | 1134 | 152 | 0.993421052631579 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides bicaudatus | |
| 29288262 | 29288262 | PRJNA541476_P_NODE_21029_length_278_cov_1.170732_g20823_i0 | PRJNA541476 | 21029 | 278 | 1.170732 | 3.25463496 | Heterodera trifolii | 157864 | Nematoda | Nematoda | 98.6 | 4.570000000000001e-22 | NR | KAL3114911.1 | 157864 | g20823 | i0 | 55.4 | 6.42086330935252 | 83 | 36 | 88.5 | 1 | 32 | 277 | 12 | 94 | KAL3114911.1 hypothetical protein niasHT_011347 [Heterodera trifolii] | diamond | 1785 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii | |
| 29414571 | 29414571 | PRJNA541476_P_NODE_12709_length_328_cov_2.980392_g12503_i0 | PRJNA541476 | 12709 | 328 | 2.980392 | 9.77568576 | Thelazia callipaeda | 103827 | Nematoda | Nematoda | 61.2 | 2.76e-8 | NR | VDN03213.1 | 103827 | g12503 | i0 | 59 | 2.65243902439024 | 39 | 16 | 35.7 | 0 | 2 | 118 | 295 | 333 | VDN03213.1 unnamed protein product [Thelazia callipaeda] | diamond | 870 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Thelaziidae | Thelazia | Thelazia callipaeda | |
| 29524334 | 29524334 | PRJNA541476_P_NODE_17930_length_292_cov_0.986301_g17724_i0 | PRJNA541476 | 17930 | 292 | 0.986301 | 2.87999892 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.5 | 1.25e-11 | NR | XP_024498467.1 | 34506 | g17724 | i0 | 41.1 | 10.5821917808219 | 90 | 48 | 92.5 | 2 | 289 | 20 | 1257 | 1341 | XP_024498467.1 A disintegrin and metalloproteinase with thrombospondin motifs 9 [Strongyloides ratti] | diamond | 3090 | 70.9 | 0.994358251057828 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 30282705 | 30282705 | PRJNA541476_P_NODE_29412_length_251_cov_1.730337_g29206_i0 | PRJNA541476 | 29412 | 251 | 1.730337 | 4.34314587 | Rhabditidae | 6243 | Nematoda | Nematoda | 48.9 | 7.87e-5 | NR | NP_001379423.1 | 6239 | g29206 | i0 | 55.3 | 3.77689243027888 | 38 | 17 | 45.4 | 0 | 87 | 200 | 28 | 65 | NP_001379423.1 ShKT domain-containing protein [Caenorhabditis elegans] | diamond | 948 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 30850977 | 30850977 | PRJNA541476_P_NODE_12674_length_329_cov_1.199219_g12468_i0 | PRJNA541476 | 12674 | 329 | 1.199219 | 3.94543051 | Metazoa | 33208 | Nematoda | Nematoda | 48.5 | 8.48e-4 | NR | XP_024507644.1 | 34506 | g12468 | i0 | 61.8 | 5.49848024316109 | 34 | 13 | 31 | 0 | 1 | 102 | 304 | 337 | XP_024507644.1 Probable tRNA N6-adenosine threonylcarbamoyltransferase [Strongyloides ratti] | diamond | 1809 | 48.9 | 0.991820040899796 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 32006162 | 32006162 | PRJNA541476_P_NODE_3138_length_659_cov_2.539249_g2946_i0 | PRJNA541476 | 3138 | 659 | 2.539249 | 16.73365091 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 47 | 0.0183 | NR | CAJ0577101.1 | 96644 | g2946 | i0 | 28.7 | 1.28831562974203 | 129 | 77 | 56.9 | 7 | 274 | 648 | 38 | 155 | CAJ0577101.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 849 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 32638284 | 32638284 | PRJNA541476_P_NODE_29280_length_251_cov_3.011236_g29074_i0 | PRJNA541476 | 29280 | 251 | 3.011236 | 7.55820236 | Toxocara canis | 6265 | Nematoda | Nematoda | 63.2 | 1.14e-9 | NR | VDM27774.1 | 6265 | g29074 | i0 | 40.4 | 3.1195219123506 | 57 | 34 | 68.1 | 0 | 171 | 1 | 28 | 84 | VDM27774.1 unnamed protein product [Toxocara canis] | diamond | 783 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 32733193 | 32733193 | PRJNA541476_P_NODE_3820_length_591_cov_3.007722_g3626_i0 | PRJNA541476 | 3820 | 591 | 3.007722 | 17.77563702 | Mesorhabditis belari | 2138241 | Nematoda | Nematoda | 60.1 | 5.83e-7 | NR | CAJ0933546.1 | 2138241 | g3626 | i0 | 34.1 | 0.416243654822335 | 82 | 36 | 40.1 | 2 | 6 | 242 | 194 | 260 | CAJ0933546.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 246 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari |
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);;