metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA287283" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA287283" and tax_phylum = "Chlorophyta"

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
26757496	26757496	PRJNA287283_P_NODE_7861_length_191_cov_1.623188_g7637_i0	PRJNA287283	7861	191	1.623188	3.10028908	Cymbomonas tetramitiformis	36881	Plants	Plants	50.1	4.8e-5	NR	KAK3260788.1	36881	g7637	i0	75.9	0.910994764397906	29	7	45.5	0	190	104	396	424	KAK3260788.1 hypothetical protein CYMTET_30267 [Cymbomonas tetramitiformis]	diamond	174	50.1	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
28148151	28148151	PRJNA287283_P_NODE_8925_length_181_cov_0.875000_g8701_i0	PRJNA287283	8925	181	0.875	1.58375	Bryopsis sp. KO-2	3115439	Plants	Plants	48.1	2.04e-4	NR	GMH39996.1	3041901	g8701	i0	55	0.662983425414365	40	18	66.3	0	124	5	4	43	GMH39996.1 hypothetical protein BSKO_07900 [Bryopsis sp. KO-2023]	diamond	120	48.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Bryopsidaceae	Bryopsis	Bryopsis sp. KO-2023
28368932	28368932	PRJNA287283_P_NODE_4306_length_301_cov_2.592742_g4082_i0	PRJNA287283	4306	301	2.592742	7.80415342	Chlamydomonas eustigma	1157962	Plants	Plants	58.5	1.94e-7	NR	GAX78925.1	1157962	g4082	i0	49.1	0.568106312292359	57	26	53.8	1	138	299	170	226	GAX78925.1 hypothetical protein CEUSTIGMA_g6364.t1 [Chlamydomonas eustigma]	diamond	171	58.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
29758167	29758167	PRJNA287283_P_NODE_1491_length_577_cov_1.444656_g1275_i0	PRJNA287283	1491	577	1.444656	8.33566512	Chlamydomonas eustigma	1157962	Plants	Plants	63.2	6.76e-8	NR	GAX78925.1	1157962	g1275	i0	27.7	0.805892547660312	155	92	75.4	5	575	141	306	450	GAX78925.1 hypothetical protein CEUSTIGMA_g6364.t1 [Chlamydomonas eustigma]	diamond	465	63.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
30105631	30105631	PRJNA287283_P_NODE_1492_length_577_cov_1.179389_g1276_i0	PRJNA287283	1492	577	1.179389	6.80507453	Chlamydomonas eustigma	1157962	Plants	Plants	68.2	1.28e-9	NR	GAX78925.1	1157962	g1276	i0	28.8	0.811091854419411	156	89	75.4	6	3	437	306	450	GAX78925.1 hypothetical protein CEUSTIGMA_g6364.t1 [Chlamydomonas eustigma]	diamond	468	68.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
30579426	30579426	PRJNA287283_P_NODE_10193_length_176_cov_0.910569_g9969_i0	PRJNA287283	10193	176	0.910569	1.60260144	Coccomyxa sp. Obi	2315456	Plants	Plants	70.5	2.48e-12	NR	BDA40807.1	2315456	g9969	i0	64.8	0.920454545454545	54	19	92	0	14	175	413	466	BDA40807.1 Vitamin B12 transport ATP-binding protein BacA [Coccomyxa sp. Obi]	diamond	162	70.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa sp. Obi

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