metadata: contig_metadata: 5 rows where bioproject = "PRJNA1150539" and tax

5 rows where bioproject = "PRJNA1150539" 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
2312075	2312075	PRJNA1150539_S_NODE_61342_length_292_cov_3.420091_g60746_i0	PRJNA1150539	61342	292	3.420091	9.98666572	Tubulinea	555369	Tubulinea	other_Eukaryota	514	2.87e-141	NTclustered	gi\|418968559\|gb\|KC164244.1\|	5778	g60746	i0	98.299	98.8493150684932	294	3	100	2	1	292	87	380	Vermamoeba vermiformis clone CF3-181 18S ribosomal RNA gene, partial sequence	blastn	28864	514	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
5404451	5404451	PRJNA1150539_S_NODE_51845_length_308_cov_1.617021_g51249_i0	PRJNA1150539	51845	308	1.617021	4.98042468	uncultured Amoebozoa	590481	Root_unresolved	Root_unresolved	529	1.0899999999999996e-145	NTclustered	gi\|221185864\|gb\|FJ577811.1\|	590481	g51249	i0	99.317	24.0616883116883	293	1	95	1	1	292	933	641	Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence	blastn	7411	529	1	Eukaryota	Amoebozoa						uncultured Amoebozoa
10505554	10505554	PRJNA1150539_S_NODE_84229_length_260_cov_3.802139_g83633_i0	PRJNA1150539	84229	260	3.802139	9.8855614	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	65.8	3.04e-6	NTclustered	gi\|66803301\|ref\|XM_630402.1\|	352472	g83633	i0	100	13.7307692307692	35	0	13	0	175	209	2744	2710	Dictyostelium discoideum AX4 hypothetical protein (pks39) mRNA, complete cds	blastn	3570	65.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
11779830	11779830	PRJNA1150539_S_NODE_37570_length_335_cov_1.763359_g36974_i0	PRJNA1150539	37570	335	1.763359	5.90725265	Cochliopodium actinophorum	703021	Discosea	other_Eukaryota	608	1.489999999999999e-169	NTclustered	gi\|330902845\|gb\|JF298249.1\|	703021	g36974	i0	99.403	67.2716417910448	335	2	100	0	1	335	167	501	Cochliopodium actinophorum clone 1202 18S ribosomal RNA gene, partial sequence	blastn	22536	608	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium actinophorum
21978680	21978680	PRJNA1150539_S_NODE_96318_length_247_cov_1.327586_g95722_i0	PRJNA1150539	96318	247	1.327586	3.27913742	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	60.2	1.33e-4	NTclustered	gi\|330795445\|ref\|XM_003285736.1\|	5786	g95722	i0	92.683	1.92307692307692	41	3	17	0	52	92	247	287	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_97172), partial mRNA	blastn	475	60.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum

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