contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA994052" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6377130 | 6377130 | PRJNA994052_P_NODE_20505_length_308_cov_7.642553_g19279_i0 | PRJNA994052 | 20505 | 308 | 7.642553 | 23.53906324 | Loxocephalidae | 311388 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 1.2299999999999999e-60 | NTclustered | gi|1332983250|gb|MG819725.1| | 638335 | g19279 | i0 | 96.026 | 44.5941558441558 | 151 | 6 | 49 | 0 | 1 | 151 | 1461 | 1611 | Dexiotricha colpidiopsis strain DEX201707a small subunit ribosomal RNA gene, partial sequence | blastn | 13735 | 246 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Loxocephalidae | Dexiotricha | Dexiotricha colpidiopsis | ||
| 7354446 | 7354446 | PRJNA994052_P_NODE_68406_length_214_cov_75.524823_g67150_i0 | PRJNA994052 | 68406 | 214 | 75.524823 | 161.62312122 | Spirostomum yagiui | 1471042 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.13e-5 | NTclustered | gi|2692944869|ref|NC_086648.1| | 1471042 | g67150 | i0 | 97.222 | 0.168224299065421 | 36 | 1 | 17 | 0 | 172 | 207 | 3866 | 3901 | Spirostomum yagiui isolate XKC mitochondrion, complete genome | blastn | 36 | 62.1 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Spirostomidae | Spirostomum | Spirostomum yagiui | ||
| 9904293 | 9904293 | PRJNA994052_P_NODE_14988_length_313_cov_19.487500_g13767_i0 | PRJNA994052 | 14988 | 313 | 19.4875 | 60.995875 | Sorogena stoianovitchae | 164621 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 2.67e-67 | NTclustered | gi|169659247|dbj|AB325967.1| | 164621 | g13767 | i0 | 84.706 | 79.8083067092652 | 255 | 36 | 81 | 3 | 59 | 313 | 1292 | 1041 | Sorogena stoianovitchae sbt mRNA for putative beta-tubulin, partial cds | blastn | 24980 | 268 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Sorogenida | Sorogenidae | Sorogena | Sorogena stoianovitchae | ||
| 16575884 | 16575884 | PRJNA994052_P_NODE_76993_length_204_cov_18.541985_g75736_i0 | PRJNA994052 | 76993 | 204 | 18.541985 | 37.8256494 | Euplotes | 5935 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 4.71e-38 | NTclustered | gi|405109099|emb|FR873717.1| | 5941 | g75736 | i0 | 100 | 88.093137254902 | 92 | 0 | 88 | 0 | 111 | 202 | 1189 | 1098 | Euplotes eurystomus partial 18S rRNA gene, isolate EM population | blastn | 17971 | 171 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes eurystomus | ||
| 17554167 | 17554167 | PRJNA994052_P_NODE_27934_length_287_cov_30.350467_g26693_i0 | PRJNA994052 | 27934 | 287 | 30.350467 | 87.10584029 | Opercularia sp. ZhW-2019a | 2582953 | SAR_Eukaryotes | SAR_Eukaryotes | 481 | 2.86e-131 | NTclustered | gi|2304601486|gb|OP458307.1| | 2582953 | g26693 | i0 | 98.885 | 91.5191637630662 | 269 | 3 | 94 | 0 | 18 | 286 | 330 | 62 | Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence | blastn | 26266 | 481 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Operculariidae | Opercularia | Opercularia sp. ZhW-2019a | ||
| 18828132 | 18828132 | PRJNA994052_P_NODE_33155_length_273_cov_159.475000_g31911_i0 | PRJNA994052 | 33155 | 273 | 159.475 | 435.36675 | Conchophthirus unionis | 3053525 | SAR_Eukaryotes | SAR_Eukaryotes | 390 | 4.6799999999999996e-104 | NTclustered | gi|2518630397|gb|OR129902.1| | 3053525 | g31911 | i0 | 93.846 | 94.9157509157509 | 260 | 15 | 95 | 1 | 15 | 273 | 875 | 616 | Conchophthirus unionis isolate HO 24 UC internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 25912 | 390 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Conchophthiridae | Conchophthirus | Conchophthirus unionis | ||
| 18828528 | 18828528 | PRJNA994052_P_NODE_67695_length_215_cov_63.338028_g66439_i0 | PRJNA994052 | 67695 | 215 | 63.338028 | 136.1767602 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 3.13e-10 | NTclustered | gi|829163709|ref|XM_001013641.3| | 312017 | g66439 | i0 | 77.305 | 3.94883720930233 | 141 | 26 | 64 | 6 | 68 | 205 | 495 | 358 | Tetrahymena thermophila SB210 60S ribosomal protein L11 partial mRNA | blastn | 849 | 78.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 25499667 | 25499667 | PRJNA994052_P_NODE_60220_length_225_cov_397.276316_g58964_i0 | PRJNA994052 | 60220 | 225 | 397.276316 | 893.871711 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 4.01e-54 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g58964 | i0 | 89.326 | 45.4755555555556 | 178 | 19 | 79 | 0 | 3 | 180 | 2905 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 10232 | 224 | 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);;