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

6 rows where analysis = "diamond", bioproject = "PRJNA591127" 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
8218292	8218292	PRJNA591127_P_NODE_28187_length_153_cov_1.379310_g28018_i0	PRJNA591127	28187	153	1.37931	2.1103443	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	95.1	1.97e-21	NR	ABQ41411.1	435424	g28018	i0	88	15.6862745098039	50	6	98	0	152	3	279	328	ABQ41411.1 elongation factor 1A, partial [Soliformovum irregulare]	diamond	2400	95.1	1	Eukaryota	Amoebozoa	Evosea	Variosea	Fractovitellida	Soliformoviidae	Soliformovum	Soliformovum irregulare
27282896	27282896	PRJNA591127_P_NODE_3423_length_388_cov_1.834758_g3255_i0	PRJNA591127	3423	388	1.8347579999999999	7.11886104	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	99	8.66e-24	NR	XP_003283857.1	5786	g3255	i0	43.5	3.43298969072165	108	53	83.5	1	364	41	16	115	XP_003283857.1 40S ribosomal protein S20 [Dictyostelium purpureum]	diamond	1332	99.4	0.995975855130785	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
27680258	27680258	PRJNA591127_P_NODE_25644_length_165_cov_1.648438_g25475_i0	PRJNA591127	25644	165	1.648438	2.7199227	Entamoeba histolytica HM-1:IMSS	294381	Evosea	other_Eukaryota	51.2	1.26e-6	NR	XP_656837.1	294381	g25475	i0	50.9	1	55	27	100	0	1	165	20	74	XP_656837.1 actobindin, putative [Entamoeba histolytica HM-1:IMSS]	diamond	165	51.2	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
28198400	28198400	PRJNA591127_P_NODE_26746_length_159_cov_3.532787_g26577_i0	PRJNA591127	26746	159	3.532787	5.61713133	Acytosteliaceae	2058183	Evosea	other_Eukaryota	68.2	1.22e-11	NR	XP_020431823.1	670386	g26577	i0	52.9	1.92452830188679	51	24	96.2	0	154	2	92	142	XP_020431823.1 glutathione S-transferase domain-containing protein [Heterostelium album PN500]	diamond	306	68.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
28816328	28816328	PRJNA591127_P_NODE_12448_length_208_cov_5.929825_g12279_i0	PRJNA591127	12448	208	5.929825	12.334036	Dictyostelium discoideum AX4	352472	Evosea	other_Eukaryota	45.8	0.00189	NR	XP_638859.1	352472	g12279	i0	43.5	1.84615384615385	62	32	85.1	2	181	5	3	64	XP_638859.1 cysteine proteinase 3 [Dictyostelium discoideum AX4]	diamond	384	45.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
29700290	29700290	PRJNA591127_P_NODE_9490_length_239_cov_1.698020_g9322_i0	PRJNA591127	9490	239	1.69802	4.0582678	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	61.6	4.79e-9	NR	KAH3764538.1	1580589	g9322	i0	45.7	0.878661087866109	70	37	87.9	1	211	2	164	232	KAH3764538.1 hypothetical protein Pelo_3644 [Pelomyxa schiedti]	diamond	210	61.6	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti

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