metadata: contig_metadata: 5 rows where bioproject = "PRJNA641991", tax_clade = "Amoebozoa" and tax

5 rows where bioproject = "PRJNA641991", tax_clade = "Amoebozoa" and tax_phylum = "Tubulinea"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3168593	3168593	PRJNA641991_P_NODE_2163_length_207_cov_1.607595_g2122_i0	PRJNA641991	2163	207	1.607595	3.32772165	Amoeba proteus	5775	Tubulinea	other_Eukaryota	176	1.03e-39	NTclustered	gi\|33946362\|gb\|AY294160.1\|	5775	g2122	i0	82.828	39.8405797101449	198	32	95	2	2	198	778	974	Amoeba proteus actin mRNA, complete cds	blastn	8247	176	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
9546359	9546359	PRJNA641991_S_NODE_11108_length_172_cov_1.243902_g10989_i0	PRJNA641991	11108	172	1.243902	2.13951144	Cryptodifflugia operculata	1078836	Tubulinea	other_Eukaryota	200	4.87e-47	NTclustered	gi\|345452564\|gb\|JF694300.1\|	1078836	g10989	i0	87.791	88.1918604651163	172	19	99	2	2	172	796	626	Cryptodifflugia operculata clone 4 actin gene, partial cds	blastn	15169	200	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Cryptodifflugiidae	Cryptodifflugia	Cryptodifflugia operculata
16461204	16461204	PRJNA641991_S_NODE_5913_length_224_cov_1.217143_g5794_i0	PRJNA641991	5913	224	1.217143	2.72640032	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	311	2.97e-80	NTclustered	gi\|399764267\|gb\|JQ271778.1\|	1215988	g5794	i0	98.851	35.6205357142857	174	2	78	0	1	174	1751	1924	Tubulinea group 02 sp. HF1KJ 18S ribosomal RNA gene, partial sequence	blastn	7979	311	1	Eukaryota	Amoebozoa	Tubulinea					Tubulinea group 02 sp. HF1KJ
28597263	28597263	PRJNA641991_S_NODE_14727_length_161_cov_0.910714_g14608_i0	PRJNA641991	14727	161	0.910714	1.46624954	Copromyxa protea	931554	Tubulinea	other_Eukaryota	97.1	6.75e-22	NR	BAN33737.1	931554	g14608	i0	83	5.92546583850932	53	9	98.8	0	159	1	277	329	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	954	97.1	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
31155121	31155121	PRJNA641991_P_NODE_1775_length_232_cov_1.038251_g1734_i0	PRJNA641991	1775	232	1.038251	2.40874232	Copromyxa protea	931554	Tubulinea	other_Eukaryota	125	8.87e-32	NR	BAN33737.1	931554	g1734	i0	72.7	1.97844827586207	77	21	99.6	0	1	231	296	372	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	459	125	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);;