contig_metadata
7 rows where bioproject = "PRJDB12578", tax_clade = "Sar" and tax_phylum = "Ciliophora"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15310124 | 15310124 | PRJDB12578_S_NODE_88293_length_340_cov_2.371134_g65235_i0 | PRJDB12578 | 88293 | 340 | 2.371134 | 8.0618556 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 545 | 1.21e-150 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g65235 | i0 | 95.588 | 51.2382352941176 | 340 | 15 | 100 | 0 | 1 | 340 | 2236 | 1897 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 17421 | 545 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 16283514 | 16283514 | PRJDB12578_S_NODE_168473_length_186_cov_3.386861_g145415_i0 | PRJDB12578 | 168473 | 186 | 3.386861 | 6.29956146 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 2.36e-85 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g145415 | i0 | 98.907 | 86.752688172043 | 183 | 2 | 98 | 0 | 1 | 183 | 255 | 437 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 16136 | 327 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 19133932 | 19133932 | PRJDB12578_S_NODE_96956_length_302_cov_2.019763_g73898_i0 | PRJDB12578 | 96956 | 302 | 2.019763 | 6.09968426 | Lamtostyla gui | 2678605 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 9.619999999999998e-37 | NTclustered | gi|1778223994|gb|MN733822.1| | 2678605 | g73898 | i0 | 91.2 | 39.3443708609271 | 125 | 8 | 41 | 3 | 86 | 209 | 4109 | 4231 | Lamtostyla gui isolate LWY2015111409 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 | 11882 | 167 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Stichotrichida | Amphisiellidae | Lamtostyla | Lamtostyla gui | ||
| 20107230 | 20107230 | PRJDB12578_S_NODE_100116_length_291_cov_1.793388_g77058_i0 | PRJDB12578 | 100116 | 291 | 1.793388 | 5.21875908 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 508 | 1.33e-139 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g77058 | i0 | 98.276 | 96.6666666666667 | 290 | 5 | 99 | 0 | 1 | 290 | 1655 | 1944 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 28130 | 508 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 20107330 | 20107330 | PRJDB12578_S_NODE_182096_length_176_cov_1.637795_g159038_i0 | PRJDB12578 | 182096 | 176 | 1.637795 | 2.8825192 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.71e-78 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g159038 | i0 | 97.727 | 98.3636363636364 | 176 | 4 | 100 | 0 | 1 | 176 | 1487 | 1662 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 17312 | 303 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 20107332 | 20107332 | PRJDB12578_S_NODE_184336_length_175_cov_1.206349_g161278_i0 | PRJDB12578 | 184336 | 175 | 1.206349 | 2.11111075 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 2.83e-84 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g161278 | i0 | 100 | 98.7028571428571 | 175 | 0 | 100 | 0 | 1 | 175 | 2591 | 2765 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 17273 | 324 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 21382916 | 21382916 | PRJDB12578_S_NODE_154157_length_199_cov_1.373333_g131099_i0 | PRJDB12578 | 154157 | 199 | 1.373333 | 2.73293267 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 368 | 1.51e-97 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g131099 | i0 | 100 | 100.241206030151 | 199 | 0 | 100 | 0 | 1 | 199 | 1182 | 1380 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 19948 | 368 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata |
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);;