contig_metadata
6 rows where bioproject = "PRJNA908278" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12369315 | 12369315 | PRJNA908278_P_NODE_1670_length_845_cov_10.582902_g1586_i0 | PRJNA908278 | 1670 | 845 | 10.582902 | 89.4255219 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 1098 | 0 | NTclustered | gi|844573744|gb|KP411223.1| | 5775 | g1586 | i0 | 91.326 | 0.955029585798817 | 807 | 65 | 95 | 3 | 1 | 803 | 826 | 21 | Amoeba proteus Tom40 mRNA, complete cds | blastn | 807 | 1098 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 14918266 | 14918266 | PRJNA908278_P_NODE_23152_length_269_cov_2.607143_g23049_i0 | PRJNA908278 | 23152 | 269 | 2.607143 | 7.01321467 | Heleopera baetica | 2844938 | Tubulinea | other_Eukaryota | 102 | 2.41e-17 | NTclustered | gi|2050647004|gb|MZ366437.1| | 2844938 | g23049 | i0 | 88.372 | 26.6208178438662 | 86 | 8 | 32 | 2 | 88 | 172 | 209 | 293 | Heleopera baetica isolate A1 small subunit ribosomal RNA gene, partial sequence | blastn | 7161 | 102 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Heleoperidae | Heleopera | Heleopera baetica | ||
| 15276956 | 15276956 | PRJNA908278_P_NODE_15732_length_319_cov_1.113821_g15629_i0 | PRJNA908278 | 15732 | 319 | 1.113821 | 3.55308899 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 348 | 3.4100000000000005e-91 | NTclustered | gi|33946358|gb|AY294158.1| | 239731 | g15629 | i0 | 86.52 | 97.7335423197492 | 319 | 39 | 99 | 3 | 3 | 319 | 410 | 94 | Hartmannella cantabrigiensis actin mRNA, complete cds | blastn | 31177 | 348 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 22567403 | 22567403 | PRJNA908278_P_NODE_2638_length_692_cov_1.709208_g2538_i0 | PRJNA908278 | 2638 | 692 | 1.709208 | 11.82771936 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 706 | 0 | NTclustered | gi|844573744|gb|KP411223.1| | 5775 | g2538 | i0 | 85.401 | 0.989884393063584 | 685 | 95 | 99 | 5 | 10 | 692 | 869 | 188 | Amoeba proteus Tom40 mRNA, complete cds | blastn | 685 | 706 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 23842473 | 23842473 | PRJNA908278_P_NODE_22619_length_273_cov_1.155000_g22516_i0 | PRJNA908278 | 22619 | 273 | 1.155 | 3.15315 | Arcella hemisphaerica | 497998 | Tubulinea | other_Eukaryota | 226 | 1.4e-54 | NTclustered | gi|304308764|gb|HM853713.1| | 497998 | g22516 | i0 | 82.156 | 45.4505494505495 | 269 | 43 | 97 | 5 | 1 | 266 | 435 | 169 | Arcella hemisphaerica strain red clone act26 actin gene, partial cds | blastn | 12408 | 226 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella hemisphaerica | ||
| 32079077 | 32079077 | PRJNA908278_P_NODE_31038_length_246_cov_0.890173_g30935_i0 | PRJNA908278 | 31038 | 246 | 0.890173 | 2.18982558 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 120 | 3.04e-30 | NR | AAD37351.1 | 5775 | g30935 | i0 | 67.5 | 0.975609756097561 | 80 | 26 | 97.6 | 0 | 2 | 241 | 114 | 193 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 240 | 120 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus |
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);;