metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA1112809" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA1112809" 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
27406965	27406965	PRJNA1112809_P_NODE_92023_length_349_cov_1.478261_g88748_i0	PRJNA1112809	92023	349	1.478261	5.15913089	root	1	Root_unresolved	Root_unresolved	43.9	0.0495	NR	KAL4853608.1	3077	g88748	i0	58.3	1.2378223495702	36	14	30.1	1	341	237	928	963	KAL4853608.1 Replication factor C subunit 1 [Chlorella vulgaris]	diamond	432	43.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
30280634	30280634	PRJNA1112809_P_NODE_159592_length_254_cov_3.502762_g156317_i0	PRJNA1112809	159592	254	3.502762	8.89701548	root	1	Root_unresolved	Root_unresolved	53.1	9.45e-6	NR	KAG2492987.1	47281	g156317	i0	39.5	1.68897637795276	76	45	88.6	1	30	254	1073	1148	KAG2492987.1 hypothetical protein HYH03_008886 [Edaphochlamys debaryana]	diamond	429	53.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales		Edaphochlamys	Edaphochlamys debaryana
31892327	31892327	PRJNA1112809_P_NODE_170637_length_249_cov_0.875000_g167362_i0	PRJNA1112809	170637	249	0.875	2.17875	Eukaryota	2759	Plants	Plants	124	8.119999999999999e-31	NR	KAL4858421.1	3077	g167362	i0	70.7	21.7228915662651	82	24	98.8	0	247	2	110	191	KAL4858421.1 40S ribosomal protein S4 [Chlorella vulgaris]	diamond	5409	125	0.992	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
32398707	32398707	PRJNA1112809_P_NODE_125359_length_290_cov_1.064516_g122084_i0	PRJNA1112809	125359	290	1.064516	3.0870964	root	1	Root_unresolved	Root_unresolved	175	1.38e-49	NR	KAI8467676.1	39955	g122084	i0	91.7	170.772413793103	96	8	99.3	0	290	3	301	396	KAI8467676.1 MAG: ATP synthase subunit beta, mitochondrial [Monoraphidium minutum]	diamond	49524	176	0.994318181818182	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium minutum

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