contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1020641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6538792 | 6538792 | PRJNA1020641_P_NODE_2746_length_369_cov_1.148649_g2703_i0 | PRJNA1020641 | 2746 | 369 | 1.148649 | 4.23851481 | Ostracodinium dentatum | 358017 | SAR_Eukaryotes | SAR_Eukaryotes | 665 | 0 | NTclustered | gi|2643596965|gb|PP067637.1| | 358017 | g2703 | i0 | 99.187 | 100.49593495935 | 369 | 3 | 100 | 0 | 1 | 369 | 2649 | 2281 | Ostracodinium dentatum isolate 07.MDA32 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 37083 | 665 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Ostracodinium | Ostracodinium dentatum | ||
| 11639173 | 11639173 | PRJNA1020641_P_NODE_5310_length_257_cov_0.836957_g5267_i0 | PRJNA1020641 | 5310 | 257 | 0.836957 | 2.15097949 | Paramecium caudatum | 5885 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|6630672|dbj|AB035972.1| | 196497 | g5267 | i0 | 100 | 0.108949416342412 | 28 | 0 | 11 | 0 | 128 | 155 | 2065 | 2092 | Paramecium caudatum pap gene for PAP, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium caudatum | ||
| 12914279 | 12914279 | PRJNA1020641_P_NODE_6431_length_246_cov_0.890173_g6388_i0 | PRJNA1020641 | 6431 | 246 | 0.890173 | 2.18982558 | Ostracodinium gracile | 358022 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.4500000000000002e-123 | NTclustered | gi|2643596966|gb|PP067638.1| | 358022 | g6388 | i0 | 100 | 71.7032520325203 | 246 | 0 | 100 | 0 | 1 | 246 | 3649 | 3894 | Ostracodinium gracile isolate 04.MDA7 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 17639 | 455 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Ostracodinium | Ostracodinium gracile | ||
| 14189201 | 14189201 | PRJNA1020641_P_NODE_2732_length_370_cov_1.037037_g2689_i0 | PRJNA1020641 | 2732 | 370 | 1.037037 | 3.8370369 | Entodinium caudatum | 47911 | SAR_Eukaryotes | SAR_Eukaryotes | 484 | 2.929999999999999e-132 | NTclustered | gi|3172503|gb|AF065249.1|AF065249 | 47911 | g2689 | i0 | 90.27 | 2.12972972972973 | 370 | 36 | 100 | 0 | 1 | 370 | 406 | 37 | Entodinium caudatum 14-3-3 protein mRNA, partial cds | blastn | 788 | 484 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Entodinium | Entodinium caudatum | ||
| 14189208 | 14189208 | PRJNA1020641_P_NODE_6212_length_248_cov_0.880000_g6169_i0 | PRJNA1020641 | 6212 | 248 | 0.88 | 2.1824 | Epidinium ecaudatum | 300017 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 2.0899999999999994e-52 | NTclustered | gi|218081353|emb|AM419221.1| | 300017 | g6169 | i0 | 84.615 | 1.78225806451613 | 221 | 33 | 89 | 1 | 1 | 221 | 302 | 83 | Epidinium ecaudatum partial mRNA for cellulase (cmc-04 gene) | blastn | 442 | 219 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Epidinium | Epidinium ecaudatum | ||
| 20561737 | 20561737 | PRJNA1020641_P_NODE_6477_length_246_cov_0.890173_g6434_i0 | PRJNA1020641 | 6477 | 246 | 0.890173 | 2.18982558 | Ostracodinium gracile | 358022 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 2.57e-81 | NTclustered | gi|2253537872|gb|ON513422.1| | 358022 | g6434 | i0 | 99.422 | 0.703252032520325 | 173 | 1 | 70 | 0 | 74 | 246 | 774 | 602 | Ostracodinium gracile strain SAG1 xylanase mRNA, complete cds | blastn | 173 | 315 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Ostracodinium | Ostracodinium gracile |
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);;