contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA888821" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2517323 | 2517323 | PRJNA888821_P_NODE_2402_length_418_cov_2.231884_g2324_i0 | PRJNA888821 | 2402 | 418 | 2.231884 | 9.32927512 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 750 | 0 | NTclustered | gi|126142771|gb|EF070244.1| | 5896 | g2324 | i0 | 99.043 | 99.9497607655502 | 418 | 4 | 100 | 0 | 1 | 418 | 1207 | 1624 | Tetrahymena caudata strain MP49 18S small subunit ribosomal RNA gene, partial sequence | blastn | 41779 | 756 | 0.992063492063492 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena caudata | ||
| 4691419 | 4691419 | PRJNA888821_P_NODE_41264_length_234_cov_6.732919_g41181_i0 | PRJNA888821 | 41264 | 234 | 6.732919 | 15.75503046 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 5.17e-88 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g41181 | i0 | 95.283 | 5.86752136752137 | 212 | 10 | 91 | 0 | 23 | 234 | 140 | 351 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 1373 | 337 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 7241208 | 7241208 | PRJNA888821_P_NODE_4626_length_340_cov_3.134831_g4544_i0 | PRJNA888821 | 4626 | 340 | 3.134831 | 10.6584254 | Tetrahymena rostrata | 5909 | SAR_Eukaryotes | SAR_Eukaryotes | 590 | 5.499999999999999e-164 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g4544 | i0 | 97.941 | 86.3705882352941 | 340 | 7 | 100 | 0 | 1 | 340 | 4554 | 4215 | 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 | 29366 | 590 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 11066239 | 11066239 | PRJNA888821_P_NODE_24009_length_295_cov_1.378378_g23927_i0 | PRJNA888821 | 24009 | 295 | 1.378378 | 4.0662151 | Sterkiella nova | 200597 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 9.24e-47 | NTclustered | gi|13399229|emb|AJ305329.1| | 200597 | g23927 | i0 | 81.933 | 0.806779661016949 | 238 | 41 | 80 | 2 | 57 | 293 | 377 | 141 | Oxytricha nova macronuclear rps26 gene for S26 ribosomal protein | blastn | 238 | 200 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella nova | ||
| 12341766 | 12341766 | PRJNA888821_P_NODE_1950_length_445_cov_3.250000_g1875_i0 | PRJNA888821 | 1950 | 445 | 3.25 | 14.4625 | Tetrahymena acanthophora | 2704174 | SAR_Eukaryotes | SAR_Eukaryotes | 806 | 0 | NTclustered | gi|2082965250|gb|MZ827090.1| | 2704174 | g1875 | i0 | 99.326 | 81.6 | 445 | 3 | 100 | 0 | 1 | 445 | 1107 | 663 | Tetrahymena acanthophora isolate NB176 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 | 36312 | 806 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena acanthophora | ||
| 16165656 | 16165656 | PRJNA888821_P_NODE_37013_length_246_cov_0.890173_g36930_i0 | PRJNA888821 | 37013 | 246 | 0.890173 | 2.18982558 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 394 | 3.2e-105 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g36930 | i0 | 95.528 | 3.76422764227642 | 246 | 11 | 100 | 0 | 1 | 246 | 1961 | 2206 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 926 | 394 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 21265100 | 21265100 | PRJNA888821_P_NODE_48697_length_209_cov_11.691176_g48614_i0 | PRJNA888821 | 48697 | 209 | 11.691176 | 24.43455784 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 7.72e-71 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g48614 | i0 | 91.262 | 13.8038277511962 | 206 | 16 | 98 | 2 | 1 | 205 | 49 | 253 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 2885 | 279 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 21644316 | 21644316 | PRJNA888821_P_NODE_937_length_556_cov_3.766046_g865_i0 | PRJNA888821 | 937 | 556 | 3.766046 | 20.93921576 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 1022 | 0 | NTclustered | gi|1216315|gb|U17356.1|TCU17356 | 5914 | g865 | i0 | 99.82 | 98.9694244604317 | 556 | 1 | 100 | 0 | 1 | 556 | 14 | 569 | Tetrahymena corlissi 18S rRNA | blastn | 55027 | 1022 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena corlissi | ||
| 24193220 | 24193220 | PRJNA888821_P_NODE_1839_length_453_cov_3.500000_g1764_i0 | PRJNA888821 | 1839 | 453 | 3.5 | 15.855 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 832 | 0 | NTclustered | gi|2624251057|gb|OR858827.1| | 5914 | g1764 | i0 | 99.779 | 100.008830022075 | 453 | 1 | 100 | 0 | 1 | 453 | 532 | 984 | Tetrahymena corlissi isolate LLH20220320 small subunit ribosomal RNA gene, partial sequence | blastn | 45304 | 837 | 0.994026284348865 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena corlissi | ||
| 25089325 | 25089325 | PRJNA888821_P_NODE_9160_length_310_cov_12.257384_g9078_i0 | PRJNA888821 | 9160 | 310 | 12.257384 | 37.9978904 | Trithigmostoma cucullulus | 1346499 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 1.69e-19 | NTclustered | gi|759083539|gb|KM222156.1| | 1346499 | g9078 | i0 | 83.333 | 27.7483870967742 | 120 | 18 | 38 | 2 | 189 | 307 | 716 | 834 | Trithigmostoma cucullulus voucher CXM08110902 large subunit ribosomal RNA gene, partial sequence | blastn | 8602 | 110 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Trithigmostoma | Trithigmostoma cucullulus |
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);;