metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA674050" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA674050" 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
26669948	26669948	PRJNA674050_P_NODE_39461_length_242_cov_0.917160_g39258_i0	PRJNA674050	39461	242	0.91716	2.2195272	Trebouxia sp. C	2796353	Plants	Plants	51.2	3.85e-5	NR	KAL0043787.1	2905655	g39258	i0	39	0.954545454545455	77	42	89.3	1	225	10	482	558	KAL0043787.1 hypothetical protein WJX82_010718 [Trebouxia sp. C0006]	diamond	231	51.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0006
28250200	28250200	PRJNA674050_P_NODE_28586_length_248_cov_0.891429_g28383_i0	PRJNA674050	28586	248	0.891429	2.21074392	Chlamydomonas incerta	51695	Plants	Plants	120	2.15e-29	NR	KAG2442811.1	51695	g28383	i0	67.1	3.82258064516129	79	26	95.6	0	12	248	340	418	KAG2442811.1 hypothetical protein HXX76_002890 [Chlamydomonas incerta]	diamond	948	120	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
30081617	30081617	PRJNA674050_P_NODE_31252_length_247_cov_0.873563_g31049_i0	PRJNA674050	31252	247	0.873563	2.15770061	Haematococcus lacustris	44745	Plants	Plants	90.1	8.52e-19	NR	KAJ9513997.1	44745	g31049	i0	48.9	1.09311740890688	90	38	99.6	1	246	1	541	630	KAJ9513997.1 hypothetical protein QJQ45_021078 [Haematococcus lacustris]	diamond	270	90.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
30346970	30346970	PRJNA674050_P_NODE_15892_length_272_cov_1.924623_g15689_i0	PRJNA674050	15892	272	1.924623	5.23497456	Chlorellales	35460	Plants	Plants	84.3	1.17e-18	NR	PRW20803.1	3076	g15689	i0	58.9	6.9375	90	26	99.3	2	270	1	27	105	PRW20803.1 60S ribosomal L35-like [Chlorella sorokiniana]	diamond	1887	85.1	0.990599294947121	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
32516500	32516500	PRJNA674050_P_NODE_35399_length_244_cov_0.912281_g35196_i0	PRJNA674050	35399	244	0.912281	2.22596564	Tetradesmus obliquus	3088	Plants	Plants	61.6	8.02e-9	NR	WIA09331.1	3088	g35196	i0	55.6	3.90983606557377	45	20	55.3	0	233	99	500	544	WIA09331.1 hypothetical protein OEZ85_008738 [Tetradesmus obliquus]	diamond	954	61.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus

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