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

5 rows where analysis = "blastn", bioproject = "PRJNA758398" and tax_clade = "Haptista"

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
4568087	4568087	PRJNA758398_S_NODE_27584_length_201_cov_0.953947_g27443_i0	PRJNA758398	27584	201	0.953947	1.91743347	Raphidocystis contractilis	2792838	Root_unresolved	Root_unresolved	159	1e-34	NTclustered	gi\|259475609\|emb\|FN392417.1\|	2792838	g27443	i0	86.806	1.57213930348259	144	17	71	2	1	143	370	228	Raphidiophrys contractilis partial mRNA for 40S ribosomal protein S13, contig 22018	blastn	316	159	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Raphidocystidae	Raphidocystis	Raphidocystis contractilis
5843218	5843218	PRJNA758398_S_NODE_26285_length_204_cov_1.896774_g26144_i0	PRJNA758398	26285	204	1.896774	3.86941896	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	141	3.69e-29	NTclustered	gi\|551548842\|ref\|XM_005762007.1\|	280463	g26144	i0	81.657	11.1274509803922	169	31	83	0	1	169	280	112	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	2270	141	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
10944033	10944033	PRJNA758398_S_NODE_45289_length_165_cov_2.637931_g45148_i0	PRJNA758398	45289	165	2.637931	4.35258615	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	154	3.68e-33	NTclustered	gi\|551577272\|ref\|XM_005774215.1\|	280463	g45148	i0	88.281	26.1151515151515	128	15	78	0	23	150	128	1	Emiliania huxleyi CCMP1516 40S ribosomal protein S4 partial mRNA	blastn	4309	154	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
14768833	14768833	PRJNA758398_S_NODE_45932_length_165_cov_0.879310_g45791_i0	PRJNA758398	45932	165	0.87931	1.4508615	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	99	1.75e-16	NTclustered	gi\|551624736\|ref\|XM_005792514.1\|	280463	g45791	i0	87.952	0.503030303030303	83	10	50	0	1	83	328	246	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	83	99	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
23692548	23692548	PRJNA758398_S_NODE_19699_length_228_cov_2.279330_g19558_i0	PRJNA758398	19699	228	2.27933	5.1968724	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	204	5.2999999999999994e-48	NTclustered	gi\|551548842\|ref\|XM_005762007.1\|	280463	g19558	i0	83.486	4.60964912280702	218	36	96	0	1	218	322	105	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	1051	204	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi

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