contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA596867" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12047162 | 12047162 | PRJNA596867_P_NODE_15110_length_241_cov_0.916667_g15035_i0 | PRJNA596867 | 15110 | 241 | 0.916667 | 2.20916747 | Meloidogyne | 189290 | Nematoda | Nematoda | 167 | 4.55e-49 | NR | KAF7634656.1 | 189291 | g15035 | i0 | 98.7 | 1.96680497925311 | 79 | 1 | 98.3 | 0 | 239 | 3 | 193 | 271 | KAF7634656.1 Flavoprotein domain-containing protein [Meloidogyne graminicola] | diamond | 474 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 16443137 | 16443137 | PRJNA596867_P_NODE_12613_length_248_cov_0.880000_g12538_i0 | PRJNA596867 | 12613 | 248 | 0.88 | 2.1824 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 166 | 1.17e-49 | NR | CAK5036759.1 | 390850 | g12538 | i0 | 97.6 | 0.991935483870968 | 82 | 2 | 99.2 | 0 | 3 | 248 | 138 | 219 | CAK5036759.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 246 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 26984806 | 26984806 | PRJNA596867_P_NODE_12962_length_247_cov_0.885057_g12887_i0 | PRJNA596867 | 12962 | 247 | 0.885057 | 2.18609079 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 159 | 4.279999999999999e-46 | NR | CAK5077684.1 | 390850 | g12887 | i0 | 91.5 | 2.98785425101215 | 82 | 7 | 99.6 | 0 | 247 | 2 | 180 | 261 | CAK5077684.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 738 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 27522086 | 27522086 | PRJNA596867_P_NODE_12943_length_247_cov_0.885057_g12868_i0 | PRJNA596867 | 12943 | 247 | 0.885057 | 2.18609079 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 166 | 3.2599999999999996e-48 | NR | KAF7623409.1 | 189291 | g12868 | i0 | 93.9 | 1.9919028340081 | 82 | 5 | 99.6 | 0 | 247 | 2 | 259 | 340 | KAF7623409.1 hypothetical protein Mgra_00010268 [Meloidogyne graminicola] | diamond | 492 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 28911121 | 28911121 | PRJNA596867_P_NODE_13228_length_246_cov_0.890173_g13153_i0 | PRJNA596867 | 13228 | 246 | 0.890173 | 2.18982558 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 130 | 2.35e-33 | NR | CAK5082748.1 | 390850 | g13153 | i0 | 85.1 | 0.902439024390244 | 74 | 10 | 89 | 1 | 219 | 1 | 5 | 78 | CAK5082748.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 222 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 29985066 | 29985066 | PRJNA596867_P_NODE_13171_length_246_cov_0.890173_g13096_i0 | PRJNA596867 | 13171 | 246 | 0.890173 | 2.18982558 | Teladorsagia circumcincta | 45464 | Nematoda | Nematoda | 43.1 | 0.0268 | NR | PIO58181.1 | 45464 | g13096 | i0 | 42.6 | 0.573170731707317 | 47 | 25 | 57.3 | 1 | 180 | 40 | 60 | 104 | PIO58181.1 hypothetical protein TELCIR_20389, partial [Teladorsagia circumcincta] | diamond | 141 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Teladorsagia | Teladorsagia circumcincta | |
| 31691675 | 31691675 | PRJNA596867_P_NODE_11837_length_250_cov_0.870056_g11762_i0 | PRJNA596867 | 11837 | 250 | 0.870056 | 2.17514 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 164 | 1.26e-48 | NR | CAK5090020.1 | 390850 | g11762 | i0 | 95.2 | 1.992 | 83 | 4 | 99.6 | 0 | 2 | 250 | 113 | 195 | CAK5090020.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 498 | 164 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 32324785 | 32324785 | PRJNA596867_P_NODE_13139_length_246_cov_0.890173_g13064_i0 | PRJNA596867 | 13139 | 246 | 0.890173 | 2.18982558 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 153 | 5.89e-41 | NR | CAD2167522.1 | 390850 | g13064 | i0 | 90.1 | 2.96341463414634 | 81 | 8 | 98.8 | 0 | 245 | 3 | 1436 | 1516 | CAD2167522.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 729 | 153 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 32514603 | 32514603 | PRJNA596867_P_NODE_12879_length_247_cov_0.885057_g12804_i0 | PRJNA596867 | 12879 | 247 | 0.885057 | 2.18609079 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 118 | 7.01e-29 | NR | CAK5072204.1 | 390850 | g12804 | i0 | 80.2 | 1.96761133603239 | 81 | 16 | 98.4 | 0 | 245 | 3 | 551 | 631 | CAK5072204.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 486 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 32640250 | 32640250 | PRJNA596867_P_NODE_13160_length_246_cov_0.890173_g13085_i0 | PRJNA596867 | 13160 | 246 | 0.890173 | 2.18982558 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 115 | 5.18e-28 | NR | CAD2202830.1 | 390850 | g13085 | i0 | 78.2 | 0.951219512195122 | 78 | 16 | 93.9 | 1 | 231 | 1 | 1 | 78 | CAD2202830.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 234 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 32703370 | 32703370 | PRJNA596867_P_NODE_15160_length_241_cov_0.916667_g15085_i0 | PRJNA596867 | 15160 | 241 | 0.916667 | 2.20916747 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 149 | 1.4799999999999998e-42 | NR | CAD2179484.1 | 390850 | g15085 | i0 | 96.2 | 0.983402489626556 | 79 | 3 | 98.3 | 0 | 239 | 3 | 13 | 91 | CAD2179484.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 237 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii |
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);;