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

5 rows where analysis = "blastn", bioproject = "PRJNA635874" 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
5711537	5711537	PRJNA635874_P_NODE_54405_length_248_cov_0.880000_g54258_i0	PRJNA635874	54405	248	0.88	2.1824	Heterostelium album	2086695	Evosea	other_Eukaryota	52.8	0.022	NTclustered	gi\|1160552044\|ref\|XM_020571356.1\|	670386	g54258	i0	100	0.112903225806452	28	0	11	0	2	29	71	44	Polysphondylium pallidum PN500 hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
15183107	15183107	PRJNA635874_P_NODE_56692_length_247_cov_0.885057_g56545_i0	PRJNA635874	56692	247	0.885057	2.18609079	Entamoeba	5758	Evosea	other_Eukaryota	56.5	0.002	NTclustered	gi\|67466586\|ref\|XM_644349.1\|	294381	g56545	i0	100	0.242914979757085	30	0	12	0	179	208	1596	1625	Entamoeba histolytica HM-1:IMSS ABC transporter, putative (EHI_124840), partial mRNA	blastn	60	56.5	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
17185684	17185684	PRJNA635874_P_NODE_47694_length_251_cov_0.865169_g47547_i0	PRJNA635874	47694	251	0.865169	2.17157419	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	62.1	3.78e-5	NTclustered	gi\|66823144\|ref\|XM_639835.1\|	352472	g47547	i0	88.679	1.28286852589641	53	3	21	1	106	158	964	915	Dictyostelium discoideum AX4 hypothetical protein (DDB_G0272865) mRNA, complete cds	blastn	322	62.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
21009948	21009948	PRJNA635874_P_NODE_42057_length_263_cov_0.947368_g41910_i0	PRJNA635874	42057	263	0.947368	2.49157784	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	394	3.46e-105	NTclustered	gi\|66804594\|ref\|XM_630938.1\|	352472	g41910	i0	93.87	98.8783269961977	261	16	99	0	2	262	166	426	Dictyostelium discoideum AX4 hypothetical protein (act10) mRNA, complete cds	blastn	26005	394	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
24834048	24834048	PRJNA635874_P_NODE_46660_length_251_cov_0.865169_g46513_i0	PRJNA635874	46660	251	0.865169	2.17157419	Entamoeba dispar	46681	Evosea	other_Eukaryota	52.8	0.023	NTclustered	gi\|167394313\|ref\|XM_001740874.1\|	370354	g46513	i0	100	0.111553784860558	28	0	11	0	14	41	1029	1002	Entamoeba dispar SAW760 uncharacterized protein (EDI_028600), partial mRNA	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar

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