metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA688736" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA688736" 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
1943321	1943321	PRJNA688736_P_NODE_13402_length_415_cov_1.783626_g13117_i0	PRJNA688736	13402	415	1.783626	7.4020479	Ripella decalvata	2047822	Discosea	other_Eukaryota	643	5.179999999999999e-180	NTclustered	gi\|1269228434\|gb\|MF683559.1\|	2047822	g13117	i0	94.774	101.067469879518	421	9	100	11	1	415	618	1031	Ripella decalvata clone 26.2.15 18S ribosomal RNA gene, partial sequence	blastn	41943	643	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella decalvata
4496039	4496039	PRJNA688736_P_NODE_42944_length_250_cov_0.881356_g42659_i0	PRJNA688736	42944	250	0.881356	2.20339	Raperostelium minutum	35219	Evosea	other_Eukaryota	65.8	2.91e-6	NTclustered	gi\|156629701\|gb\|EF612188.1\|	35219	g42659	i0	95.122	15.316	41	2	16	0	175	215	546	586	Raperostelium minutum strain 71-2 unknown (Dm0233813) gene, partial cds; adenylyl cyclase G (AcgA) gene, complete cds; and putative mitochondrial tryptophanyl-tRNA synthetase (MtrpS) gene, partial cds; nuclear genes for mitochondrial products	blastn	3829	65.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Raperostelium	Raperostelium minutum
22344882	22344882	PRJNA688736_P_NODE_22498_length_332_cov_1.204633_g22213_i0	PRJNA688736	22498	332	1.204633	3.99938156	Protacanthamoeba bohemica	325062	Discosea	other_Eukaryota	470	7.289999999999999e-128	NTclustered	gi\|2806326584\|gb\|PQ345834.1\|	325062	g22213	i0	92.771	45.2530120481928	332	13	100	10	1	332	460	140	Protacanthamoeba bohemica isolate 6FSb1 small subunit ribosomal RNA gene, partial sequence	blastn	15024	470	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Protacanthamoeba	Protacanthamoeba bohemica
24894307	24894307	PRJNA688736_P_NODE_46680_length_246_cov_0.901734_g46395_i0	PRJNA688736	46680	246	0.901734	2.21826564	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	318	1.98e-82	NTclustered	gi\|300078498\|gb\|GU001160.1\|	5755	g46395	i0	90	1.05691056910569	260	7	100	17	1	246	5662	5916	Acanthamoeba castellanii 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	260	318	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii

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