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

5 rows where analysis = "blastn", bioproject = "PRJNA1002570" 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
3978703	3978703	PRJNA1002570_P_NODE_25784_length_278_cov_1.195122_g25589_i0	PRJNA1002570	25784	278	1.195122	3.32243916	Coccomyxa sp. Obi	2315456	Plants	Plants	294	3.85e-75	NTclustered	gi\|2106301938\|dbj\|AP025008.1\|	2315456	g25589	i0	86.111	1.49280575539568	288	22	99	5	1	275	148746	149028	Coccomyxa sp. Obi chloroplast DNA, complete genome	blastn	415	294	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa sp. Obi
9079924	9079924	PRJNA1002570_P_NODE_34748_length_254_cov_1.701657_g34553_i0	PRJNA1002570	34748	254	1.701657	4.32220878	Paradoxia multiseta	249350	Plants	Plants	459	1.1599999999999999e-124	NTclustered	gi\|723457039\|ref\|NC_025540.1\|	249350	g34553	i0	99.213	15.4645669291339	254	2	100	0	1	254	127158	127411	Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome	blastn	3928	459	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Paradoxia	Paradoxia multiseta
12906061	12906061	PRJNA1002570_P_NODE_27191_length_274_cov_2.069652_g26996_i0	PRJNA1002570	27191	274	2.069652	5.67084648	Coccomyxa subellipsoidea	248742	Plants	Plants	204	6.569999999999999e-48	NTclustered	gi\|545359875\|ref\|XM_005645307.1\|	574566	g26996	i0	95.312	7.86496350364964	128	6	47	0	120	247	1	128	Coccomyxa subellipsoidea C-169 hypothetical protein mRNA	blastn	2155	204	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
19277778	19277778	PRJNA1002570_P_NODE_20176_length_290_cov_1.341014_g19981_i0	PRJNA1002570	20176	290	1.341014	3.8889406	Chlamydomonas reinhardtii	3055	Plants	Plants	63.9	1.24e-5	NTclustered	gi\|58257870\|gb\|AC148879.2\|	3055	g19981	i0	95	0.551724137931034	40	2	14	0	246	285	31540	31501	Chlamydomonas reinhardtii clone cr-36D8, complete sequence	blastn	160	63.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
21829385	21829385	PRJNA1002570_P_NODE_41038_length_245_cov_0.895349_g40843_i0	PRJNA1002570	41038	245	0.895349	2.19360505	Coccomyxa subellipsoidea	248742	Plants	Plants	233	7.36e-57	NTclustered	gi\|545365573\|ref\|XM_005647694.1\|	574566	g40843	i0	89.418	9.96326530612245	189	14	77	6	10	197	453	636	Coccomyxa subellipsoidea C-169 hypothetical protein mRNA	blastn	2441	233	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea

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