contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA1233465" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25681884 | 25681884 | PRJNA1233465e_S_NODE_108506_length_186_cov_2.510949_g107196_i0 | PRJNA1233465 | 108506 | 186 | 2.510949 | 4.67036514 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.016 | NTclustered | gi|690018475|emb|LM525713.1| | 174720 | g107196 | i0 | 100 | 0.150537634408602 | 28 | 0 | 15 | 0 | 127 | 154 | 10778 | 10751 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000109 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 25689134 | 25689134 | PRJNA1233465f_S_NODE_143282_length_204_cov_4.948387_g141002_i0 | PRJNA1233465 | 143282 | 204 | 4.948387 | 10.09470948 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 56.5 | 0.001 | NTclustered | gi|1376151369|ref|XM_024644170.1| | 34506 | g141002 | i0 | 94.595 | 0.181372549019608 | 37 | 1 | 18 | 1 | 14 | 49 | 462 | 426 | Strongyloides ratti Dynamin-like 120 kDa protein, mitochondrial (SRAE_2000518900), partial mRNA | blastn | 37 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 25809207 | 25809207 | PRJNA1233465b_S_NODE_169259_length_224_cov_2.685714_g167574_i0 | PRJNA1233465 | 169259 | 224 | 2.685714 | 6.01599936 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 56.5 | 0.002 | NTclustered | gi|687865940|emb|LK928062.1| | 6239 | g167574 | i0 | 100 | 0.267857142857143 | 30 | 0 | 13 | 0 | 123 | 152 | 5809 | 5838 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000088 | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 25816969 | 25816969 | PRJNA1233465d_S_NODE_77555_length_202_cov_3.307190_g76444_i0 | PRJNA1233465 | 77555 | 202 | 3.30719 | 6.6805238 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.018 | NTclustered | gi|690018475|emb|LM525713.1| | 174720 | g76444 | i0 | 100 | 0.138613861386139 | 28 | 0 | 14 | 0 | 49 | 76 | 10751 | 10778 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000109 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 25820159 | 25820159 | PRJNA1233465e_S_NODE_162283_length_162_cov_0.902655_g160973_i0 | PRJNA1233465 | 162283 | 162 | 0.902655 | 1.4623011 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 56.5 | 0.001 | NTclustered | gi|687865940|emb|LK928062.1| | 6239 | g160973 | i0 | 100 | 0.37037037037037 | 30 | 0 | 19 | 0 | 130 | 159 | 5809 | 5838 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000088 | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 25959083 | 25959083 | PRJNA1233465e_S_NODE_88188_length_203_cov_0.993506_g86878_i0 | PRJNA1233465 | 88188 | 203 | 0.993506 | 2.01681718 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 58.4 | 3.8e-4 | NTclustered | gi|687022674|emb|LM525588.1| | 174720 | g86878 | i0 | 100 | 0.152709359605911 | 31 | 0 | 15 | 0 | 72 | 102 | 44213 | 44183 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000011 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 25959549 | 25959549 | PRJNA1233465e_S_NODE_99228_length_193_cov_2.138889_g97918_i0 | PRJNA1233465 | 99228 | 193 | 2.138889 | 4.12805577 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 56.5 | 0.001 | NTclustered | gi|1376151369|ref|XM_024644170.1| | 34506 | g97918 | i0 | 94.595 | 0.191709844559585 | 37 | 1 | 19 | 1 | 156 | 191 | 426 | 462 | Strongyloides ratti Dynamin-like 120 kDa protein, mitochondrial (SRAE_2000518900), partial mRNA | blastn | 37 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 26097522 | 26097522 | PRJNA1233465f_S_NODE_143957_length_204_cov_1.503226_g141677_i0 | PRJNA1233465 | 143957 | 204 | 1.503226 | 3.06658104 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.018 | NTclustered | gi|687866253|emb|LK928260.1| | 6239 | g141677 | i0 | 100 | 0.274509803921569 | 28 | 0 | 14 | 0 | 62 | 89 | 36125 | 36152 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000572 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 26101003 | 26101003 | PRJNA1233465f_S_NODE_223789_length_170_cov_0.826446_g221509_i0 | PRJNA1233465 | 223789 | 170 | 0.826446 | 1.4049582 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 54.7 | 0.004 | NTclustered | gi|1376137491|ref|XM_024648897.1| | 34506 | g221509 | i0 | 94.444 | 0.211764705882353 | 36 | 1 | 21 | 1 | 110 | 144 | 141 | 176 | Strongyloides ratti Hypothetical protein (SRAE_1000188700), partial mRNA | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 26211420 | 26211420 | PRJNA1233465a_S_NODE_118270_length_214_cov_12.193939_g116996_i0 | PRJNA1233465 | 118270 | 214 | 12.193939 | 26.09502946 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.019 | NTclustered | gi|690018475|emb|LM525713.1| | 174720 | g116996 | i0 | 100 | 0.130841121495327 | 28 | 0 | 13 | 0 | 156 | 183 | 10778 | 10751 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000109 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 26212895 | 26212895 | PRJNA1233465a_S_NODE_178718_length_182_cov_0.977444_g177444_i0 | PRJNA1233465 | 178718 | 182 | 0.977444 | 1.77894808 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.015 | NTclustered | gi|687865515|emb|LK927686.1| | 6239 | g177444 | i0 | 100 | 0.307692307692308 | 28 | 0 | 15 | 0 | 18 | 45 | 135174 | 135147 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000136 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 26215655 | 26215655 | PRJNA1233465a_S_NODE_56734_length_282_cov_1.669528_g55460_i0 | PRJNA1233465 | 56734 | 282 | 1.669528 | 4.70806896 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 54.7 | 0.007 | NTclustered | gi|687022714|emb|LM525628.1| | 174720 | g55460 | i0 | 100 | 0.102836879432624 | 29 | 0 | 10 | 0 | 228 | 256 | 57925 | 57953 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000037 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 26221539 | 26221539 | PRJNA1233465d_S_NODE_102806_length_180_cov_3.022901_g101695_i0 | PRJNA1233465 | 102806 | 180 | 3.022901 | 5.4412218 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 56.5 | 0.001 | NTclustered | gi|1376151369|ref|XM_024644170.1| | 34506 | g101695 | i0 | 94.595 | 0.205555555555556 | 37 | 1 | 20 | 1 | 132 | 167 | 426 | 462 | Strongyloides ratti Dynamin-like 120 kDa protein, mitochondrial (SRAE_2000518900), partial mRNA | blastn | 37 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 26227719 | 26227719 | PRJNA1233465e_S_NODE_141742_length_167_cov_1.694915_g140432_i0 | PRJNA1233465 | 141742 | 167 | 1.694915 | 2.83050805 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.014 | NTclustered | gi|687865486|emb|LK927790.1| | 6239 | g140432 | i0 | 100 | 0.335329341317365 | 28 | 0 | 17 | 0 | 8 | 35 | 21608 | 21635 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000230 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 26231995 | 26231995 | PRJNA1233465f_S_NODE_104606_length_234_cov_3.518919_g102326_i0 | PRJNA1233465 | 104606 | 234 | 3.518919 | 8.23427046 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 56.5 | 0.002 | NTclustered | gi|687865940|emb|LK928062.1| | 6239 | g102326 | i0 | 100 | 0.256410256410256 | 30 | 0 | 13 | 0 | 158 | 187 | 5809 | 5838 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000088 | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 26361217 | 26361217 | PRJNA1233465d_S_NODE_79071_length_201_cov_1.006579_g77960_i0 | PRJNA1233465 | 79071 | 201 | 1.006579 | 2.02322379 | Capillaria sp. cat-2 | 3439026 | Nematoda | Nematoda | 52.8 | 0.017 | NTclustered | gi|1633817164|gb|MH665363.1| | 2488633 | g77960 | i0 | 96.774 | 0.154228855721393 | 31 | 1 | 15 | 0 | 132 | 162 | 13017 | 13047 | Capillaria sp. cat-2018 mitochondrion, complete genome | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Capillaria | Capillaria sp. cat-2018 | |
| 26369608 | 26369608 | PRJNA1233465f_S_NODE_146687_length_202_cov_4.686275_g144407_i0 | PRJNA1233465 | 146687 | 202 | 4.686275 | 9.4662755 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.018 | NTclustered | gi|690018475|emb|LM525713.1| | 174720 | g144407 | i0 | 100 | 0.138613861386139 | 28 | 0 | 14 | 0 | 49 | 76 | 10751 | 10778 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000109 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 26374323 | 26374323 | PRJNA1233465f_S_NODE_258327_length_162_cov_11.867257_g256047_i0 | PRJNA1233465 | 258327 | 162 | 11.867257 | 19.22495634 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.013 | NTclustered | gi|351062746|emb|FO081321.1| | 6239 | g256047 | i0 | 100 | 0.864197530864197 | 28 | 0 | 17 | 0 | 63 | 90 | 194 | 167 | Caenorhabditis elegans Cosmid F37F2, complete sequence | blastn | 140 | 52.8 | 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);;