metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJEB41113" and tax

7 rows where analysis = "diamond", bioproject = "PRJEB41113" 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
19184627	19184627	PRJEB41113_S_NODE_1736_length_234_cov_2.137056_g1727_i0	PRJEB41113	1736	234	2.137056	5.00071104	Coccomyxa subellipsoidea C-169	574566	Plants	Plants	105	2.64e-24	NR	XP_005643606.1	574566	g1727	i0	66.3	1.02564102564103	80	24	98.7	1	231	1	527	606	XP_005643606.1 vacuolar ATP synthase, subunit A [Coccomyxa subellipsoidea C-169]	diamond	240	105	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
27437885	27437885	PRJEB41113_S_NODE_2043_length_225_cov_13.265957_g2034_i0	PRJEB41113	2043	225	13.265957	29.84840325	Eukaryota	2759	Plants	Plants	67.4	1.14e-11	NR	XP_011399104.1	3075	g2034	i0	87.5	14.9333333333333	32	4	42.7	0	2	97	145	176	XP_011399104.1 40S ribosomal protein S9-1 [Auxenochlorella protothecoides]	diamond	3360	67.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
28321656	28321656	PRJEB41113_S_NODE_13826_length_152_cov_1.991304_g13817_i0	PRJEB41113	13826	152	1.991304	3.02678208	root	1	Root_unresolved	Root_unresolved	40.8	0.0162	NR	BBD21622.1	1449749	g13817	i0	47.8	1.69736842105263	46	24	90.8	0	146	9	2	47	BBD21622.1 30S ribosomal protein S14 [Poropsis sp. ID1_4]	diamond	258	40.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales		Poropsis	Poropsis sp. ID1_4
29907212	29907212	PRJEB41113_S_NODE_8231_length_167_cov_2.907692_g8222_i0	PRJEB41113	8231	167	2.907692	4.85584564	Scenedesmus sp. NREL 46B-D3	2650976	Plants	Plants	72.8	1.24e-14	NR	KAF6258266.1	2650976	g8222	i0	65.5	0.988023952095808	55	19	98.8	0	165	1	57	111	KAF6258266.1 ribosomal protein L14 component of cytosolic 80S ribosome and 60S large subunit [Scenedesmus sp. NREL 46B-D3]	diamond	165	72.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. NREL 46B-D3
30002021	30002021	PRJEB41113_S_NODE_9611_length_161_cov_2.806452_g9602_i0	PRJEB41113	9611	161	2.806452	4.51838772	Chlamydomonas eustigma	1157962	Plants	Plants	48.5	8.05e-5	NR	GAX80709.1	1157962	g9602	i0	63.9	0.670807453416149	36	13	67.1	0	160	53	175	210	GAX80709.1 hypothetical protein CEUSTIGMA_g8144.t1 [Chlamydomonas eustigma]	diamond	108	48.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
31834904	31834904	PRJEB41113_S_NODE_3577_length_200_cov_1.944785_g3568_i0	PRJEB41113	3577	200	1.944785	3.88957	Rhexinema sarcinoideum	43261	Plants	Plants	45.8	0.00173	NR	AOC61498.1	43261	g3568	i0	44.6	1.935	65	25	97.5	2	1	195	501	554	AOC61498.1 NADH dehydrogenase subunit 2 [Rhexinema sarcinoideum]	diamond	387	45.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulotrichales	Helicodictyaceae	Rhexinema	Rhexinema sarcinoideum
32625684	32625684	PRJEB41113_S_NODE_2500_length_216_cov_2.860335_g2491_i0	PRJEB41113	2500	216	2.860335	6.1783236	Trebouxia sp. C	2796353	Plants	Plants	82.4	2.51e-16	NR	KAL3148025.1	3373144	g2491	i0	92.7	1.13888888888889	41	3	56.9	0	7	129	410	450	KAL3148025.1 hypothetical protein ABBQ38_014316 [Trebouxia sp. C0009 RCD-2024]	diamond	246	82.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0009 RCD-2024

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