contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA414036" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1082932 | 1082932 | PRJNA414036_P_NODE_48221_length_231_cov_2.540816_g46482_i0 | PRJNA414036 | 48221 | 231 | 2.540816 | 5.86928496 | Panagrolaimus | 55784 | Nematoda | Nematoda | 124 | 4.31e-24 | NTclustered | gi|1393507003|gb|MH399794.1| | 2211197 | g46482 | i0 | 100 | 55.5151515151515 | 67 | 0 | 60 | 0 | 9 | 75 | 282 | 348 | Panagrolaimus sp. B3 ARA-2018 small subunit ribosomal RNA gene, partial sequence | blastn | 12824 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Panagrolaimus | Panagrolaimus sp. B3 ARA-2018 | |
| 6796492 | 6796492 | PRJNA414036_P_NODE_38766_length_236_cov_570.497512_g37027_i0 | PRJNA414036 | 38766 | 236 | 570.497512 | 1346.37412832 | Heterodera koreana | 501549 | Nematoda | Nematoda | 100 | 7.45e-17 | NTclustered | gi|164504681|gb|EU306357.1| | 501549 | g37027 | i0 | 86.667 | 3.09322033898305 | 90 | 12 | 38 | 0 | 127 | 216 | 1443 | 1354 | Heterodera koreana isolate wb17 18S ribosomal RNA gene, partial sequence | blastn | 730 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera koreana | |
| 7460946 | 7460946 | PRJNA414036_P_NODE_80326_length_162_cov_3.307087_g78587_i0 | PRJNA414036 | 80326 | 162 | 3.307087 | 5.35748094 | Metazoa | 33208 | Nematoda | Nematoda | 161 | 2.15e-35 | NTclustered | gi|62082933|gb|AY854224.1| | 320137 | g78587 | i0 | 100 | 63.2530864197531 | 87 | 0 | 54 | 0 | 7 | 93 | 868 | 782 | Daptonema normandicum 18S small subunit ribosomal RNA gene, partial sequence | blastn | 10247 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Monhysterida | Xyalidae | Daptonema | Daptonema normandicum | |
| 10010978 | 10010978 | PRJNA414036_P_NODE_35628_length_248_cov_10.131455_g33892_i0 | PRJNA414036 | 35628 | 248 | 10.131455 | 25.1260084 | Nematoda | 6231 | Nematoda | Nematoda | 182 | 2.74e-41 | NTclustered | gi|482677747|gb|KC522713.1| | 55785 | g33892 | i0 | 100 | 42.0846774193548 | 98 | 0 | 40 | 0 | 12 | 109 | 756 | 659 | Panagrolaimus sp. PS1159 small subunit ribosomal RNA gene, complete sequence | blastn | 10437 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Panagrolaimus | Panagrolaimus sp. PS1159 | |
| 13172466 | 13172466 | PRJNA414036_P_NODE_37951_length_239_cov_7.313725_g36212_i0 | PRJNA414036 | 37951 | 239 | 7.313725 | 17.47980275 | Panagrolaimus sp. JU1645 | 1325423 | Nematoda | Nematoda | 366 | 6.75e-97 | NTclustered | gi|482677736|gb|KC522702.1| | 1325423 | g36212 | i0 | 96.818 | 80.255230125523 | 220 | 6 | 92 | 1 | 8 | 227 | 310 | 92 | Panagrolaimus sp. JU1645 large subunit ribosomal RNA gene, partial sequence | blastn | 19181 | 366 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Panagrolaimus | Panagrolaimus sp. JU1645 | |
| 15110725 | 15110725 | PRJNA414036_P_NODE_63732_length_202_cov_5.970060_g61993_i0 | PRJNA414036 | 63732 | 202 | 5.97006 | 12.0595212 | Panagrolaimus | 55784 | Nematoda | Nematoda | 171 | 4.65e-38 | NTclustered | gi|166014126|gb|EU253569.1| | 55785 | g61993 | i0 | 98.947 | 15.8316831683168 | 95 | 1 | 72 | 0 | 10 | 104 | 1538 | 1632 | Panagrolaimus sp. PS1159 28S large subunit ribosomal RNA gene, partial sequence | blastn | 3198 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Panagrolaimus | Panagrolaimus sp. PS1159 | |
| 18270262 | 18270262 | PRJNA414036_P_NODE_13695_length_394_cov_2.395543_g12046_i0 | PRJNA414036 | 13695 | 394 | 2.395543 | 9.43843942 | Panagrolaimus sp. ES6 | 591446 | Nematoda | Nematoda | 143 | 2.17e-29 | NTclustered | gi|221327465|gb|FJ590996.1| | 591446 | g12046 | i0 | 100 | 22.2918781725888 | 77 | 0 | 37 | 0 | 10 | 86 | 152 | 228 | Panagrolaimus sp. ES6 28S ribosomal RNA gene, partial sequence | blastn | 8783 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Panagrolaimus | Panagrolaimus sp. ES6 | |
| 18270375 | 18270375 | PRJNA414036_P_NODE_50415_length_231_cov_2.137755_g48676_i0 | PRJNA414036 | 50415 | 231 | 2.137755 | 4.93821405 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 63.9 | 9.54e-6 | NTclustered | gi|690021544|emb|LM529246.1| | 174720 | g48676 | i0 | 100 | 0.147186147186147 | 34 | 0 | 15 | 0 | 10 | 43 | 430 | 463 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0003553 | blastn | 34 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 18270468 | 18270468 | PRJNA414036_P_NODE_89475_length_150_cov_1.400000_g87736_i0 | PRJNA414036 | 89475 | 150 | 1.4 | 2.1 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 58.4 | 2.63e-4 | NTclustered | gi|687022708|emb|LM525622.1| | 174720 | g87736 | i0 | 97.059 | 2.50666666666667 | 34 | 1 | 23 | 0 | 87 | 120 | 76086 | 76119 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000031 | blastn | 376 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 20209113 | 20209113 | PRJNA414036_P_NODE_42696_length_231_cov_4.147959_g40957_i0 | PRJNA414036 | 42696 | 231 | 4.147959 | 9.58178529 | Panagrolaimus | 55784 | Nematoda | Nematoda | 132 | 2.58e-26 | NTclustered | gi|1393507003|gb|MH399794.1| | 2211197 | g40957 | i0 | 98.649 | 32.3203463203463 | 74 | 1 | 60 | 0 | 10 | 83 | 395 | 322 | Panagrolaimus sp. B3 ARA-2018 small subunit ribosomal RNA gene, partial sequence | blastn | 7466 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Panagrolaimus | Panagrolaimus sp. B3 ARA-2018 | |
| 22759881 | 22759881 | PRJNA414036_P_NODE_32098_length_264_cov_2.213974_g30362_i0 | PRJNA414036 | 32098 | 264 | 2.213974 | 5.84489136 | Opisthokonta | 33154 | Nematoda | Nematoda | 52.8 | 0.024 | NTclustered | gi|339249468|ref|XM_003373674.1| | 6334 | g30362 | i0 | 100 | 2.14772727272727 | 28 | 0 | 11 | 0 | 9 | 36 | 1320 | 1293 | Trichinella spiralis putative UBA/TS-N domain protein (Tsp_10709) mRNA, complete cds | blastn | 567 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis |
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);;