metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA888821" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA888821" and tax_clade = "Amoebozoa"

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
2517207	2517207	PRJNA888821_P_NODE_15002_length_310_cov_6.544304_g14920_i0	PRJNA888821	15002	310	6.544304	20.2873424	Paramoeba	200890	Discosea	other_Eukaryota	73.1	2.22e-8	NTclustered	gi\|1079488025\|ref\|NC_031417.1\|	180228	g14920	i0	97.619	1.65161290322581	42	1	14	0	10	51	42743	42784	Paramoeba pemaquidensis culture-collection CCAP:1560/4 mitochondrion, complete genome	blastn	512	73.1	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Paramoeba	Paramoeba pemaquidensis
5966034	5966034	PRJNA888821_P_NODE_27625_length_280_cov_9.314010_g27543_i0	PRJNA888821	27625	280	9.31401	26.079228	Cochliopodium larifeili	1017091	Discosea	other_Eukaryota	414	2.86e-111	NTclustered	gi\|330902856\|gb\|JF298254.1\|	1017091	g27543	i0	93.571	31.3071428571429	280	15	100	3	1	280	1393	1669	Cochliopodium larifeili clone 902 18S ribosomal RNA gene, partial sequence	blastn	8766	414	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium larifeili
8515782	8515782	PRJNA888821_P_NODE_34687_length_251_cov_1.719101_g34604_i0	PRJNA888821	34687	251	1.719101	4.31494351	Ripella sp. GP2	1217115	Discosea	other_Eukaryota	370	5.53e-98	NTclustered	gi\|399764204\|gb\|JQ271715.1\|	1217115	g34604	i0	98.122	86.804780876494	213	3	85	1	1	213	11	222	Ripella sp. GP2 18S ribosomal RNA gene, partial sequence	blastn	21788	370	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. GP2
16165985	16165985	PRJNA888821_P_NODE_8573_length_310_cov_13.333333_g8491_i0	PRJNA888821	8573	310	13.333333	41.3333323	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	161	4.6099999999999995e-35	NTclustered	gi\|562028\|gb\|U12386.1\|ACU12386	5755	g8491	i0	86	1.45161290322581	150	21	48	0	161	310	33215	33364	Acanthamoeba castellanii mitochondrion, complete genome	blastn	450	161	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
22539942	22539942	PRJNA888821_P_NODE_48178_length_211_cov_5.463768_g48095_i0	PRJNA888821	48178	211	5.463768	11.52855048	Physarum polycephalum	5791	Evosea	other_Eukaryota	148	2.3e-31	NTclustered	gi\|3225\|emb\|V01160.1\|	5791	g48095	i0	80	6.01421800947867	220	29	99	14	1	210	18	232	Introns 1 and 2 of Physarum gene for 26S ribosomal RNA, together with flanking exon regions	blastn	1269	148	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum

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);;