contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA177642" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 365436 | 365436 | PRJNA177642_P_NODE_15641_length_183_cov_2.012987_g14416_i0 | PRJNA177642 | 15641 | 183 | 2.012987 | 3.68376621 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 5.109999999999999e-67 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g14416 | i0 | 92.896 | 3 | 183 | 13 | 100 | 0 | 1 | 183 | 445 | 627 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 549 | 267 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 365458 | 365458 | PRJNA177642_P_NODE_16641_length_171_cov_1.014085_g15416_i0 | PRJNA177642 | 16641 | 171 | 1.014085 | 1.73408535 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 3.08e-4 | NTclustered | gi|916497612|ref|XM_013494182.1| | 44415 | g15416 | i0 | 94.595 | 0.385964912280702 | 37 | 2 | 22 | 0 | 121 | 157 | 182 | 146 | Eimeria mitis uncharacterized protein (EMH_0028660), partial mRNA | blastn | 66 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 1640262 | 1640262 | PRJNA177642_P_NODE_17402_length_167_cov_1.036232_g16177_i0 | PRJNA177642 | 17402 | 167 | 1.036232 | 1.73050744 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 1.01e-53 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g16177 | i0 | 96.296 | 76.3173652694611 | 135 | 5 | 81 | 0 | 33 | 167 | 2807 | 2673 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 12745 | 222 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 6157847 | 6157847 | PRJNA177642_P_NODE_14225_length_218_cov_1.634921_g13000_i0 | PRJNA177642 | 14225 | 218 | 1.634921 | 3.56412778 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 2.92e-70 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g13000 | i0 | 98.113 | 3.64220183486239 | 159 | 3 | 73 | 0 | 1 | 159 | 2924 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 794 | 278 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 8707891 | 8707891 | PRJNA177642_P_NODE_5527_length_604_cov_3.186087_g4450_i0 | PRJNA177642 | 5527 | 604 | 3.186087 | 19.24396548 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 575 | 2.869999999999999e-159 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g4450 | i0 | 97.067 | 54.8791390728477 | 341 | 10 | 98 | 0 | 264 | 604 | 2345 | 2005 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 33147 | 580 | 0.991379310344828 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 11844021 | 11844021 | PRJNA177642_P_NODE_15410_length_188_cov_1.169811_g14185_i0 | PRJNA177642 | 15410 | 188 | 1.169811 | 2.19924468 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 8.72e-75 | NTclustered | gi|347439295|gb|JN111996.1| | 151077 | g14185 | i0 | 94.681 | 96.8351063829787 | 188 | 10 | 100 | 0 | 1 | 188 | 556 | 369 | Chilodonella uncinata strain USA_SC2 alpha-tubulin (atub) gene, partial cds; macronuclear | blastn | 18205 | 292 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 16357511 | 16357511 | PRJNA177642_P_NODE_13253_length_264_cov_4.123404_g12028_i0 | PRJNA177642 | 13253 | 264 | 4.123404 | 10.88578656 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 477 | 3.359999999999999e-130 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g12028 | i0 | 99.242 | 14.1931818181818 | 264 | 2 | 100 | 0 | 1 | 264 | 1775 | 1512 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 3747 | 477 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 18906585 | 18906585 | PRJNA177642_P_NODE_18595_length_162_cov_1.082707_g17370_i0 | PRJNA177642 | 18595 | 162 | 1.082707 | 1.75398534 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.36e-77 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g17370 | i0 | 100 | 26.962962962963 | 162 | 0 | 100 | 0 | 1 | 162 | 1209 | 1370 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 4368 | 300 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 19491459 | 19491459 | PRJNA177642_P_NODE_16196_length_174_cov_1.703448_g14971_i0 | PRJNA177642 | 16196 | 174 | 1.703448 | 2.96399952 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 2.3e-45 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g14971 | i0 | 88.679 | 40.0402298850575 | 159 | 18 | 99 | 0 | 16 | 174 | 299232 | 299390 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 6967 | 195 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 22042309 | 22042309 | PRJNA177642_P_NODE_7558_length_459_cov_1.527907_g6371_i0 | PRJNA177642 | 7558 | 459 | 1.527907 | 7.01309313 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 2.4299999999999997e-69 | NTclustered | gi|158347525|gb|EU047814.1| | 151077 | g6371 | i0 | 93.085 | 36.7712418300654 | 188 | 13 | 41 | 0 | 271 | 458 | 97 | 284 | Chilodonella uncinata clone Shared_P1 beta-tubulin gene, partial cds; macronuclear | blastn | 16878 | 276 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24007062 | 24007062 | PRJNA177642_P_NODE_10999_length_334_cov_2.219672_g9774_i0 | PRJNA177642 | 10999 | 334 | 2.219672 | 7.41370448 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 1.36e-50 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g9774 | i0 | 99.16 | 55.7904191616766 | 119 | 0 | 68 | 1 | 1 | 118 | 1656 | 1538 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 18634 | 213 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24591791 | 24591791 | PRJNA177642_P_NODE_1960_length_1106_cov_5.842154_g1362_i0 | PRJNA177642 | 1960 | 1106 | 5.842154 | 64.61422324 | Pyrocystis lunula | 2972 | SAR_Eukaryotes | SAR_Eukaryotes | 1520 | 0 | NTclustered | gi|27450758|gb|AF508263.1| | 2972 | g1362 | i0 | 91.584 | 96.3824593128391 | 1105 | 88 | 99 | 5 | 1 | 1103 | 1116 | 15 | Pyrocystis lunula actin mRNA, complete cds | blastn | 106599 | 1520 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Pyrocystaceae | Pyrocystis | Pyrocystis lunula |
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);;