contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1195551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 322643 | 322643 | PRJNA1195551_S_NODE_9001_length_306_cov_4.365759_g8648_i0 | PRJNA1195551 | 9001 | 306 | 4.365759 | 13.35922254 | uncultured dinoflagellate | 187300 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 7.6599999999999985e-28 | NTclustered | gi|309255118|gb|GU555054.1| | 187300 | g8648 | i0 | 85.075 | 12.016339869281 | 134 | 20 | 44 | 0 | 173 | 306 | 306 | 173 | uncultured dinoflagellate clone ML1_1061048824671 mRNA sequence | blastn | 3677 | 137 | 1 | Eukaryota | Sar | Dinophyceae | uncultured dinoflagellate | ||||||
| 6700427 | 6700427 | PRJNA1195551_S_NODE_17526_length_237_cov_1.106383_g17173_i0 | PRJNA1195551 | 17526 | 237 | 1.106383 | 2.62212771 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 2.71e-11 | NTclustered | gi|695429697|ref|XM_009531962.1| | 67593 | g17173 | i0 | 89.231 | 19.4556962025316 | 65 | 7 | 27 | 0 | 2 | 66 | 242 | 306 | Phytophthora sojae hypothetical protein mRNA | blastn | 4611 | 82.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 7975931 | 7975931 | PRJNA1195551_S_NODE_26947_length_195_cov_1.424658_g26594_i0 | PRJNA1195551 | 26947 | 195 | 1.424658 | 2.7780831 | Spumella sinechrysos | 2849684 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 2.46e-95 | NTclustered | gi|2055919754|gb|MZ420312.1| | 2849684 | g26594 | i0 | 100 | 99.1589743589744 | 195 | 0 | 100 | 0 | 1 | 195 | 220 | 26 | Spumella sinechrysos strain Hwarim032418A7 large subunit ribosomal RNA gene, partial sequence | blastn | 19336 | 361 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella sinechrysos | |||
| 11801076 | 11801076 | PRJNA1195551_S_NODE_20950_length_219_cov_1.788235_g20597_i0 | PRJNA1195551 | 20950 | 219 | 1.788235 | 3.91623465 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|915147194|ref|XM_013483103.1| | 5804 | g20597 | i0 | 96.875 | 0.785388127853881 | 32 | 1 | 15 | 0 | 95 | 126 | 3242 | 3211 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 172 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 15625368 | 15625368 | PRJNA1195551_S_NODE_29313_length_187_cov_2.630435_g28960_i0 | PRJNA1195551 | 29313 | 187 | 2.630435 | 4.91891345 | Wobblia lunata | 104657 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 3.1600000000000004e-64 | NTclustered | gi|2163288121|gb|MZ440312.1| | 104657 | g28960 | i0 | 91.444 | 99.3262032085562 | 187 | 16 | 100 | 0 | 1 | 187 | 1081 | 1267 | Wobblia lunata strain NIES-1015 alpha-tubulin mRNA, complete cds | blastn | 18574 | 257 | 1 | Eukaryota | Sar | Bigyra | Placidida | Placidiaceae | Wobblia | Wobblia lunata | |||
| 15625369 | 15625369 | PRJNA1195551_S_NODE_29373_length_187_cov_1.702899_g29020_i0 | PRJNA1195551 | 29373 | 187 | 1.702899 | 3.18442113 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 6.79e-66 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g29020 | i0 | 91.979 | 51.1604278074866 | 187 | 15 | 100 | 0 | 1 | 187 | 213 | 27 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 9567 | 263 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 17620873 | 17620873 | PRJNA1195551_S_NODE_32634_length_178_cov_1.581395_g32281_i0 | PRJNA1195551 | 32634 | 178 | 1.581395 | 2.8148831 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 6.21e-86 | NTclustered | gi|2065561668|gb|MZ540265.1| | 44029 | g32281 | i0 | 100 | 100 | 178 | 0 | 100 | 0 | 1 | 178 | 893 | 716 | Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence | blastn | 17800 | 329 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium jenningsi | ||
| 19448638 | 19448638 | PRJNA1195551_S_NODE_31916_length_180_cov_0.969466_g31563_i0 | PRJNA1195551 | 31916 | 180 | 0.969466 | 1.7450388 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.015 | NTclustered | gi|145528242|ref|XM_001449884.1| | 5888 | g31563 | i0 | 100 | 0.155555555555556 | 28 | 0 | 16 | 0 | 135 | 162 | 274 | 301 | Paramecium tetraurelia uncharacterized protein (GSPATT00016911001), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 25269239 | 25269239 | PRJNA1195551_S_NODE_12640_length_270_cov_5.760181_g12287_i0 | PRJNA1195551 | 12640 | 270 | 5.760181 | 15.5524887 | root | 1 | Root_unresolved | Root_unresolved | 130 | 1.11e-25 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g12287 | i0 | 88.182 | 16.4518518518519 | 110 | 12 | 40 | 1 | 1 | 109 | 2454 | 2345 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 4442 | 130 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa |
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);;