contig_metadata
6 rows where bioproject = "PRJNA781196", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10963429 | 10963429 | PRJNA781196_P_NODE_39169_length_285_cov_2.575472_g38792_i0 | PRJNA781196 | 39169 | 285 | 2.575472 | 7.3400952 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 4.0799999999999985e-55 | NTclustered | gi|2163362080|dbj|LC663516.1| | 37360 | g38792 | i0 | 81.495 | 97.2280701754386 | 281 | 48 | 98 | 4 | 7 | 285 | 479 | 201 | Plasmodiophora brassicae Yamguchi-Car act1 gene for actin 1, partial cds | blastn | 27710 | 228 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 10963758 | 10963758 | PRJNA781196_P_NODE_59269_length_247_cov_0.896552_g58892_i0 | PRJNA781196 | 59269 | 247 | 0.896552 | 2.21448344 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 2.08e-18 | NR | CEP00189.1 | 37360 | g58892 | i0 | 56 | 0.910931174089069 | 75 | 30 | 91.1 | 1 | 230 | 6 | 529 | 600 | CEP00189.1 hypothetical protein PBRA_007923 [Plasmodiophora brassicae] | diamond | 225 | 89 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 26768635 | 26768635 | PRJNA781196_P_NODE_54921_length_250_cov_0.881356_g54544_i0 | PRJNA781196 | 54921 | 250 | 0.881356 | 2.20339 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0223 | NR | CEO96208.1 | 37360 | g54544 | i0 | 55.6 | 0.432 | 36 | 16 | 43.2 | 0 | 124 | 17 | 27 | 62 | CEO96208.1 hypothetical protein PBRA_004879 [Plasmodiophora brassicae] | diamond | 108 | 43.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28443324 | 28443324 | PRJNA781196_P_NODE_58926_length_247_cov_0.896552_g58549_i0 | PRJNA781196 | 58926 | 247 | 0.896552 | 2.21448344 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 89.7 | 1.02e-18 | NR | CEO96292.1 | 37360 | g58549 | i0 | 51.9 | 5.7085020242915 | 77 | 36 | 93.5 | 1 | 14 | 244 | 379 | 454 | CEO96292.1 hypothetical protein PBRA_004963 [Plasmodiophora brassicae] | diamond | 1410 | 89.7 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29990363 | 29990363 | PRJNA781196_P_NODE_37351_length_291_cov_1.431193_g36974_i0 | PRJNA781196 | 37351 | 291 | 1.431193 | 4.16477163 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 1.09e-12 | NR | CEO98802.1 | 37360 | g36974 | i0 | 53.1 | 1.01030927835052 | 98 | 34 | 90.7 | 4 | 289 | 26 | 286 | 381 | CEO98802.1 hypothetical protein PBRA_006916 [Plasmodiophora brassicae] | diamond | 294 | 73.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31190580 | 31190580 | PRJNA781196_P_NODE_36715_length_293_cov_2.104545_g36338_i0 | PRJNA781196 | 36715 | 293 | 2.104545 | 6.16631685 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 1.46e-28 | NR | CEO99235.1 | 37360 | g36338 | i0 | 61.4 | 0.849829351535836 | 83 | 32 | 85 | 0 | 268 | 20 | 1 | 83 | CEO99235.1 hypothetical protein PBRA_001141 [Plasmodiophora brassicae] | diamond | 249 | 108 | 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);;