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

5 rows where bioproject = "PRJNA929922" 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
8558862	8558862	PRJNA929922_P_NODE_128247_length_247_cov_0.885057_g127707_i0	PRJNA929922	128247	247	0.885057	2.18609079	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	446	8.759999999999998e-121	NTclustered	gi\|470491270\|ref\|XM_004345824.1\|	1257118	g127707	i0	99.19	21.3279352226721	247	2	100	0	1	247	206	452	Acanthamoeba castellanii str. Neff adenylosuccinate synthase (ACA1_182320), partial mRNA	blastn	5268	446	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
12385566	12385566	PRJNA929922_P_NODE_152510_length_243_cov_0.905882_g151970_i0	PRJNA929922	152510	243	0.905882	2.20129326	Physarum polycephalum	5791	Evosea	other_Eukaryota	211	3.41e-50	NTclustered	gi\|3719262\|gb\|AF079798.1\|AF079798	5791	g151970	i0	82.449	2.01646090534979	245	40	100	3	1	243	619	376	Physarum polycephalum apocytochrome b gene, mitochondrial gene encoding mitochondrial protein, complete cds	blastn	490	211	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
23859141	23859141	PRJNA929922_P_NODE_2039_length_975_cov_3.888027_g1640_i0	PRJNA929922	2039	975	3.888027	37.90826325	Heterostelium album	2086695	Evosea	other_Eukaryota	54.7	0.027	NTclustered	gi\|1160554730\|ref\|XM_020573190.1\|	670386	g1640	i0	100	0.0297435897435897	29	0	3	0	621	649	1213	1185	Polysphondylium pallidum PN500 SNF2-related domain-containing protein (ercc6), partial mRNA	blastn	29	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
27214385	27214385	PRJNA929922_P_NODE_18762_length_430_cov_1.792717_g18227_i0	PRJNA929922	18762	430	1.792717	7.7086831	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	66.6	1.18e-9	NR	PRP78645.1	1890364	g18227	i0	33	0.634883720930233	91	61	63.5	0	397	125	274	364	PRP78645.1 hypothetical protein PROFUN_13478 [Planoprotostelium fungivorum]	diamond	273	66.6	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
30751697	30751697	PRJNA929922_P_NODE_17094_length_443_cov_0.867568_g16559_i0	PRJNA929922	17094	443	0.867568	3.84332624	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	47.4	0.0065	NR	PRP78645.1	1890364	g16559	i0	29.2	0.487584650112867	72	51	48.8	0	142	357	293	364	PRP78645.1 hypothetical protein PROFUN_13478 [Planoprotostelium fungivorum]	diamond	216	47.4	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum

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