contig_metadata
8 rows where bioproject = "PRJNA951810", tax_clade = "Sar" and tax_phylum = "Endomyxa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11139725 | 11139725 | PRJNA951810_P_NODE_145109_length_262_cov_1.497354_g144764_i0 | PRJNA951810 | 145109 | 262 | 1.497354 | 3.92306748 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.29e-37 | NR | CEP00212.1 | 37360 | g144764 | i0 | 74.1 | 1.94656488549618 | 85 | 22 | 97.3 | 0 | 262 | 8 | 10 | 94 | CEP00212.1 hypothetical protein PBRA_007946 [Plasmodiophora brassicae] | diamond | 510 | 143 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 21337778 | 21337778 | PRJNA951810_P_NODE_121677_length_279_cov_1.791262_g121332_i0 | PRJNA951810 | 121677 | 279 | 1.791262 | 4.99762098 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 1.5e-31 | NR | SPQ93189.1 | 37360 | g121332 | i0 | 65.2 | 7.91397849462366 | 92 | 31 | 98.9 | 1 | 2 | 277 | 21 | 111 | SPQ93189.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 2208 | 124 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27089005 | 27089005 | PRJNA951810_P_NODE_176082_length_236_cov_5.558282_g175737_i0 | PRJNA951810 | 176082 | 236 | 5.558282 | 13.11754552 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 8.95e-5 | NR | SPR02013.1 | 37360 | g175737 | i0 | 53.5 | 1.09322033898305 | 43 | 20 | 54.7 | 0 | 88 | 216 | 180 | 222 | SPR02013.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 258 | 50.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28415452 | 28415452 | PRJNA951810_P_NODE_176346_length_236_cov_3.576687_g176001_i0 | PRJNA951810 | 176346 | 236 | 3.576687 | 8.44098132 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 1.14e-6 | NR | CEP00087.1 | 37360 | g176001 | i0 | 42.1 | 0.966101694915254 | 76 | 41 | 94.1 | 2 | 5 | 226 | 555 | 629 | CEP00087.1 hypothetical protein PBRA_007821 [Plasmodiophora brassicae] | diamond | 228 | 55.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28762561 | 28762561 | PRJNA951810_P_NODE_26607_length_390_cov_2.558360_g26265_i0 | PRJNA951810 | 26607 | 390 | 2.55836 | 9.977604 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 8.24e-16 | NR | CEO95246.1 | 37360 | g26265 | i0 | 33.1 | 2.09230769230769 | 136 | 82 | 99.2 | 4 | 388 | 2 | 157 | 290 | CEO95246.1 hypothetical protein PBRA_004012 [Plasmodiophora brassicae] | diamond | 816 | 82.4 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30537700 | 30537700 | PRJNA951810_P_NODE_67613_length_309_cov_10.423729_g67270_i0 | PRJNA951810 | 67613 | 309 | 10.423729 | 32.20932261 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 1.97e-14 | NR | YP_010227892.1 | 41456 | g67270 | i0 | 51.5 | 3.67961165048544 | 97 | 42 | 89.3 | 1 | 33 | 308 | 68 | 164 | YP_010227892.1 NADH dehydrogenase subunit 4 [Polymyxa betae] | diamond | 1137 | 79 | 0.994936708860759 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Polymyxa | Polymyxa betae | ||
| 31416118 | 31416118 | PRJNA951810_P_NODE_184176_length_227_cov_3.058442_g183831_i0 | PRJNA951810 | 184176 | 227 | 3.058442 | 6.94266334 | Bonamia ostreae | 126728 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0022 | NR | MES1922135.1 | 126728 | g183831 | i0 | 51.1 | 0.621145374449339 | 47 | 18 | 62.1 | 1 | 1 | 141 | 26 | 67 | MES1922135.1 hypothetical protein [Bonamia ostreae] | diamond | 141 | 43.5 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Haplosporida | Bonamia | Bonamia ostreae | |||
| 32618034 | 32618034 | PRJNA951810_P_NODE_177760_length_234_cov_7.204969_g177415_i0 | PRJNA951810 | 177760 | 234 | 7.204969 | 16.85962746 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 3.49e-8 | NR | AVG22652.1 | 37360 | g177415 | i0 | 45 | 0.769230769230769 | 60 | 31 | 74.4 | 1 | 53 | 226 | 904 | 963 | AVG22652.1 MAPKKK5 [Plasmodiophora brassicae] | diamond | 180 | 59.7 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae |
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);;