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

5 rows where analysis = "blastn", bioproject = "PRJNA798511" 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
791162	791162	PRJNA798511_P_NODE_85701_length_255_cov_1.692308_g81435_i0	PRJNA798511	85701	255	1.692308	4.3153854	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	60.2	1.38e-4	NTclustered	gi\|330843931\|ref\|XM_003293847.1\|	5786	g81435	i0	97.222	0.141176470588235	36	0	14	1	142	177	1341	1375	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_158818), partial mRNA	blastn	36	60.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
2066575	2066575	PRJNA798511_P_NODE_59642_length_319_cov_0.979675_g55376_i0	PRJNA798511	59642	319	0.979675	3.12516325	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	56.5	0.002	NTclustered	gi\|330795158\|ref\|XM_003285594.1\|	5786	g55376	i0	97.059	0.106583072100313	34	0	11	1	206	239	2	34	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_76572), partial mRNA	blastn	34	56.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
13544070	13544070	PRJNA798511_P_NODE_43931_length_391_cov_31.588050_g39667_i0	PRJNA798511	43931	391	31.58805	123.5092755	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	52.8	0.037	NTclustered	gi\|470239771\|ref\|XM_004351803.1\|	261658	g39667	i0	100	0.0716112531969309	28	0	7	0	75	102	497	524	Cavenderia fasciculata pleckstrin domain-containing protein (DFA_09959), partial mRNA	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
17369705	17369705	PRJNA798511_P_NODE_98994_length_243_cov_3.194118_g94728_i0	PRJNA798511	98994	243	3.194118	7.76170674	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	58.4	4.71e-4	NTclustered	gi\|470236295\|ref\|XM_004350051.1\|	261658	g94728	i0	89.583	0.197530864197531	48	1	19	3	97	141	66	20	Cavenderia fasciculata uncharacterized protein (DFA_11158), partial mRNA	blastn	48	58.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
25017219	25017219	PRJNA798511_P_NODE_59420_length_319_cov_8.796748_g55154_i0	PRJNA798511	59420	319	8.796748	28.06162612	uncultured Amoebozoa	590481	Root_unresolved	Root_unresolved	568	2.3999999999999993e-157	NTclustered	gi\|365928255\|gb\|JN825705.1\|	590481	g55154	i0	99.054	69.8432601880878	317	1	99	2	3	319	1029	715	Uncultured Amoebozoa clone Alchichica_AQ2b_5E_39 small subunit ribosomal RNA gene, partial sequence	blastn	22280	568	1	Eukaryota	Amoebozoa						uncultured Amoebozoa

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