metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJEB30004" and tax

4 rows where analysis = "blastn", bioproject = "PRJEB30004" 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
45640	45640	PRJEB30004_P_NODE_504841_length_190_cov_1.629139_g489214_i0	PRJEB30004	504841	190	1.629139	3.0953641	uncultured Scenedesmus	223195	Plants	Plants	333	5.209999999999999e-87	NTclustered	gi\|430000717\|gb\|JX877643.1\|	223195	g489214	i0	98.413	119.194736842105	189	3	99	0	2	190	409	221	Uncultured Scenedesmus clone HP04 23S ribosomal RNA gene, partial sequence	blastn	22647	333	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae		uncultured Scenedesmus
15016511	15016511	PRJEB30004_P_NODE_533452_length_182_cov_1.944056_g517825_i0	PRJEB30004	533452	182	1.944056	3.53818192	root	1	Root_unresolved	Root_unresolved	76.8	9.19e-10	NTclustered	gi\|2254866750\|gb\|MW900257.1\|	3077	g517825	i0	100	21.8131868131868	41	0	23	0	1	41	19251	19291	Chlorella vulgaris chloroplast, complete genome	blastn	3970	76.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
16613012	16613012	PRJEB30004_P_NODE_306614_length_277_cov_2.109244_g290987_i0	PRJEB30004	306614	277	2.109244	5.84260588	Prasiolopsis sp. SAG 84.81	3239232	Plants	Plants	329	1.05e-85	NTclustered	gi\|698347906\|gb\|KM462862.1\|	1562155	g290987	i0	92.34	96.4584837545126	235	13	85	4	1	235	2099	2328	Prasiolopsis sp. SAG 84.81 chloroplast, complete genome	blastn	26719	329	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Prasiolaceae	Prasiolopsis	Prasiolopsis sp. SAG 84.81
17905058	17905058	PRJEB30004_P_NODE_667095_length_154_cov_1.304348_g651468_i0	PRJEB30004	667095	154	1.304348	2.00869592	Monoraphidium neglectum	145388	Plants	Plants	52.8	0.013	NTclustered	gi\|926782681\|ref\|XM_014044361.1\|	145388	g651468	i0	100	0.181818181818182	28	0	18	0	16	43	170	143	Monoraphidium neglectum COBW domain-containing protein 1 mRNA	blastn	28	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum

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