contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA515078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1761975 | 1761975 | PRJNA515078_P_NODE_12722_length_249_cov_1.448113_g12489_i0 | PRJNA515078 | 12722 | 249 | 1.448113 | 3.60580137 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 198 | 2.74e-46 | NTclustered | gi|268577906|ref|XM_002643890.1| | 6238 | g12489 | i0 | 86.592 | 47.429718875502 | 179 | 24 | 72 | 0 | 12 | 190 | 517 | 695 | Caenorhabditis briggsae Protein CBR-FTT-2 (Cbr-ftt-2), partial mRNA | blastn | 11810 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 8139893 | 8139893 | PRJNA515078_P_NODE_23147_length_180_cov_1.636364_g22914_i0 | PRJNA515078 | 23147 | 180 | 1.636364 | 2.9454552 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 110 | 8.93e-20 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g22914 | i0 | 93.243 | 1.31111111111111 | 74 | 5 | 41 | 0 | 63 | 136 | 37 | 110 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 236 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 11965517 | 11965517 | PRJNA515078_P_NODE_14910_length_227_cov_1.847368_g14677_i0 | PRJNA515078 | 14910 | 227 | 1.847368 | 4.19352536 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|11095099|gb|AC084653.1|CBRG45O14 | 6238 | g14677 | i0 | 96.875 | 0.140969162995595 | 32 | 1 | 14 | 0 | 2 | 33 | 14527 | 14496 | Caenorhabditis briggsae cosmid G45O14, complete sequence | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 11965706 | 11965706 | PRJNA515078_P_NODE_8990_length_304_cov_3.584270_g8757_i0 | PRJNA515078 | 8990 | 304 | 3.58427 | 10.8961808 | Pristionchus hoplostomus | 1355913 | Nematoda | Nematoda | 167 | 9.7e-37 | NTclustered | gi|524845312|gb|KC819366.1| | 1355913 | g8757 | i0 | 81.166 | 43.875 | 223 | 28 | 71 | 11 | 84 | 299 | 264 | 49 | 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 | |
| 12589890 | 12589890 | PRJNA515078_P_NODE_22850_length_181_cov_4.215278_g22617_i0 | PRJNA515078 | 22850 | 181 | 4.215278 | 7.62965318 | Metazoa | 33208 | Nematoda | Nematoda | 154 | 4.1e-33 | NTclustered | gi|156481|gb|M23433.1|CELUBIA | 6239 | g22617 | i0 | 86.014 | 92.939226519337 | 143 | 20 | 80 | 0 | 1 | 143 | 2250 | 2108 | C.elegans polyubiquitin (UbiA) gene, complete cds | blastn | 16822 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 13240741 | 13240741 | PRJNA515078_P_NODE_23431_length_179_cov_1.605634_g23198_i0 | PRJNA515078 | 23431 | 179 | 1.605634 | 2.87408486 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 202 | 1.42e-47 | NTclustered | gi|687022656|emb|LM525570.1| | 174720 | g23198 | i0 | 87.079 | 94.5139664804469 | 178 | 23 | 99 | 0 | 2 | 179 | 200485 | 200662 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000005 | blastn | 16918 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 15789629 | 15789629 | PRJNA515078_P_NODE_6053_length_383_cov_2.832370_g5820_i0 | PRJNA515078 | 6053 | 383 | 2.83237 | 10.8479771 | Pristionchus sp. 15 RS5229 | 452809 | Nematoda | Nematoda | 187 | 9.599999999999999e-43 | NTclustered | gi|150984457|gb|EF634871.1| | 452809 | g5820 | i0 | 77.532 | 22.8041775456919 | 316 | 67 | 82 | 3 | 28 | 341 | 329 | 16 | Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds | blastn | 8734 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 17063995 | 17063995 | PRJNA515078_P_NODE_11434_length_264_cov_2.687225_g11201_i0 | PRJNA515078 | 11434 | 264 | 2.687225 | 7.094274 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 60.2 | 1.44e-4 | NTclustered | gi|687022673|emb|LM525587.1| | 174720 | g11201 | i0 | 90.909 | 0.166666666666667 | 44 | 4 | 17 | 0 | 62 | 105 | 102403 | 102446 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000010 | blastn | 44 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 23439305 | 23439305 | PRJNA515078_P_NODE_26979_length_167_cov_2.153846_g26746_i0 | PRJNA515078 | 26979 | 167 | 2.153846 | 3.59692282 | Levipalatum texanum | 1486449 | Nematoda | Nematoda | 143 | 8.08e-30 | NTclustered | gi|610559467|gb|KJ395558.1| | 1486449 | g26746 | i0 | 84.564 | 2.40119760479042 | 149 | 17 | 87 | 4 | 14 | 159 | 220 | 365 | Levipalatum texanum ribosomal protein (rpl-23) gene, partial cds | blastn | 401 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Levipalatum | Levipalatum texanum | |
| 24712848 | 24712848 | PRJNA515078_P_NODE_14040_length_235_cov_2.212121_g13807_i0 | PRJNA515078 | 14040 | 235 | 2.212121 | 5.19848435 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 161 | 3.3499999999999996e-35 | NTclustered | gi|156347|gb|M26906.1|CELHSP3B | 6238 | g13807 | i0 | 80.09 | 57.1957446808511 | 221 | 40 | 93 | 4 | 17 | 235 | 1929 | 1711 | C.briggsae heat shock protein 3 gene, complete cds | blastn | 13441 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 24713031 | 24713031 | PRJNA515078_P_NODE_7680_length_333_cov_2.527027_g7447_i0 | PRJNA515078 | 7680 | 333 | 2.527027 | 8.41499991 | Diplogastrellus gracilis | 669117 | Nematoda | Nematoda | 202 | 2.94e-47 | NTclustered | gi|256709130|gb|GQ422217.1| | 669117 | g7447 | i0 | 79.861 | 71.5795795795796 | 288 | 48 | 85 | 8 | 51 | 333 | 723 | 441 | Diplogastrellus gracilis large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 23836 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Diplogastrellus | Diplogastrellus gracilis |
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);;