contig_metadata
13 rows where bioproject = "PRJNA1146029", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1564850 | 1564850 | PRJNA1146029_P_NODE_5462_length_373_cov_2.310000_g5184_i0 | PRJNA1146029 | 5462 | 373 | 2.31 | 8.6163 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 1.54e-64 | NR | CEO97530.1 | 37360 | g5184 | i0 | 80.3 | 1.96246648793566 | 122 | 24 | 98.1 | 0 | 2 | 367 | 30 | 151 | CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] | diamond | 732 | 202 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 5393423 | 5393423 | PRJNA1146029_P_NODE_4205_length_418_cov_2.153623_g3927_i0 | PRJNA1146029 | 4205 | 418 | 2.153623 | 9.00214414 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 1.7899999999999998e-56 | NR | CEP02640.1 | 37360 | g3927 | i0 | 72.9 | 0.925837320574163 | 129 | 35 | 92.6 | 0 | 30 | 416 | 13 | 141 | CEP02640.1 hypothetical protein PBRA_002607 [Plasmodiophora brassicae] | diamond | 387 | 183 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 6667993 | 6667993 | PRJNA1146029_P_NODE_1866_length_638_cov_1.753982_g1596_i0 | PRJNA1146029 | 1866 | 638 | 1.753982 | 11.19040516 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 3.26e-36 | NR | CEP01632.1 | 37360 | g1596 | i0 | 64.3 | 0.540752351097179 | 115 | 41 | 54.1 | 0 | 45 | 389 | 18 | 132 | CEP01632.1 hypothetical protein PBRA_008575 [Plasmodiophora brassicae] | diamond | 345 | 134 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 7943278 | 7943278 | PRJNA1146029_P_NODE_3107_length_484_cov_2.243309_g2830_i0 | PRJNA1146029 | 3107 | 484 | 2.243309 | 10.85761556 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 216 | 2.46e-67 | NR | CEO96095.1 | 37360 | g2830 | i0 | 65.1 | 0.942148760330578 | 152 | 53 | 94.2 | 0 | 28 | 483 | 1 | 152 | CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] | diamond | 456 | 216 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 21967037 | 21967037 | PRJNA1146029_P_NODE_4278_length_415_cov_1.576023_g4000_i0 | PRJNA1146029 | 4278 | 415 | 1.576023 | 6.54049545 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 164 | 3.24e-49 | NR | SPQ93437.1 | 37360 | g4000 | i0 | 68.4 | 2.47228915662651 | 117 | 35 | 84.6 | 1 | 415 | 65 | 33 | 147 | SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 1026 | 164 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27038922 | 27038922 | PRJNA1146029_P_NODE_2382_length_557_cov_1.590909_g2107_i0 | PRJNA1146029 | 2382 | 557 | 1.590909 | 8.86136313 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 4.79e-28 | NR | CEP02593.1 | 37360 | g2107 | i0 | 62 | 0.495511669658887 | 92 | 35 | 49.6 | 0 | 8 | 283 | 11 | 102 | CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] | diamond | 276 | 111 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27196819 | 27196819 | PRJNA1146029_P_NODE_13442_length_269_cov_1.051020_g13161_i0 | PRJNA1146029 | 13442 | 269 | 1.05102 | 2.8272438 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 92.8 | 9.69e-21 | NR | CEO99991.1 | 37360 | g13161 | i0 | 64.9 | 0.825278810408922 | 74 | 22 | 80.3 | 2 | 269 | 54 | 143 | 214 | CEO99991.1 hypothetical protein PBRA_007725 [Plasmodiophora brassicae] | diamond | 222 | 92.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28428692 | 28428692 | PRJNA1146029_P_NODE_1426_length_744_cov_2.114754_g1178_i0 | PRJNA1146029 | 1426 | 744 | 2.114754 | 15.73376976 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 349 | 9.46e-118 | NR | CEP01219.1 | 37360 | g1178 | i0 | 81.4 | 4.00403225806452 | 253 | 41 | 99.6 | 1 | 742 | 2 | 51 | 303 | CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] | diamond | 2979 | 349 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28933869 | 28933869 | PRJNA1146029_P_NODE_19688_length_245_cov_0.895349_g19407_i0 | PRJNA1146029 | 19688 | 245 | 0.895349 | 2.19360505 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 1.96e-14 | NR | CEP02444.1 | 37360 | g19407 | i0 | 58.1 | 0.759183673469388 | 62 | 26 | 75.9 | 0 | 245 | 60 | 206 | 267 | CEP02444.1 hypothetical protein PBRA_009028 [Plasmodiophora brassicae] | diamond | 186 | 76.3 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29028807 | 29028807 | PRJNA1146029_P_NODE_5688_length_367_cov_1.309524_g5410_i0 | PRJNA1146029 | 5688 | 367 | 1.309524 | 4.80595308 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 1.59e-12 | NR | CEO99081.1 | 37360 | g5410 | i0 | 65.1 | 0.35149863760218 | 43 | 15 | 35.1 | 0 | 2 | 130 | 100 | 142 | CEO99081.1 hypothetical protein PBRA_007195 [Plasmodiophora brassicae] | diamond | 129 | 70.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30386950 | 30386950 | PRJNA1146029_P_NODE_21373_length_242_cov_0.911243_g21092_i0 | PRJNA1146029 | 21373 | 242 | 0.911243 | 2.20520806 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 84.3 | 8.11e-17 | NR | CEO98822.1 | 37360 | g21092 | i0 | 46.8 | 1.95867768595041 | 79 | 41 | 96.7 | 1 | 242 | 9 | 157 | 235 | CEO98822.1 hypothetical protein PBRA_006936, partial [Plasmodiophora brassicae] | diamond | 474 | 84.3 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30702472 | 30702472 | PRJNA1146029_P_NODE_6914_length_338_cov_1.743396_g6636_i0 | PRJNA1146029 | 6914 | 338 | 1.743396 | 5.89267848 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 168 | 6.99e-50 | NR | CEP01968.1 | 37360 | g6636 | i0 | 73.9 | 1.97041420118343 | 111 | 29 | 98.5 | 0 | 6 | 338 | 61 | 171 | CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] | diamond | 666 | 168 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31207561 | 31207561 | PRJNA1146029_P_NODE_1855_length_639_cov_1.840989_g1585_i0 | PRJNA1146029 | 1855 | 639 | 1.840989 | 11.76391971 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 1.42e-34 | NR | CEO95180.1 | 37360 | g1585 | i0 | 40.7 | 1.99530516431925 | 214 | 100 | 95.3 | 9 | 611 | 3 | 149 | 346 | CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae] | diamond | 1275 | 140 | 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);;