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

5 rows where analysis = "blastn", bioproject = "PRJNA195897" 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
1055327	1055327	PRJNA195897_P_NODE_3281_length_270_cov_1.276018_g3248_i0	PRJNA195897	3281	270	1.276018	3.4452486	Eukaryota	2759	Plants	Plants	147	1.1000000000000001e-30	NTclustered	gi\|552823017\|ref\|XM_005846187.1\|	554065	g3248	i0	79.71	11.6481481481481	207	39	76	3	8	213	2153	1949	Chlorella variabilis hypothetical protein (CHLNCDRAFT_36029) mRNA, complete cds	blastn	3145	147	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
15668810	15668810	PRJNA195897_P_NODE_6473_length_194_cov_1.075862_g6440_i0	PRJNA195897	6473	194	1.075862	2.08717228	Chlamydomonas incerta	51695	Plants	Plants	126	9.73e-25	NTclustered	gi\|74272616\|gb\|DQ122873.1\|	51695	g6440	i0	82.237	26.8814432989691	152	21	77	6	24	172	390	242	Chlamydomonas incerta mitochondrial alternative oxidase (AOX1) mRNA, partial cds; nuclear gene for mitochondrial product	blastn	5215	126	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
19492012	19492012	PRJNA195897_P_NODE_7056_length_187_cov_1.507246_g7023_i0	PRJNA195897	7056	187	1.507246	2.81855002	Coccomyxa subellipsoidea	248742	Plants	Plants	119	1.56e-22	NTclustered	gi\|545360680\|ref\|XM_005645643.1\|	574566	g7023	i0	91.765	17.8502673796791	85	7	45	0	1	85	728	812	Coccomyxa subellipsoidea C-169 14-3-3 protein mRNA	blastn	3338	119	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
23318082	23318082	PRJNA195897_P_NODE_2859_length_292_cov_1.423868_g2826_i0	PRJNA195897	2859	292	1.423868	4.15769456	Volvox carteri	3067	Plants	Plants	126	1.57e-24	NTclustered	gi\|302851385\|ref\|XM_002957171.1\|	3068	g2826	i0	91.304	3.69178082191781	92	8	32	0	165	256	590	499	Volvox carteri f. nagariensis alpha tubulin (tubA1), mRNA	blastn	1078	126	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
24007291	24007291	PRJNA195897_P_NODE_9519_length_168_cov_0.873950_g9486_i0	PRJNA195897	9519	168	0.87395	1.468236	Eukaryota	2759	Plants	Plants	300	4.56e-77	NTclustered	gi\|1201359271\|gb\|MF040793.1\|	3078	g9486	i0	98.81	61.6428571428571	168	2	100	0	1	168	564	731	Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence	blastn	10356	300	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella pyrenoidosa

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