contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA399711" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25562754 | 25562754 | PRJNA399711_S_NODE_25297_length_254_cov_2.156682_g25155_i0 | PRJNA399711 | 25297 | 254 | 2.156682 | 5.47797228 | Cryptosporidium ubiquitum | 857276 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 4.72e-39 | NTclustered | gi|1624735034|ref|XM_029019898.1| | 857276 | g25155 | i0 | 86.335 | 31.748031496063 | 161 | 20 | 63 | 2 | 1 | 160 | 584 | 743 | Cryptosporidium ubiquitum 60s ribosomal protein L8 L2 (cubi_02887), partial mRNA | blastn | 8064 | 174 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ubiquitum | ||
| 25565073 | 25565073 | PRJNA399711_S_NODE_86345_length_163_cov_4.357143_g86203_i0 | PRJNA399711 | 86345 | 163 | 4.357143 | 7.10214309 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.014 | NTclustered | gi|916416461|ref|XM_013374008.1| | 5802 | g86203 | i0 | 100 | 0.171779141104294 | 28 | 0 | 17 | 0 | 6 | 33 | 120 | 93 | Eimeria tenella uncharacterized protein (ETH_00040805), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 25700390 | 25700390 | PRJNA399711_S_NODE_62194_length_184_cov_2.408163_g62052_i0 | PRJNA399711 | 62194 | 184 | 2.408163 | 4.43101992 | Nitzschia traheaformis | 1881117 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 6.61e-71 | NTclustered | gi|2199203581|ref|NC_061047.1| | 1881117 | g62052 | i0 | 94.022 | 65.6467391304348 | 184 | 11 | 100 | 0 | 1 | 184 | 41164 | 41347 | Nitzschia traheaformis chloroplast, complete genome | blastn | 12079 | 279 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Nitzschia | Nitzschia traheaformis | ||
| 25761141 | 25761141 | PRJNA399711_S_NODE_91298_length_160_cov_2.512195_g91156_i0 | PRJNA399711 | 91298 | 160 | 2.512195 | 4.019512 | Botrydiopsis | 44435 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 5.55e-76 | NTclustered | gi|46019696|emb|AJ579339.1| | 240384 | g91156 | i0 | 100 | 101.33125 | 160 | 0 | 100 | 0 | 1 | 160 | 743 | 584 | Botrydiopsis constricta partial 18S rRNA gene | blastn | 16213 | 296 | 1 | Eukaryota | Sar | Xanthophyceae | Mischococcales | Botrydiopsidaceae | Botrydiopsis | Botrydiopsis constricta | |||
| 25835571 | 25835571 | PRJNA399711_S_NODE_39099_length_217_cov_12.111111_g38957_i0 | PRJNA399711 | 39099 | 217 | 12.111111 | 26.28111087 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|914998632|ref|XM_013392170.1| | 5801 | g38957 | i0 | 89.13 | 0.341013824884793 | 46 | 2 | 21 | 1 | 16 | 61 | 1545 | 1503 | Eimeria acervulina glycosylphosphatidylinositol anchor attachment 1 protein, putative partial mRNA | blastn | 74 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 25837171 | 25837171 | PRJNA399711_S_NODE_82963_length_166_cov_1.519380_g82821_i0 | PRJNA399711 | 82963 | 166 | 1.51938 | 2.5221708 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.014 | NTclustered | gi|1620148298|ref|XM_028678236.1| | 85471 | g82821 | i0 | 100 | 0.168674698795181 | 28 | 0 | 17 | 0 | 137 | 164 | 7869 | 7842 | Plasmodium relictum conserved Plasmodium membrane protein, unknown function (PRELSG_1243100), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 25896803 | 25896803 | PRJNA399711_S_NODE_77787_length_169_cov_12.500000_g77645_i0 | PRJNA399711 | 77787 | 169 | 12.5 | 21.125 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 1.27e-77 | NTclustered | gi|1802599797|gb|MT001206.1| | 41631 | g77645 | i0 | 98.817 | 99.1538461538462 | 169 | 2 | 100 | 0 | 1 | 169 | 680 | 512 | Colpoda sp. strain HFCC1227 small subunit ribosomal RNA gene, partial sequence | blastn | 16757 | 302 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 25896829 | 25896829 | PRJNA399711_S_NODE_83227_length_165_cov_10.695312_g83085_i0 | PRJNA399711 | 83227 | 165 | 10.695312 | 17.6472648 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.45e-78 | NTclustered | gi|1802599796|gb|MT001205.1| | 41631 | g83085 | i0 | 100 | 100.139393939394 | 164 | 0 | 99 | 0 | 1 | 164 | 129 | 292 | Colpoda sp. strain HFCC864 small subunit ribosomal RNA gene, partial sequence | blastn | 16523 | 303 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 25971300 | 25971300 | PRJNA399711_S_NODE_27116_length_247_cov_9.128571_g26974_i0 | PRJNA399711 | 27116 | 247 | 9.128571 | 22.54757037 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 1.9199999999999992e-107 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g26974 | i0 | 96.694 | 97.7044534412955 | 242 | 7 | 98 | 1 | 6 | 247 | 3693 | 3453 | Colpoda sp. isolate JGP15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 24133 | 401 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 25971930 | 25971930 | PRJNA399711_S_NODE_40812_length_214_cov_4.774011_g40670_i0 | PRJNA399711 | 40812 | 214 | 4.774011 | 10.21638354 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.06e-49 | NTclustered | gi|11466252|ref|NC_000862.1| | 5908 | g40670 | i0 | 85.507 | 73.1168224299065 | 207 | 23 | 95 | 6 | 11 | 213 | 1149 | 946 | Tetrahymena pyriformis mitochondrion, complete genome | blastn | 15647 | 209 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 25973577 | 25973577 | PRJNA399711_S_NODE_87972_length_162_cov_3.432000_g87830_i0 | PRJNA399711 | 87972 | 162 | 3.432 | 5.55984 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.013 | NTclustered | gi|2795622194|ref|XM_068065127.1| | 483139 | g87830 | i0 | 96.875 | 0.197530864197531 | 32 | 0 | 19 | 1 | 129 | 159 | 398 | 367 | Cystoisospora suis uncharacterized protein (CSUI_004946), partial mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 26169068 | 26169068 | PRJNA399711_S_NODE_37997_length_219_cov_49.384615_g37855_i0 | PRJNA399711 | 37997 | 219 | 49.384615 | 108.15230685 | root | 1 | Root_unresolved | Root_unresolved | 270 | 4.91e-68 | NTclustered | gi|2666680359|ref|NC_085297.1| | 116065 | g37855 | i0 | 90.686 | 183.03196347032 | 204 | 17 | 92 | 1 | 1 | 202 | 42089 | 42292 | Choristocarpus tenellus plastid, complete genome | blastn | 40084 | 270 | 1 | Eukaryota | Sar | Phaeophyceae | Sphacelariales | Choristocarpaceae | Choristocarpus | Choristocarpus tenellus | |||
| 26244736 | 26244736 | PRJNA399711_S_NODE_57214_length_189_cov_8.815789_g57072_i0 | PRJNA399711 | 57214 | 189 | 8.815789 | 16.66184121 | Sticholonche zanclea | 1054997 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 4.48e-8 | NTclustered | gi|1133508201|emb|LT673670.1| | 1054997 | g57072 | i0 | 97.561 | 0.216931216931217 | 41 | 1 | 22 | 0 | 138 | 178 | 443 | 403 | Sticholonche zanclea partial mRNA for Ribosomal Protein L11 (rpl11 gene), isolate AKK-51 2016 | blastn | 41 | 71.3 | 1 | Eukaryota | Sar | Sticholonchida | Sticholonchidae | Sticholonche | Sticholonche zanclea | ||||
| 26244917 | 26244917 | PRJNA399711_S_NODE_62430_length_184_cov_1.265306_g62288_i0 | PRJNA399711 | 62430 | 184 | 1.265306 | 2.32816304 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|170285697|emb|CU672270.3| | 123356 | g62288 | i0 | 100 | 0.157608695652174 | 29 | 0 | 16 | 0 | 55 | 83 | 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 | ||
| 26245267 | 26245267 | PRJNA399711_S_NODE_71238_length_175_cov_2.710145_g71096_i0 | PRJNA399711 | 71238 | 175 | 2.710145 | 4.74275375 | Saprolegnia diclina VS2 | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|669159437|ref|XM_008617059.1| | 1156394 | g71096 | i0 | 100 | 0.325714285714286 | 29 | 0 | 17 | 0 | 1 | 29 | 519 | 547 | Saprolegnia diclina VS20 hypothetical protein mRNA | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 26378667 | 26378667 | PRJNA399711_S_NODE_15391_length_301_cov_3.753788_g15249_i0 | PRJNA399711 | 15391 | 301 | 3.753788 | 11.29890188 | Chrysoparadoxa australica | 2498842 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 4.52e-25 | NTclustered | gi|1546603083|gb|MK189074.1| | 2498842 | g15249 | i0 | 92.308 | 62.4750830564784 | 91 | 5 | 30 | 2 | 112 | 202 | 1325 | 1413 | Chrysoparadoxa australica cytochrome c oxidase subunit I mRNA, complete cds; mitochondrial | blastn | 18805 | 128 | 1 | Eukaryota | Sar | Chrysoparadoxa | Chrysoparadoxa australica | ||||||
| 26515018 | 26515018 | PRJNA399711_S_NODE_16264_length_295_cov_15.837209_g16122_i0 | PRJNA399711 | 16264 | 295 | 15.837209 | 46.71976655 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|915011600|ref|XM_013396010.1| | 5801 | g16122 | i0 | 100 | 0.674576271186441 | 30 | 0 | 10 | 0 | 87 | 116 | 661 | 632 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 199 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 26576787 | 26576787 | PRJNA399711_S_NODE_21080_length_270_cov_10.240343_g20938_i0 | PRJNA399711 | 21080 | 270 | 10.240343 | 27.6489261 | root | 1 | Root_unresolved | Root_unresolved | 451 | 2.09e-122 | NTclustered | gi|613433395|gb|KJ410683.1| | 145522 | g20938 | i0 | 98.069 | 167.32962962963 | 259 | 5 | 96 | 0 | 12 | 270 | 65263 | 65005 | Nannochloropsis oceanica strain LAMB0001 chloroplast, partial genome | blastn | 45179 | 451 | 1 | Eukaryota | Sar | Eustigmatophyceae | Eustigmatales | Monodopsidaceae | Nannochloropsis | Nannochloropsis oceanica |
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);;