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

5 rows where analysis = "blastn", bioproject = "PRJNA768450" and tax_clade = "Discoba"

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
7124037	7124037	PRJNA768450_P_NODE_1726_length_180_cov_1.390728_g1654_i0	PRJNA768450	1726	180	1.390728	2.5033104	Rhynchobodo ATCC50359	51334	Euglenozoa	other_Eukaryota	272	1.08e-68	NTclustered	gi\|2267233\|gb\|U67184.1\|U67184	51334	g1654	i0	93.923	102.188888888889	181	10	100	1	1	180	613	793	Rhynchobodo ATCC50359 large subunit ribosomal RNA gene, partial sequence	blastn	18394	272	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Rhynchobodo	Rhynchobodo ATCC50359
7584174	7584174	PRJNA768450_P_NODE_1566_length_206_cov_1.847458_g1494_i0	PRJNA768450	1566	206	1.847458	3.80576348	Rhynchobodo	51333	Euglenozoa	other_Eukaryota	270	4.569999999999999e-68	NTclustered	gi\|2267232\|gb\|U67183.1\|U67183	51334	g1494	i0	92.593	76.3834951456311	189	12	91	2	19	206	966	1153	Rhynchobodo ATCC50359 small subunit ribosomal RNA gene, complete sequence	blastn	15735	272	0.992647058823529	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Rhynchobodo	Rhynchobodo ATCC50359
12685778	12685778	PRJNA768450_P_NODE_1750_length_175_cov_1.534247_g1678_i0	PRJNA768450	1750	175	1.534247	2.68493225	Rhynchobodo	51333	Euglenozoa	other_Eukaryota	279	6.21e-71	NTclustered	gi\|2267232\|gb\|U67183.1\|U67183	51334	g1678	i0	97.006	84.8114285714286	167	3	95	2	1	166	507	672	Rhynchobodo ATCC50359 small subunit ribosomal RNA gene, complete sequence	blastn	14842	281	0.99288256227758	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Rhynchobodo	Rhynchobodo ATCC50359
19872111	19872111	PRJNA768450_P_NODE_16_length_2142_cov_5.490771_g14_i0	PRJNA768450	16	2142	5.490771	117.61231482	Entosiphon oblongus	1732444	Euglenozoa	other_Eukaryota	3843	0	NTclustered	gi\|937541988\|gb\|KP306754.1\|	1732444	g14	i0	99.248	12.483660130719	2127	11	99	1	16	2142	11	2132	Entosiphon oblongum strain CCAP 1220/2 18S ribosomal RNA gene, partial sequence	blastn	26740	3843	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Heteronematales	Peranemataceae	Entosiphon	Entosiphon oblongus
21608291	21608291	PRJNA768450_P_NODE_1757_length_172_cov_3.727273_g1685_i0	PRJNA768450	1757	172	3.727273	6.41090956	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	246	6.17e-61	NTclustered	gi\|440222388\|gb\|JX030056.1\|	5659	g1685	i0	92.442	121.656976744186	172	13	100	0	1	172	11	182	Leishmania amazonensis isolate LaPH8.rRNA.32 28S ribosomal RNA (LSU-delta M2), partial sequence	blastn	20925	246	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania amazonensis

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