contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1118794" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 230604 | 230604 | PRJNA1118794_P_NODE_33321_length_284_cov_1.165877_g32571_i0 | PRJNA1118794 | 33321 | 284 | 1.165877 | 3.31109068 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.026 | NTclustered | gi|1845972949|ref|NM_001356891.4| | 6239 | g32571 | i0 | 96.774 | 0.316901408450704 | 31 | 1 | 11 | 0 | 133 | 163 | 100 | 70 | Caenorhabditis elegans Apple domain-containing protein (T05B9.2), mRNA | blastn | 90 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 231030 | 231030 | PRJNA1118794_P_NODE_68781_length_243_cov_0.905882_g68031_i0 | PRJNA1118794 | 68781 | 243 | 0.905882 | 2.20129326 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 128 | 3.54e-25 | NTclustered | gi|690018531|emb|LM525769.1| | 174720 | g68031 | i0 | 89.32 | 4.13168724279835 | 103 | 9 | 42 | 2 | 6 | 107 | 28374 | 28475 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000058 | blastn | 1004 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 7883292 | 7883292 | PRJNA1118794_P_NODE_14687_length_379_cov_2.725490_g13937_i0 | PRJNA1118794 | 14687 | 379 | 2.72549 | 10.3296071 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 311 | 5.4e-80 | NTclustered | gi|268537031|ref|XM_002633606.1| | 6238 | g13937 | i0 | 84.79 | 78.8891820580475 | 309 | 47 | 82 | 0 | 66 | 374 | 55 | 363 | Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA | blastn | 29899 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 10433856 | 10433856 | PRJNA1118794_P_NODE_17089_length_358_cov_1.466667_g16339_i0 | PRJNA1118794 | 17089 | 358 | 1.466667 | 5.25066786 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 220 | 8.78e-53 | NTclustered | gi|1376153203|ref|XM_024645200.1| | 34506 | g16339 | i0 | 83.197 | 12.6173184357542 | 244 | 37 | 68 | 4 | 1 | 242 | 263 | 22 | Strongyloides ratti Pyruvate dehydrogenase E1 component subunit beta, mitochondrial (SRAE_X000081100), partial mRNA | blastn | 4517 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 10434247 | 10434247 | PRJNA1118794_P_NODE_45309_length_257_cov_1.673913_g44559_i0 | PRJNA1118794 | 45309 | 257 | 1.673913 | 4.30195641 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 209 | 1.31e-49 | NTclustered | gi|1376147935|ref|XM_024654645.1| | 34506 | g44559 | i0 | 81.569 | 2.28015564202335 | 255 | 45 | 99 | 2 | 4 | 257 | 767 | 514 | Strongyloides ratti GMP reductase (SRAE_2000345100), partial mRNA | blastn | 586 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 10434424 | 10434424 | PRJNA1118794_P_NODE_59769_length_246_cov_1.780347_g59019_i0 | PRJNA1118794 | 59769 | 246 | 1.780347 | 4.37965362 | Brugia malayi | 6279 | Nematoda | Nematoda | 228 | 3.4399999999999986e-55 | NTclustered | gi|2082298039|ref|XM_043075942.1| | 6279 | g59019 | i0 | 88.36 | 22.7967479674797 | 189 | 22 | 77 | 0 | 50 | 238 | 1 | 189 | Brugia malayi Uncharacterized protein (Bma-tbb-4), partial mRNA | blastn | 5608 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 11709228 | 11709228 | PRJNA1118794_P_NODE_25190_length_312_cov_1.924686_g24440_i0 | PRJNA1118794 | 25190 | 312 | 1.924686 | 6.00502032 | Pristionchus sp. 15 RS5229 | 452809 | Nematoda | Nematoda | 163 | 1.2899999999999998e-35 | NTclustered | gi|150984457|gb|EF634871.1| | 452809 | g24440 | i0 | 77.536 | 20.6634615384615 | 276 | 58 | 88 | 3 | 4 | 277 | 289 | 16 | Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds | blastn | 6447 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 11709536 | 11709536 | PRJNA1118794_P_NODE_47330_length_253_cov_1.705556_g46580_i0 | PRJNA1118794 | 47330 | 253 | 1.705556 | 4.31505668 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 93.5 | 1.35e-14 | NTclustered | gi|268531145|ref|XM_002630653.1| | 6238 | g46580 | i0 | 89.189 | 2.20948616600791 | 74 | 8 | 29 | 0 | 176 | 249 | 86 | 159 | Caenorhabditis briggsae Protein CBR-PRDX-2 (Cbr-prdx-2), partial mRNA | blastn | 559 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 14259581 | 14259581 | PRJNA1118794_P_NODE_30312_length_291_cov_1.756881_g29562_i0 | PRJNA1118794 | 30312 | 291 | 1.756881 | 5.11252371 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 259 | 1.4800000000000002e-64 | NTclustered | gi|1376154927|ref|XM_024651418.1| | 34506 | g29562 | i0 | 83.099 | 75.4776632302406 | 284 | 48 | 98 | 0 | 1 | 284 | 128 | 411 | Strongyloides ratti Histone H3 (SRAE_X000165500), partial mRNA | blastn | 21964 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 15052638 | 15052638 | PRJNA1118794_P_NODE_57412_length_247_cov_1.942529_g56662_i0 | PRJNA1118794 | 57412 | 247 | 1.942529 | 4.79804663 | Pristionchus | 54125 | Nematoda | Nematoda | 145 | 3.58e-30 | NTclustered | gi|150984639|gb|EF634981.1| | 452806 | g56662 | i0 | 80.851 | 22.8218623481781 | 188 | 32 | 75 | 4 | 1 | 186 | 236 | 51 | Pristionchus sp. 11 RS5228 small subunit ribosomal protein 27 (rps-27) mRNA, complete cds | blastn | 5637 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 11 RS5228 | |
| 15532911 | 15532911 | PRJNA1118794_P_NODE_10673_length_433_cov_2.472222_g9925_i0 | PRJNA1118794 | 10673 | 433 | 2.472222 | 10.70472126 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 374 | 7.85e-99 | NTclustered | gi|1376147859|ref|XM_024654603.1| | 34506 | g9925 | i0 | 86.377 | 165.131639722864 | 345 | 44 | 79 | 3 | 3 | 346 | 127 | 469 | Strongyloides ratti Polyubiquitin-C (SRAE_2000341300), partial mRNA | blastn | 71502 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 15533767 | 15533767 | PRJNA1118794_P_NODE_9053_length_469_cov_1.040404_g8305_i0 | PRJNA1118794 | 9053 | 469 | 1.040404 | 4.87949476 | Pristionchus hoplostomus | 1355913 | Nematoda | Nematoda | 167 | 1.56e-36 | NTclustered | gi|524845312|gb|KC819366.1| | 1355913 | g8305 | i0 | 81.166 | 26.3326226012793 | 223 | 28 | 46 | 11 | 68 | 283 | 49 | 264 | Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds | blastn | 12350 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus hoplostomus | |
| 16807560 | 16807560 | PRJNA1118794_P_NODE_2054_length_1018_cov_2.800000_g1485_i0 | PRJNA1118794 | 2054 | 1018 | 2.8 | 28.504 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 634 | 8.059999999999999e-177 | NTclustered | gi|1376147725|ref|XM_024654528.1| | 34506 | g1485 | i0 | 82.913 | 67.1512770137525 | 714 | 112 | 70 | 10 | 298 | 1006 | 1387 | 679 | Strongyloides ratti ATP synthase subunit alpha, mitochondrial (SRAE_2000334600), partial mRNA | blastn | 68360 | 634 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 18876530 | 18876530 | PRJNA1118794_P_NODE_10535_length_436_cov_1.415978_g9787_i0 | PRJNA1118794 | 10535 | 436 | 1.415978 | 6.17366408 | Metazoa | 33208 | Nematoda | Nematoda | 313 | 1.75e-80 | NTclustered | gi|2082298039|ref|XM_043075942.1| | 6279 | g9787 | i0 | 81.013 | 81.0045871559633 | 395 | 73 | 90 | 2 | 43 | 436 | 1 | 394 | Brugia malayi Uncharacterized protein (Bma-tbb-4), partial mRNA | blastn | 35318 | 316 | 0.990506329113924 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 20632229 | 20632229 | PRJNA1118794_P_NODE_977_length_1475_cov_4.186163_g624_i0 | PRJNA1118794 | 977 | 1475 | 4.186163 | 61.74590425 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 1090 | 0 | NTclustered | gi|1376148845|ref|XM_024642710.1| | 34506 | g624 | i0 | 81.722 | 90.344406779661 | 1324 | 226 | 89 | 12 | 87 | 1402 | 1316 | 1 | Strongyloides ratti Tubulin beta-2A chain (SRAE_2000390300), partial mRNA | blastn | 133258 | 1090 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti |
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);;