contig_metadata
9 rows where bioproject = "PRJNA438687" and tax_clade = "Apusozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1710197 | 1710197 | PRJNA438687_S_NODE_5022_length_198_cov_4.018405_g4932_i0 | PRJNA438687 | 5022 | 198 | 4.018405 | 7.9564419 | Apusomonas proboscidea | 41120 | Root_unresolved | Root_unresolved | 355 | 1.17e-93 | NTclustered | gi|61187360|gb|AY752987.1| | 41120 | g4932 | i0 | 98.99 | 101.459595959596 | 198 | 2 | 100 | 0 | 1 | 198 | 1745 | 1942 | Apusomonas sp. CCAP1905/1 28S ribosomal RNA gene, partial sequence | blastn | 20089 | 355 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Apusomonas | Apusomonas proboscidea | ||||
| 2986073 | 2986073 | PRJNA438687_S_NODE_8223_length_150_cov_2.043478_g8133_i0 | PRJNA438687 | 8223 | 150 | 2.043478 | 3.065217 | Apusomonas proboscidea | 41120 | Root_unresolved | Root_unresolved | 158 | 2.5199999999999998e-34 | NTclustered | gi|61187360|gb|AY752987.1| | 41120 | g8133 | i0 | 85.906 | 36.8333333333333 | 149 | 19 | 99 | 2 | 3 | 150 | 2053 | 2200 | Apusomonas sp. CCAP1905/1 28S ribosomal RNA gene, partial sequence | blastn | 5525 | 158 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Apusomonas | Apusomonas proboscidea | ||||
| 6813062 | 6813062 | PRJNA438687_S_NODE_3426_length_240_cov_43.853659_g3336_i0 | PRJNA438687 | 3426 | 240 | 43.853659 | 105.2487816 | Apusomonas australiensis | 3003317 | Root_unresolved | Root_unresolved | 383 | 6.74e-102 | NTclustered | gi|2206682164|gb|OM966637.1| | 3003317 | g3336 | i0 | 95.417 | 101.3625 | 240 | 11 | 100 | 0 | 1 | 240 | 4632 | 4393 | Apusomonas australiensis strain PROMEX small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 24327 | 383 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Apusomonas | Apusomonas australiensis | ||||
| 13188997 | 13188997 | PRJNA438687_S_NODE_4251_length_215_cov_6.583333_g4161_i0 | PRJNA438687 | 4251 | 215 | 6.583333 | 14.15416595 | Apusomonas proboscidea | 41120 | Root_unresolved | Root_unresolved | 381 | 2.1299999999999996e-101 | NTclustered | gi|61187360|gb|AY752987.1| | 41120 | g4161 | i0 | 98.611 | 101.367441860465 | 216 | 2 | 100 | 1 | 1 | 215 | 2486 | 2701 | Apusomonas sp. CCAP1905/1 28S ribosomal RNA gene, partial sequence | blastn | 21794 | 381 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Apusomonas | Apusomonas proboscidea | ||||
| 15738032 | 15738032 | PRJNA438687_S_NODE_7013_length_164_cov_5.007752_g6923_i0 | PRJNA438687 | 7013 | 164 | 5.007752 | 8.21271328 | Apusomonas proboscidea | 41120 | Root_unresolved | Root_unresolved | 303 | 3.42e-78 | NTclustered | gi|225216787|gb|FJ176702.1| | 41120 | g6923 | i0 | 100 | 56.1219512195122 | 164 | 0 | 100 | 0 | 1 | 164 | 596 | 759 | Apusomonas proboscidea HFCC47 28S ribosomal RNA gene, partial sequence | blastn | 9204 | 303 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Apusomonas | Apusomonas proboscidea | ||||
| 18286954 | 18286954 | PRJNA438687_S_NODE_395_length_493_cov_10.196507_g316_i0 | PRJNA438687 | 395 | 493 | 10.196507 | 50.26877951 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 159 | 2.76e-34 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g316 | i0 | 89.6 | 27.3204868154158 | 125 | 13 | 25 | 0 | 40 | 164 | 5302 | 5178 | Catacumbia lutetiensis strain ORSAYFEB19APU2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 13469 | 159 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 19561262 | 19561262 | PRJNA438687_S_NODE_5876_length_182_cov_1.612245_g5786_i0 | PRJNA438687 | 5876 | 182 | 1.612245 | 2.9342859 | Amastigomonas bermudensis | 172822 | Root_unresolved | Root_unresolved | 91.6 | 3.28e-14 | NTclustered | gi|300078505|gb|GU001167.1| | 172822 | g5786 | i0 | 79.699 | 42.3626373626374 | 133 | 20 | 70 | 6 | 41 | 167 | 2791 | 2660 | Amastigomonas bermudensis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 7710 | 91.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Amastigomonas | Amastigomonas bermudensis | ||||
| 22112016 | 22112016 | PRJNA438687_S_NODE_7658_length_156_cov_2.677686_g7568_i0 | PRJNA438687 | 7658 | 156 | 2.677686 | 4.17719016 | Apusomonas proboscidea | 41120 | Root_unresolved | Root_unresolved | 250 | 4.25e-62 | NTclustered | gi|2206682169|gb|OM966642.1| | 41120 | g7568 | i0 | 95.513 | 35.5320512820513 | 156 | 7 | 100 | 0 | 1 | 156 | 5765 | 5920 | Apusomonas proboscidea strain MPSANABRIA15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 5543 | 250 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Apusomonas | Apusomonas proboscidea | ||||
| 23387567 | 23387567 | PRJNA438687_S_NODE_7099_length_163_cov_3.046875_g7009_i0 | PRJNA438687 | 7099 | 163 | 3.046875 | 4.96640625 | Apusomonas proboscidea | 41120 | Root_unresolved | Root_unresolved | 291 | 2.64e-74 | NTclustered | gi|61187360|gb|AY752987.1| | 41120 | g7009 | i0 | 98.773 | 116.840490797546 | 163 | 2 | 100 | 0 | 1 | 163 | 1528 | 1366 | Apusomonas sp. CCAP1905/1 28S ribosomal RNA gene, partial sequence | blastn | 19045 | 291 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Apusomonas | Apusomonas proboscidea |
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);;