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

5 rows where analysis = "blastn", bioproject = "PRJNA682774" 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
1174713	1174713	PRJNA682774_P_NODE_801_length_479_cov_2.229064_g772_i0	PRJNA682774	801	479	2.229064	10.67721656	Bryopsis	3128	Plants	Plants	468	3.91e-127	NTclustered	gi\|969822372\|gb\|KT950953.1\|	3129	g772	i0	84.914	98.8496868475992	464	68	97	2	17	479	617	155	Bryopsis maxima actin gene, partial cds	blastn	47349	468	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Bryopsidaceae	Bryopsis	Bryopsis maxima
10868624	10868624	PRJNA682774_P_NODE_1389_length_370_cov_1.575758_g1360_i0	PRJNA682774	1389	370	1.575758	5.8303046	Chlamydomonas reinhardtii	3055	Plants	Plants	355	2.39e-93	NTclustered	gi\|5738230\|gb\|AF175385.1\|AF175385	3055	g1360	i0	85.07	77.7594594594595	355	46	95	6	15	367	57	406	Chlamydomonas reinhardtii 60S ribosomal protein L10a mRNA, complete cds	blastn	28771	355	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
17752547	17752547	PRJNA682774_P_NODE_4354_length_248_cov_0.891429_g4325_i0	PRJNA682774	4354	248	0.891429	2.21074392	Eukaryota	2759	Plants	Plants	457	4.07e-124	NTclustered	gi\|1714003650\|gb\|MN243923.1\|	3079	g4325	i0	100	99.9354838709677	247	0	99	0	2	248	769	523	Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence	blastn	24784	457	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sp.
23617541	23617541	PRJNA682774_P_NODE_3359_length_254_cov_2.585635_g3330_i0	PRJNA682774	3359	254	2.585635	6.5675129	Coccomyxa subellipsoidea	248742	Plants	Plants	217	7.73e-52	NTclustered	gi\|545374848\|ref\|XM_005651606.1\|	574566	g3330	i0	84.475	34.988188976378	219	34	86	0	4	222	271	53	Coccomyxa subellipsoidea C-169 ribosomal protein S26 component of cytosolic 80S ribosome and 40S small subunit mRNA	blastn	8887	217	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
24890790	24890790	PRJNA682774_P_NODE_2640_length_284_cov_0.957346_g2611_i0	PRJNA682774	2640	284	0.957346	2.71886264	Monoraphidium neglectum	145388	Plants	Plants	267	8.599999999999999e-67	NTclustered	gi\|926766867\|ref\|XM_014037032.1\|	145388	g2611	i0	86.92	81.5387323943662	237	31	83	0	2	238	237	1	Monoraphidium neglectum Tubulin alpha-1 chain mRNA	blastn	23157	267	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);;