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

5 rows where analysis = "blastn", bioproject = "PRJNA624323" 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
9524752	9524752	PRJNA624323_P_NODE_9788_length_232_cov_6.880503_g9626_i0	PRJNA624323	9788	232	6.880503	15.96276696	Echinamoeba exundans	136450	Tubulinea	other_Eukaryota	429	8.2e-116	NTclustered	gi\|165968562\|gb\|EU377602.1\|	136450	g9626	i0	100	69.7844827586207	232	0	100	0	1	232	295	64	Echinamoeba exundans strain CRIB40 18S ribosomal RNA gene, partial sequence	blastn	16190	429	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida		Echinamoebidae	Echinamoeba	Echinamoeba exundans
12075748	12075748	PRJNA624323_P_NODE_9790_length_232_cov_6.685535_g9628_i0	PRJNA624323	9790	232	6.685535	15.5104412	Filamoeba nolandi	136452	Evosea	other_Eukaryota	399	6.429999999999999e-107	NTclustered	gi\|57546814\|gb\|AY714368.1\|	136452	g9628	i0	97.835	25.0344827586207	231	5	99	0	2	232	626	856	Filamoeba nolandi strain CCAP1526 small subunit ribosomal RNA gene, complete sequence	blastn	5808	399	1	Eukaryota	Amoebozoa	Evosea	Variosea			Filamoeba	Filamoeba nolandi
13350550	13350550	PRJNA624323_P_NODE_6671_length_277_cov_1.617647_g6509_i0	PRJNA624323	6671	277	1.617647	4.48088219	uncultured Soliformovum	2510342	Evosea	other_Eukaryota	462	9.929999999999999e-126	NTclustered	gi\|1564356923\|gb\|MK443523.1\|	2510342	g6509	i0	96.751	1	277	9	100	0	1	277	328	52	Uncultured Soliformovum clone OTUA345 small subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	277	462	1	Eukaryota	Amoebozoa	Evosea	Variosea	Protosteliida	Protosteliaceae		uncultured Soliformovum
13904087	13904087	PRJNA624323_P_NODE_6971_length_270_cov_1.786802_g6809_i0	PRJNA624323	6971	270	1.786802	4.8243654	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	425	1.27e-114	NTclustered	gi\|300078498\|gb\|GU001160.1\|	5755	g6809	i0	95.221	8.06296296296296	272	8	100	3	1	270	4324	4056	Acanthamoeba castellanii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	2177	425	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
22273514	22273514	PRJNA624323_P_NODE_9698_length_236_cov_2.085890_g9536_i0	PRJNA624323	9698	236	2.08589	4.9227004	Planopodium desertum	2773111	Discosea	other_Eukaryota	431	2.33e-116	NTclustered	gi\|330902850\|gb\|JF298244.1\|	2773111	g9536	i0	99.576	34.6737288135593	236	1	100	0	1	236	583	818	Ovalopodium desertum clone 3702 18S ribosomal RNA gene, partial sequence	blastn	8183	431	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Planopodium	Planopodium desertum

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