contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA839281" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2105170 | 2105170 | PRJNA839281_S_NODE_2722_length_811_cov_2.914698_g2488_i0 | PRJNA839281 | 2722 | 811 | 2.914698 | 23.63820078 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.023 | NTclustered | gi|916414171|ref|XM_013372863.1| | 5802 | g2488 | i0 | 96.875 | 0.0394574599260173 | 32 | 1 | 4 | 0 | 186 | 217 | 1992 | 2023 | Eimeria tenella uncharacterized protein (ETH_00030875), partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 2505979 | 2505979 | PRJNA839281_S_NODE_39242_length_153_cov_2.365385_g38973_i0 | PRJNA839281 | 39242 | 153 | 2.365385 | 3.61903905 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 1.6e-11 | NTclustered | gi|239579434|gb|FJ438471.1| | 4792 | g38973 | i0 | 81.633 | 4.6078431372549 | 98 | 18 | 64 | 0 | 54 | 151 | 466 | 563 | Phytophthora nicotianae cyclophilin B (CyPB) gene, complete cds | blastn | 705 | 82.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 9757474 | 9757474 | PRJNA839281_S_NODE_10308_length_247_cov_1.358586_g10039_i0 | PRJNA839281 | 10308 | 247 | 1.358586 | 3.35570742 | Aureococcus anophagefferens | 44056 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 3.51e-45 | NTclustered | gi|676390134|ref|XM_009040098.1| | 44056 | g10039 | i0 | 81.328 | 72.825910931174107 | 241 | 43 | 97 | 2 | 8 | 247 | 705 | 944 | Aureococcus anophagefferens hypothetical protein mRNA | blastn | 17988 | 195 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Aureococcus | Aureococcus anophagefferens | |||
| 9757930 | 9757930 | PRJNA839281_S_NODE_8028_length_282_cov_1.751073_g7759_i0 | PRJNA839281 | 8028 | 282 | 1.751073 | 4.93802586 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 8.469999999999999e-72 | NTclustered | gi|2795052452|ref|XM_067926699.1| | 4785 | g7759 | i0 | 92.424 | 68.354609929078 | 198 | 15 | 70 | 0 | 1 | 198 | 322 | 519 | Phytophthora cinnamomi caltractin (IUM83_02754), partial mRNA | blastn | 19276 | 283 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 11033236 | 11033236 | PRJNA839281_S_NODE_10349_length_246_cov_3.502538_g10080_i0 | PRJNA839281 | 10349 | 246 | 3.502538 | 8.61624348 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 3.54e-35 | NTclustered | gi|2794916528|ref|XM_067893497.1| | 164328 | g10080 | i0 | 79.821 | 63.6056910569106 | 223 | 43 | 90 | 2 | 1 | 222 | 265 | 44 | Phytophthora ramorum 60S ribosomal protein L21-B (KRP23_8096), partial mRNA | blastn | 15647 | 161 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 11434097 | 11434097 | PRJNA839281_S_NODE_18889_length_190_cov_1.446809_g18620_i0 | PRJNA839281 | 18889 | 190 | 1.446809 | 2.7489371 | Tintinnida | 200604 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 3.34e-39 | NTclustered | gi|23957291|gb|AF399167.1| | 1513492 | g18620 | i0 | 83.158 | 97.8421052631579 | 190 | 32 | 100 | 0 | 1 | 190 | 509 | 320 | Schmidingerella sp. LAK-2008 clone Fehr99atub_3 alpha-tubulin gene, partial cds | blastn | 18590 | 174 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Tintinnida | Rhabdonellidae | Schmidingerella | Schmidingerella sp. LAK-2008 | ||
| 12308893 | 12308893 | PRJNA839281_S_NODE_27190_length_167_cov_0.864407_g26921_i0 | PRJNA839281 | 27190 | 167 | 0.864407 | 1.44355969 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 7.53e-80 | NTclustered | gi|166046671|emb|CU367781.1| | 100861 | g26921 | i0 | 100 | 99.0479041916168 | 167 | 0 | 100 | 0 | 1 | 167 | 720 | 554 | Aphanomyces euteiches cDNA | blastn | 16541 | 309 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 13984271 | 13984271 | PRJNA839281_S_NODE_9391_length_259_cov_1.638095_g9122_i0 | PRJNA839281 | 9391 | 259 | 1.638095 | 4.24266605 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 3.03e-6 | NTclustered | gi|813118109|ref|XM_012340462.1| | 695850 | g9122 | i0 | 89.091 | 0.416988416988417 | 55 | 2 | 20 | 3 | 185 | 237 | 1334 | 1282 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 108 | 65.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 14857649 | 14857649 | PRJNA839281_S_NODE_27272_length_167_cov_0.864407_g27003_i0 | PRJNA839281 | 27272 | 167 | 0.864407 | 1.44355969 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.5e-78 | NTclustered | gi|209883104|ref|XM_002142938.1| | 441375 | g27003 | i0 | 99.401 | 1 | 167 | 1 | 100 | 0 | 1 | 167 | 517 | 683 | Cryptosporidium muris RN66 uncharacterized protein (CMU_004200), partial mRNA | blastn | 167 | 303 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 16533013 | 16533013 | PRJNA839281_S_NODE_35233_length_162_cov_0.902655_g34964_i0 | PRJNA839281 | 35233 | 162 | 0.902655 | 1.4623011 | root | 1 | Root_unresolved | Root_unresolved | 294 | 2.03e-75 | NTclustered | gi|166046587|emb|CU367704.1| | 100861 | g34964 | i0 | 99.383 | 34.6358024691358 | 162 | 1 | 100 | 0 | 1 | 162 | 392 | 553 | Aphanomyces euteiches cDNA | blastn | 5611 | 294 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 18681136 | 18681136 | PRJNA839281_S_NODE_4095_length_487_cov_3.826484_g3827_i0 | PRJNA839281 | 4095 | 487 | 3.826484 | 18.63497708 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.013 | NTclustered | gi|170285697|emb|CU672270.3| | 123356 | g3827 | i0 | 100 | 0.0595482546201232 | 29 | 0 | 6 | 0 | 287 | 315 | 1789 | 1761 | H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica |
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);;