contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1073183" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187012 | 187012 | PRJNA1073183_P_NODE_10301_length_400_cov_1.094801_g10207_i0 | PRJNA1073183 | 10301 | 400 | 1.094801 | 4.379204 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 383 | 1.2e-101 | NTclustered | gi|470266101|ref|XM_004361626.1| | 261658 | g10207 | i0 | 84.08 | 99.48 | 402 | 58 | 99 | 3 | 2 | 400 | 992 | 594 | Cavenderia fasciculata uncharacterized protein (DFA_05968), partial mRNA | blastn | 39792 | 383 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 1016035 | 1016035 | PRJNA1073183_P_NODE_26721_length_251_cov_0.865169_g26626_i0 | PRJNA1073183 | 26721 | 251 | 0.865169 | 2.17157419 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 204 | 5.93e-48 | NTclustered | gi|1408305|gb|U61989.1|DDU61989 | 44689 | g26626 | i0 | 81.275 | 5.35458167330677 | 251 | 47 | 100 | 0 | 1 | 251 | 748 | 498 | Dictyostelium discoideum ndufv1 (ndufv1) mRNA, complete cds | blastn | 1344 | 204 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 2737938 | 2737938 | PRJNA1073183_P_NODE_31643_length_244_cov_1.777778_g31548_i0 | PRJNA1073183 | 31643 | 244 | 1.777778 | 4.33777832 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 235 | 2.0399999999999997e-57 | NTclustered | gi|831771146|ref|XM_012897758.1| | 1410327 | g31548 | i0 | 85.463 | 71.422131147541 | 227 | 31 | 93 | 2 | 17 | 242 | 469 | 694 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 17427 | 235 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 11666056 | 11666056 | PRJNA1073183_P_NODE_33350_length_242_cov_0.911243_g33255_i0 | PRJNA1073183 | 33350 | 242 | 0.911243 | 2.20520806 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 268 | 1.99e-67 | NTclustered | gi|62910949|gb|AY925001.1| | 5778 | g33255 | i0 | 96.875 | 0.834710743801653 | 160 | 5 | 66 | 0 | 1 | 160 | 160 | 1 | Hartmannella vermiformis Rpl7A mRNA, partial cds | blastn | 202 | 268 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 12941208 | 12941208 | PRJNA1073183_P_NODE_3651_length_657_cov_2.306507_g3562_i0 | PRJNA1073183 | 3651 | 657 | 2.306507 | 15.15375099 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 654 | 0 | NTclustered | gi|470237241|ref|XM_004350527.1| | 261658 | g3562 | i0 | 84.733 | 99.3348554033486 | 655 | 98 | 99 | 2 | 1 | 654 | 1113 | 460 | Cavenderia fasciculata actin (DFA_11631), partial mRNA | blastn | 65263 | 654 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 16764059 | 16764059 | PRJNA1073183_P_NODE_18674_length_303_cov_0.852174_g18579_i0 | PRJNA1073183 | 18674 | 303 | 0.852174 | 2.58208722 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|470237325|ref|XM_004350569.1| | 261658 | g18579 | i0 | 96.97 | 0.108910891089109 | 33 | 1 | 11 | 0 | 165 | 197 | 612 | 644 | Cavenderia fasciculata uncharacterized protein (DFA_11673), partial mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata |
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);;