contig_metadata
16 rows where bioproject = "PRJNA624323" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1872371 | 1872371 | PRJNA624323_P_NODE_10262_length_200_cov_16.850394_g10100_i0 | PRJNA624323 | 10262 | 200 | 16.850394 | 33.700788 | uncultured ciliate | 187299 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 4.22e-98 | NTclustered | gi|1095429585|gb|KX465173.1| | 187299 | g10100 | i0 | 100 | 80.645 | 200 | 0 | 100 | 0 | 1 | 200 | 603 | 802 | Uncultured ciliate clone OL16 18S ribosomal RNA gene, partial sequence | blastn | 16129 | 370 | 1 | Eukaryota | Sar | Ciliophora | uncultured ciliate | ||||||
| 6253865 | 6253865 | PRJNA624323_P_NODE_5125_length_320_cov_5.157895_g4963_i0 | PRJNA624323 | 5125 | 320 | 5.157895 | 16.505264 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 586 | 6.65e-163 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g4963 | i0 | 99.688 | 96.334375 | 320 | 1 | 100 | 0 | 1 | 320 | 2937 | 2618 | 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 | 30827 | 586 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 6253870 | 6253870 | PRJNA624323_P_NODE_5585_length_305_cov_8.637931_g5423_i0 | PRJNA624323 | 5585 | 305 | 8.637931 | 26.34568955 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 7.31e-58 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5423 | i0 | 97.143 | 1.37704918032787 | 140 | 4 | 46 | 0 | 1 | 140 | 2943 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 420 | 237 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 6974820 | 6974820 | PRJNA624323_P_NODE_6846_length_272_cov_5.728643_g6684_i0 | PRJNA624323 | 6846 | 272 | 5.728643 | 15.58190896 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.28e-114 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g6684 | i0 | 94.853 | 3.72794117647059 | 272 | 14 | 100 | 0 | 1 | 272 | 1940 | 2211 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 1014 | 425 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 11353568 | 11353568 | PRJNA624323_P_NODE_4469_length_343_cov_23.537037_g4307_i0 | PRJNA624323 | 4469 | 343 | 23.537037 | 80.73203691 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 601 | 2.57e-167 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g4307 | i0 | 98.251 | 100.967930029155 | 343 | 6 | 100 | 0 | 1 | 343 | 1518 | 1860 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 34632 | 606 | 0.991749174917492 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 13350535 | 13350535 | PRJNA624323_P_NODE_3111_length_419_cov_2.494220_g2950_i0 | PRJNA624323 | 3111 | 419 | 2.49422 | 10.4507818 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 769 | 0 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g2950 | i0 | 99.761 | 15.7828162291169 | 419 | 1 | 100 | 0 | 1 | 419 | 212 | 630 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 6613 | 769 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 13350552 | 13350552 | PRJNA624323_P_NODE_6851_length_272_cov_3.944724_g6689_i0 | PRJNA624323 | 6851 | 272 | 3.944724 | 10.72964928 | Tetrahymena sp. KGE15 | 1200497 | SAR_Eukaryotes | SAR_Eukaryotes | 497 | 2.67e-136 | NTclustered | gi|523704203|emb|HE861887.1| | 1200497 | g6689 | i0 | 99.632 | 90.7941176470588 | 272 | 1 | 100 | 0 | 1 | 272 | 281 | 552 | Tetrahymena sp. KGE15 partial 28S rRNA gene, strain KGE15 | blastn | 24696 | 497 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena sp. KGE15 | ||
| 14625308 | 14625308 | PRJNA624323_P_NODE_9272_length_242_cov_4.627219_g9110_i0 | PRJNA624323 | 9272 | 242 | 4.627219 | 11.19786998 | Tetrahymena hegewischi | 5923 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 1.8799999999999994e-107 | NTclustered | gi|1241841581|gb|KY399445.1| | 5923 | g9110 | i0 | 97.854 | 101.96694214876 | 233 | 3 | 95 | 2 | 12 | 242 | 298 | 66 | Tetrahymena hegewischi isolate 19077-1 large subunit ribosomal RNA gene, partial sequence | blastn | 24676 | 401 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena hegewischi | ||
| 17174243 | 17174243 | PRJNA624323_P_NODE_5094_length_321_cov_6.334677_g4932_i0 | PRJNA624323 | 5094 | 321 | 6.334677 | 20.33431317 | uncultured ciliate | 187299 | SAR_Eukaryotes | SAR_Eukaryotes | 593 | 3.9899999999999986e-165 | NTclustered | gi|1095429585|gb|KX465173.1| | 187299 | g4932 | i0 | 100 | 93 | 321 | 0 | 100 | 0 | 1 | 321 | 21 | 341 | Uncultured ciliate clone OL16 18S ribosomal RNA gene, partial sequence | blastn | 29853 | 593 | 1 | Eukaryota | Sar | Ciliophora | uncultured ciliate | ||||||
| 17728048 | 17728048 | PRJNA624323_P_NODE_9594_length_239_cov_3.710843_g9432_i0 | PRJNA624323 | 9594 | 239 | 3.710843 | 8.86891477 | Helicoprorodontidae | 1607782 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 5.93e-8 | NTclustered | gi|375305434|gb|JF975394.1| | 652932 | g9432 | i0 | 95.455 | 20.2677824267782 | 44 | 2 | 18 | 0 | 196 | 239 | 206 | 249 | Trachelotractus entzi isolate LWW07033111 28S ribosomal RNA gene, partial sequence | blastn | 4844 | 71.3 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Trachelotractus | Trachelotractus entzi | |||
| 18448437 | 18448437 | PRJNA624323_P_NODE_6075_length_291_cov_12.380734_g5913_i0 | PRJNA624323 | 6075 | 291 | 12.380734 | 36.02793594 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 4.2e-50 | NTclustered | gi|49616744|gb|AY643504.1| | 282688 | g5913 | i0 | 92.568 | 47.319587628866 | 148 | 9 | 51 | 2 | 2 | 148 | 243 | 97 | Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence | blastn | 13770 | 211 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 23548859 | 23548859 | PRJNA624323_P_NODE_4799_length_332_cov_2.347490_g4637_i0 | PRJNA624323 | 4799 | 332 | 2.34749 | 7.7936668 | Naviculales sp. | 2126271 | SAR_Eukaryotes | SAR_Eukaryotes | 595 | 1.1499999999999998e-165 | NTclustered | gi|2633519340|gb|OR805654.1| | 2126271 | g4637 | i0 | 99.094 | 197.403614457831 | 331 | 3 | 99 | 0 | 1 | 331 | 121191 | 121521 | Naviculales sp. strain SZCZO2114 plastid, complete genome | blastn | 65538 | 595 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculales sp. | ||||
| 24102005 | 24102005 | PRJNA624323_P_NODE_5219_length_317_cov_5.995902_g5057_i0 | PRJNA624323 | 5219 | 317 | 5.995902 | 19.00700934 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 542 | 1.45e-149 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5057 | i0 | 97.476 | 8.93375394321767 | 317 | 8 | 100 | 0 | 1 | 317 | 1525 | 1841 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 2832 | 542 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 24102030 | 24102030 | PRJNA624323_P_NODE_9419_length_241_cov_3.148810_g9257_i0 | PRJNA624323 | 9419 | 241 | 3.14881 | 7.5886321 | Navicula | 50949 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 3.959999999999999e-119 | NTclustered | gi|2088232843|ref|NC_056794.1| | 138539 | g9257 | i0 | 99.585 | 197.979253112033 | 241 | 1 | 100 | 0 | 1 | 241 | 86131 | 86371 | Navicula veneta isolate SZCZR1826 chloroplast, complete genome | blastn | 47713 | 440 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Navicula | Navicula veneta | ||
| 24822559 | 24822559 | PRJNA624323_P_NODE_4140_length_358_cov_20.150877_g3978_i0 | PRJNA624323 | 4140 | 358 | 20.150877 | 72.14013966 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 656 | 0 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g3978 | i0 | 99.721 | 51.6787709497207 | 358 | 1 | 100 | 0 | 1 | 358 | 3323 | 2966 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 18501 | 656 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 24822569 | 24822569 | PRJNA624323_P_NODE_7160_length_265_cov_17.270833_g6998_i0 | PRJNA624323 | 7160 | 265 | 17.270833 | 45.76770745 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 9.579999999999999e-116 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g6998 | i0 | 95.849 | 6.22264150943396 | 265 | 11 | 100 | 0 | 1 | 265 | 332 | 68 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 1649 | 429 | 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);;