contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA641991" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 617757 | 617757 | PRJNA641991_S_NODE_13821_length_163_cov_0.894737_g13702_i0 | PRJNA641991 | 13821 | 163 | 0.894737 | 1.45842131 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 8.12e-5 | NTclustered | gi|2795027405|ref|XM_067926264.1| | 4785 | g13702 | i0 | 100 | 3.85889570552147 | 32 | 0 | 20 | 0 | 8 | 39 | 1478 | 1447 | Phytophthora cinnamomi putative SWI/SNF-related matrix-associated actin-dependent regulator of chromatin (IUM83_02354), partial mRNA | blastn | 629 | 60.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 2433541 | 2433541 | PRJNA641991_S_NODE_11482_length_170_cov_0.842975_g11363_i0 | PRJNA641991 | 11482 | 170 | 0.842975 | 1.4330575 | Naviculaceae | 67474 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 7.64e-80 | NTclustered | gi|2301268953|ref|NC_066075.1| | 355634 | g11363 | i0 | 99.412 | 197.994117647059 | 170 | 1 | 100 | 0 | 1 | 170 | 8725 | 8556 | Navicula arenaria isolate Jiaozhou Bay in China chloroplast, complete genome | blastn | 33659 | 309 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Navicula | Navicula arenaria | ||
| 6262081 | 6262081 | PRJNA641991_S_NODE_1225_length_475_cov_9.889671_g1106_i0 | PRJNA641991 | 1225 | 475 | 9.889671 | 46.97593725 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 1.5399999999999998e-56 | NTclustered | gi|166301|gb|J05597.1|ACKBTUB | 4767 | g1106 | i0 | 87.081 | 41.9642105263158 | 209 | 23 | 44 | 4 | 1 | 207 | 1331 | 1537 | A.klebsiana beta-tubulin gene, complete cds | blastn | 19933 | 235 | 0.991489361702128 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 6996316 | 6996316 | PRJNA641991_S_NODE_10866_length_173_cov_4.330645_g10747_i0 | PRJNA641991 | 10866 | 173 | 4.330645 | 7.49201585 | Lagenidium sp. SL10 | 1702235 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 1.79e-36 | NTclustered | gi|918464445|gb|KT257536.1| | 1702235 | g10747 | i0 | 84.431 | 27.1156069364162 | 167 | 26 | 97 | 0 | 7 | 173 | 315 | 149 | Lagenidium sp. SL10 isolate LEV5850 beta-tubulin gene, partial cds | blastn | 4691 | 165 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium sp. SL10 | ||
| 6996331 | 6996331 | PRJNA641991_S_NODE_14846_length_161_cov_0.910714_g14727_i0 | PRJNA641991 | 14846 | 161 | 0.910714 | 1.46624954 | Aureococcus anophagefferens | 44056 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 2.18e-20 | NTclustered | gi|676382586|ref|XM_009036324.1| | 44056 | g14727 | i0 | 80.272 | 0.91304347826087 | 147 | 29 | 91 | 0 | 2 | 148 | 291 | 145 | Aureococcus anophagefferens hypothetical protein partial mRNA | blastn | 147 | 111 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Aureococcus | Aureococcus anophagefferens | |||
| 7536291 | 7536291 | PRJNA641991_P_NODE_1846_length_226_cov_2.129944_g1805_i0 | PRJNA641991 | 1846 | 226 | 2.129944 | 4.81367344 | Rhopalodiales | 245176 | SAR_Eukaryotes | SAR_Eukaryotes | 396 | 8.069999999999997e-106 | NTclustered | gi|2325195844|gb|OM494341.1| | 186043 | g1805 | i0 | 98.661 | 197.738938053097 | 224 | 2 | 99 | 1 | 3 | 226 | 89290 | 89068 | Entomoneis sp. isolate C2 plastid, complete genome | blastn | 44689 | 396 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Entomoneidaceae | Entomoneis | Entomoneis sp. | |||
| 10086921 | 10086921 | PRJNA641991_S_NODE_3588_length_279_cov_1.504348_g3469_i0 | PRJNA641991 | 3588 | 279 | 1.504348 | 4.19713092 | Isotrichidae | 5985 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.43e-54 | NTclustered | gi|92790147|emb|AJ965259.1| | 40806 | g3469 | i0 | 87.958 | 99.8028673835125 | 191 | 23 | 69 | 0 | 89 | 279 | 1085 | 895 | Dasytricha ruminantium partial mRNA for Polyubiqutin 3 (polyubiqutin 3 gene) | blastn | 27845 | 226 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Dasytricha | Dasytricha ruminantium | ||
| 12097183 | 12097183 | PRJNA641991_S_NODE_2590_length_327_cov_1.284173_g2471_i0 | PRJNA641991 | 2590 | 327 | 1.284173 | 4.19924571 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 1.08e-16 | NTclustered | gi|1027949921|ref|XR_001678647.1| | 31271 | g2471 | i0 | 76.531 | 1.54128440366972 | 196 | 38 | 59 | 6 | 1 | 193 | 1275 | 1465 | Plasmodium chabaudi chabaudi 28S ribosomal RNA (PCHAS_0521461), rRNA | blastn | 504 | 100 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 13371794 | 13371794 | PRJNA641991_P_NODE_751_length_399_cov_1.391429_g710_i0 | PRJNA641991 | 751 | 399 | 1.391429 | 5.55180171 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 6.09e-35 | NTclustered | gi|673024575|ref|XM_008868027.1| | 157072 | g710 | i0 | 89.764 | 33.7142857142857 | 127 | 12 | 32 | 1 | 4 | 129 | 2262 | 2388 | Aphanomyces invadans tubulin beta chain mRNA | blastn | 13452 | 161 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 14646668 | 14646668 | PRJNA641991_P_NODE_3132_length_170_cov_0.867769_g3091_i0 | PRJNA641991 | 3132 | 170 | 0.867769 | 1.4752073 | Schizochytrium sp. ATCC 20888 | 368446 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 3.7599999999999997e-38 | NTclustered | gi|85822988|gb|DQ356660.1| | 368446 | g3091 | i0 | 85.714 | 73.1176470588235 | 161 | 23 | 95 | 0 | 1 | 161 | 628 | 788 | Schizochytrium sp. ATCC 20888 actin gene, partial cds | blastn | 12430 | 171 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Schizochytrium | Schizochytrium sp. ATCC 20888 | |||
| 15186865 | 15186865 | PRJNA641991_S_NODE_15152_length_156_cov_2.214953_g15033_i0 | PRJNA641991 | 15152 | 156 | 2.214953 | 3.45532668 | Poteriospumella | 1117026 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 9e-74 | NTclustered | gi|685431582|gb|KF697341.1| | 1117027 | g15033 | i0 | 100 | 80.5961538461538 | 156 | 0 | 100 | 0 | 1 | 156 | 111 | 266 | Poteriospumella lacustris strain JBC07 28S ribosomal RNA gene, partial sequence | blastn | 12573 | 289 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella lacustris | |||
| 15920664 | 15920664 | PRJNA641991_S_NODE_9213_length_186_cov_1.299270_g9094_i0 | PRJNA641991 | 9213 | 186 | 1.29927 | 2.4166422 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 4.12e-53 | NTclustered | gi|675203540|ref|XM_008912407.1| | 761204 | g9094 | i0 | 88.462 | 78.747311827957 | 182 | 21 | 98 | 0 | 4 | 185 | 397 | 216 | Phytophthora parasitica INRA-310 actin-1 mRNA | blastn | 14647 | 220 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 16461197 | 16461197 | PRJNA641991_S_NODE_14553_length_161_cov_1.366071_g14434_i0 | PRJNA641991 | 14553 | 161 | 1.366071 | 2.19937431 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 1.69e-16 | NTclustered | gi|2248513400|ref|NC_063804.1| | 4784 | g14434 | i0 | 83.654 | 6.4472049689441 | 104 | 17 | 65 | 0 | 3 | 106 | 17471 | 17368 | Phytophthora capsici isolate TaiwanPc33e mitochondrion, complete genome | blastn | 1038 | 99 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 17736315 | 17736315 | PRJNA641991_S_NODE_4634_length_248_cov_4.592965_g4515_i0 | PRJNA641991 | 4634 | 248 | 4.592965 | 11.3905532 | Entomoneis | 186042 | SAR_Eukaryotes | SAR_Eukaryotes | 431 | 2.47e-116 | NTclustered | gi|2325195844|gb|OM494341.1| | 186043 | g4515 | i0 | 97.992 | 192.79435483871 | 249 | 3 | 100 | 2 | 1 | 248 | 89064 | 89311 | Entomoneis sp. isolate C2 plastid, complete genome | blastn | 47813 | 431 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Entomoneidaceae | Entomoneis | Entomoneis sp. | |||
| 21560366 | 21560366 | PRJNA641991_S_NODE_1117_length_502_cov_18.938190_g998_i0 | PRJNA641991 | 1117 | 502 | 18.93819 | 95.0697138 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 1.63e-56 | NTclustered | gi|166301|gb|J05597.1|ACKBTUB | 4767 | g998 | i0 | 87.081 | 39.6334661354582 | 209 | 23 | 41 | 4 | 296 | 502 | 1537 | 1331 | A.klebsiana beta-tubulin gene, complete cds | blastn | 19896 | 235 | 0.991489361702128 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 23570496 | 23570496 | PRJNA641991_S_NODE_2779_length_316_cov_1.501873_g2660_i0 | PRJNA641991 | 2779 | 316 | 1.501873 | 4.74591868 | Phytophthora boehmeriae | 109152 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 9.64e-72 | NTclustered | gi|1133565931|gb|KU518486.1| | 109152 | g2660 | i0 | 83.226 | 95.7088607594937 | 310 | 50 | 98 | 2 | 8 | 316 | 330 | 22 | Phytophthora boehmeriae strain OCPC27 translation elongation factor 1-alpha gene, partial cds | blastn | 30244 | 283 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora boehmeriae |
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);;