contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1078753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192550 | 192550 | PRJNA1078753_P_NODE_31241_length_249_cov_0.875000_g31045_i0 | PRJNA1078753 | 31241 | 249 | 0.875 | 2.17875 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 167 | 7.709999999999999e-37 | NTclustered | gi|1376151971|ref|XM_024644498.1| | 34506 | g31045 | i0 | 80.088 | 3.79518072289157 | 226 | 43 | 90 | 2 | 25 | 249 | 312 | 88 | Strongyloides ratti Histone H4 family and Histone core domain and Histone-fold domain-containing protein (SRAE_X000018400), partial mRNA | blastn | 945 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 1467218 | 1467218 | PRJNA1078753_P_NODE_38142_length_244_cov_0.900585_g37946_i0 | PRJNA1078753 | 38142 | 244 | 0.900585 | 2.1974274 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 150 | 7.589999999999999e-32 | NTclustered | gi|1376157525|ref|XM_024646217.1| | 34506 | g37946 | i0 | 86.667 | 48.0491803278689 | 135 | 18 | 55 | 0 | 2 | 136 | 231 | 97 | Strongyloides ratti 26S proteasome non-ATPase regulatory subunit 14 (SRAE_0000034000), partial mRNA | blastn | 11724 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 5295383 | 5295383 | PRJNA1078753_P_NODE_3265_length_558_cov_6.694845_g3072_i0 | PRJNA1078753 | 3265 | 558 | 6.694845 | 37.3572351 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 464 | 5.96e-126 | NTclustered | gi|1376149319|ref|XM_024642975.1| | 34506 | g3072 | i0 | 83.603 | 78.7795698924731 | 494 | 81 | 89 | 0 | 65 | 558 | 1131 | 638 | Strongyloides ratti Actin, alpha cardiac muscle 1 (SRAE_2000414100), partial mRNA | blastn | 43959 | 464 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 15495359 | 15495359 | PRJNA1078753_P_NODE_8033_length_385_cov_2.929487_g7837_i0 | PRJNA1078753 | 8033 | 385 | 2.929487 | 11.27852495 | Pristionchus sp. 13 RS5231 | 452807 | Nematoda | Nematoda | 82.4 | 4.69e-11 | NTclustered | gi|150982219|gb|EF634698.1| | 452807 | g7837 | i0 | 87.324 | 1.03636363636364 | 71 | 9 | 18 | 0 | 16 | 86 | 1 | 71 | Pristionchus sp. 13 RS5231 large subunit ribosomal protein 29 (rpl-29) mRNA, complete cds | blastn | 399 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 13 RS5231 | |
| 16769407 | 16769407 | PRJNA1078753_P_NODE_1234_length_859_cov_11.353690_g1080_i0 | PRJNA1078753 | 1234 | 859 | 11.35369 | 97.5281971 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 798 | 0 | NTclustered | gi|1376149319|ref|XM_024642975.1| | 34506 | g1080 | i0 | 84.818 | 89.5064027939464 | 797 | 117 | 93 | 4 | 1 | 795 | 337 | 1131 | Strongyloides ratti Actin, alpha cardiac muscle 1 (SRAE_2000414100), partial mRNA | blastn | 76886 | 798 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 19318227 | 19318227 | PRJNA1078753_P_NODE_22276_length_269_cov_1.540816_g22080_i0 | PRJNA1078753 | 22276 | 269 | 1.540816 | 4.14479504 | Aphelenchoides besseyi | 269767 | Nematoda | Nematoda | 497 | 2.63e-136 | NTclustered | gi|1153118091|gb|KY123696.1| | 269767 | g22080 | i0 | 100 | 96.2118959107807 | 269 | 0 | 100 | 0 | 1 | 269 | 754 | 486 | Aphelenchoides besseyi isolate DJ18S clone 4 28S ribosomal RNA gene, partial sequence | blastn | 25881 | 497 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 19318464 | 19318464 | PRJNA1078753_P_NODE_9356_length_364_cov_1.470790_g9160_i0 | PRJNA1078753 | 9356 | 364 | 1.47079 | 5.3536756 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 54.7 | 0.01 | NTclustered | gi|2445392365|ref|XM_053735414.1| | 31234 | g9160 | i0 | 100 | 0.0796703296703297 | 29 | 0 | 8 | 0 | 25 | 53 | 905 | 877 | Caenorhabditis remanei uncharacterized protein (GCK72_023494), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 21869210 | 21869210 | PRJNA1078753_P_NODE_11098_length_342_cov_6.457249_g10902_i0 | PRJNA1078753 | 11098 | 342 | 6.457249 | 22.08379158 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 244 | 4.9699999999999996e-60 | NTclustered | gi|690022274|emb|LM530102.1| | 174720 | g10902 | i0 | 85.965 | 98.8654970760234 | 228 | 32 | 67 | 0 | 98 | 325 | 228 | 1 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0004347 | blastn | 33812 | 244 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus |
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);;