contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1233465" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25554798 | 25554798 | PRJNA1233465f_S_NODE_180905_length_185_cov_2.250000_g178625_i0 | PRJNA1233465 | 180905 | 185 | 2.25 | 4.1625 | Colpoda steini | 63136 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 8.369999999999999e-90 | NTclustered | gi|646281697|gb|KJ607915.1| | 63136 | g178625 | i0 | 100 | 99.4486486486486 | 185 | 0 | 100 | 0 | 1 | 185 | 736 | 552 | Colpoda steinii strain PABBc-29 18S ribosomal RNA gene, partial sequence | blastn | 18398 | 342 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda steini | ||
| 25619753 | 25619753 | PRJNA1233465b_S_NODE_182473_length_217_cov_3.732143_g180788_i0 | PRJNA1233465 | 182473 | 217 | 3.732143 | 8.09875031 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.09e-39 | NTclustered | gi|161728|gb|M86723.1|TETATUB | 5911 | g180788 | i0 | 94.69 | 4.00921658986175 | 113 | 6 | 52 | 0 | 4 | 116 | 2621 | 2733 | Tetrahymena thermophila alpha-tubulin gene, complete cds | blastn | 870 | 176 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 25758059 | 25758059 | PRJNA1233465d_S_NODE_86674_length_193_cov_2.125000_g85563_i0 | PRJNA1233465 | 86674 | 193 | 2.125 | 4.10125 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.46e-92 | NTclustered | gi|1802599797|gb|MT001206.1| | 41631 | g85563 | i0 | 99.482 | 99.5336787564767 | 193 | 1 | 100 | 0 | 1 | 193 | 734 | 542 | Colpoda sp. strain HFCC1227 small subunit ribosomal RNA gene, partial sequence | blastn | 19210 | 351 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 25819584 | 25819584 | PRJNA1233465e_S_NODE_146643_length_166_cov_0.871795_g145333_i0 | PRJNA1233465 | 146643 | 166 | 0.871795 | 1.4471797 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 2.99e-4 | NTclustered | gi|146171411|ref|XM_001471339.1| | 312017 | g145333 | i0 | 100 | 0.186746987951807 | 31 | 0 | 19 | 0 | 71 | 101 | 291 | 321 | Tetrahymena thermophila SB210 transmembrane protein, putative partial mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 26030738 | 26030738 | PRJNA1233465e_S_NODE_58116_length_242_cov_1.005181_g56806_i0 | PRJNA1233465 | 58116 | 242 | 1.005181 | 2.43253802 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 9.52e-46 | NTclustered | gi|161728|gb|M86723.1|TETATUB | 5911 | g56806 | i0 | 97.391 | 44.3553719008264 | 115 | 3 | 48 | 0 | 128 | 242 | 2733 | 2619 | Tetrahymena thermophila alpha-tubulin gene, complete cds | blastn | 10734 | 196 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 26032502 | 26032502 | PRJNA1233465f_S_NODE_97308_length_242_cov_1.015544_g95028_i0 | PRJNA1233465 | 97308 | 242 | 1.015544 | 2.45761648 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 9.52e-46 | NTclustered | gi|161728|gb|M86723.1|TETATUB | 5911 | g95028 | i0 | 97.391 | 44.3553719008264 | 115 | 3 | 48 | 0 | 128 | 242 | 2733 | 2619 | Tetrahymena thermophila alpha-tubulin gene, complete cds | blastn | 10734 | 196 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 26075316 | 26075316 | PRJNA1233465a_S_NODE_122957_length_211_cov_2.000000_g121683_i0 | PRJNA1233465 | 122957 | 211 | 2 | 4.22 | Cyclidium sp. MMP-2 | 2021665 | SAR_Eukaryotes | SAR_Eukaryotes | 390 | 3.459999999999999e-104 | NTclustered | gi|2009899914|gb|MW785065.1| | 2704628 | g121683 | i0 | 100 | 98.4075829383886 | 211 | 0 | 100 | 0 | 1 | 211 | 111 | 321 | Cyclidium sp. MMP-2020a isolate SM20191018 large subunit ribosomal RNA gene, partial sequence | blastn | 20764 | 390 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Cyclidiidae | Cyclidium | Cyclidium sp. MMP-2020a | ||
| 26103635 | 26103635 | PRJNA1233465f_S_NODE_42173_length_345_cov_1.398649_g39893_i0 | PRJNA1233465 | 42173 | 345 | 1.398649 | 4.82533905 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.009 | NTclustered | gi|829099803|ref|XM_001007021.2| | 312017 | g39893 | i0 | 96.97 | 0.0956521739130435 | 33 | 0 | 9 | 1 | 203 | 234 | 862 | 894 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 26166587 | 26166587 | PRJNA1233465e_S_NODE_22221_length_365_cov_1.759494_g20911_i0 | PRJNA1233465 | 22221 | 365 | 1.759494 | 6.4221531 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 614 | 3.519999999999999e-171 | NTclustered | gi|1802599797|gb|MT001206.1| | 41631 | g20911 | i0 | 99.408 | 92.2191780821918 | 338 | 2 | 93 | 0 | 1 | 338 | 512 | 849 | Colpoda sp. strain HFCC1227 small subunit ribosomal RNA gene, partial sequence | blastn | 33660 | 614 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 26434703 | 26434703 | PRJNA1233465a_S_NODE_175983_length_183_cov_1.141791_g174709_i0 | PRJNA1233465 | 175983 | 183 | 1.141791 | 2.08947753 | Vorticellidae | 85904 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 6.52e-76 | NTclustered | gi|1151071387|gb|KX926064.1| | 282477 | g174709 | i0 | 97.688 | 94.5355191256831 | 173 | 3 | 94 | 1 | 1 | 172 | 361 | 189 | Uncultured Peritrichia clone Peri974F_W_31 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 17300 | 296 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | uncultured Peritrichia | |||||
| 26572588 | 26572588 | PRJNA1233465b_S_NODE_329712_length_167_cov_1.728814_g328027_i0 | PRJNA1233465 | 329712 | 167 | 1.728814 | 2.88711938 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 7.53e-80 | NTclustered | gi|1802599794|gb|MT001203.1| | 41631 | g328027 | i0 | 100 | 100.119760479042 | 167 | 0 | 100 | 0 | 1 | 167 | 701 | 867 | Colpoda sp. strain HFCC848 small subunit ribosomal RNA gene, partial sequence | blastn | 16720 | 309 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. |
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);;