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

5 rows where analysis = "blastn", bioproject = "PRJNA758398" and tax_phylum = "Tubulinea"

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
3291042	3291042	PRJNA758398_S_NODE_33263_length_185_cov_2.132353_g33122_i0	PRJNA758398	33263	185	2.132353	3.94485305	Copromyxa protea	931554	Tubulinea	other_Eukaryota	219	1.4699999999999996e-52	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g33122	i0	92.715	0.816216216216216	151	11	82	0	35	185	523	373	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	151	219	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
3291079	3291079	PRJNA758398_S_NODE_36603_length_178_cov_1.186047_g36462_i0	PRJNA758398	36603	178	1.186047	2.11116366	Spumochlamys perforata	675831	Tubulinea	other_Eukaryota	243	8.33e-60	NTclustered	gi\|259595680\|gb\|FJ705344.1\|	675831	g36462	i0	92.353	99.438202247191	170	13	96	0	9	178	653	484	Spumochlamys perforata actin gene, partial cds	blastn	17700	243	1	Eukaryota	Amoebozoa	Tubulinea	Corycida		Microchlamyiidae	Spumochlamys	Spumochlamys perforata
9668276	9668276	PRJNA758398_S_NODE_31888_length_189_cov_1.092857_g31747_i0	PRJNA758398	31888	189	1.092857	2.06549973	Cryptodifflugia operculata	1078836	Tubulinea	other_Eukaryota	178	2.5599999999999993e-40	NTclustered	gi\|345452566\|gb\|JF694301.1\|	1078836	g31747	i0	83.957	50.6507936507937	187	28	98	2	3	188	505	320	Cryptodifflugia operculata clone 5 actin gene, partial cds	blastn	9573	178	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Cryptodifflugiidae	Cryptodifflugia	Cryptodifflugia operculata
17317855	17317855	PRJNA758398_S_NODE_21614_length_220_cov_1.783626_g21473_i0	PRJNA758398	21614	220	1.783626	3.9239772	Copromyxa protea	931554	Tubulinea	other_Eukaryota	303	4.87e-78	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g21473	i0	91.818	5.73636363636364	220	14	99	3	3	220	1011	794	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	1262	303	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
17318130	17318130	PRJNA758398_S_NODE_42794_length_167_cov_0.864407_g42653_i0	PRJNA758398	42794	167	0.864407	1.44355969	Copromyxa protea	931554	Tubulinea	other_Eukaryota	259	7.69e-65	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g42653	i0	94.611	28.1916167664671	167	9	100	0	1	167	310	144	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	4708	259	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea

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