contig_metadata
7 rows where bioproject = "PRJNA1036688", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2283328 | 2283328 | PRJNA1036688_P_NODE_4402_length_298_cov_2.938697_g4110_i0 | PRJNA1036688 | 4402 | 298 | 2.938697 | 8.75731706 | Colpodida | 88566 | SAR_Eukaryotes | SAR_Eukaryotes | 542 | 1.35e-149 | NTclustered | gi|156499055|gb|EU039885.1| | 459237 | g4110 | i0 | 99.333 | 100.395973154362 | 300 | 0 | 100 | 2 | 1 | 298 | 51 | 350 | Bresslauides discoideus 18S ribosomal RNA gene, partial sequence; macronuclear | blastn | 29918 | 542 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Hausmanniellidae | Bresslauides | Bresslauides discoideus | ||
| 7822312 | 7822312 | PRJNA1036688_P_NODE_8967_length_182_cov_1.048276_g8675_i0 | PRJNA1036688 | 8967 | 182 | 1.048276 | 1.90786232 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 3.9e-73 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g8675 | i0 | 95.055 | 3.53846153846154 | 182 | 9 | 100 | 0 | 1 | 182 | 2007 | 2188 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 644 | 287 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 10372931 | 10372931 | PRJNA1036688_P_NODE_8629_length_186_cov_2.322148_g8337_i0 | PRJNA1036688 | 8629 | 186 | 2.322148 | 4.31919528 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 8.61e-75 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g8337 | i0 | 95.161 | 45.8225806451613 | 186 | 7 | 100 | 2 | 1 | 186 | 3368 | 3551 | Colpoda sp. isolate CIL1 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 | 8523 | 292 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 11648193 | 11648193 | PRJNA1036688_P_NODE_6530_length_225_cov_1.909574_g6238_i0 | PRJNA1036688 | 6530 | 225 | 1.909574 | 4.2965415 | Lamtostyla gui | 2678605 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 2.97e-85 | NTclustered | gi|1778223994|gb|MN733822.1| | 2678605 | g6238 | i0 | 92.889 | 100.133333333333 | 225 | 16 | 100 | 0 | 1 | 225 | 4923 | 4699 | Lamtostyla gui isolate LWY2015111409 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 | 22530 | 327 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Stichotrichida | Amphisiellidae | Lamtostyla | Lamtostyla gui | ||
| 16746614 | 16746614 | PRJNA1036688_P_NODE_12294_length_150_cov_1.362832_g12002_i0 | PRJNA1036688 | 12294 | 150 | 1.362832 | 2.044248 | Sterkiella histriomuscorum | 94289 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 1.97e-25 | NTclustered | gi|47176397|gb|AY617977.1| | 94289 | g12002 | i0 | 87.5 | 6.81333333333333 | 112 | 12 | 74 | 2 | 32 | 142 | 455 | 345 | Sterkiella histriomuscorum clone UGC1O0006_M16_R genomic sequence | blastn | 1022 | 128 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 20570867 | 20570867 | PRJNA1036688_P_NODE_9137_length_179_cov_3.352113_g8845_i0 | PRJNA1036688 | 9137 | 179 | 3.352113 | 6.00028227 | Parabistichella variabilis | 1071703 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 2.91e-84 | NTclustered | gi|751363249|gb|KP266659.1| | 1071703 | g8845 | i0 | 99.438 | 99.195530726257 | 178 | 1 | 99 | 0 | 1 | 178 | 1528 | 1705 | Parabistichella variabilis isolate B102 28S ribosomal RNA gene, partial sequence | blastn | 17756 | 324 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Parabistichella | Parabistichella variabilis | ||||
| 32501520 | 32501520 | PRJNA1036688_P_NODE_8099_length_194_cov_2.210191_g7807_i0 | PRJNA1036688 | 8099 | 194 | 2.210191 | 4.28777054 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 52 | 5.61e-6 | NR | KRX05597.1 | 266149 | g7807 | i0 | 60.9 | 1.31443298969072 | 46 | 16 | 68 | 1 | 61 | 192 | 49 | 94 | KRX05597.1 Ribosomal protein L6, alpha-beta domain [Pseudocohnilembus persalinus] | diamond | 255 | 52 | 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);;