contig_metadata
20 rows where bioproject = "PRJNA688736" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 668241 | 668241 | PRJNA688736_P_NODE_51341_length_234_cov_2.422360_g51056_i0 | PRJNA688736 | 51341 | 234 | 2.42236 | 5.6683224 | Opisthonecta sp. FG-2015 | 1607889 | SAR_Eukaryotes | SAR_Eukaryotes | 422 | 1.39e-113 | NTclustered | gi|759083562|gb|KM222179.1| | 1607889 | g51056 | i0 | 99.145 | 99.5470085470085 | 234 | 2 | 100 | 0 | 1 | 234 | 1677 | 1444 | Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence | blastn | 23294 | 422 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta sp. FG-2015 | ||
| 2452470 | 2452470 | PRJNA688736_P_NODE_17942_length_365_cov_1.691781_g17657_i0 | PRJNA688736 | 17942 | 365 | 1.691781 | 6.17500065 | root | 1 | Root_unresolved | Root_unresolved | 665 | 0 | NTclustered | gi|363412127|gb|JN120201.1| | 6026 | g17657 | i0 | 99.455 | 100.550684931507 | 367 | 0 | 100 | 1 | 1 | 365 | 447 | 813 | Opisthonecta henneguyi isolate 43Opisthonectau1S1S2 18S ribosomal RNA gene, partial sequence | blastn | 36701 | 665 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta henneguyi | ||
| 6281425 | 6281425 | PRJNA688736_P_NODE_29285_length_295_cov_1.783784_g29000_i0 | PRJNA688736 | 29285 | 295 | 1.783784 | 5.2621628 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 540 | 4.79e-149 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g29000 | i0 | 99.661 | 100.237288135593 | 295 | 1 | 100 | 0 | 1 | 295 | 2984 | 2690 | Colpoda sp. isolate JGP15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 29570 | 540 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 6281538 | 6281538 | PRJNA688736_P_NODE_33425_length_277_cov_3.352941_g33140_i0 | PRJNA688736 | 33425 | 277 | 3.352941 | 9.28764657 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 512 | 9.73e-141 | NTclustered | gi|2065561668|gb|MZ540265.1| | 44029 | g33140 | i0 | 100 | 99.6028880866426 | 277 | 0 | 100 | 0 | 1 | 277 | 23 | 299 | Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence | blastn | 27590 | 512 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium jenningsi | ||
| 8830162 | 8830162 | PRJNA688736_P_NODE_19347_length_353_cov_11.435714_g19062_i0 | PRJNA688736 | 19347 | 353 | 11.435714 | 40.36807042 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 652 | 0 | NTclustered | gi|1202134875|gb|KY454454.1| | 63136 | g19062 | i0 | 100 | 98.9886685552408 | 353 | 0 | 100 | 0 | 1 | 353 | 8 | 360 | Colpoda steinii 18S ribosomal RNA gene, partial sequence | blastn | 34943 | 652 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda steini | ||
| 8830817 | 8830817 | PRJNA688736_P_NODE_49467_length_243_cov_0.917647_g49182_i0 | PRJNA688736 | 49467 | 243 | 0.917647 | 2.22988221 | Tetrahymenidae | 291294 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.0599999999999998e-31 | NR | XP_004029989.1 | 5932 | g49182 | i0 | 71.3 | 1.97530864197531 | 80 | 23 | 98.8 | 0 | 2 | 241 | 375 | 454 | XP_004029989.1 hypothetical protein IMG5_169500 [Ichthyophthirius multifiliis] | diamond | 480 | 127 | 0.992125984251969 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 9596722 | 9596722 | PRJNA688736_P_NODE_47928_length_245_cov_0.906977_g47643_i0 | PRJNA688736 | 47928 | 245 | 0.906977 | 2.22209365 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 9.79e-28 | NR | QBH22568.1 | 282688 | g47643 | i0 | 72.8 | 0.991836734693878 | 81 | 22 | 99.2 | 0 | 245 | 3 | 767 | 847 | QBH22568.1 V-type proton ATPase subunit a [Philasterides dicentrarchi] | diamond | 243 | 115 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 12147493 | 12147493 | PRJNA688736_P_NODE_47730_length_245_cov_0.906977_g47445_i0 | PRJNA688736 | 47730 | 245 | 0.906977 | 2.22209365 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 5.65e-63 | NTclustered | gi|829100487|ref|XM_001007447.3| | 312017 | g47445 | i0 | 85.306 | 4.57959183673469 | 245 | 36 | 100 | 0 | 1 | 245 | 725 | 481 | Tetrahymena thermophila SB210 transitional endoplasmic reticulum ATPase, putative partial mRNA | blastn | 1122 | 254 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 13422031 | 13422031 | PRJNA688736_P_NODE_45531_length_247_cov_0.896552_g45246_i0 | PRJNA688736 | 45531 | 247 | 0.896552 | 2.21448344 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 7.59e-42 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g45246 | i0 | 82.464 | 10.1457489878543 | 211 | 35 | 85 | 2 | 37 | 246 | 420 | 211 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 2506 | 183 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15969970 | 15969970 | PRJNA688736_P_NODE_10213_length_468_cov_1.326582_g9928_i0 | PRJNA688736 | 10213 | 468 | 1.326582 | 6.20840376 | Opisthonecta sp. FG-2015 | 1607889 | SAR_Eukaryotes | SAR_Eukaryotes | 791 | 0 | NTclustered | gi|759083562|gb|KM222179.1| | 1607889 | g9928 | i0 | 97.222 | 96.6282051282051 | 468 | 12 | 100 | 1 | 1 | 468 | 819 | 353 | Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence | blastn | 45222 | 791 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta sp. FG-2015 | ||
| 19794587 | 19794587 | PRJNA688736_P_NODE_26816_length_307_cov_3.324786_g26531_i0 | PRJNA688736 | 26816 | 307 | 3.324786 | 10.20709302 | Vorticella sp. | 2219883 | SAR_Eukaryotes | SAR_Eukaryotes | 568 | 2.3e-157 | NTclustered | gi|2217167749|gb|ON157274.1| | 2219883 | g26531 | i0 | 100 | 98.1693811074919 | 307 | 0 | 100 | 0 | 1 | 307 | 1676 | 1370 | Vorticella sp. isolate BP174 small subunit ribosomal RNA gene, partial sequence | blastn | 30138 | 568 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. | ||
| 20304302 | 20304302 | PRJNA688736_P_NODE_51696_length_209_cov_5.058824_g51411_i0 | PRJNA688736 | 51696 | 209 | 5.058824 | 10.57294216 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 385 | 1.59e-102 | NTclustered | gi|1802599794|gb|MT001203.1| | 41631 | g51411 | i0 | 100 | 99.6028708133971 | 208 | 0 | 99 | 0 | 1 | 208 | 1356 | 1563 | Colpoda sp. strain HFCC848 small subunit ribosomal RNA gene, partial sequence | blastn | 20817 | 385 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 21579291 | 21579291 | PRJNA688736_P_NODE_14297_length_403_cov_14.336364_g14012_i0 | PRJNA688736 | 14297 | 403 | 14.336364 | 57.77554692 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 743 | 0 | NTclustered | gi|1802599797|gb|MT001206.1| | 41631 | g14012 | i0 | 100 | 98.9205955334988 | 402 | 0 | 99 | 0 | 1 | 402 | 508 | 909 | Colpoda sp. strain HFCC1227 small subunit ribosomal RNA gene, partial sequence | blastn | 39865 | 743 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 21579762 | 21579762 | PRJNA688736_P_NODE_33117_length_279_cov_1.135922_g32832_i0 | PRJNA688736 | 33117 | 279 | 1.135922 | 3.16922238 | Colpodidae | 5978 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 1.3000000000000002e-124 | NTclustered | gi|2166921685|gb|OL894853.1| | 63136 | g32832 | i0 | 96.416 | 11.2293906810036 | 279 | 8 | 100 | 2 | 1 | 279 | 789 | 513 | Colpoda steini clone MITTA small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 3133 | 459 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda steini | ||
| 29335926 | 29335926 | PRJNA688736_P_NODE_43809_length_249_cov_0.886364_g43524_i0 | PRJNA688736 | 43809 | 249 | 0.886364 | 2.20704636 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 4.74e-9 | NR | XP_001444384.1 | 5888 | g43524 | i0 | 40.5 | 4.74698795180723 | 79 | 42 | 95.2 | 1 | 248 | 12 | 101 | 174 | XP_001444384.1 uncharacterized protein GSPATT00012511001 [Paramecium tetraurelia] | diamond | 1182 | 62.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 29967518 | 29967518 | PRJNA688736_P_NODE_47031_length_246_cov_0.901734_g46746_i0 | PRJNA688736 | 47031 | 246 | 0.901734 | 2.21826564 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 1.9499999999999999e-31 | NR | XP_012653439.1 | 312017 | g46746 | i0 | 69.1 | 2.96341463414634 | 81 | 25 | 98.8 | 0 | 245 | 3 | 23 | 103 | XP_012653439.1 60S ribosomal protein L17 [Tetrahymena thermophila SB210] | diamond | 729 | 119 | 0.991596638655462 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30967082 | 30967082 | PRJNA688736_P_NODE_45854_length_247_cov_0.896552_g45569_i0 | PRJNA688736 | 45854 | 247 | 0.896552 | 2.21448344 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 2.51e-24 | NR | OMJ78935.1 | 5963 | g45569 | i0 | 59.3 | 0.983805668016194 | 81 | 32 | 98.4 | 1 | 245 | 3 | 333 | 412 | OMJ78935.1 hypothetical protein SteCoe_21156 [Stentor coeruleus] | diamond | 243 | 105 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 31883856 | 31883856 | PRJNA688736_P_NODE_45757_length_247_cov_0.896552_g45472_i0 | PRJNA688736 | 45757 | 247 | 0.896552 | 2.21448344 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 4.26e-16 | NR | XP_001426365.1 | 5888 | g45472 | i0 | 44.9 | 0.947368421052632 | 78 | 43 | 94.7 | 0 | 2 | 235 | 151 | 228 | XP_001426365.1 uncharacterized protein GSPATT00029597001 [Paramecium tetraurelia] | diamond | 234 | 82.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 32200400 | 32200400 | PRJNA688736_P_NODE_9958_length_473_cov_3.570000_g9674_i0 | PRJNA688736 | 9958 | 473 | 3.57 | 16.8861 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 3.27e-5 | NR | CAG9310987.1 | 1481888 | g9674 | i0 | 35.1 | 0.596194503171247 | 94 | 56 | 59 | 2 | 401 | 123 | 231 | 320 | CAG9310987.1 unnamed protein product [Blepharisma stoltei] | diamond | 282 | 54.3 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 32232260 | 32232260 | PRJNA688736_P_NODE_48618_length_244_cov_0.912281_g48333_i0 | PRJNA688736 | 48618 | 244 | 0.912281 | 2.22596564 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 1.44e-5 | NR | KRX06315.1 | 266149 | g48333 | i0 | 37.9 | 1.45081967213115 | 58 | 36 | 71.3 | 0 | 241 | 68 | 265 | 322 | KRX06315.1 Protein kinase-like domain [Pseudocohnilembus persalinus] | diamond | 354 | 52.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus |
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);;