contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA533114" and tax_clade = "Haptista"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1780251 | 1780251 | PRJNA533114_P_NODE_29402_length_421_cov_1.540230_g29150_i0 | PRJNA533114 | 29402 | 421 | 1.54023 | 6.4843683 | Raphidocystis contractilis | 2792838 | Root_unresolved | Root_unresolved | 241 | 8.06e-59 | NTclustered | gi|259475613|emb|FN392421.1| | 2792838 | g29150 | i0 | 78.706 | 5.92636579572447 | 371 | 71 | 87 | 7 | 33 | 399 | 400 | 34 | Raphidiophrys contractilis partial mRNA for 40S ribosomal protein S18, contig 0726MP2-15 | blastn | 2495 | 241 | 1 | Eukaryota | Haptista | Centroplasthelida | Acanthocystida | Raphidocystidae | Raphidocystis | Raphidocystis contractilis | |||
| 5609423 | 5609423 | PRJNA533114_P_NODE_89385_length_257_cov_1.255435_g89133_i0 | PRJNA533114 | 89385 | 257 | 1.255435 | 3.22646795 | Raphidocystis contractilis | 2792838 | Root_unresolved | Root_unresolved | 220 | 6.06e-53 | NTclustered | gi|159147872|dbj|AB288080.1| | 2792838 | g89133 | i0 | 82.239 | 2.63424124513619 | 259 | 42 | 100 | 4 | 1 | 257 | 1598 | 1342 | Raphidocystis contractilis EF2 mRNA for elongation factor 2, partial cds | blastn | 677 | 220 | 1 | Eukaryota | Haptista | Centroplasthelida | Acanthocystida | Raphidocystidae | Raphidocystis | Raphidocystis contractilis | |||
| 9433538 | 9433538 | PRJNA533114_P_NODE_53328_length_324_cov_1.147410_g53076_i0 | PRJNA533114 | 53328 | 324 | 1.14741 | 3.7176084 | Chlamydaster sterni | 193542 | Root_unresolved | Root_unresolved | 555 | 1.8999999999999993e-153 | NTclustered | gi|33089907|gb|AY283744.1| | 193542 | g53076 | i0 | 97.531 | 80.6882716049383 | 324 | 8 | 100 | 0 | 1 | 324 | 684 | 361 | Chlamydaster sterni isolate Chlam30_2 actin mRNA, partial cds | blastn | 26143 | 555 | 1 | Eukaryota | Haptista | Centroplasthelida | Pterocystida | Pterocystidae | Chlamydaster | Chlamydaster sterni | |||
| 13258222 | 13258222 | PRJNA533114_P_NODE_107211_length_246_cov_0.890173_g106959_i0 | PRJNA533114 | 107211 | 246 | 0.890173 | 2.18982558 | Raphidocystis contractilis | 2792838 | Root_unresolved | Root_unresolved | 100 | 7.82e-17 | NTclustered | gi|259475561|emb|FN392369.1| | 2792838 | g106959 | i0 | 82.456 | 0.463414634146341 | 114 | 20 | 46 | 0 | 1 | 114 | 694 | 807 | Raphidiophrys contractilis partial mRNA for transitional endoplasmic reticulum ATPase, contig 01884 | blastn | 114 | 100 | 1 | Eukaryota | Haptista | Centroplasthelida | Acanthocystida | Raphidocystidae | Raphidocystis | Raphidocystis contractilis | |||
| 20907196 | 20907196 | PRJNA533114_P_NODE_43217_length_355_cov_0.975177_g42965_i0 | PRJNA533114 | 43217 | 355 | 0.975177 | 3.46187835 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 320 | 8.34e-83 | NTclustered | gi|551577960|ref|XM_005774525.1| | 280463 | g42965 | i0 | 85.531 | 90.3211267605634 | 311 | 40 | 87 | 3 | 1 | 310 | 549 | 243 | Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA | blastn | 32064 | 320 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 23456765 | 23456765 | PRJNA533114_P_NODE_12879_length_631_cov_1.116487_g12637_i0 | PRJNA533114 | 12879 | 631 | 1.116487 | 7.04503297 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 455 | 4.09e-123 | NTclustered | gi|551539306|ref|XM_005758086.1| | 280463 | g12637 | i0 | 81.282 | 35.3882725832013 | 577 | 94 | 90 | 13 | 7 | 576 | 740 | 171 | Emiliania huxleyi CCMP1516 receptor of activated protein kinase C partial mRNA | blastn | 22330 | 455 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 24730999 | 24730999 | PRJNA533114_P_NODE_37480_length_377_cov_1.496711_g37228_i0 | PRJNA533114 | 37480 | 377 | 1.496711 | 5.64260047 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 235 | 3.3199999999999994e-57 | NTclustered | gi|551548842|ref|XM_005762007.1| | 280463 | g37228 | i0 | 81.164 | 37.4668435013263 | 292 | 55 | 77 | 0 | 7 | 298 | 395 | 104 | Emiliania huxleyi CCMP1516 hypothetical protein mRNA | blastn | 14125 | 235 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 24731129 | 24731129 | PRJNA533114_P_NODE_48240_length_338_cov_2.218868_g47988_i0 | PRJNA533114 | 48240 | 338 | 2.218868 | 7.49977384 | Raphidocystis contractilis | 2792838 | Root_unresolved | Root_unresolved | 228 | 4.9399999999999985e-55 | NTclustered | gi|259475521|emb|FN392329.1| | 2792838 | g47988 | i0 | 81.495 | 3.83727810650888 | 281 | 48 | 83 | 4 | 13 | 291 | 338 | 60 | Raphidiophrys contractilis partial mRNA for ADP/ATP translocase 1, contig 0629MP25 | blastn | 1297 | 228 | 1 | Eukaryota | Haptista | Centroplasthelida | Acanthocystida | Raphidocystidae | Raphidocystis | Raphidocystis contractilis |
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);;