metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1102048" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1102048" and tax_phylum = "Chlorophyta"

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
1486358	1486358	PRJNA1102048_P_NODE_15402_length_245_cov_2.680233_g15298_i0	PRJNA1102048	15402	245	2.680233	6.56657085	Ostreococcus sp. 'lucimarinus'	242159	Plants	Plants	143	1.28e-29	NTclustered	gi\|145344331\|ref\|XM_001416652.1\|	436017	g15298	i0	84.247	3.52244897959184	146	23	60	0	15	160	277	422	Ostreococcus lucimarinus CCE9901 Cytosolic 80S ribosomal protein L39; Cytosolic 60S large ribosomal protein L39 (RPL39), partial mRNA	blastn	863	143	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Ostreococcus	Ostreococcus sp. 'lucimarinus'
6123064	6123064	PRJNA1102048_P_NODE_10245_length_275_cov_2.391089_g10141_i0	PRJNA1102048	10245	275	2.391089	6.57549475	Eukaryota	2759	Plants	Plants	508	1.2499999999999999e-139	NTclustered	gi\|1714003650\|gb\|MN243923.1\|	3079	g10141	i0	100	99.1527272727273	275	0	100	0	1	275	844	570	Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence	blastn	27267	508	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sp.
7864439	7864439	PRJNA1102048_P_NODE_17287_length_242_cov_0.911243_g17183_i0	PRJNA1102048	17287	242	0.911243	2.20520806	Micromonas pusilla	38833	Plants	Plants	198	2.6499999999999997e-46	NTclustered	gi\|303284071\|ref\|XM_003061281.1\|	564608	g17183	i0	81.481	3.66528925619835	243	43	100	2	1	242	547	788	Micromonas pusilla CCMP1545 uncharacterized protein (MICPUCDRAFT_49687), mRNA	blastn	887	198	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas pusilla
7864513	7864513	PRJNA1102048_P_NODE_8607_length_296_cov_1.381166_g8503_i0	PRJNA1102048	8607	296	1.381166	4.08825136	Chlamydomonas reinhardtii	3055	Plants	Plants	128	4.44e-25	NTclustered	gi\|2082253493\|ref\|XM_043066154.1\|	3055	g8503	i0	81.366	3.55743243243243	161	27	54	3	7	166	613	771	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_09g405106v5), mRNA	blastn	1053	128	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
9139278	9139278	PRJNA1102048_P_NODE_11608_length_261_cov_1.382979_g11504_i0	PRJNA1102048	11608	261	1.382979	3.60957519	Auxenochlorella protothecoides	3075	Plants	Plants	239	1.7e-58	NTclustered	gi\|760446750\|ref\|XM_011402142.1\|	3075	g11504	i0	87.44	71.4980842911877	207	26	79	0	51	257	459	665	Auxenochlorella protothecoides Nucleolar GTP-binding protein 1 partial mRNA	blastn	18661	239	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
11690471	11690471	PRJNA1102048_P_NODE_6350_length_342_cov_2.416357_g6246_i0	PRJNA1102048	6350	342	2.416357	8.26394094	Auxenochlorella pyrenoidosa	3078	Plants	Plants	621	1.9599999999999997e-173	NTclustered	gi\|1201359271\|gb\|MF040793.1\|	3078	g6246	i0	99.415	97.4444444444444	342	2	100	0	1	342	652	993	Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence	blastn	33326	621	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella pyrenoidosa
12965531	12965531	PRJNA1102048_P_NODE_14131_length_248_cov_0.880000_g14027_i0	PRJNA1102048	14131	248	0.88	2.1824	Chlamydomonas reinhardtii	3055	Plants	Plants	67.6	8.01e-7	NTclustered	gi\|2082237132\|ref\|XM_001689609.2\|	3055	g14027	i0	80	0.725806451612903	90	18	36	0	80	169	825	914	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g038400v5), mRNA	blastn	180	67.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
12965562	12965562	PRJNA1102048_P_NODE_16151_length_244_cov_0.900585_g16047_i0	PRJNA1102048	16151	244	0.900585	2.1974274	Mantoniella tinhauana	3097027	Plants	Plants	52.8	0.022	NTclustered	gi\|2735153279\|gb\|CP140064.1\|	3097027	g16047	i0	100	0.114754098360656	28	0	11	0	89	116	1376821	1376794	Mantoniella tinhauana isolate LFS chromosome 3	blastn	28	52.8	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Mantoniella	Mantoniella tinhauana
18063455	18063455	PRJNA1102048_P_NODE_17755_length_241_cov_0.916667_g17651_i0	PRJNA1102048	17755	241	0.916667	2.20916747	Chlamydomonas reinhardtii	3055	Plants	Plants	174	4.4399999999999997e-39	NTclustered	gi\|2082236323\|ref\|XM_001689445.2\|	3055	g17651	i0	80.252	3.0207468879668	238	41	96	4	10	241	616	379	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g019250v5), mRNA	blastn	728	174	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
18063459	18063459	PRJNA1102048_P_NODE_2095_length_563_cov_5.608163_g1993_i0	PRJNA1102048	2095	563	5.608163	31.57395769	Micromonas commoda	296587	Plants	Plants	361	8.12e-95	NTclustered	gi\|255078525\|ref\|XM_002502797.1\|	296587	g1993	i0	79.135	51.1989342806394	532	103	94	8	1	528	575	48	Micromonas commoda translation elongation factor EF-1alpha/Tu (TEF1.1), mRNA	blastn	28825	361	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
19337466	19337466	PRJNA1102048_P_NODE_10096_length_277_cov_1.509804_g9992_i0	PRJNA1102048	10096	277	1.509804	4.18215708	Chlamydomonas reinhardtii	3055	Plants	Plants	248	3.0299999999999997e-61	NTclustered	gi\|2082261495\|ref\|XM_001692933.2\|	3055	g9992	i0	84.17	24.0541516245487	259	37	93	4	11	267	673	929	Chlamydomonas reinhardtii ribosomal protein L8 (CHLRE_12g535851v5), mRNA	blastn	6663	248	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
19337556	19337556	PRJNA1102048_P_NODE_3936_length_429_cov_3.345506_g3832_i0	PRJNA1102048	3936	429	3.345506	14.35222074	Volvox carteri	3067	Plants	Plants	167	1.42e-36	NTclustered	gi\|302850129\|ref\|XM_002956547.1\|	3068	g3832	i0	85.625	5.17249417249417	160	21	37	2	229	387	193	35	Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 60S large subunit (rpl27A), mRNA	blastn	2219	167	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
24437650	24437650	PRJNA1102048_P_NODE_3700_length_443_cov_3.102703_g3596_i0	PRJNA1102048	3700	443	3.102703	13.74497429	Chlorella variabilis	554065	Plants	Plants	211	6.68e-50	NTclustered	gi\|552813385\|ref\|XM_005843877.1\|	554065	g3596	i0	81.439	8.46726862302483	264	43	59	6	86	346	1107	1367	Chlorella variabilis hypothetical protein (CHLNCDRAFT_59785) mRNA, complete cds	blastn	3751	211	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis

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