contig_metadata
14 rows where bioproject = "PRJEB10320", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1287815 | 1287815 | PRJEB10320_P_NODE_25022_length_164_cov_1.232558_g24764_i0 | PRJEB10320 | 25022 | 164 | 1.232558 | 2.02139512 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 1.28e-47 | NTclustered | gi|157887508|emb|AM411665.1| | 37360 | g24764 | i0 | 89.375 | 92.2682926829268 | 160 | 17 | 98 | 0 | 1 | 160 | 1737 | 1578 | Plasmodiophora brassicae beta tub gene for beta tubulin, clone PbBTUB | blastn | 15132 | 202 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 2563395 | 2563395 | PRJEB10320_P_NODE_16683_length_219_cov_1.304348_g16425_i0 | PRJEB10320 | 16683 | 219 | 1.304348 | 2.85652212 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.15e-24 | NR | CEP00157.1 | 37360 | g16425 | i0 | 67.1 | 1 | 73 | 24 | 100 | 0 | 219 | 1 | 24 | 96 | CEP00157.1 hypothetical protein PBRA_007891 [Plasmodiophora brassicae] | diamond | 219 | 102 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 2563421 | 2563421 | PRJEB10320_P_NODE_23943_length_169_cov_1.194030_g23685_i0 | PRJEB10320 | 23943 | 169 | 1.19403 | 2.0179107 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 85.5 | 3.96e-19 | NR | CEO94913.1 | 37360 | g23685 | i0 | 69.6 | 11.9289940828402 | 56 | 17 | 99.4 | 0 | 1 | 168 | 112 | 167 | CEO94913.1 hypothetical protein PBRA_003726 [Plasmodiophora brassicae] | diamond | 2016 | 85.9 | 0.9953434225844 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 19139081 | 19139081 | PRJEB10320_P_NODE_6216_length_418_cov_1.806789_g5964_i0 | PRJEB10320 | 6216 | 418 | 1.806789 | 7.55237802 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 3.25e-44 | NR | CEO98592.1 | 37360 | g5964 | i0 | 63.7 | 1.50717703349282 | 113 | 41 | 81.1 | 0 | 416 | 78 | 101 | 213 | CEO98592.1 hypothetical protein PBRA_006706 [Plasmodiophora brassicae] | diamond | 630 | 154 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27854000 | 27854000 | PRJEB10320_P_NODE_20005_length_193_cov_1.012658_g19747_i0 | PRJEB10320 | 20005 | 193 | 1.012658 | 1.95442994 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 4.89e-8 | NR | CEO97729.1 | 37360 | g19747 | i0 | 41 | 1.86528497409326 | 61 | 35 | 94.8 | 1 | 184 | 2 | 43 | 102 | CEO97729.1 hypothetical protein PBRA_005843 [Plasmodiophora brassicae] | diamond | 360 | 56.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28832760 | 28832760 | PRJEB10320_P_NODE_15388_length_231_cov_1.831633_g15130_i0 | PRJEB10320 | 15388 | 231 | 1.831633 | 4.23107223 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 7.47e-15 | NR | CEP03425.1 | 37360 | g15130 | i0 | 54.7 | 1.85714285714286 | 75 | 33 | 97.4 | 1 | 2 | 226 | 145 | 218 | CEP03425.1 hypothetical protein PBRA_003185 [Plasmodiophora brassicae] | diamond | 429 | 78.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28895845 | 28895845 | PRJEB10320_P_NODE_928_length_1047_cov_3.978261_g806_i0 | PRJEB10320 | 928 | 1047 | 3.978261 | 41.65239267 | Bonamia ostreae | 126728 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 1.61e-11 | NR | MES1919628.1 | 126728 | g806 | i0 | 32.2 | 0.851002865329513 | 149 | 82 | 37.8 | 3 | 564 | 959 | 132 | 278 | MES1919628.1 hypothetical protein [Bonamia ostreae] | diamond | 891 | 75.9 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Haplosporida | Bonamia | Bonamia ostreae | |||
| 29527538 | 29527538 | PRJEB10320_P_NODE_8550_length_343_cov_1.457792_g8292_i0 | PRJEB10320 | 8550 | 343 | 1.457792 | 5.00022656 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 2.7e-5 | NR | SPQ99088.1 | 37360 | g8292 | i0 | 37.9 | 1.89795918367347 | 58 | 36 | 50.7 | 0 | 342 | 169 | 151 | 208 | SPQ99088.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 651 | 53.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29558921 | 29558921 | PRJEB10320_P_NODE_22770_length_175_cov_1.735714_g22512_i0 | PRJEB10320 | 22770 | 175 | 1.735714 | 3.0374995 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 2.48e-11 | NR | CEO95994.1 | 37360 | g22512 | i0 | 55.2 | 1.98857142857143 | 58 | 26 | 99.4 | 0 | 1 | 174 | 151 | 208 | CEO95994.1 hypothetical protein PBRA_004684 [Plasmodiophora brassicae] | diamond | 348 | 67 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30917562 | 30917562 | PRJEB10320_P_NODE_14234_length_244_cov_3.028708_g13976_i0 | PRJEB10320 | 14234 | 244 | 3.028708 | 7.39004752 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 2.41e-11 | NR | CEO98595.1 | 37360 | g13976 | i0 | 63.5 | 0.639344262295082 | 52 | 19 | 63.9 | 0 | 218 | 63 | 1 | 52 | CEO98595.1 hypothetical protein PBRA_006708 [Plasmodiophora brassicae] | diamond | 156 | 63.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32119247 | 32119247 | PRJEB10320_P_NODE_15438_length_231_cov_1.142857_g15180_i0 | PRJEB10320 | 15438 | 231 | 1.142857 | 2.63999967 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 3.95e-5 | NR | CEP03257.1 | 37360 | g15180 | i0 | 38.6 | 0.909090909090909 | 70 | 27 | 89.6 | 3 | 208 | 2 | 209 | 263 | CEP03257.1 hypothetical protein PBRA_003017 [Plasmodiophora brassicae] | diamond | 210 | 50.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32150831 | 32150831 | PRJEB10320_P_NODE_7718_length_366_cov_1.679758_g7462_i0 | PRJEB10320 | 7718 | 366 | 1.679758 | 6.14791428 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 1.89e-32 | NR | CEP03742.1 | 37360 | g7462 | i0 | 51.2 | 2.01639344262295 | 123 | 59 | 100 | 1 | 1 | 366 | 76 | 198 | CEP03742.1 hypothetical protein PBRA_003349 [Plasmodiophora brassicae] | diamond | 738 | 125 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32751070 | 32751070 | PRJEB10320_P_NODE_18080_length_207_cov_0.924419_g17822_i0 | PRJEB10320 | 18080 | 207 | 0.924419 | 1.91354733 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 3.58e-4 | NR | CEO96223.1 | 37360 | g17822 | i0 | 47.2 | 0.521739130434783 | 36 | 19 | 52.2 | 0 | 207 | 100 | 80 | 115 | CEO96223.1 hypothetical protein PBRA_004894 [Plasmodiophora brassicae] | diamond | 108 | 46.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32876922 | 32876922 | PRJEB10320_P_NODE_20140_length_192_cov_1.242038_g19882_i0 | PRJEB10320 | 20140 | 192 | 1.242038 | 2.38471296 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 1.56e-17 | NR | CEO99081.1 | 37360 | g19882 | i0 | 60.4 | 0.828125 | 53 | 21 | 82.8 | 0 | 5 | 163 | 91 | 143 | CEO99081.1 hypothetical protein PBRA_007195 [Plasmodiophora brassicae] | diamond | 159 | 80.9 | 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);;