metadata: contig_metadata: 5 rows where bioproject = "PRJEB12366" and tax

5 rows where bioproject = "PRJEB12366" 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
5123120	5123120	PRJEB12366_P_NODE_12545_length_206_cov_40.602339_g12355_i0	PRJEB12366	12545	206	40.602339	83.64081834	Cochliopodium minutoidum	703020	Discosea	other_Eukaryota	270	4.569999999999999e-68	NTclustered	gi\|659103920\|gb\|KJ569722.1\|	703020	g12355	i0	93.407	77.1359223300971	182	12	88	0	1	182	2045	1864	Cochliopodium minutoidum clone 1308 18S ribosomal RNA gene, partial sequence	blastn	15890	270	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium minutoidum
10223519	10223519	PRJEB12366_P_NODE_14749_length_186_cov_1.470199_g14559_i0	PRJEB12366	14749	186	1.470199	2.73457014	Entamoeba invadens	33085	Evosea	other_Eukaryota	222	1.15e-53	NTclustered	gi\|471215015\|ref\|XM_004261636.1\|	370355	g14559	i0	88.298	98.8118279569892	188	18	100	3	1	186	42	227	Entamoeba invadens IP1 actin, putative (EIN_249970) mRNA, partial cds	blastn	18379	222	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba invadens
12774390	12774390	PRJEB12366_P_NODE_19771_length_153_cov_1.127119_g19581_i0	PRJEB12366	19771	153	1.127119	1.72449207	Heterostelium album	2086695	Evosea	other_Eukaryota	124	2.62e-24	NTclustered	gi\|1160555578\|ref\|XM_020573614.1\|	670386	g19581	i0	82.069	11.8039215686275	145	26	95	0	9	153	987	843	Polysphondylium pallidum PN500 actin partial mRNA	blastn	1806	124	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
17872372	17872372	PRJEB12366_P_NODE_1695_length_662_cov_4.840510_g1540_i0	PRJEB12366	1695	662	4.84051	32.0441762	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	508	3.25e-139	NTclustered	gi\|66804872\|ref\|XM_631077.1\|	352472	g1540	i0	84.023	80.3625377643504	532	81	80	4	133	662	21	550	Dictyostelium discoideum AX4 hypothetical protein (act1) mRNA, complete cds	blastn	53200	508	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
19146244	19146244	PRJEB12366_P_NODE_12936_length_202_cov_2.365269_g12746_i0	PRJEB12366	12936	202	2.365269	4.77784338	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	58.4	3.78e-4	NTclustered	gi\|831780295\|ref\|XM_012900533.1\|	1410327	g12746	i0	100	1.27227722772277	31	0	15	0	80	110	100	70	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	257	58.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum

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