metadata: contig_metadata: 5 rows where bioproject = "PRJEB25789" and tax

5 rows where bioproject = "PRJEB25789" and tax_clade = "core chlorophytes"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
23309	23309	PRJEB25789_S_NODE_7121_length_346_cov_1.959707_g7042_i0	PRJEB25789	7121	346	1.959707	6.78058622	Bryopsis sp. KO-2	3115439	Plants	Plants	84	1.53e-16	NR	GMH41011.1	3041901	g7042	i0	56.8	0.641618497109827	74	31	64.2	1	345	124	211	283	GMH41011.1 hypothetical protein BSKO_08921 [Bryopsis sp. KO-2023]	diamond	222	84	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Bryopsidaceae	Bryopsis	Bryopsis sp. KO-2023
6401413	6401413	PRJEB25789_S_NODE_4426_length_421_cov_1.545977_g4347_i0	PRJEB25789	4426	421	1.545977	6.50856317	Raphidocelis subcapitata	307507	Plants	Plants	186	1.33e-57	NR	GBF93448.1	307507	g4347	i0	76.5	4.06888361045131	115	25	80.5	1	399	61	42	156	GBF93448.1 ribosomal protein S1 [Raphidocelis subcapitata]	diamond	1713	186	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Raphidocelis	Raphidocelis subcapitata
15325507	15325507	PRJEB25789_S_NODE_7893_length_333_cov_1.730769_g7814_i0	PRJEB25789	7893	333	1.730769	5.76346077	Raphidocelis subcapitata	307507	Plants	Plants	164	2.8e-49	NR	GBF93448.1	307507	g7814	i0	75.9	2.90990990990991	108	24	95.5	1	318	1	42	149	GBF93448.1 ribosomal protein S1 [Raphidocelis subcapitata]	diamond	969	164	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Raphidocelis	Raphidocelis subcapitata
31638460	31638460	PRJEB25789_S_NODE_17616_length_248_cov_0.880000_g17537_i0	PRJEB25789	17616	248	0.88	2.1824	Eukaryota	2759	Plants	Plants	139	4.42e-36	NR	KAL4858421.1	3077	g17537	i0	79.3	152.758064516129	82	17	99.2	0	247	2	89	170	KAL4858421.1 40S ribosomal protein S4 [Chlorella vulgaris]	diamond	37884	140	0.992857142857143	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
32303271	32303271	PRJEB25789_S_NODE_12579_length_280_cov_1.173913_g12500_i0	PRJEB25789	12579	280	1.173913	3.2869564	Eukaryota	2759	Plants	Plants	99.8	4.92e-25	NR	KAG2494930.1	47281	g12500	i0	53.8	5.35714285714286	80	37	85.7	0	245	6	16	95	KAG2494930.1 hypothetical protein HYH03_006865 [Edaphochlamys debaryana]	diamond	1500	99.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales		Edaphochlamys	Edaphochlamys debaryana

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