contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1248424" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 353149 | 353149 | PRJNA1248424_P_NODE_75621_length_245_cov_0.895349_g69552_i0 | PRJNA1248424 | 75621 | 245 | 0.895349 | 2.19360505 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 7.41e-52 | NTclustered | gi|2386235661|ref|XM_001440072.2| | 5888 | g69552 | i0 | 83.913 | 3.09387755102041 | 230 | 34 | 94 | 3 | 13 | 242 | 1015 | 1241 | Paramecium tetraurelia uncharacterized protein (GSPATT00009104001), mRNA | blastn | 758 | 217 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 10556880 | 10556880 | PRJNA1248424_P_NODE_47469_length_322_cov_3.449799_g41402_i0 | PRJNA1248424 | 47469 | 322 | 3.449799 | 11.10835278 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 527 | 4.119999999999998e-145 | NTclustered | gi|194245783|gb|EU828456.1| | 5888 | g41402 | i0 | 96.273 | 99.9192546583851 | 322 | 10 | 100 | 1 | 1 | 322 | 1805 | 1486 | Paramecium tetraurelia large subunit ribosomal RNA gene, complete sequence | blastn | 32174 | 527 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 14382159 | 14382159 | PRJNA1248424_P_NODE_60432_length_274_cov_2.099502_g54364_i0 | PRJNA1248424 | 60432 | 274 | 2.099502 | 5.75263548 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 4.7299999999999984e-99 | NTclustered | gi|2386227721|ref|XM_001430998.2| | 5888 | g54364 | i0 | 91.513 | 3.94160583941606 | 271 | 23 | 99 | 0 | 4 | 274 | 272 | 2 | Paramecium tetraurelia uncharacterized protein (GSPATT00033490001), partial mRNA | blastn | 1080 | 374 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 16354318 | 16354318 | PRJNA1248424_P_NODE_51273_length_302_cov_2.397380_g45205_i0 | PRJNA1248424 | 51273 | 302 | 2.39738 | 7.2400876 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 553 | 6.32e-153 | NTclustered | gi|1899794309|gb|MT975644.1| | 5887 | g45205 | i0 | 99.669 | 99.9867549668874 | 302 | 1 | 100 | 0 | 1 | 302 | 1236 | 1537 | Paramecium sp. strain RB1 small subunit ribosomal RNA gene, partial sequence | blastn | 30196 | 553 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sp. | ||
| 18204734 | 18204734 | PRJNA1248424_P_NODE_61295_length_272_cov_1.447236_g55227_i0 | PRJNA1248424 | 61295 | 272 | 1.447236 | 3.93648192 | Paramecium multimicronucleatum | 44030 | SAR_Eukaryotes | SAR_Eukaryotes | 497 | 2.67e-136 | NTclustered | gi|519419878|gb|KF287718.1| | 44030 | g55227 | i0 | 99.632 | 96.8125 | 272 | 1 | 100 | 0 | 1 | 272 | 557 | 286 | Paramecium multimicronucleatum isolate 2_m large subunit ribosomal RNA gene, partial sequence | blastn | 26333 | 497 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium multimicronucleatum | ||
| 20178059 | 20178059 | PRJNA1248424_P_NODE_67016_length_256_cov_1.737705_g60947_i0 | PRJNA1248424 | 67016 | 256 | 1.737705 | 4.4485248 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 470 | 5.42e-128 | NTclustered | gi|1899794309|gb|MT975644.1| | 5887 | g60947 | i0 | 100 | 98.51171875 | 254 | 0 | 99 | 0 | 1 | 254 | 520 | 773 | Paramecium sp. strain RB1 small subunit ribosomal RNA gene, partial sequence | blastn | 25219 | 470 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sp. | ||
| 20754148 | 20754148 | PRJNA1248424_P_NODE_41777_length_359_cov_1.115385_g35715_i0 | PRJNA1248424 | 41777 | 359 | 1.115385 | 4.00423215 | Oxytricha trifallax | 1172189 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.034 | NTclustered | gi|359817572|gb|JN383843.1| | 1172189 | g35715 | i0 | 100 | 0.0779944289693593 | 28 | 0 | 8 | 0 | 137 | 164 | 52030 | 52057 | Oxytricha trifallax mitochondrion | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Oxytricha | Oxytricha trifallax |
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);;