metadata: contig_metadata: 6 rows where bioproject = "PRJNA380660" and tax

6 rows where bioproject = "PRJNA380660" 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
15102076	15102076	PRJNA380660_P_NODE_5232_length_342_cov_162.741214_g4834_i0	PRJNA380660	5232	342	162.741214	556.57495188	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	189	2.3599999999999993e-43	NTclustered	gi\|61187370\|gb\|AY752991.1\|	299901	g4834	i0	94.355	39.6491228070175	124	6	48	1	85	208	1977	2099	Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence	blastn	13560	189	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Heterophryidae	Sphaerastrum	Sphaerastrum fockii
27376803	27376803	PRJNA380660_P_NODE_4403_length_385_cov_2.382022_g4007_i0	PRJNA380660	4403	385	2.382022	9.1707847	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	135	9.16e-38	NR	ALD47893.1	2903	g4007	i0	57.5	4.97142857142857	127	23	99	2	382	2	20	115	ALD47893.1 adaptor protein complex 4 subunit sigma [Emiliania huxleyi]	diamond	1914	136	0.992647058823529	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
27707258	27707258	PRJNA380660_P_NODE_7484_length_263_cov_2.320513_g7084_i0	PRJNA380660	7484	263	2.320513	6.10294919	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	43.5	0.0251	NR	XP_005794329.1	280463	g7084	i0	76.9	1.106463878327	26	6	29.7	0	89	12	472	497	XP_005794329.1 hypothetical protein EMIHUDRAFT_447507 [Emiliania huxleyi CCMP1516]	diamond	291	43.5	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
28811601	28811601	PRJNA380660_P_NODE_9168_length_222_cov_2.238342_g8768_i0	PRJNA380660	9168	222	2.238342	4.96911924	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	43.1	0.0221	NR	KAL1510668.1	97485	g8768	i0	36.5	1	74	43	100	2	222	1	1687	1756	KAL1510668.1 hypothetical protein AB1Y20_006965 [Prymnesium parvum]	diamond	222	43.1	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
29822058	29822058	PRJNA380660_P_NODE_4751_length_366_cov_2.445104_g4354_i0	PRJNA380660	4751	366	2.445104	8.94908064	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	99.4	3.74e-23	NR	XP_005790106.1	280463	g4354	i0	59	2.04098360655738	83	30	68	1	36	284	120	198	XP_005790106.1 FKBP type peptidylprolyl isomerase [Emiliania huxleyi CCMP1516]	diamond	747	99.4	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
31592182	31592182	PRJNA380660_P_NODE_2276_length_562_cov_1.707317_g1926_i0	PRJNA380660	2276	562	1.707317	9.59512154	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	164	4.6699999999999985e-43	NR	KAL1529061.1	97485	g1926	i0	52.3	0.795373665480427	149	67	79	3	444	1	741	886	KAL1529061.1 hypothetical protein AB1Y20_000024 [Prymnesium parvum]	diamond	447	164	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum

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