contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA432257" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2980385 | 2980385 | PRJNA432257_S_NODE_45463_length_239_cov_21.767327_g45082_i0 | PRJNA432257 | 45463 | 239 | 21.767327 | 52.02391153 | Turbatrix aceti | 114909 | Nematoda | Nematoda | 128 | 3.47e-25 | NTclustered | gi|76560686|gb|DQ145711.1| | 114909 | g45082 | i0 | 86.441 | 41.5062761506276 | 118 | 14 | 49 | 2 | 84 | 200 | 1234 | 1118 | Turbatrix aceti 28S ribosomal RNA gene, partial sequence | blastn | 9920 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Turbatrix | Turbatrix aceti | |
| 4916909 | 4916909 | PRJNA432257_S_NODE_59104_length_217_cov_3.116667_g58723_i0 | PRJNA432257 | 59104 | 217 | 3.116667 | 6.76316739 | Panagrolaimus | 55784 | Nematoda | Nematoda | 348 | 2.1800000000000002e-91 | NTclustered | gi|166014126|gb|EU253569.1| | 55785 | g58723 | i0 | 95.455 | 72.0921658986175 | 220 | 7 | 100 | 2 | 1 | 217 | 2534 | 2753 | Panagrolaimus sp. PS1159 28S large subunit ribosomal RNA gene, partial sequence | blastn | 15644 | 348 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Panagrolaimus | Panagrolaimus sp. PS1159 | |
| 8083631 | 8083631 | PRJNA432257_S_NODE_93767_length_181_cov_3.201389_g93386_i0 | PRJNA432257 | 93767 | 181 | 3.201389 | 5.79451409 | Howardula sp. SP-B | 209946 | Nematoda | Nematoda | 239 | 1.0999999999999999e-58 | NTclustered | gi|28208703|gb|AF519223.1| | 209946 | g93386 | i0 | 91.011 | 88.2817679558011 | 178 | 15 | 98 | 1 | 1 | 178 | 1573 | 1749 | Howardula sp. SP-B isolate B331 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence | blastn | 15979 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Allantonematidae | Howardula | Howardula sp. SP-B | |
| 14458904 | 14458904 | PRJNA432257_S_NODE_71292_length_202_cov_2.236364_g70911_i0 | PRJNA432257 | 71292 | 202 | 2.236364 | 4.51745528 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 54.7 | 0.005 | NTclustered | gi|339236050|ref|XM_003379532.1| | 6334 | g70911 | i0 | 96.875 | 0.158415841584158 | 32 | 1 | 16 | 0 | 31 | 62 | 128 | 159 | Trichinella spiralis serine protease hepsin (Tsp_03237) mRNA, complete cds | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 16391321 | 16391321 | PRJNA432257_S_NODE_57353_length_219_cov_89.170330_g56972_i0 | PRJNA432257 | 57353 | 219 | 89.17033 | 195.2830227 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 4.16e-4 | NTclustered | gi|1335348092|emb|LT965051.1| | 45931 | g56972 | i0 | 97.059 | 13.8082191780822 | 34 | 1 | 16 | 0 | 36 | 69 | 1033 | 1066 | Pratylenchus vulnus partial 28S rRNA gene, clone 1_1 | blastn | 3024 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 20831091 | 20831091 | PRJNA432257_S_NODE_25797_length_294_cov_276.599222_g25416_i0 | PRJNA432257 | 25797 | 294 | 276.599222 | 813.20171268 | Koerneria sp. RS1982 | 358044 | Nematoda | Nematoda | 189 | 1.9899999999999992e-43 | NTclustered | gi|150984687|gb|EF635005.1| | 358044 | g25416 | i0 | 85.405 | 20.6394557823129 | 185 | 24 | 62 | 1 | 26 | 207 | 194 | 10 | Koerneria sp. RS1982 small subunit ribosomal protein 28 (rps-28) mRNA, complete cds | blastn | 6068 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Koerneria | Koerneria sp. RS1982 |
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);;