contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA795983" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4608593 | 4608593 | PRJNA795983_S_NODE_38904_length_246_cov_1.763006_g38779_i0 | PRJNA795983 | 38904 | 246 | 1.763006 | 4.33699476 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 185 | 2.1e-42 | NTclustered | gi|690018930|emb|LM526223.1| | 174720 | g38779 | i0 | 85.246 | 76.7967479674797 | 183 | 23 | 74 | 4 | 64 | 244 | 9904 | 9724 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000575 | blastn | 18892 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 4608634 | 4608634 | PRJNA795983_S_NODE_44544_length_227_cov_2.987013_g44419_i0 | PRJNA795983 | 44544 | 227 | 2.987013 | 6.78051951 | Brugia malayi | 6279 | Nematoda | Nematoda | 237 | 5.199999999999999e-58 | NTclustered | gi|2082297892|ref|XM_043075899.1| | 6279 | g44419 | i0 | 85.714 | 74.6387665198238 | 224 | 32 | 99 | 0 | 4 | 227 | 908 | 685 | Brugia malayi Heat shock 70 kDa protein C precursor, putative (Bm13661), partial mRNA | blastn | 16943 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 14808707 | 14808707 | PRJNA795983_S_NODE_31672_length_262_cov_2.164021_g31547_i0 | PRJNA795983 | 31672 | 262 | 2.164021 | 5.66973502 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 193 | 1.35e-44 | NTclustered | gi|1376146275|ref|XM_024653703.1| | 34506 | g31547 | i0 | 82.174 | 9.61832061068702 | 230 | 35 | 87 | 5 | 26 | 252 | 712 | 938 | Strongyloides ratti Bifunctional glutamate/proline--tRNA ligase (SRAE_2000261400), partial mRNA | blastn | 2520 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 14808737 | 14808737 | PRJNA795983_S_NODE_35192_length_252_cov_2.374302_g35067_i0 | PRJNA795983 | 35192 | 252 | 2.374302 | 5.98324104 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 259 | 1.25e-64 | NTclustered | gi|1376147725|ref|XM_024654528.1| | 34506 | g35067 | i0 | 87.556 | 85.2222222222222 | 225 | 27 | 89 | 1 | 28 | 252 | 1154 | 931 | Strongyloides ratti ATP synthase subunit alpha, mitochondrial (SRAE_2000334600), partial mRNA | blastn | 21476 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 19906824 | 19906824 | PRJNA795983_S_NODE_21756_length_299_cov_1.296460_g21631_i0 | PRJNA795983 | 21756 | 299 | 1.29646 | 3.8764154 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 237 | 7.15e-58 | NTclustered | gi|687022644|emb|LM525558.1| | 174720 | g21631 | i0 | 83.465 | 59.5451505016722 | 254 | 42 | 85 | 0 | 44 | 297 | 232772 | 232519 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000004 | blastn | 17804 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 19907088 | 19907088 | PRJNA795983_S_NODE_7276_length_436_cov_1.870523_g7151_i0 | PRJNA795983 | 7276 | 436 | 1.870523 | 8.15548028 | Pristionchus sp. 15 RS5229 | 452809 | Nematoda | Nematoda | 193 | 2.38e-44 | NTclustered | gi|150984457|gb|EF634871.1| | 452809 | g7151 | i0 | 77.848 | 21.2798165137615 | 316 | 66 | 72 | 3 | 119 | 432 | 329 | 16 | Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds | blastn | 9278 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 19907103 | 19907103 | PRJNA795983_S_NODE_9456_length_396_cov_2.424149_g9331_i0 | PRJNA795983 | 9456 | 396 | 2.424149 | 9.59963004 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 364 | 4.289999999999999e-96 | NTclustered | gi|1376148845|ref|XM_024642710.1| | 34506 | g9331 | i0 | 84.595 | 94.7575757575758 | 370 | 54 | 93 | 3 | 24 | 391 | 1316 | 948 | Strongyloides ratti Tubulin beta-2A chain (SRAE_2000390300), partial mRNA | blastn | 37524 | 364 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 25006365 | 25006365 | PRJNA795983_S_NODE_11060_length_375_cov_1.529801_g10935_i0 | PRJNA795983 | 11060 | 375 | 1.529801 | 5.73675375 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 202 | 3.35e-47 | NTclustered | gi|1376136451|ref|XM_024648309.1| | 34506 | g10935 | i0 | 77.311 | 46.8586666666667 | 357 | 71 | 94 | 10 | 18 | 371 | 725 | 376 | Strongyloides ratti Enolase (SRAE_1000136300), partial mRNA | blastn | 17572 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 25006465 | 25006465 | PRJNA795983_S_NODE_21600_length_299_cov_3.907080_g21475_i0 | PRJNA795983 | 21600 | 299 | 3.90708 | 11.6821692 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 250 | 9.19e-62 | NTclustered | gi|268537031|ref|XM_002633606.1| | 6238 | g21475 | i0 | 87.5 | 66.314381270903 | 216 | 27 | 72 | 0 | 7 | 222 | 270 | 55 | Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA | blastn | 19828 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 25006688 | 25006688 | PRJNA795983_S_NODE_44840_length_218_cov_5.572414_g44715_i0 | PRJNA795983 | 44840 | 218 | 5.572414 | 12.14786252 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 110 | 1.13e-19 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g44715 | i0 | 93.243 | 1.08256880733945 | 74 | 5 | 34 | 0 | 67 | 140 | 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 |
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);;