metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1198392" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1198392" 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
4871827	4871827	PRJNA1198392_P_NODE_12424_length_270_cov_1.563452_g12283_i0	PRJNA1198392	12424	270	1.563452	4.2213204	Micractinium sp. CCAP 211/92	554058	Plants	Plants	144	1.0899999999999997e-42	NR	KAL4446784.1	554058	g12283	i0	75.9	4.84444444444444	87	21	96.7	0	8	268	10	96	KAL4446784.1 hypothetical protein ABPG77_008028 [Micractinium sp. CCAP 211/92]	diamond	1308	144	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium sp. CCAP 211/92
9252458	9252458	PRJNA1198392_P_NODE_15048_length_255_cov_1.692308_g14907_i0	PRJNA1198392	15048	255	1.692308	4.3153854	Bryopsis sp. KO-2	3115439	Plants	Plants	58.2	1.65e-7	NR	GMH40484.1	3041901	g14907	i0	66.7	9.2	45	14	51.8	1	7	138	248	292	GMH40484.1 hypothetical protein BSKO_08388 [Bryopsis sp. KO-2023]	diamond	2346	58.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Bryopsidaceae	Bryopsis	Bryopsis sp. KO-2023
28114663	28114663	PRJNA1198392_P_NODE_16185_length_250_cov_1.740113_g16044_i0	PRJNA1198392	16185	250	1.740113	4.3502825	Coccomyxa subellipsoidea	248742	Plants	Plants	60.8	1.71e-8	NR	KAK9903904.1	248742	g16044	i0	44.3	0.948	79	39	90	3	231	7	24	101	KAK9903904.1 hypothetical protein WJX75_000011 [Coccomyxa subellipsoidea]	diamond	237	60.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
28228198	28228198	PRJNA1198392_P_NODE_9246_length_286_cov_1.244131_g9105_i0	PRJNA1198392	9246	286	1.244131	3.55821466	Eukaryota	2759	Plants	Plants	69.7	2.08e-11	NR	KAJ9512917.1	44745	g9105	i0	47	4.40559440559441	83	41	85	2	257	15	245	326	KAJ9512917.1 hypothetical protein QJQ45_029067 [Haematococcus lacustris]	diamond	1260	69.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
29440619	29440619	PRJNA1198392_P_NODE_11390_length_275_cov_2.193069_g11249_i0	PRJNA1198392	11390	275	2.193069	6.03093975	Monoraphidium neglectum	145388	Plants	Plants	45.1	0.00269	NR	XP_013906395.1	145388	g11249	i0	60.5	0.905454545454545	43	16	45.8	1	274	149	27	69	XP_013906395.1 hypothetical protein MNEG_0583 [Monoraphidium neglectum]	diamond	249	45.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
29617341	29617341	PRJNA1198392_P_NODE_18590_length_246_cov_0.890173_g18449_i0	PRJNA1198392	18590	246	0.890173	2.18982558	Chlamydomonadales	3042	Plants	Plants	48.9	2.59e-4	NR	XP_042917195.1	3055	g18449	i0	56.8	7.1219512195122	44	17	51.2	1	228	103	393	436	XP_042917195.1 uncharacterized protein CHLRE_13g563733v5 [Chlamydomonas reinhardtii]	diamond	1752	48.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
30249672	30249672	PRJNA1198392_P_NODE_10592_length_279_cov_2.160194_g10451_i0	PRJNA1198392	10592	279	2.160194	6.02694126	Chlorophyta	3041	Plants	Plants	90.5	9.36e-19	NR	KAK9807779.1	41462	g10451	i0	52.2	8.90322580645161	92	42	98.9	1	277	2	741	830	KAK9807779.1 hypothetical protein WJX72_008954 [[Myrmecia] bisecta]	diamond	2484	90.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
32317478	32317478	PRJNA1198392_P_NODE_14739_length_257_cov_1.673913_g14598_i0	PRJNA1198392	14739	257	1.673913	4.30195641	Chlamydomonas eustigma	1157962	Plants	Plants	78.6	3.65e-16	NR	GAX83532.1	1157962	g14598	i0	50.8	0.712062256809339	61	30	71.2	0	3	185	92	152	GAX83532.1 hypothetical protein CEUSTIGMA_g10957.t1 [Chlamydomonas eustigma]	diamond	183	78.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma

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