contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA986481" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2248497 | 2248497 | PRJNA986481_P_NODE_18562_length_380_cov_1.824773_g18037_i0 | PRJNA986481 | 18562 | 380 | 1.824773 | 6.9341374 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 211 | 5.65e-50 | NTclustered | gi|1376146183|ref|XM_024653652.1| | 34506 | g18037 | i0 | 81.111 | 4.03684210526316 | 270 | 46 | 70 | 5 | 108 | 374 | 1212 | 945 | Strongyloides ratti ATP synthase subunit beta (SRAE_2000256800), partial mRNA | blastn | 1534 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 2547724 | 2547724 | PRJNA986481_P_NODE_23222_length_340_cov_2.701031_g22697_i0 | PRJNA986481 | 23222 | 340 | 2.701031 | 9.1835054 | Rhabditida | 6236 | Nematoda | Nematoda | 87.9 | 8.8e-13 | NTclustered | gi|150984667|gb|EF634995.1| | 358043 | g22697 | i0 | 86.25 | 4.29117647058824 | 80 | 11 | 24 | 0 | 261 | 340 | 194 | 115 | Pristionchus sp. 6 RS5101 small subunit ribosomal protein 28 (rps-28) mRNA, complete cds | blastn | 1459 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 6 RS5101 | |
| 3524352 | 3524352 | PRJNA986481_P_NODE_49743_length_252_cov_2.536946_g49218_i0 | PRJNA986481 | 49743 | 252 | 2.536946 | 6.39310392 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 198 | 2.77e-46 | NTclustered | gi|687022641|emb|LM525555.1| | 174720 | g49218 | i0 | 81.481 | 5.75 | 243 | 43 | 96 | 2 | 10 | 251 | 397712 | 397953 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000001 | blastn | 1449 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 4801787 | 4801787 | PRJNA986481_P_NODE_56164_length_245_cov_1.545918_g55639_i0 | PRJNA986481 | 56164 | 245 | 1.545918 | 3.7874991 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 60.2 | 1.32e-4 | NTclustered | gi|1376152563|ref|XM_024644830.1| | 34506 | g55639 | i0 | 94.872 | 3.26122448979592 | 39 | 1 | 16 | 1 | 6 | 44 | 3926 | 3963 | Strongyloides ratti Hypothetical protein (SRAE_X000048000), partial mRNA | blastn | 799 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 7351065 | 7351065 | PRJNA986481_P_NODE_17126_length_396_cov_1.743516_g16601_i0 | PRJNA986481 | 17126 | 396 | 1.743516 | 6.90432336 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 220 | 9.82e-53 | NTclustered | gi|567773431|gb|KF739066.1| | 6326 | g16601 | i0 | 82.422 | 9.88131313131313 | 256 | 41 | 64 | 4 | 57 | 310 | 13 | 266 | Bursaphelenchus xylophilus isolate ZJZS FTT-2 protein mRNA, complete cds | blastn | 3913 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 9902155 | 9902155 | PRJNA986481_P_NODE_61248_length_236_cov_2.294118_g60723_i0 | PRJNA986481 | 61248 | 236 | 2.294118 | 5.41411848 | Diplogastrellus gracilis | 669117 | Nematoda | Nematoda | 174 | 4.33e-39 | NTclustered | gi|256709130|gb|GQ422217.1| | 669117 | g60723 | i0 | 83.598 | 79.9703389830509 | 189 | 27 | 79 | 4 | 50 | 236 | 723 | 537 | Diplogastrellus gracilis large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 18873 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Diplogastrellus | Diplogastrellus gracilis | |
| 9902187 | 9902187 | PRJNA986481_P_NODE_6948_length_614_cov_2.693805_g6461_i0 | PRJNA986481 | 6948 | 614 | 2.693805 | 16.5399627 | Brugia malayi | 6279 | Nematoda | Nematoda | 67.6 | 2.17e-6 | NTclustered | gi|2082286190|ref|XM_043080968.1| | 6279 | g6461 | i0 | 95.238 | 7.41205211726384 | 42 | 2 | 7 | 0 | 3 | 44 | 1777 | 1736 | Brugia malayi Iroquois-class homeobox protein C36F7.1, putative (Bma-irx-1), partial mRNA | blastn | 4551 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 9902223 | 9902223 | PRJNA986481_P_NODE_9068_length_541_cov_2.705285_g8554_i0 | PRJNA986481 | 9068 | 541 | 2.705285 | 14.63559185 | Pristionchus hoplostomus | 1355913 | Nematoda | Nematoda | 167 | 1.82e-36 | NTclustered | gi|524845312|gb|KC819366.1| | 1355913 | g8554 | i0 | 81.166 | 24.6543438077634 | 223 | 28 | 40 | 11 | 76 | 291 | 49 | 264 | Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds | blastn | 13338 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus hoplostomus | |
| 18824987 | 18824987 | PRJNA986481_P_NODE_14315_length_433_cov_4.736979_g13790_i0 | PRJNA986481 | 14315 | 433 | 4.736979 | 20.51111907 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 292 | 2.26e-74 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g13790 | i0 | 81.492 | 5.2101616628175504 | 362 | 61 | 83 | 6 | 32 | 390 | 395 | 37 | 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 | |
| 18825686 | 18825686 | PRJNA986481_P_NODE_5815_length_663_cov_7.563518_g5359_i0 | PRJNA986481 | 5815 | 663 | 7.563518 | 50.14612434 | Necator americanus | 51031 | Nematoda | Nematoda | 87.9 | 1.81e-12 | NTclustered | gi|2707603115|ref|XM_064206786.1| | 51031 | g5359 | i0 | 91.045 | 0.40422322775264 | 67 | 3 | 13 | 1 | 467 | 533 | 192 | 129 | Necator americanus uncharacterized protein (RB195_015869), partial mRNA | blastn | 268 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 23926154 | 23926154 | PRJNA986481_P_NODE_38219_length_266_cov_0.930876_g37694_i0 | PRJNA986481 | 38219 | 266 | 0.930876 | 2.47613016 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.024 | NTclustered | gi|687022786|emb|LM525898.1| | 174720 | g37694 | i0 | 100 | 0.105263157894737 | 28 | 0 | 11 | 0 | 105 | 132 | 11034 | 11007 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000272 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 25199897 | 25199897 | PRJNA986481_P_NODE_43360_length_260_cov_0.957346_g42835_i0 | PRJNA986481 | 43360 | 260 | 0.957346 | 2.4890996 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 481 | 2.55e-131 | NTclustered | gi|1972265861|ref|NM_001392207.1| | 6239 | g42835 | i0 | 100 | 3 | 260 | 0 | 100 | 0 | 1 | 260 | 858 | 1117 | Caenorhabditis elegans TASPase homolog (tasp-1), mRNA | blastn | 780 | 481 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans |
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);;