metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA743294" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA743294" 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
25424903	25424903	PRJNA743294_P_NODE_15260_length_411_cov_1.399408_g14804_i0	PRJNA743294	15260	411	1.399408	5.75156688	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	221	6.03e-68	NR	AOW71839.1	5778	g14804	i0	91.9	0.897810218978102	123	10	89.8	0	1	369	291	413	AOW71839.1 bacterial recombinase A [Vermamoeba vermiformis]	diamond	369	221	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
26672401	26672401	PRJNA743294_P_NODE_10441_length_490_cov_2.119904_g9985_i0	PRJNA743294	10441	490	2.119904	10.3875296	Amoeba proteus	5775	Tubulinea	other_Eukaryota	215	7.19e-62	NR	AKN09691.1	5775	g9985	i0	63.6	0.991836734693878	162	57	98.6	2	1	483	741	901	AKN09691.1 Tom70 [Amoeba proteus]	diamond	486	215	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
27652990	27652990	PRJNA743294_P_NODE_14324_length_423_cov_1.485714_g13868_i0	PRJNA743294	14324	423	1.485714	6.28457022	Amoeba proteus	5775	Tubulinea	other_Eukaryota	139	6.22e-35	NR	AKN09691.1	5775	g13868	i0	47.8	0.964539007092199	136	71	96.5	0	411	4	459	594	AKN09691.1 Tom70 [Amoeba proteus]	diamond	408	139	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
27842131	27842131	PRJNA743294_P_NODE_30684_length_301_cov_1.368421_g30228_i0	PRJNA743294	30684	301	1.368421	4.11894721	Amoeba proteus	5775	Tubulinea	other_Eukaryota	171	1.25e-50	NR	AKN09692.1	5775	g30228	i0	78.8	0.98671096345515	99	21	98.7	0	299	3	103	201	AKN09692.1 Tom40 [Amoeba proteus]	diamond	297	171	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
28704987	28704987	PRJNA743294_P_NODE_47027_length_252_cov_1.307263_g46571_i0	PRJNA743294	47027	252	1.307263	3.29430276	root	1	Root_unresolved	Root_unresolved	106	2.04e-25	NR	ABD46601.1	5778	g46571	i0	54.8	3.95238095238095	84	36	97.6	2	250	5	13	96	ABD46601.1 oxidoreductase, partial [Vermamoeba vermiformis]	diamond	996	107	0.990654205607477	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
32434118	32434118	PRJNA743294_P_NODE_36999_length_278_cov_1.282927_g36543_i0	PRJNA743294	36999	278	1.282927	3.56653706	Arcellinida	318493	Tubulinea	other_Eukaryota	149	2.0399999999999998e-43	NR	AFX73089.1	497998	g36543	i0	73.6	4.93165467625899	91	24	98.2	0	278	6	14	104	AFX73089.1 elongation factor 2 alpha, partial [Arcella hemisphaerica]	diamond	1371	149	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Arcellidae	Arcella	Arcella hemisphaerica

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