contig_metadata
8 rows where bioproject = "PRJNA1073005", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186983 | 186983 | PRJNA1073005_P_NODE_3181_length_595_cov_6.808429_g3063_i0 | PRJNA1073005 | 3181 | 595 | 6.808429 | 40.51015255 | Ptolemeba bulliensis | 1525729 | Tubulinea | other_Eukaryota | 1029 | 0 | NTclustered | gi|667752759|gb|KJ542108.1| | 1525729 | g3063 | i0 | 97.987 | 85.527731092437 | 596 | 6 | 100 | 3 | 1 | 595 | 1867 | 1277 | Ptolemeba bulliensis isolate Sk13-4e 18S ribosomal RNA gene, partial sequence | blastn | 50889 | 1029 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Ptolemeba | Ptolemeba bulliensis | ||
| 1461544 | 1461544 | PRJNA1073005_P_NODE_3022_length_615_cov_8.525830_g2904_i0 | PRJNA1073005 | 3022 | 615 | 8.52583 | 52.4338545 | Ptolemeba bulliensis | 1525729 | Tubulinea | other_Eukaryota | 1007 | 0 | NTclustered | gi|1255287465|dbj|LC272073.1| | 1525729 | g2904 | i0 | 96.423 | 74.8439024390244 | 615 | 15 | 100 | 6 | 1 | 615 | 595 | 1202 | Ptolemeba bulliensis gene for 18S ribosomal RNA, partial sequence, strain: BA02 | blastn | 46029 | 1007 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Ptolemeba | Ptolemeba bulliensis | ||
| 1461558 | 1461558 | PRJNA1073005_P_NODE_8142_length_278_cov_1.126829_g8023_i0 | PRJNA1073005 | 8142 | 278 | 1.126829 | 3.13258462 | Arcella discoides | 1078856 | Tubulinea | other_Eukaryota | 279 | 1.08e-70 | NTclustered | gi|345452540|gb|JF694288.1| | 1078856 | g8023 | i0 | 84.946 | 58.431654676259 | 279 | 38 | 99 | 4 | 2 | 278 | 642 | 366 | Arcella discoides isolate DL3_98 clone 2 actin gene, partial cds | blastn | 16244 | 279 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella discoides | ||
| 1461567 | 1461567 | PRJNA1073005_P_NODE_9742_length_245_cov_1.872093_g9623_i0 | PRJNA1073005 | 9742 | 245 | 1.872093 | 4.58662785 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 154 | 2.2e-43 | NR | AAP88974.1 | 5775 | g9623 | i0 | 88.9 | 0.991836734693878 | 81 | 9 | 99.2 | 0 | 244 | 2 | 121 | 201 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 243 | 154 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 2737537 | 2737537 | PRJNA1073005_P_NODE_7443_length_304_cov_2.095238_g7324_i0 | PRJNA1073005 | 7443 | 304 | 2.095238 | 6.36952352 | Amoeba leningradensis | 160820 | Tubulinea | other_Eukaryota | 305 | 1.97e-78 | NTclustered | gi|17897590|emb|AJ314605.1| | 160820 | g7324 | i0 | 84.936 | 50.5460526315789 | 312 | 36 | 100 | 9 | 1 | 304 | 1294 | 1602 | Amoeba leningradensis partial 16S rRNA gene, strain CCAP 1503/6 | blastn | 15366 | 305 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba leningradensis | ||
| 11665626 | 11665626 | PRJNA1073005_P_NODE_4310_length_478_cov_2.185185_g4191_i0 | PRJNA1073005 | 4310 | 478 | 2.185185 | 10.4451843 | Chaos nobile | 160822 | Tubulinea | other_Eukaryota | 499 | 1.38e-136 | NTclustered | gi|17902587|emb|AJ314606.1| | 160822 | g4191 | i0 | 91.105 | 76.4644351464435 | 371 | 29 | 77 | 4 | 111 | 478 | 942 | 1311 | Chaos nobile partial 16S rRNA gene, strain CCAP 1511/2 | blastn | 36550 | 499 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos nobile | ||
| 19312652 | 19312652 | PRJNA1073005_P_NODE_3456_length_563_cov_2.206122_g3337_i0 | PRJNA1073005 | 3456 | 563 | 2.206122 | 12.42046686 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 483 | 1.66e-131 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g3337 | i0 | 81.9 | 4.101243339254 | 558 | 93 | 98 | 4 | 13 | 563 | 570 | 14 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 2309 | 483 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 28235682 | 28235682 | PRJNA1073005_P_NODE_1806_length_837_cov_1.308901_g1710_i0 | PRJNA1073005 | 1806 | 837 | 1.308901 | 10.95550137 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 452 | 7.14e-156 | NR | BAN33737.1 | 931554 | g1710 | i0 | 79.9 | 0.96415770609319 | 269 | 51 | 95.3 | 1 | 2 | 799 | 198 | 466 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 807 | 452 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea |
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);;