contig_metadata
14 rows where bioproject = "PRJNA914897", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2170442 | 2170442 | PRJNA914897_P_NODE_7922_length_688_cov_261.478049_g7521_i0 | PRJNA914897 | 7922 | 688 | 261.478049 | 1798.96897712 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 3.03e-72 | NR | CEP02281.1 | 37360 | g7521 | i0 | 60.3 | 7.21220930232558 | 204 | 78 | 89 | 2 | 18 | 629 | 1 | 201 | CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] | diamond | 4962 | 228 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 9822882 | 9822882 | PRJNA914897_P_NODE_40068_length_245_cov_0.895349_g39644_i0 | PRJNA914897 | 40068 | 245 | 0.895349 | 2.19360505 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 8.27e-34 | NR | CEP01018.1 | 37360 | g39644 | i0 | 79 | 0.991836734693878 | 81 | 15 | 99.2 | 1 | 245 | 3 | 104 | 182 | CEP01018.1 hypothetical protein PBRA_008330 [Plasmodiophora brassicae] | diamond | 243 | 131 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 26771345 | 26771345 | PRJNA914897_P_NODE_29781_length_289_cov_1.898148_g29357_i0 | PRJNA914897 | 29781 | 289 | 1.898148 | 5.48564772 | Bonamia ostreae | 126728 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 1.55e-9 | NR | MES1919356.1 | 126728 | g29357 | i0 | 38.3 | 0.622837370242215 | 60 | 37 | 62.3 | 0 | 180 | 1 | 114 | 173 | MES1919356.1 hypothetical protein [Bonamia ostreae] | diamond | 180 | 62.4 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Haplosporida | Bonamia | Bonamia ostreae | |||
| 27498625 | 27498625 | PRJNA914897_P_NODE_19383_length_387_cov_0.980892_g18961_i0 | PRJNA914897 | 19383 | 387 | 0.980892 | 3.79605204 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.62e-42 | NR | SPQ99411.1 | 37360 | g18961 | i0 | 56.7 | 2.95348837209302 | 127 | 55 | 98.4 | 0 | 383 | 3 | 133 | 259 | SPQ99411.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 1143 | 156 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28484722 | 28484722 | PRJNA914897_P_NODE_41666_length_242_cov_3.639053_g41242_i0 | PRJNA914897 | 41666 | 242 | 3.639053 | 8.80650826 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 5.52e-13 | NR | CEO94341.1 | 37360 | g41242 | i0 | 56.5 | 3.18595041322314 | 62 | 27 | 76.9 | 0 | 187 | 2 | 17 | 78 | CEO94341.1 hypothetical protein PBRA_000126 [Plasmodiophora brassicae] | diamond | 771 | 73.2 | 0.994535519125683 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28540690 | 28540690 | PRJNA914897_P_NODE_11487_length_546_cov_4.139535_g11067_i0 | PRJNA914897 | 11487 | 546 | 4.139535 | 22.6018611 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 181 | 3.419999999999999e-54 | NR | CEP02281.1 | 37360 | g11067 | i0 | 57.6 | 10.8406593406593 | 177 | 72 | 97.3 | 2 | 533 | 3 | 1 | 174 | CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] | diamond | 5919 | 181 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28548077 | 28548077 | PRJNA914897_P_NODE_8987_length_637_cov_9.657801_g8574_i0 | PRJNA914897 | 8987 | 637 | 9.657801 | 61.52019237 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 2.8299999999999997e-61 | NR | CEP02281.1 | 37360 | g8574 | i0 | 53.8 | 2.95290423861852 | 208 | 89 | 98 | 2 | 10 | 633 | 1 | 201 | CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] | diamond | 1881 | 200 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28705830 | 28705830 | PRJNA914897_P_NODE_24467_length_332_cov_0.891892_g24043_i0 | PRJNA914897 | 24467 | 332 | 0.891892 | 2.96108144 | Endomyxa | 2604748 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 3.7e-36 | NR | CEO97280.1 | 37360 | g24043 | i0 | 61.1 | 3.9578313253012 | 108 | 42 | 97.6 | 0 | 331 | 8 | 135 | 242 | CEO97280.1 hypothetical protein PBRA_000625 [Plasmodiophora brassicae] | diamond | 1314 | 135 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29242495 | 29242495 | PRJNA914897_P_NODE_30689_length_284_cov_2.729858_g30265_i0 | PRJNA914897 | 30689 | 284 | 2.729858 | 7.75279672 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 3.6e-5 | NR | CEP00555.1 | 37360 | g30265 | i0 | 42.4 | 1.24647887323944 | 59 | 29 | 62.3 | 1 | 101 | 277 | 4 | 57 | CEP00555.1 hypothetical protein PBRA_001609 [Plasmodiophora brassicae] | diamond | 354 | 49.3 | 0.991886409736308 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30379855 | 30379855 | PRJNA914897_P_NODE_4932_length_902_cov_1.826297_g4596_i0 | PRJNA914897 | 4932 | 902 | 1.826297 | 16.47319894 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 408 | 4.55e-138 | NR | CEP02272.1 | 37360 | g4596 | i0 | 66.6 | 12.9412416851441 | 299 | 100 | 99.4 | 0 | 897 | 1 | 140 | 438 | CEP02272.1 hypothetical protein PBRA_002537 [Plasmodiophora brassicae] | diamond | 11673 | 408 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30687900 | 30687900 | PRJNA914897_P_NODE_15013_length_459_cov_1.733161_g14591_i0 | PRJNA914897 | 15013 | 459 | 1.733161 | 7.95520899 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 2.12e-32 | NR | CEO95391.1 | 37360 | g14591 | i0 | 48.4 | 0.797385620915033 | 122 | 62 | 79.1 | 1 | 447 | 85 | 21 | 142 | CEO95391.1 hypothetical protein PBRA_009658 [Plasmodiophora brassicae] | diamond | 366 | 124 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31612172 | 31612172 | PRJNA914897_P_NODE_8136_length_677_cov_2.867550_g7733_i0 | PRJNA914897 | 8136 | 677 | 2.86755 | 19.4133135 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 232 | 9.4e-74 | NR | CEP00705.1 | 37360 | g7733 | i0 | 58.5 | 13.7725258493353 | 183 | 75 | 81.1 | 1 | 35 | 583 | 5 | 186 | CEP00705.1 hypothetical protein PBRA_001759 [Plasmodiophora brassicae] | diamond | 9324 | 233 | 0.995708154506438 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32522524 | 32522524 | PRJNA914897_P_NODE_11119_length_558_cov_1.354639_g10699_i0 | PRJNA914897 | 11119 | 558 | 1.354639 | 7.55888562 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 7.94e-16 | NR | CEP01654.1 | 37360 | g10699 | i0 | 38.7 | 1.47311827956989 | 137 | 84 | 73.7 | 0 | 411 | 1 | 25 | 161 | CEP01654.1 hypothetical protein PBRA_008596 [Plasmodiophora brassicae] | diamond | 822 | 85.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32522566 | 32522566 | PRJNA914897_P_NODE_8859_length_643_cov_2.163158_g8447_i0 | PRJNA914897 | 8859 | 643 | 2.163158 | 13.90910594 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 1.02e-17 | NR | CEO98408.1 | 37360 | g8447 | i0 | 37 | 0.503888024883359 | 108 | 68 | 50.4 | 0 | 472 | 149 | 65 | 172 | CEO98408.1 hypothetical protein PBRA_006522 [Plasmodiophora brassicae] | diamond | 324 | 92.4 | 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);;