contig_metadata
15 rows where bioproject = "PRJNA934332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2185936 | 2185936 | PRJNA934332_P_NODE_2762_length_379_cov_1.627451_g2675_i0 | PRJNA934332 | 2762 | 379 | 1.627451 | 6.16803929 | Pristionchus sp. 6 RS5101 | 358043 | Nematoda | Nematoda | 228 | 5.589999999999998e-55 | NTclustered | gi|150982243|gb|EF634710.1| | 358043 | g2675 | i0 | 83.333 | 41.3693931398417 | 252 | 36 | 66 | 5 | 130 | 378 | 303 | 55 | Pristionchus sp. 6 RS5101 large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds | blastn | 15679 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 6 RS5101 | |
| 12734847 | 12734847 | PRJNA934332_P_NODE_4010_length_326_cov_2.624506_g3923_i0 | PRJNA934332 | 4010 | 326 | 2.624506 | 8.55588956 | Steinernema hermaphroditum | 289476 | Nematoda | Nematoda | 135 | 3.89e-34 | NR | KAK0412541.1 | 289476 | g3923 | i0 | 66.7 | 3.60736196319018 | 99 | 33 | 91.1 | 0 | 298 | 2 | 708 | 806 | KAK0412541.1 hypothetical protein QR680_006270 [Steinernema hermaphroditum] | diamond | 1176 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema hermaphroditum | |
| 26778881 | 26778881 | PRJNA934332_P_NODE_10361_length_243_cov_1.358824_g10274_i0 | PRJNA934332 | 10361 | 243 | 1.358824 | 3.30194232 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 114 | 2.32e-29 | NR | ACZ13327.1 | 6326 | g10274 | i0 | 74 | 5.76543209876543 | 77 | 20 | 95.1 | 0 | 231 | 1 | 51 | 127 | ACZ13327.1 60S ribosomal protein L7 [Bursaphelenchus xylophilus] | diamond | 1401 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 27189908 | 27189908 | PRJNA934332_P_NODE_8702_length_248_cov_0.880000_g8615_i0 | PRJNA934332 | 8702 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 64.7 | 7.12e-10 | NR | GMS81058.1 | 358040 | g8615 | i0 | 35.2 | 7.04032258064516 | 88 | 48 | 95.6 | 2 | 3 | 239 | 298 | 385 | GMS81058.1 hypothetical protein PENTCL1PPCAC_3233, partial [Pristionchus entomophagus] | diamond | 1746 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus entomophagus | |
| 28541131 | 28541131 | PRJNA934332_P_NODE_10147_length_244_cov_0.900585_g10060_i0 | PRJNA934332 | 10147 | 244 | 0.900585 | 2.1974274 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 64.3 | 9.62e-10 | NR | CAD2172123.1 | 390850 | g10060 | i0 | 38.1 | 1.0327868852459 | 84 | 45 | 94.7 | 1 | 10 | 240 | 419 | 502 | CAD2172123.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 252 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 28642822 | 28642822 | PRJNA934332_P_NODE_6467_length_269_cov_1.571429_g6380_i0 | PRJNA934332 | 6467 | 269 | 1.571429 | 4.22714401 | Rhabditida | 6236 | Nematoda | Nematoda | 97.4 | 5.31e-24 | NR | ABN49241.1 | 34506 | g6380 | i0 | 57 | 4.817843866171 | 86 | 36 | 94.8 | 1 | 13 | 267 | 1 | 86 | ABN49241.1 chaperonin 10 [Strongyloides ratti] | diamond | 1296 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 28888129 | 28888129 | PRJNA934332_P_NODE_6908_length_261_cov_1.622340_g6821_i0 | PRJNA934332 | 6908 | 261 | 1.62234 | 4.2343074 | Strongylus vulgaris | 40348 | Nematoda | Nematoda | 88.2 | 3.4e-19 | NR | VDM78559.1 | 40348 | g6821 | i0 | 65.4 | 1.74712643678161 | 52 | 18 | 59.8 | 0 | 260 | 105 | 171 | 222 | VDM78559.1 unnamed protein product [Strongylus vulgaris] | diamond | 456 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Strongylus | Strongylus vulgaris | |
| 29014825 | 29014825 | PRJNA934332_P_NODE_2628_length_386_cov_1.476038_g2541_i0 | PRJNA934332 | 2628 | 386 | 1.476038 | 5.69750668 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 77.4 | 7.39e-14 | NR | CAD5226920.1 | 6326 | g2541 | i0 | 39.8 | 0.955958549222798 | 123 | 70 | 93.3 | 2 | 20 | 379 | 11 | 132 | CAD5226920.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 369 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 29109383 | 29109383 | PRJNA934332_P_NODE_2788_length_378_cov_1.009836_g2701_i0 | PRJNA934332 | 2788 | 378 | 1.009836 | 3.81718008 | Trichuris suis | 68888 | Nematoda | Nematoda | 109 | 8.79e-26 | NR | KFD57259.1 | 68888 | g2701 | i0 | 49 | 0.825396825396825 | 104 | 51 | 81 | 1 | 71 | 376 | 38 | 141 | KFD57259.1 hypothetical protein M513_01770 [Trichuris suis] | diamond | 312 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 29109384 | 29109384 | PRJNA934332_P_NODE_3748_length_336_cov_1.171103_g3661_i0 | PRJNA934332 | 3748 | 336 | 1.171103 | 3.93490608 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 138 | 3.74e-37 | NR | CAD5212124.1 | 6326 | g3661 | i0 | 54.1 | 0.973214285714286 | 109 | 49 | 96.4 | 1 | 12 | 335 | 222 | 330 | CAD5212124.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 327 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 29116395 | 29116395 | PRJNA934332_P_NODE_7408_length_252_cov_1.290503_g7321_i0 | PRJNA934332 | 7408 | 252 | 1.290503 | 3.25206756 | Rhabditida | 6236 | Nematoda | Nematoda | 43.5 | 0.0185 | NR | VDM78544.1 | 40348 | g7321 | i0 | 48.6 | 1.66666666666667 | 35 | 18 | 41.7 | 0 | 3 | 107 | 40 | 74 | VDM78544.1 unnamed protein product [Strongylus vulgaris] | diamond | 420 | 43.9 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Strongylus | Strongylus vulgaris | |
| 31612249 | 31612249 | PRJNA934332_P_NODE_4836_length_301_cov_1.350877_g4749_i0 | PRJNA934332 | 4836 | 301 | 1.350877 | 4.06613977 | Rhabditida | 6236 | Nematoda | Nematoda | 96.3 | 2.08e-21 | NR | VDO70226.1 | 6339 | g4749 | i0 | 58.1 | 4.41528239202658 | 74 | 31 | 73.8 | 0 | 222 | 1 | 44 | 117 | VDO70226.1 unnamed protein product [Heligmosomoides polygyrus] | diamond | 1329 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heligmosomidae | Heligmosomoides | Heligmosomoides polygyrus | |
| 31833445 | 31833445 | PRJNA934332_P_NODE_6017_length_277_cov_1.132353_g5930_i0 | PRJNA934332 | 6017 | 277 | 1.132353 | 3.13661781 | Rhabditida | 6236 | Nematoda | Nematoda | 92.4 | 6.89e-20 | NR | NP_001369965.1 | 6239 | g5930 | i0 | 78.7 | 5.14440433212996 | 47 | 10 | 50.9 | 0 | 276 | 136 | 299 | 345 | NP_001369965.1 Peptidase C1A papain C-terminal domain-containing protein [Caenorhabditis elegans] | diamond | 1425 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 32181778 | 32181778 | PRJNA934332_P_NODE_6758_length_264_cov_1.308901_g6671_i0 | PRJNA934332 | 6758 | 264 | 1.308901 | 3.45549864 | Opisthokonta | 33154 | Nematoda | Nematoda | 49.3 | 2.3e-4 | NR | CAD5232653.1 | 6326 | g6671 | i0 | 35.4 | 5.81818181818182 | 99 | 49 | 98.9 | 3 | 3 | 263 | 13 | 108 | CAD5232653.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 1536 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 32687220 | 32687220 | PRJNA934332_P_NODE_7460_length_251_cov_1.432584_g7373_i0 | PRJNA934332 | 7460 | 251 | 1.432584 | 3.59578584 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 123 | 1.2199999999999999e-32 | NR | CAJ0579848.1 | 96644 | g7373 | i0 | 69.9 | 10.9123505976096 | 83 | 25 | 99.2 | 0 | 250 | 2 | 157 | 239 | CAJ0579848.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 2739 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera |
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);;