contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1035005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 169036 | 169036 | PRJNA1035005_P_NODE_67481_length_248_cov_0.891429_g67075_i0 | PRJNA1035005 | 67481 | 248 | 0.891429 | 2.21074392 | Sterkiella nova | 200597 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 6.11e-18 | NTclustered | gi|405113123|gb|JX441315.1| | 200597 | g67075 | i0 | 87.778 | 0.362903225806452 | 90 | 10 | 36 | 1 | 5 | 93 | 341 | 252 | Sterkiella nova macronuclear nanochromosome, complete sequence | blastn | 90 | 104 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella nova | ||
| 3558591 | 3558591 | PRJNA1035005_P_NODE_79763_length_244_cov_0.912281_g79357_i0 | PRJNA1035005 | 79763 | 244 | 0.912281 | 2.22596564 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 4.47e-44 | NTclustered | gi|10793|emb|X12769.1| | 5908 | g79357 | i0 | 82.488 | 60.2172131147541 | 217 | 38 | 89 | 0 | 1 | 217 | 345 | 129 | Tetrahymena pyriformis beta-tubulin gene 2 (beta-TT2) | blastn | 14693 | 191 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 3995489 | 3995489 | PRJNA1035005_P_NODE_57784_length_252_cov_0.871508_g57378_i0 | PRJNA1035005 | 57784 | 252 | 0.871508 | 2.19620016 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 5.96e-48 | NTclustered | gi|290684|gb|J04534.1|EUPBTUB | 5936 | g57378 | i0 | 82.353 | 96.2539682539683 | 238 | 38 | 94 | 4 | 1 | 236 | 1309 | 1074 | E.crassus macronuclear beta-tubulin gene, complete cds | blastn | 24256 | 204 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 7821341 | 7821341 | PRJNA1035005_P_NODE_25287_length_289_cov_1.134259_g24881_i0 | PRJNA1035005 | 25287 | 289 | 1.134259 | 3.27800851 | Euplotes focardii | 36767 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 2.49e-52 | NTclustered | gi|603435|gb|S72098.1| | 36767 | g24881 | i0 | 87.368 | 57.8442906574394 | 190 | 24 | 66 | 0 | 100 | 289 | 1320 | 1131 | Euplotes focardii beta-tubulin gene, complete cds | blastn | 16717 | 219 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes focardii | ||
| 8660959 | 8660959 | PRJNA1035005_P_NODE_3147_length_620_cov_3.012797_g2757_i0 | PRJNA1035005 | 3147 | 620 | 3.012797 | 18.6793414 | Isotricha | 5986 | SAR_Eukaryotes | SAR_Eukaryotes | 608 | 2.9099999999999987e-169 | NTclustered | gi|92790159|emb|AJ965265.1| | 5987 | g2757 | i0 | 84.466 | 192.527419354839 | 618 | 95 | 99 | 1 | 2 | 619 | 160 | 776 | Isotricha prostoma partial mRNA for Polyubiqutin 3 (polyubiqutin 3 gene) | blastn | 119367 | 610 | 0.99672131147541 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Isotricha | Isotricha prostoma | ||
| 9935825 | 9935825 | PRJNA1035005_P_NODE_10408_length_360_cov_1.087108_g10003_i0 | PRJNA1035005 | 10408 | 360 | 1.087108 | 3.9135888 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 322 | 2.35e-83 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g10003 | i0 | 98.361 | 56.8722222222222 | 183 | 3 | 51 | 0 | 1 | 183 | 2900 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 20474 | 322 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 13761292 | 13761292 | PRJNA1035005_P_NODE_6171_length_431_cov_1.907821_g5769_i0 | PRJNA1035005 | 6171 | 431 | 1.907821 | 8.22270851 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.012 | NTclustered | gi|471232194|ref|XM_004037166.1| | 5932 | g5769 | i0 | 96.875 | 0.206496519721578 | 32 | 1 | 7 | 0 | 246 | 277 | 1407 | 1376 | Ichthyophthirius multifiliis hypothetical protein (IMG5_058710) mRNA, partial cds | blastn | 89 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 19294863 | 19294863 | PRJNA1035005_P_NODE_70356_length_247_cov_0.896552_g69950_i0 | PRJNA1035005 | 70356 | 247 | 0.896552 | 2.21448344 | Planilamina ovata | 2684848 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 9.14e-91 | NTclustered | gi|1784308423|gb|MN830171.1| | 2684848 | g69950 | i0 | 94.273 | 18.3643724696356 | 227 | 11 | 91 | 2 | 22 | 247 | 1772 | 1547 | Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence | blastn | 4536 | 346 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Dysteriida | Kyaroikeidae | Planilamina | Planilamina ovata |
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);;