contig_metadata
8 rows where bioproject = "PRJEB7614", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18848119 | 18848119 | PRJEB7614_P_NODE_2235_length_252_cov_310823.466368_g2168_i0 | PRJEB7614 | 2235 | 252 | 310823.466368 | 783275.13524736 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 5.7999999999999984e-68 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2168 | i0 | 98.065 | 48.6428571428571 | 155 | 3 | 62 | 0 | 12 | 166 | 2649 | 2495 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 12258 | 270 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 20539640 | 20539640 | PRJEB7614_P_NODE_1857_length_268_cov_21.962343_g1790_i0 | PRJEB7614 | 1857 | 268 | 21.962343 | 58.85907924 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 5.96e-98 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1790 | i0 | 93.254 | 9.17910447761194 | 252 | 15 | 94 | 2 | 5 | 255 | 112 | 362 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 2460 | 370 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 25661663 | 25661663 | PRJEB7614c_S_NODE_66_length_414_cov_7.313984_g65_i0 | PRJEB7614 | 66 | 414 | 7.313984 | 30.27989376 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 558 | 1.92e-154 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g65 | i0 | 94.49 | 47.6980676328502 | 363 | 18 | 87 | 2 | 21 | 382 | 1 | 362 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 19747 | 558 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 25888354 | 25888354 | PRJEB7614a_S_NODE_85731_length_204_cov_4.733728_g84527_i0 | PRJEB7614 | 85731 | 204 | 4.733728 | 9.65680512 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 372 | 1.2e-98 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g84527 | i0 | 99.51 | 87.5588235294118 | 204 | 1 | 100 | 0 | 1 | 204 | 2735 | 2938 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 17862 | 372 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 26069942 | 26069942 | PRJEB7614b_S_NODE_117_length_382_cov_33606.259366_g115_i0 | PRJEB7614 | 117 | 382 | 33606.259366 | 128375.91077812 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 436 | 8.61e-118 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g115 | i0 | 93.537 | 18.6020942408377 | 294 | 17 | 77 | 2 | 77 | 369 | 362 | 70 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 7106 | 436 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 26160819 | 26160819 | PRJEB7614a_S_NODE_127853_length_160_cov_1.912000_g126649_i0 | PRJEB7614 | 127853 | 160 | 1.912 | 3.0592 | root | 1 | Root_unresolved | Root_unresolved | 291 | 2.5799999999999998e-74 | NTclustered | gi|10832|emb|X54512.1| | 5911 | g126649 | i0 | 99.375 | 95.7125 | 160 | 1 | 100 | 0 | 1 | 160 | 8308 | 8149 | T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA | blastn | 15314 | 291 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 26206242 | 26206242 | PRJEB7614e_S_NODE_2446_length_199_cov_4.603659_g2438_i0 | PRJEB7614 | 2446 | 199 | 4.603659 | 9.16128141 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 3.3599999999999998e-74 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2438 | i0 | 93 | 5.98492462311558 | 200 | 12 | 100 | 2 | 1 | 199 | 147 | 345 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 1191 | 291 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 26342059 | 26342059 | PRJEB7614c_S_NODE_1447_length_196_cov_5.173913_g1446_i0 | PRJEB7614 | 1447 | 196 | 5.173913 | 10.14086948 | Dysteria brasiliensis | 497733 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.6199999999999998e-32 | NTclustered | gi|1216628402|gb|KX099196.1| | 497733 | g1446 | i0 | 81.095 | 1.75510204081633 | 201 | 28 | 100 | 7 | 1 | 196 | 67 | 262 | Dysteria brasiliensis clone DB3 28S ribosomal RNA gene, partial sequence | blastn | 344 | 152 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Dysteriida | Dysteriidae | Dysteria | Dysteria brasiliensis |
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);;