metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA816047" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA816047" 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
25737174	25737174	PRJNA816047d_S_NODE_108130_length_246_cov_2.896373_g106295_i0	PRJNA816047	108130	246	2.896373	7.12507758	Prototheca miyajii	2034260	Plants	Plants	121	6.01e-23	NTclustered	gi\|2692959722\|ref\|NC_086909.1\|	2034260	g106295	i0	88.889	17.0609756097561	99	9	39	1	51	147	31470	31372	Prototheca miyajii strain IFM53848 plastid, complete genome	blastn	4197	121	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca miyajii
25741187	25741187	PRJNA816047d_S_NODE_57322_length_296_cov_2.201646_g55487_i0	PRJNA816047	57322	296	2.201646	6.51687216	Prototheca lentecrescens	2836214	Plants	Plants	313	1.14e-80	NTclustered	gi\|2692959681\|ref\|NC_086908.1\|	2836214	g55487	i0	92.273	103.503378378378	220	17	74	0	75	294	2053	1834	Prototheca lentecrescens strain PK1 plastid, complete genome	blastn	30637	313	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca lentecrescens
25770211	25770211	PRJNA816047b_S_NODE_27986_length_312_cov_3.866109_g25674_i0	PRJNA816047	27986	312	3.866109	12.06226008	Chlorellaceae	35461	Plants	Plants	453	6.84e-123	NTclustered	gi\|77627727\|dbj\|AB237642.1\|	3077	g25674	i0	100	77.8910256410256	245	0	79	0	56	300	272	28	Chlorella vulgaris NIES:227 gene for 28S ribosomal RNA, partial sequence	blastn	24302	453	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
25876133	25876133	PRJNA816047d_S_NODE_41835_length_335_cov_3.248227_g40000_i0	PRJNA816047	41835	335	3.248227	10.88156045	Monoraphidium neglectum	145388	Plants	Plants	52.8	0.032	NTclustered	gi\|926767213\|ref\|XM_014037205.1\|	145388	g40000	i0	100	0.0835820895522388	28	0	8	0	290	317	1103	1076	Monoraphidium neglectum hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
26003525	26003525	PRJNA816047a_S_NODE_65556_length_262_cov_1.550265_g62896_i0	PRJNA816047	65556	262	1.550265	4.0616943	Chlorotetraedron incus	162317	Plants	Plants	67.6	8.54e-7	NTclustered	gi\|674840704\|ref\|NC_024757.1\|	162317	g62896	i0	85.714	0.576335877862595	63	9	24	0	189	251	12026	11964	Chlorotetraedron incus strain SAG 43.81 mitochondrion, complete genome	blastn	151	67.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Neochloridaceae	Chlorotetraedron	Chlorotetraedron incus
26008643	26008643	PRJNA816047b_S_NODE_60588_length_207_cov_4.067164_g58276_i0	PRJNA816047	60588	207	4.067164	8.41902948	Chlamydomonas zimbabwiensis	158510	Plants	Plants	351	1.5899999999999995e-92	NTclustered	gi\|66864303\|gb\|DQ015758.1\|	158510	g58276	i0	97.129	107.898550724638	209	4	100	2	1	207	2324	2532	Chlamydomonas zimbabwiensis strain UTEX 2214 26S ribosomal RNA gene, partial sequence	blastn	22335	351	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas zimbabwiensis
26142654	26142654	PRJNA816047b_S_NODE_26917_length_318_cov_1.040816_g24605_i0	PRJNA816047	26917	318	1.040816	3.30979488	Chlamydomonas reinhardtii	3055	Plants	Plants	250	9.85e-62	NTclustered	gi\|2082261216\|ref\|XM_001696912.2\|	3055	g24605	i0	85.477	1.59119496855346	241	33	75	2	66	305	814	575	Chlamydomonas reinhardtii ribosomal protein L7a (CHLRE_12g529651v5), mRNA	blastn	506	250	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
26281461	26281461	PRJNA816047d_S_NODE_110462_length_245_cov_2.000000_g108627_i0	PRJNA816047	110462	245	2	4.9	Prototheca lentecrescens	2836214	Plants	Plants	220	5.73e-53	NTclustered	gi\|2692959681\|ref\|NC_086908.1\|	2836214	g108627	i0	90	0.693877551020408	170	17	69	0	2	171	12992	13161	Prototheca lentecrescens strain PK1 plastid, complete genome	blastn	170	220	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca lentecrescens
26417958	26417958	PRJNA816047d_S_NODE_132159_length_229_cov_2.028409_g130324_i0	PRJNA816047	132159	229	2.028409	4.64505661	Auxenochlorella protothecoides	3075	Plants	Plants	86.1	2.01e-12	NTclustered	gi\|760444542\|ref\|XM_011401038.1\|	3075	g130324	i0	100	0.200873362445415	46	0	20	0	24	69	2133	2178	Auxenochlorella protothecoides ABC transporter F family member 3 partial mRNA	blastn	46	86.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
26550644	26550644	PRJNA816047b_S_NODE_26304_length_321_cov_0.891129_g23992_i0	PRJNA816047	26304	321	0.891129	2.86052409	Chlamydomonas reinhardtii	3055	Plants	Plants	196	1.31e-45	NTclustered	gi\|2082270606\|ref\|XM_001701479.2\|	3055	g23992	i0	90.066	0.470404984423676	151	15	47	0	164	314	308	458	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_17g732000v5), mRNA	blastn	151	196	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
26558440	26558440	PRJNA816047d_S_NODE_76552_length_265_cov_1.160377_g74717_i0	PRJNA816047	76552	265	1.160377	3.07499905	Lobosphaera incisa	312850	Plants	Plants	143	1.3999999999999996e-29	NTclustered	gi\|725539263\|gb\|KM821265.1\|	312850	g74717	i0	85.106	6.28301886792453	141	19	53	2	23	162	144865	144726	Lobosphaera incisa chloroplast, complete genome	blastn	1665	143	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Lobosphaera	Lobosphaera incisa

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