contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJEB39643" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2607578 | 2607578 | PRJEB39643_P_NODE_155843_length_226_cov_2.411765_g155649_i0 | PRJEB39643 | 155843 | 226 | 2.411765 | 5.4505889 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|1376137057|ref|XM_024648649.1| | 34506 | g155649 | i0 | 100 | 0.128318584070796 | 29 | 0 | 13 | 0 | 5 | 33 | 1483 | 1511 | Strongyloides ratti Matrilin-2 (SRAE_1000166600), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 6435735 | 6435735 | PRJEB39643_P_NODE_14226_length_496_cov_3.810875_g14035_i0 | PRJEB39643 | 14226 | 496 | 3.810875 | 18.90194 | Brugia malayi | 6279 | Nematoda | Nematoda | 56.5 | 0.004 | NTclustered | gi|2082273863|ref|XM_043076275.1| | 6279 | g14035 | i0 | 97.059 | 0.137096774193548 | 34 | 0 | 7 | 1 | 14 | 46 | 46 | 13 | Brugia malayi Uncharacterized protein (Bma-lgc-37), partial mRNA | blastn | 68 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 7710452 | 7710452 | PRJEB39643_P_NODE_4107_length_1026_cov_7.161595_g3995_i0 | PRJEB39643 | 4107 | 1026 | 7.161595 | 73.4779647 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 56.5 | 0.008 | NTclustered | gi|687022647|emb|LM525561.1| | 174720 | g3995 | i0 | 96.97 | 0.0321637426900585 | 33 | 1 | 3 | 0 | 967 | 999 | 236856 | 236824 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000006 | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 11536082 | 11536082 | PRJEB39643_P_NODE_27130_length_352_cov_1.781362_g26937_i0 | PRJEB39643 | 27130 | 352 | 1.781362 | 6.27039424 | Rotylenchulus reniformis | 239373 | Nematoda | Nematoda | 52.8 | 0.033 | NTclustered | gi|320577020|gb|HQ158017.1| | 239373 | g26937 | i0 | 100 | 0.159090909090909 | 28 | 0 | 8 | 0 | 223 | 250 | 178 | 205 | Rotylenchulus reniformis microsatellite RR4-4 sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Hoplolaimidae | Rotylenchulus | Rotylenchulus reniformis | |
| 12811464 | 12811464 | PRJEB39643_P_NODE_34551_length_316_cov_4.662551_g34358_i0 | PRJEB39643 | 34551 | 316 | 4.662551 | 14.73366116 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.03 | NTclustered | gi|687022669|emb|LM525583.1| | 174720 | g34358 | i0 | 100 | 0.0886075949367089 | 28 | 0 | 9 | 0 | 143 | 170 | 131273 | 131300 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000021 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 14085883 | 14085883 | PRJEB39643_P_NODE_147952_length_242_cov_0.911243_g147759_i0 | PRJEB39643 | 147952 | 242 | 0.911243 | 2.20520806 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.022 | NTclustered | gi|413001960|emb|Z69635.2| | 6239 | g147759 | i0 | 96.875 | 0.264462809917355 | 32 | 0 | 13 | 1 | 88 | 119 | 1288 | 1258 | Caenorhabditis elegans Cosmid F19B6, complete sequence | blastn | 64 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 15359853 | 15359853 | PRJEB39643_P_NODE_15693_length_466_cov_27.498728_g15501_i0 | PRJEB39643 | 15693 | 466 | 27.498728 | 128.14407248 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.045 | NTclustered | gi|687022641|emb|LM525555.1| | 174720 | g15501 | i0 | 100 | 0.0600858369098712 | 28 | 0 | 6 | 0 | 270 | 297 | 1143453 | 1143426 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000001 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 16634713 | 16634713 | PRJEB39643_P_NODE_2994_length_1173_cov_13.704545_g2898_i0 | PRJEB39643 | 2994 | 1173 | 13.704545 | 160.75431285 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 60.2 | 7.15e-4 | NTclustered | gi|687022727|emb|LM525641.1| | 174720 | g2898 | i0 | 100 | 0.0272804774083546 | 32 | 0 | 3 | 0 | 353 | 384 | 87331 | 87300 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000049 | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 21735010 | 21735010 | PRJEB39643_P_NODE_65118_length_278_cov_1.502439_g64925_i0 | PRJEB39643 | 65118 | 278 | 1.502439 | 4.17678042 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.026 | NTclustered | gi|687865918|emb|LK927922.1| | 6239 | g64925 | i0 | 100 | 0.201438848920863 | 28 | 0 | 10 | 0 | 251 | 278 | 13659 | 13686 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000340 | blastn | 56 | 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);;