contig_metadata
15 rows where bioproject = "PRJNA473201" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6821240 | 6821240 | PRJNA473201_P_NODE_27986_length_372_cov_3.096990_g27244_i0 | PRJNA473201 | 27986 | 372 | 3.09699 | 11.5208028 | Pristionchus hoplostomus | 1355913 | Nematoda | Nematoda | 161 | 5.63e-35 | NTclustered | gi|524845312|gb|KC819366.1| | 1355913 | g27244 | i0 | 80.717 | 28.502688172043 | 223 | 29 | 58 | 11 | 63 | 278 | 49 | 264 | Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds | blastn | 10603 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus hoplostomus | |
| 10648077 | 10648077 | PRJNA473201_P_NODE_65189_length_252_cov_11.960894_g64447_i0 | PRJNA473201 | 65189 | 252 | 11.960894 | 30.14145288 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|687865727|emb|LK927732.1| | 6239 | g64447 | i0 | 100 | 0.23015873015873 | 29 | 0 | 12 | 0 | 222 | 250 | 79462 | 79434 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000178 | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 10648428 | 10648428 | PRJNA473201_P_NODE_82749_length_242_cov_0.911243_g82007_i0 | PRJNA473201 | 82749 | 242 | 0.911243 | 2.20520806 | Pristionchus sp. 15 RS5229 | 452809 | Nematoda | Nematoda | 87.9 | 5.98e-13 | NTclustered | gi|150982147|gb|EF634662.1| | 452809 | g82007 | i0 | 86.25 | 0.611570247933884 | 80 | 11 | 33 | 0 | 163 | 242 | 410 | 331 | Pristionchus sp. 15 RS5229 large subunit ribosomal protein 27a (rpl-27a) mRNA, partial cds | blastn | 148 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 14473312 | 14473312 | PRJNA473201_P_NODE_84712_length_241_cov_0.916667_g83970_i0 | PRJNA473201 | 84712 | 241 | 0.916667 | 2.20916747 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 446 | 8.519999999999999e-121 | NTclustered | gi|1831511604|ref|NM_001268223.3| | 6239 | g83970 | i0 | 100 | 6.37344398340249 | 241 | 0 | 100 | 0 | 1 | 241 | 1116 | 876 | Caenorhabditis elegans uncharacterized protein (brp-1), partial mRNA | blastn | 1536 | 446 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 15746373 | 15746373 | PRJNA473201_P_NODE_33513_length_342_cov_28.334572_g32771_i0 | PRJNA473201 | 33513 | 342 | 28.334572 | 96.90423624 | Philometra sp. HZ-2022 | 3016125 | Nematoda | Nematoda | 56.5 | 0.002 | NTclustered | gi|2416169854|gb|OM469015.1| | 3016125 | g32771 | i0 | 100 | 0.087719298245614 | 30 | 0 | 9 | 0 | 77 | 106 | 5557 | 5586 | Philometra sp. HZ-2022 mitochondrion, complete genome | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Philometridae | Philometra | Philometra sp. HZ-2022 | |
| 17021800 | 17021800 | PRJNA473201_P_NODE_73594_length_247_cov_0.885057_g72852_i0 | PRJNA473201 | 73594 | 247 | 0.885057 | 2.18609079 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.022 | NTclustered | gi|687866048|emb|LK927941.1| | 6239 | g72852 | i0 | 100 | 0.340080971659919 | 28 | 0 | 11 | 0 | 47 | 74 | 3614 | 3641 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000060 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 19569471 | 19569471 | PRJNA473201_P_NODE_35756_length_333_cov_1.180769_g35014_i0 | PRJNA473201 | 35756 | 333 | 1.180769 | 3.93196077 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 616 | 8.87e-172 | NTclustered | gi|1972264646|ref|NM_066119.9| | 6239 | g35014 | i0 | 100 | 93.3663663663664 | 333 | 0 | 100 | 0 | 1 | 333 | 1177 | 845 | Caenorhabditis elegans Elongation factor 1-alpha (eef-1A.1), mRNA | blastn | 31091 | 616 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 20844950 | 20844950 | PRJNA473201_P_NODE_11797_length_587_cov_0.832685_g11060_i0 | PRJNA473201 | 11797 | 587 | 0.832685 | 4.88786095 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 236 | 1.03e-72 | NR | VDN92629.1 | 6280 | g11060 | i0 | 69.1 | 12.2810902896082 | 162 | 50 | 82.8 | 0 | 101 | 586 | 289 | 450 | VDN92629.1 unnamed protein product [Brugia pahangi] | diamond | 7209 | 237 | 0.9957805907173 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia pahangi | |
| 24669533 | 24669533 | PRJNA473201_P_NODE_18060_length_467_cov_5.177665_g17318_i0 | PRJNA473201 | 18060 | 467 | 5.177665 | 24.17969555 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 292 | 2.4599999999999993e-74 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g17318 | i0 | 81.492 | 4.83083511777302 | 362 | 61 | 77 | 6 | 62 | 420 | 37 | 395 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 2256 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 28718446 | 28718446 | PRJNA473201_P_NODE_62967_length_258_cov_1.664865_g62225_i0 | PRJNA473201 | 62967 | 258 | 1.664865 | 4.2953517 | Aphelenchoides bicaudatus | 293665 | Nematoda | Nematoda | 109 | 2.2e-27 | NR | KAI6182696.1 | 293665 | g62225 | i0 | 65.4 | 2.80232558139535 | 81 | 28 | 94.2 | 0 | 245 | 3 | 15 | 95 | KAI6182696.1 Ribosomal protein L1 domain containing protein [Aphelenchoides bicaudatus] | diamond | 723 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides bicaudatus | |
| 28860716 | 28860716 | PRJNA473201_P_NODE_63428_length_257_cov_1.331522_g62686_i0 | PRJNA473201 | 63428 | 257 | 1.331522 | 3.42201154 | Aphelenchoides | 90723 | Nematoda | Nematoda | 62 | 2.36e-9 | NR | KAI6211714.1 | 269767 | g62686 | i0 | 65.1 | 4.59922178988327 | 43 | 15 | 50.2 | 0 | 252 | 124 | 151 | 193 | KAI6211714.1 50S ribosomal protein L5 [Aphelenchoides besseyi] | diamond | 1182 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 28923824 | 28923824 | PRJNA473201_P_NODE_82048_length_243_cov_0.905882_g81306_i0 | PRJNA473201 | 82048 | 243 | 0.905882 | 2.20129326 | Nematoda | 6231 | Nematoda | Nematoda | 97.8 | 6.13e-25 | NR | NP_001379573.1 | 6239 | g81306 | i0 | 71.4 | 13.0864197530864 | 56 | 16 | 69.1 | 0 | 239 | 72 | 1 | 56 | NP_001379573.1 Small ribosomal subunit protein uS14 [Caenorhabditis elegans] | diamond | 3180 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 30282293 | 30282293 | PRJNA473201_P_NODE_74392_length_247_cov_0.885057_g73650_i0 | PRJNA473201 | 74392 | 247 | 0.885057 | 2.18609079 | Metazoa | 33208 | Nematoda | Nematoda | 99.8 | 2.63e-22 | NR | CAD5222489.1 | 6326 | g73650 | i0 | 64 | 17.3562753036437 | 75 | 27 | 91.1 | 0 | 1 | 225 | 54 | 128 | CAD5222489.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 4287 | 100 | 0.998 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 30314059 | 30314059 | PRJNA473201_P_NODE_79552_length_244_cov_0.900585_g78810_i0 | PRJNA473201 | 79552 | 244 | 0.900585 | 2.1974274 | Trichostrongylidae | 6315 | Nematoda | Nematoda | 62.8 | 1.16e-10 | NR | KAK6009138.1 | 6317 | g78810 | i0 | 50 | 2.4344262295082 | 66 | 31 | 81.1 | 1 | 198 | 1 | 2 | 65 | KAK6009138.1 acyl CoA binding protein, partial [Ostertagia ostertagi] | diamond | 594 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi | |
| 31656224 | 31656224 | PRJNA473201_P_NODE_32037_length_350_cov_1.050542_g31295_i0 | PRJNA473201 | 32037 | 350 | 1.050542 | 3.676897 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 53.5 | 1.66e-5 | NR | AVZ46778.1 | 189291 | g31295 | i0 | 48.4 | 0.548571428571429 | 64 | 33 | 54.9 | 0 | 193 | 2 | 117 | 180 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 192 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola |
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);;