contig_metadata
11 rows where bioproject = "PRJNA606583" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 583452 | 583452 | PRJNA606583_P_NODE_15821_length_316_cov_9.082437_g15392_i0 | PRJNA606583 | 15821 | 316 | 9.082437 | 28.70050092 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 516 | 8.73e-142 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g15392 | i0 | 96.19 | 38.7974683544304 | 315 | 12 | 99 | 0 | 1 | 315 | 324 | 10 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 12260 | 516 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 583563 | 583563 | PRJNA606583_P_NODE_35101_length_172_cov_1.155556_g34672_i0 | PRJNA606583 | 35101 | 172 | 1.155556 | 1.98755632 | Poteriospumella lacustris | 1117027 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 1.7e-66 | NTclustered | gi|1922073065|gb|MN935478.1| | 1117027 | g34672 | i0 | 99.315 | 86.5813953488372 | 146 | 1 | 85 | 0 | 1 | 146 | 47996 | 48141 | Poteriospumella lacustris strain Yongseonkyo072317C3 leucoplast | blastn | 14892 | 265 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella lacustris | |||
| 2421716 | 2421716 | PRJNA606583_P_NODE_33542_length_177_cov_3.342857_g33113_i0 | PRJNA606583 | 33542 | 177 | 3.342857 | 5.91685689 | Poteriospumella | 1117026 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 2.2199999999999996e-85 | NTclustered | gi|685431582|gb|KF697341.1| | 1117027 | g33113 | i0 | 100 | 77.316384180791 | 177 | 0 | 100 | 0 | 1 | 177 | 45 | 221 | Poteriospumella lacustris strain JBC07 28S ribosomal RNA gene, partial sequence | blastn | 13685 | 327 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella lacustris | |||
| 9511958 | 9511958 | PRJNA606583_P_NODE_20568_length_261_cov_6.312500_g20139_i0 | PRJNA606583 | 20568 | 261 | 6.3125 | 16.475625 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 3.38e-115 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g20139 | i0 | 96.169 | 15.2030651340996 | 261 | 10 | 100 | 0 | 1 | 261 | 391 | 651 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 3968 | 427 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 11349947 | 11349947 | PRJNA606583_P_NODE_36729_length_166_cov_2.116279_g36300_i0 | PRJNA606583 | 36729 | 166 | 2.116279 | 3.51302314 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 2.69e-79 | NTclustered | gi|2065561668|gb|MZ540265.1| | 44029 | g36300 | i0 | 100 | 86.1084337349398 | 166 | 0 | 100 | 0 | 1 | 166 | 755 | 590 | Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence | blastn | 14294 | 307 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium jenningsi | ||
| 15886525 | 15886525 | PRJNA606583_P_NODE_28813_length_200_cov_1.171779_g28384_i0 | PRJNA606583 | 28813 | 200 | 1.171779 | 2.343558 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 5.659999999999999e-72 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g28384 | i0 | 93.651 | 2.84 | 189 | 12 | 95 | 0 | 12 | 200 | 1958 | 2146 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 568 | 283 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 18997600 | 18997600 | PRJNA606583_P_NODE_15075_length_327_cov_3.175862_g14646_i0 | PRJNA606583 | 15075 | 327 | 3.175862 | 10.38506874 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 560 | 4.13e-155 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g14646 | i0 | 97.554 | 12.9938837920489 | 327 | 8 | 100 | 0 | 1 | 327 | 1512 | 1838 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 4249 | 560 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 19710094 | 19710094 | PRJNA606583_P_NODE_16056_length_313_cov_2.826087_g15627_i0 | PRJNA606583 | 16056 | 313 | 2.826087 | 8.84565231 | Poteriospumella lacustris | 1117027 | SAR_Eukaryotes | SAR_Eukaryotes | 568 | 2.3499999999999998e-157 | NTclustered | gi|2295553597|gb|OP378946.1| | 1117027 | g15627 | i0 | 99.361 | 93.4472843450479 | 313 | 2 | 100 | 0 | 1 | 313 | 1679 | 1367 | Poteriospumella lacustris isolate 1532 large subunit ribosomal RNA gene, partial sequence | blastn | 29249 | 568 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella lacustris | |||
| 19710216 | 19710216 | PRJNA606583_P_NODE_37676_length_163_cov_1.841270_g37247_i0 | PRJNA606583 | 37676 | 163 | 1.84127 | 3.0012701 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 2.24e-10 | NTclustered | gi|288272|emb|X58846.1| | 5911 | g37247 | i0 | 91.228 | 103.147239263804 | 57 | 5 | 35 | 0 | 107 | 163 | 67 | 11 | T.thermophila U2.2 snRNA | blastn | 16813 | 78.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 20272914 | 20272914 | PRJNA606583_P_NODE_31896_length_185_cov_1.310811_g31467_i0 | PRJNA606583 | 31896 | 185 | 1.310811 | 2.42500035 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 8.430000000000001e-85 | NTclustered | gi|2065561668|gb|MZ540265.1| | 44029 | g31467 | i0 | 98.387 | 100.502702702703 | 186 | 2 | 100 | 1 | 1 | 185 | 315 | 130 | Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence | blastn | 18593 | 326 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium jenningsi | ||
| 22823445 | 22823445 | PRJNA606583_P_NODE_13178_length_358_cov_6.744548_g12750_i0 | PRJNA606583 | 13178 | 358 | 6.744548 | 24.14548184 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.4599999999999995e-55 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g12750 | i0 | 97.059 | 1.13966480446927 | 136 | 4 | 38 | 0 | 1 | 136 | 2947 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 408 | 230 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola |
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);;