contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1044115" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2284023 | 2284023 | PRJNA1044115_P_NODE_16742_length_357_cov_4.904930_g16558_i0 | PRJNA1044115 | 16742 | 357 | 4.90493 | 17.5106001 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 8.51e-73 | NTclustered | gi|161736|gb|L01416.1|TETBTUBUB | 5911 | g16558 | i0 | 83.495 | 61.7422969187675 | 309 | 50 | 86 | 1 | 6 | 313 | 438 | 130 | Tetrahymena thermophila beta-tubulin (BTU2) gene, complete cds | blastn | 22042 | 287 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 6549245 | 6549245 | PRJNA1044115_P_NODE_13346_length_405_cov_5.253012_g13162_i0 | PRJNA1044115 | 13346 | 405 | 5.253012 | 21.2746986 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 732 | 0 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g13162 | i0 | 99.259 | 90.4074074074074 | 405 | 3 | 100 | 0 | 1 | 405 | 1918 | 1514 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 36615 | 732 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 8662022 | 8662022 | PRJNA1044115_P_NODE_8547_length_524_cov_104.949002_g8365_i0 | PRJNA1044115 | 8547 | 524 | 104.949002 | 549.93277048 | Euplotes | 5935 | SAR_Eukaryotes | SAR_Eukaryotes | 963 | 0 | NTclustered | gi|1516250946|gb|MK177633.1| | 343864 | g8365 | i0 | 99.809 | 101.030534351145 | 524 | 1 | 100 | 0 | 1 | 524 | 603 | 1126 | Uncultured Euplotes sp. clone DDI217.fa small subunit ribosomal RNA gene, partial sequence | blastn | 52940 | 968 | 0.994834710743802 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | uncultured Euplotes sp. | ||
| 9099265 | 9099265 | PRJNA1044115_P_NODE_848_length_1590_cov_6.870138_g800_i0 | PRJNA1044115 | 848 | 1590 | 6.870138 | 109.2351942 | Spirostomum yagiui | 1471042 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 7.39e-20 | NTclustered | gi|2692944869|ref|NC_086648.1| | 1471042 | g800 | i0 | 85.981 | 8.16415094339623 | 107 | 14 | 7 | 1 | 950 | 1055 | 3975 | 3869 | Spirostomum yagiui isolate XKC mitochondrion, complete genome | blastn | 12981 | 113 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Spirostomidae | Spirostomum | Spirostomum yagiui | ||
| 15036544 | 15036544 | PRJNA1044115_P_NODE_43832_length_219_cov_17.000000_g43648_i0 | PRJNA1044115 | 43832 | 219 | 17 | 37.23 | Euplotes | 5935 | SAR_Eukaryotes | SAR_Eukaryotes | 405 | 1.29e-108 | NTclustered | gi|1333898193|gb|MG827339.1| | 178273 | g43648 | i0 | 100 | 100.009132420091 | 219 | 0 | 100 | 0 | 1 | 219 | 161 | 379 | Euplotes sp. strain SLS1 small subunit ribosomal RNA gene, partial sequence | blastn | 21902 | 405 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes sp. | ||
| 18023396 | 18023396 | PRJNA1044115_P_NODE_37075_length_248_cov_76.788571_g36891_i0 | PRJNA1044115 | 37075 | 248 | 76.788571 | 190.43565608 | Euplotes aediculatus | 5940 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 5.38e-108 | NTclustered | gi|6980030|gb|AF223571.1|AF223571 | 5940 | g36891 | i0 | 95.984 | 101.213709677419 | 249 | 9 | 100 | 1 | 1 | 248 | 3424 | 3176 | Euplotes aediculatus internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 25101 | 403 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes aediculatus | ||
| 20572687 | 20572687 | PRJNA1044115_P_NODE_3557_length_851_cov_762.863753_g3409_i0 | PRJNA1044115 | 3557 | 851 | 762.863753 | 6491.97053803 | Euplotes encysticus | 440145 | SAR_Eukaryotes | SAR_Eukaryotes | 1273 | 0 | NTclustered | gi|1233819925|gb|KX516617.1| | 440145 | g3409 | i0 | 100 | 74.4112808460634 | 689 | 0 | 81 | 0 | 1 | 689 | 689 | 1 | Euplotes encysticus isolate B555 large subunit ribosomal RNA gene, partial sequence | blastn | 63324 | 1273 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes encysticus | ||
| 20572849 | 20572849 | PRJNA1044115_P_NODE_997_length_1503_cov_36.783217_g939_i0 | PRJNA1044115 | 997 | 1503 | 36.783217 | 552.85175151 | Euplotes vanleeuwenhoeki | 2794224 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 7.89e-114 | NTclustered | gi|2055401904|ref|NC_056101.1| | 2794224 | g939 | i0 | 77.068 | 13.3313373253493 | 798 | 146 | 77 | 30 | 527 | 1308 | 17756 | 18532 | Euplotes vanleeuwenhoeki strain KKR18 mitochondrion, complete genome | blastn | 20037 | 425 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes vanleeuwenhoeki | ||
| 24397216 | 24397216 | PRJNA1044115_P_NODE_10660_length_461_cov_286.564433_g10476_i0 | PRJNA1044115 | 10660 | 461 | 286.564433 | 1321.06203613 | Euplotes aediculatus | 5940 | SAR_Eukaryotes | SAR_Eukaryotes | 490 | 7.999999999999998e-134 | NTclustered | gi|6980030|gb|AF223571.1|AF223571 | 5940 | g10476 | i0 | 91.008 | 39.590021691974 | 367 | 27 | 79 | 6 | 75 | 437 | 3581 | 3945 | Euplotes aediculatus internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 18251 | 490 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes aediculatus | ||
| 24397226 | 24397226 | PRJNA1044115_P_NODE_11380_length_444_cov_7.730458_g11196_i0 | PRJNA1044115 | 11380 | 444 | 7.730458 | 34.32323352 | Tetrahymena sp. KGE15 | 1200497 | SAR_Eukaryotes | SAR_Eukaryotes | 808 | 0 | NTclustered | gi|523704203|emb|HE861887.1| | 1200497 | g11196 | i0 | 99.549 | 85.213963963964 | 443 | 2 | 99 | 0 | 2 | 444 | 485 | 43 | Tetrahymena sp. KGE15 partial 28S rRNA gene, strain KGE15 | blastn | 37835 | 808 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena sp. KGE15 | ||
| 24397519 | 24397519 | PRJNA1044115_P_NODE_30840_length_265_cov_1.218750_g30656_i0 | PRJNA1044115 | 30840 | 265 | 1.21875 | 3.2296875 | Tetrahymena pigmentosa | 5907 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 5.85e-103 | NTclustered | gi|114329902|ref|NC_008339.1| | 5907 | g30656 | i0 | 93.487 | 32.222641509434 | 261 | 15 | 98 | 1 | 1 | 261 | 1812 | 1554 | Tetrahymena pigmentosa mitochondrion, complete genome | blastn | 8539 | 387 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pigmentosa | ||
| 25235038 | 25235038 | PRJNA1044115_P_NODE_18900_length_335_cov_488.232824_g18716_i0 | PRJNA1044115 | 18900 | 335 | 488.232824 | 1635.5799604 | Euplotes | 5935 | SAR_Eukaryotes | SAR_Eukaryotes | 614 | 3.209999999999999e-171 | NTclustered | gi|1233819925|gb|KX516617.1| | 440145 | g18716 | i0 | 99.701 | 99.7611940298507 | 335 | 1 | 100 | 0 | 1 | 335 | 672 | 1006 | Euplotes encysticus isolate B555 large subunit ribosomal RNA gene, partial sequence | blastn | 33420 | 614 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes encysticus |
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);;