contig_metadata
11 rows where bioproject = "PRJNA1132896", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5386824 | 5386824 | PRJNA1132896_P_NODE_3725_length_295_cov_1.040541_g3634_i0 | PRJNA1132896 | 3725 | 295 | 1.040541 | 3.06959595 | Loxophyllum shini | 1346494 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.7900000000000002e-123 | NTclustered | gi|375305428|gb|JF975388.1| | 1346494 | g3634 | i0 | 94.558 | 98.7050847457627 | 294 | 16 | 99 | 0 | 1 | 294 | 1339 | 1046 | Loxophyllum shini isolate PHB2007053101 28S ribosomal RNA gene, partial sequence | blastn | 29118 | 455 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Pleurostomatida | Litonotidae | Loxophyllum | Loxophyllum shini | ||
| 7936660 | 7936660 | PRJNA1132896_P_NODE_5527_length_267_cov_1.474227_g5436_i0 | PRJNA1132896 | 5527 | 267 | 1.474227 | 3.93618609 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 2.5599999999999994e-24 | NR | CAD8044835.1 | 5886 | g5436 | i0 | 57.5 | 8.89887640449438 | 87 | 36 | 97.8 | 1 | 2 | 262 | 249 | 334 | CAD8044835.1 unnamed protein product [Paramecium primaurelia] | diamond | 2376 | 105 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 18135374 | 18135374 | PRJNA1132896_P_NODE_335_length_922_cov_1.478210_g261_i0 | PRJNA1132896 | 335 | 922 | 1.47821 | 13.6290962 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 446 | 1.5999999999999994e-152 | NR | XP_004032246.1 | 5932 | g261 | i0 | 68.6 | 3.98590021691974 | 306 | 95 | 99.6 | 1 | 2 | 919 | 128 | 432 | XP_004032246.1 hypothetical protein IMG5_126640 [Ichthyophthirius multifiliis] | diamond | 3675 | 446 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 18135429 | 18135429 | PRJNA1132896_P_NODE_8115_length_247_cov_0.885057_g8024_i0 | PRJNA1132896 | 8115 | 247 | 0.885057 | 2.18609079 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 4.1099999999999996e-114 | NTclustered | gi|662862630|gb|KJ000270.1| | 151077 | g8024 | i0 | 97.571 | 3.88259109311741 | 247 | 6 | 100 | 0 | 1 | 247 | 414 | 168 | Chilodonella uncinata strain ATCC PRA-256 clone P7 protein kinase domain containing protein gene, partial cds; macronuclear | blastn | 959 | 424 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 21960415 | 21960415 | PRJNA1132896_P_NODE_5238_length_271_cov_1.863636_g5147_i0 | PRJNA1132896 | 5238 | 271 | 1.863636 | 5.05045356 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|118399045|ref|XM_001031849.1| | 312017 | g5147 | i0 | 100 | 0.107011070110701 | 29 | 0 | 11 | 0 | 174 | 202 | 2034 | 2006 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 27659840 | 27659840 | PRJNA1132896_P_NODE_5264_length_271_cov_1.393939_g5173_i0 | PRJNA1132896 | 5264 | 271 | 1.393939 | 3.77757469 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 73.6 | 1.55e-14 | NR | OMJ81504.1 | 5963 | g5173 | i0 | 58.2 | 1.81549815498155 | 55 | 23 | 60.9 | 0 | 165 | 1 | 4 | 58 | OMJ81504.1 hypothetical protein SteCoe_18023 [Stentor coeruleus] | diamond | 492 | 74.3 | 0.990578734858681 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 27723235 | 27723235 | PRJNA1132896_P_NODE_3604_length_299_cov_1.194690_g3513_i0 | PRJNA1132896 | 3604 | 299 | 1.19469 | 3.5721231 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 87.8 | 1.06e-17 | NR | CAD8180374.1 | 43138 | g3513 | i0 | 48.9 | 5.438127090301 | 90 | 35 | 87.3 | 3 | 4 | 264 | 533 | 614 | CAD8180374.1 unnamed protein product [Paramecium pentaurelia] | diamond | 1626 | 88.6 | 0.99097065462754 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 28144406 | 28144406 | PRJNA1132896_P_NODE_5805_length_263_cov_1.621053_g5714_i0 | PRJNA1132896 | 5805 | 263 | 1.621053 | 4.26336939 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 7.62e-12 | NR | XP_001470894.1 | 312017 | g5714 | i0 | 44.6 | 0.946768060836502 | 83 | 42 | 93.5 | 2 | 251 | 6 | 8 | 87 | XP_001470894.1 glutathione S-transferase, amine-terminal domain protein [Tetrahymena thermophila SB210] | diamond | 249 | 68.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 29312445 | 29312445 | PRJNA1132896_P_NODE_2369_length_356_cov_1.088339_g2278_i0 | PRJNA1132896 | 2369 | 356 | 1.088339 | 3.87448684 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.0199 | NR | CAD8193241.1 | 43137 | g2278 | i0 | 34 | 0.421348314606742 | 50 | 33 | 42.1 | 0 | 356 | 207 | 435 | 484 | CAD8193241.1 unnamed protein product [Paramecium octaurelia] | diamond | 150 | 45.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 29344088 | 29344088 | PRJNA1132896_P_NODE_2049_length_378_cov_1.478689_g1958_i0 | PRJNA1132896 | 2049 | 378 | 1.478689 | 5.58944442 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 95.9 | 4.22e-20 | NR | CAG9320388.1 | 1481888 | g1958 | i0 | 39.5 | 0.984126984126984 | 124 | 73 | 98.4 | 1 | 5 | 376 | 380 | 501 | CAG9320388.1 unnamed protein product [Blepharisma stoltei] | diamond | 372 | 95.9 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 31650390 | 31650390 | PRJNA1132896_P_NODE_5877_length_262_cov_1.629630_g5786_i0 | PRJNA1132896 | 5877 | 262 | 1.62963 | 4.2696306 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 8.16e-31 | NR | CAG9318382.1 | 1481888 | g5786 | i0 | 72.4 | 0.870229007633588 | 76 | 21 | 87 | 0 | 230 | 3 | 12 | 87 | CAG9318382.1 unnamed protein product [Blepharisma stoltei] | diamond | 228 | 116 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei |
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);;