metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA752572" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA752572" 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
7579317	7579317	PRJNA752572_P_NODE_259666_length_166_cov_1.442748_g259159_i0	PRJNA752572	259666	166	1.442748	2.39496168	Chlamydomonadales	3042	Plants	Plants	154	3.699999999999999e-33	NTclustered	gi\|167441\|gb\|M11447.1\|CRETBA1A	3055	g259159	i0	89.344	75.1867469879518	122	13	73	0	45	166	1919	1798	Chlamydomonas reinhardtii alpha-1 tubulin gene, complete cds	blastn	12481	154	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
10130034	10130034	PRJNA752572_P_NODE_220208_length_179_cov_1.111111_g219701_i0	PRJNA752572	220208	179	1.111111	1.98888869	Eukaryota	2759	Plants	Plants	135	1.46e-27	NTclustered	gi\|760440306\|ref\|XM_011398920.1\|	3075	g219701	i0	90.291	55.6871508379888	103	10	58	0	1	103	802	700	Auxenochlorella protothecoides S-adenosylmethionine synthase 2 partial mRNA	blastn	9968	135	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
11405164	11405164	PRJNA752572_P_NODE_101869_length_267_cov_4.534483_g101362_i0	PRJNA752572	101869	267	4.534483	12.10706961	Eukaryota	2759	Plants	Plants	102	2.39e-17	NTclustered	gi\|157043070\|gb\|EU116020.1\|	3046	g101362	i0	82.258	8.73782771535581	124	16	45	6	16	136	103	223	Dunaliella salina histone H3 (dh3) and histone H4 (dh4) genes, partial cds	blastn	2333	102	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Dunaliellaceae	Dunaliella	Dunaliella salina
16031171	16031171	PRJNA752572_P_NODE_166653_length_207_cov_1.534884_g166146_i0	PRJNA752572	166653	207	1.534884	3.17720988	Tupiella akineta	160070	Plants	Plants	54.7	0.005	NTclustered	gi\|108796875\|ref\|NC_008114.1\|	160070	g166146	i0	87.755	0.236714975845411	49	3	22	2	61	106	81231	81279	Pseudendoclonium akinetum chloroplast, complete genome	blastn	49	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulotrichales	Tupiellaceae	Tupiella	Tupiella akineta
21131206	21131206	PRJNA752572_P_NODE_30157_length_496_cov_7.856833_g29671_i0	PRJNA752572	30157	496	7.856833	38.96989168	Monoraphidium neglectum	145388	Plants	Plants	226	2.7e-54	NTclustered	gi\|926780803\|ref\|XM_014043422.1\|	145388	g29671	i0	80.519	70.5725806451613	308	48	61	10	113	417	310	12	Monoraphidium neglectum Histone H4 mRNA	blastn	35004	226	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);;