metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA760904" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA760904" 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
5845842	5845842	PRJNA760904_P_NODE_5505_length_366_cov_1.846416_g5448_i0	PRJNA760904	5505	366	1.846416	6.75788256	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	159	6.08e-44	NR	ABD46557.1	5778	g5448	i0	63.1	1	122	45	100	0	1	366	5	126	ABD46557.1 sodium:galactoside symporter-like protein, partial [Vermamoeba vermiformis]	diamond	366	159	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
28789915	28789915	PRJNA760904_P_NODE_5027_length_380_cov_1.254072_g4970_i0	PRJNA760904	5027	380	1.254072	4.7654736	Copromyxa protea	931554	Tubulinea	other_Eukaryota	214	4.9600000000000004e-65	NR	BAN33737.1	931554	g4970	i0	78.6	0.994736842105263	126	27	99.5	0	380	3	310	435	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	378	214	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
29263431	29263431	PRJNA760904_P_NODE_10749_length_281_cov_1.480769_g10692_i0	PRJNA760904	10749	281	1.480769	4.16096089	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	109	6.95e-26	NR	ABD46557.1	5778	g10692	i0	59.8	0.928825622775801	87	35	92.9	0	1	261	240	326	ABD46557.1 sodium:galactoside symporter-like protein, partial [Vermamoeba vermiformis]	diamond	261	109	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
29326676	29326676	PRJNA760904_P_NODE_1289_length_678_cov_1.684298_g1235_i0	PRJNA760904	1289	678	1.684298	11.41954044	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	184	6.49e-56	NR	ABD72565.1	5778	g1235	i0	62.6	0.579646017699115	131	49	58	0	1	393	4	134	ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis]	diamond	393	184	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
29579127	29579127	PRJNA760904_P_NODE_770_length_847_cov_4.735142_g724_i0	PRJNA760904	770	847	4.735142	40.10665274	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	128	3.64e-33	NR	ABD72565.1	5778	g724	i0	48.5	0.474616292798111	134	64	45.7	2	665	279	2	135	ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis]	diamond	402	128	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis

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