contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA565778" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1135859 | 1135859 | PRJNA565778_S_NODE_41301_length_158_cov_2.991736_g41005_i0 | PRJNA565778 | 41301 | 158 | 2.991736 | 4.72694288 | root | 1 | Root_unresolved | Root_unresolved | 180 | 5.74e-41 | NTclustered | gi|166046530|emb|CU367647.1| | 100861 | g41005 | i0 | 100 | 61.7215189873418 | 97 | 0 | 87 | 0 | 1 | 97 | 615 | 711 | Aphanomyces euteiches cDNA | blastn | 9752 | 180 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 3109365 | 3109365 | PRJNA565778_S_NODE_4943_length_465_cov_7.612150_g4709_i0 | PRJNA565778 | 4943 | 465 | 7.61215 | 35.3964975 | Analipus japonicus | 31333 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 2.09e-5 | NTclustered | gi|2049955473|gb|MZ156065.1| | 31333 | g4709 | i0 | 97.297 | 0.0795698924731183 | 37 | 1 | 8 | 0 | 287 | 323 | 34797 | 34761 | Analipus japonicus mitochondrion, complete genome | blastn | 37 | 63.9 | 1 | Eukaryota | Sar | Phaeophyceae | Ralfsiales | Ralfsiaceae | Analipus | Analipus japonicus | |||
| 4963891 | 4963891 | PRJNA565778_S_NODE_31284_length_196_cov_4.100629_g30988_i0 | PRJNA565778 | 31284 | 196 | 4.100629 | 8.03723284 | root | 1 | Root_unresolved | Root_unresolved | 254 | 4.33e-63 | NTclustered | gi|166044547|emb|CU367456.1| | 100861 | g30988 | i0 | 99.291 | 14.1020408163265 | 141 | 0 | 72 | 1 | 22 | 162 | 169 | 30 | Aphanomyces euteiches cDNA | blastn | 2764 | 254 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 5661984 | 5661984 | PRJNA565778_S_NODE_23225_length_229_cov_114.614583_g22929_i0 | PRJNA565778 | 23225 | 229 | 114.614583 | 262.46739507 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 1.4e-88 | NTclustered | gi|328802538|emb|FR832890.1| | 890382 | g22929 | i0 | 98.438 | 85.5196506550218 | 192 | 3 | 84 | 0 | 1 | 192 | 1014 | 1205 | Albugo laibachii Nc14, mitochondrial genomic contig NODE_36_length_2553_cov_1396.121460 | blastn | 19584 | 339 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 7513665 | 7513665 | PRJNA565778_S_NODE_31306_length_196_cov_3.144654_g31010_i0 | PRJNA565778 | 31306 | 196 | 3.144654 | 6.16352184 | root | 1 | Root_unresolved | Root_unresolved | 252 | 1.56e-62 | NTclustered | gi|166046607|emb|CU367724.1| | 100861 | g31010 | i0 | 99.281 | 9.74489795918367 | 139 | 1 | 71 | 0 | 21 | 159 | 360 | 498 | Aphanomyces euteiches cDNA | blastn | 1910 | 252 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 8211387 | 8211387 | PRJNA565778_S_NODE_34187_length_186_cov_245.879195_g33891_i0 | PRJNA565778 | 34187 | 186 | 245.879195 | 457.3353027 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 4.06e-63 | NTclustered | gi|166046594|emb|CU367711.1| | 100861 | g33891 | i0 | 97.959 | 14.7688172043011 | 147 | 2 | 78 | 1 | 11 | 156 | 485 | 339 | Aphanomyces euteiches cDNA | blastn | 2747 | 254 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 10064337 | 10064337 | PRJNA565778_S_NODE_40328_length_163_cov_3.500000_g40032_i0 | PRJNA565778 | 40328 | 163 | 3.5 | 5.705 | root | 1 | Root_unresolved | Root_unresolved | 265 | 1.6e-66 | NTclustered | gi|166044518|emb|CU367427.1| | 100861 | g40032 | i0 | 99.32 | 30.4049079754601 | 147 | 0 | 90 | 1 | 6 | 151 | 346 | 492 | Aphanomyces euteiches cDNA | blastn | 4956 | 265 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 10762673 | 10762673 | PRJNA565778_S_NODE_33949_length_187_cov_9.000000_g33653_i0 | PRJNA565778 | 33949 | 187 | 9 | 16.83 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 1.4799999999999998e-57 | NTclustered | gi|49616744|gb|AY643504.1| | 282688 | g33653 | i0 | 90.857 | 93.7700534759358 | 175 | 16 | 94 | 0 | 1 | 175 | 301 | 127 | Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence | blastn | 17535 | 235 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 10762777 | 10762777 | PRJNA565778_S_NODE_43029_length_150_cov_3.840708_g42733_i0 | PRJNA565778 | 43029 | 150 | 3.840708 | 5.761062 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 1.11e-67 | NTclustered | gi|194245783|gb|EU828456.1| | 5888 | g42733 | i0 | 98.684 | 95.2466666666667 | 152 | 0 | 100 | 1 | 1 | 150 | 3164 | 3013 | Paramecium tetraurelia large subunit ribosomal RNA gene, complete sequence | blastn | 14287 | 268 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 11339039 | 11339039 | PRJNA565778_S_NODE_40429_length_163_cov_1.484127_g40133_i0 | PRJNA565778 | 40429 | 163 | 1.484127 | 2.41912701 | root | 1 | Root_unresolved | Root_unresolved | 257 | 2.68e-64 | NTclustered | gi|166044533|emb|CU367442.1| | 100861 | g40133 | i0 | 100 | 38.5705521472393 | 139 | 0 | 85 | 0 | 3 | 141 | 651 | 513 | Aphanomyces euteiches cDNA | blastn | 6287 | 257 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 12614801 | 12614801 | PRJNA565778_S_NODE_29690_length_201_cov_306.585366_g29394_i0 | PRJNA565778 | 29690 | 201 | 306.585366 | 616.23658566 | root | 1 | Root_unresolved | Root_unresolved | 291 | 3.4e-74 | NTclustered | gi|166044652|emb|CU367561.1| | 100861 | g29394 | i0 | 100 | 77.6019900497512 | 157 | 0 | 78 | 0 | 9 | 165 | 403 | 247 | Aphanomyces euteiches cDNA | blastn | 15598 | 291 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 12614841 | 12614841 | PRJNA565778_S_NODE_38450_length_173_cov_2.992647_g38154_i0 | PRJNA565778 | 38450 | 173 | 2.992647 | 5.17727931 | root | 1 | Root_unresolved | Root_unresolved | 196 | 6.339999999999999e-46 | NTclustered | gi|166046788|emb|CU367363.1| | 100861 | g38154 | i0 | 99.083 | 17.7630057803468 | 109 | 1 | 82 | 0 | 65 | 173 | 539 | 431 | Aphanomyces euteiches cDNA | blastn | 3073 | 196 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 13889836 | 13889836 | PRJNA565778_S_NODE_34111_length_187_cov_1.493333_g33815_i0 | PRJNA565778 | 34111 | 187 | 1.493333 | 2.79253271 | Guttulinopsis | 1144921 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 6.56e-91 | NTclustered | gi|1402550487|gb|MH488773.1| | 2231167 | g33815 | i0 | 100 | 8.56149732620321 | 187 | 0 | 100 | 0 | 1 | 187 | 1047 | 861 | Guttulinopsis sp. isolate STA small subunit ribosomal RNA gene, partial sequence | blastn | 1601 | 346 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis sp. | ||||
| 15163958 | 15163958 | PRJNA565778_S_NODE_43072_length_150_cov_2.654867_g42776_i0 | PRJNA565778 | 43072 | 150 | 2.654867 | 3.9823005 | Xanthophyceae | 2833 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 1.15e-47 | NTclustered | gi|223029651|gb|FJ030881.1| | 243652 | g42776 | i0 | 90.85 | 100.246666666667 | 153 | 10 | 100 | 3 | 1 | 150 | 1428 | 1277 | Chlorellidium tetrabotrys strain SAG811-1 28S ribosomal RNA gene, partial sequence | blastn | 15037 | 202 | 1 | Eukaryota | Sar | Xanthophyceae | Mischococcales | Botryochloridaceae | Chlorellidium | Chlorellidium tetrabotrys | |||
| 16438507 | 16438507 | PRJNA565778_S_NODE_8193_length_375_cov_32.923077_g7900_i0 | PRJNA565778 | 8193 | 375 | 32.923077 | 123.46153875 | root | 1 | Root_unresolved | Root_unresolved | 599 | 1.0199999999999998e-166 | NTclustered | gi|166046508|emb|CU367625.1| | 100861 | g7900 | i0 | 100 | 86.3866666666667 | 324 | 0 | 86 | 0 | 35 | 358 | 436 | 113 | Aphanomyces euteiches cDNA | blastn | 32395 | 599 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 17713647 | 17713647 | PRJNA565778_S_NODE_18114_length_260_cov_3.914798_g17818_i0 | PRJNA565778 | 18114 | 260 | 3.9147979999999998 | 10.1784748 | root | 1 | Root_unresolved | Root_unresolved | 411 | 3.39e-110 | NTclustered | gi|166046727|emb|CU367837.1| | 100861 | g17818 | i0 | 99.558 | 86.9230769230769 | 226 | 0 | 87 | 1 | 34 | 259 | 548 | 772 | Aphanomyces euteiches cDNA | blastn | 22600 | 411 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 18410306 | 18410306 | PRJNA565778_S_NODE_36635_length_179_cov_4.112676_g36339_i0 | PRJNA565778 | 36635 | 179 | 4.1126760000000004 | 7.36169004 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 8.75e-30 | NTclustered | gi|1402550488|gb|MH488774.1| | 2231170 | g36339 | i0 | 98.765 | 34.4916201117318 | 81 | 0 | 45 | 1 | 68 | 147 | 2216 | 2136 | Guttulinopsis rogosa isolate FOLDEDA sequence | blastn | 6174 | 143 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 22235164 | 22235164 | PRJNA565778_S_NODE_13058_length_304_cov_6.681648_g12762_i0 | PRJNA565778 | 13058 | 304 | 6.681648 | 20.31220992 | Peronospora rumicis | 162101 | SAR_Eukaryotes | SAR_Eukaryotes | 562 | 1.06e-155 | NTclustered | gi|511773433|gb|KC495032.1| | 162101 | g12762 | i0 | 100 | 99.8782894736842 | 304 | 0 | 100 | 0 | 1 | 304 | 4 | 307 | Peronospora rumicis isolate HV312 28S ribosomal RNA gene, partial sequence | blastn | 30363 | 562 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora rumicis | ||
| 22235286 | 22235286 | PRJNA565778_S_NODE_21358_length_239_cov_261.935644_g21062_i0 | PRJNA565778 | 21358 | 239 | 261.935644 | 626.02618916 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.89e-92 | NTclustered | gi|166046788|emb|CU367363.1| | 100861 | g21062 | i0 | 99.482 | 78.2887029288703 | 193 | 1 | 81 | 0 | 12 | 204 | 193 | 385 | Aphanomyces euteiches cDNA | blastn | 18711 | 351 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 22235443 | 22235443 | PRJNA565778_S_NODE_33898_length_187_cov_78.353333_g33602_i0 | PRJNA565778 | 33898 | 187 | 78.353333 | 146.52073271 | Nitzschia dissipata | 303402 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.19e-28 | NTclustered | gi|2248495830|ref|NC_063456.1| | 303402 | g33602 | i0 | 90.476 | 32.8983957219251 | 105 | 10 | 56 | 0 | 1 | 105 | 36373 | 36477 | Nitzschia dissipata isolate Qingdao in China mitochondrion, complete genome | blastn | 6152 | 139 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Nitzschia | Nitzschia dissipata |
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);;