metadata: contig_metadata: 9 rows where bioproject = "PRJNA986547" and tax

9 rows where bioproject = "PRJNA986547" 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
9902413	9902413	PRJNA986547_P_NODE_6448_length_265_cov_5.348958_g6366_i0	PRJNA986547	6448	265	5.348958	14.1747387	Prototheca wickerhamii	3111	Plants	Plants	67.4	1e-10	NR	KAK2080072.1	3111	g6366	i0	66	3.10188679245283	53	18	60	0	1	159	397	449	KAK2080072.1 hypothetical protein QBZ16_002468 [Prototheca wickerhamii]	diamond	822	67.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca wickerhamii
12453435	12453435	PRJNA986547_P_NODE_4870_length_280_cov_18.768116_g4788_i0	PRJNA986547	4870	280	18.768116	52.5507248	Pleurastrosarcina brevispinosa	163096	Plants	Plants	220	6.68e-53	NTclustered	gi\|698349064\|gb\|KM462875.1\|	163096	g4788	i0	96.947	0.467857142857143	131	4	47	0	1	131	14344	14474	Chlorosarcina brevispinosa culture-collection UTEX:1176 chloroplast, partial genome	blastn	131	220	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae			Pleurastrosarcina	Pleurastrosarcina brevispinosa
16277068	16277068	PRJNA986547_P_NODE_2513_length_311_cov_3.533613_g2431_i0	PRJNA986547	2513	311	3.533613	10.98953643	Chlamydomonas reinhardtii	3055	Plants	Plants	54.7	0.008	NTclustered	gi\|2082255134\|ref\|XM_043066014.1\|	3055	g2431	i0	100	0.0932475884244373	29	0	9	0	261	289	101	129	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_09g401108v5), mRNA	blastn	29	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
21376238	21376238	PRJNA986547_P_NODE_11977_length_241_cov_1.833333_g11895_i0	PRJNA986547	11977	241	1.833333	4.41833253	Pleurastrum terricola	34116	Plants	Plants	440	3.959999999999999e-119	NTclustered	gi\|153805558\|ref\|NC_009681.1\|	34116	g11895	i0	99.585	100.701244813278	241	1	100	0	1	241	2485	2725	Leptosira terrestris chloroplast, complete genome	blastn	24269	440	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Pleurastraceae	Pleurastrum	Pleurastrum terricola
23926806	23926806	PRJNA986547_P_NODE_8199_length_253_cov_1.411111_g8117_i0	PRJNA986547	8199	253	1.411111	3.57011083	Volvox carteri	3067	Plants	Plants	108	4.83e-19	NTclustered	gi\|302840791\|ref\|XM_002951896.1\|	3068	g8117	i0	82.4	7.27667984189723	125	20	49	2	124	247	451	328	Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 60S large subunit (rpl19), mRNA	blastn	1841	108	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
27601293	27601293	PRJNA986547_P_NODE_15664_length_212_cov_5.532374_g15582_i0	PRJNA986547	15664	212	5.532374	11.72863288	Micractinium	126838	Plants	Plants	47.4	5.89e-4	NR	KAL4444560.1	554058	g15582	i0	67.6	0.962264150943396	34	11	48.1	0	2	103	1116	1149	KAL4444560.1 hypothetical protein ABPG77_002377 [Micractinium sp. CCAP 211/92]	diamond	204	47.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium sp. CCAP 211/92
28542597	28542597	PRJNA986547_P_NODE_2907_length_310_cov_3.493671_g2825_i0	PRJNA986547	2907	310	3.493671	10.8303801	Edaphochlamys debaryana	47281	Plants	Plants	89.4	2.94e-18	NR	KAG2496141.1	47281	g2825	i0	47.6	0.996774193548387	103	49	99.7	2	310	2	175	272	KAG2496141.1 hypothetical protein HYH03_005743 [Edaphochlamys debaryana]	diamond	309	89.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales		Edaphochlamys	Edaphochlamys debaryana
30317234	30317234	PRJNA986547_P_NODE_16512_length_204_cov_6.641221_g16430_i0	PRJNA986547	16512	204	6.641221	13.54809084	Eukaryota	2759	Plants	Plants	104	2.49e-25	NR	KAK9809117.1	41462	g16430	i0	77.9	43	68	15	100	0	1	204	160	227	KAK9809117.1 hypothetical protein WJX72_009563 [[Myrmecia] bisecta]	diamond	8772	105	0.990476190476191	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
32813584	32813584	PRJNA986547_P_NODE_16880_length_201_cov_6.140625_g16798_i0	PRJNA986547	16880	201	6.140625	12.34265625	Eukaryota	2759	Plants	Plants	65.9	1.49e-10	NR	CAD7695962.1	121088	g16798	i0	51.5	22.6567164179104	68	28	95.5	2	200	9	731	797	CAD7695962.1 unnamed protein product [Ostreobium quekettii]	diamond	4554	65.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Ostreobiaceae	Ostreobium	Ostreobium quekettii

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