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

13 rows where analysis = "blastn", bioproject = "PRJEB75230" 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
995714	995714	PRJEB75230_P_NODE_10501_length_463_cov_1.171795_g10319_i0	PRJEB75230	10501	463	1.171795	5.42541085	Eukaryota	2759	Plants	Plants	202	4.2199999999999996e-47	NTclustered	gi\|926775739\|ref\|XM_014040890.1\|	145388	g10319	i0	90.789	63	152	13	33	1	312	462	400	551	Monoraphidium neglectum ubiquitin C partial mRNA	blastn	29169	202	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
3962897	3962897	PRJEB75230_P_NODE_178624_length_241_cov_1.654762_g178442_i0	PRJEB75230	178624	241	1.654762	3.98797642	Volvox carteri	3067	Plants	Plants	58.4	4.66e-4	NTclustered	gi\|302843905\|ref\|XM_002953448.1\|	3068	g178442	i0	100	0.128630705394191	31	0	13	0	34	64	1015	1045	Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_94152), partial mRNA	blastn	31	58.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
3963949	3963949	PRJEB75230_P_NODE_7764_length_515_cov_2.588235_g7582_i0	PRJEB75230	7764	515	2.588235	13.32941025	Chlorella variabilis	554065	Plants	Plants	329	2.08e-85	NTclustered	gi\|552846103\|ref\|XM_005851468.1\|	554065	g7582	i0	78.42	21.5533980582524	519	102	99	10	1	514	1574	1061	Chlorella variabilis hypothetical protein (CHLNCDRAFT_55979) mRNA, complete cds	blastn	11100	329	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
7788332	7788332	PRJEB75230_P_NODE_117907_length_251_cov_0.921348_g117725_i0	PRJEB75230	117907	251	0.921348	2.31258348	Pediastrum duplex	3105	Plants	Plants	54.7	0.006	NTclustered	gi\|1388162558\|gb\|MF276981.1\|	3105	g117725	i0	96.875	0.127490039840637	32	1	13	0	132	163	163937	163968	Pediastrum duplex chloroplast, complete genome	blastn	32	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Hydrodictyaceae	Pediastrum	Pediastrum duplex
11615388	11615388	PRJEB75230_P_NODE_19550_length_386_cov_2.718850_g19368_i0	PRJEB75230	19550	386	2.71885	10.494761	Chlamydomonas reinhardtii	3055	Plants	Plants	169	3.5099999999999995e-37	NTclustered	gi\|2082241740\|ref\|XM_001697476.2\|	3055	g19368	i0	79.668	10.7227979274611	241	43	62	6	49	286	938	701	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g156750v5), mRNA	blastn	4139	169	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
11616237	11616237	PRJEB75230_P_NODE_7250_length_529_cov_1.868421_g7068_i0	PRJEB75230	7250	529	1.868421	9.88394709	Chlorella variabilis	554065	Plants	Plants	305	3.61e-78	NTclustered	gi\|552822727\|ref\|XM_005846130.1\|	554065	g7068	i0	80.144	4.6937618147448	418	76	78	5	1	413	599	184	Chlorella variabilis ATP/ADP translocator (CHLNCDRAFT_136213) mRNA, complete cds	blastn	2483	305	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
12890918	12890918	PRJEB75230_P_NODE_51371_length_310_cov_1.299578_g51189_i0	PRJEB75230	51371	310	1.299578	4.0286918	Auxenochlorella protothecoides	3075	Plants	Plants	185	2.7399999999999998e-42	NTclustered	gi\|760444702\|ref\|XM_011401118.1\|	3075	g51189	i0	82.407	39.1258064516129	216	34	69	4	3	216	273	486	Auxenochlorella protothecoides 40S ribosomal protein S23-2 partial mRNA	blastn	12129	185	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
13749523	13749523	PRJEB75230_P_NODE_40531_length_327_cov_1.208661_g40349_i0	PRJEB75230	40531	327	1.208661	3.95232147	Volvox	3066	Plants	Plants	104	8.37e-18	NTclustered	gi\|2089721935\|gb\|MZ445637.1\|	47289	g40349	i0	88.372	1.57492354740061	86	10	26	0	221	306	761	676	Volvox obversus strain NIES-868 hypothetical protein mRNA, partial cds	blastn	515	104	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox obversus
15439666	15439666	PRJEB75230_P_NODE_4153_length_670_cov_2.576214_g3977_i0	PRJEB75230	4153	670	2.576214	17.2606338	Chlamydomonas reinhardtii	3055	Plants	Plants	416	2.05e-111	NTclustered	gi\|2082235498\|ref\|XM_001700320.2\|	3055	g3977	i0	84.906	57.4194029850746	424	51	63	7	207	628	460	48	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g002300v5), mRNA	blastn	38471	416	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
17989390	17989390	PRJEB75230_P_NODE_82695_length_277_cov_1.529412_g82513_i0	PRJEB75230	82695	277	1.529412	4.23647124	Cephaleuros karstenii	1985640	Plants	Plants	75	5.44e-9	NTclustered	gi\|2192923902\|ref\|NC_060534.1\|	1985640	g82513	i0	94	0.454873646209386	50	2	18	1	86	134	91253	91204	Cephaleuros karstenii strain GD1942 chloroplast, complete genome	blastn	126	75	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Trentepohliales	Trentepohliaceae	Cephaleuros	Cephaleuros karstenii
17989465	17989465	PRJEB75230_P_NODE_87375_length_273_cov_1.765000_g87193_i0	PRJEB75230	87375	273	1.765	4.81845	Helicosporidium sp. ex Simulium jonesi	145475	Plants	Plants	315	2.9e-81	NTclustered	gi\|54399515\|gb\|AY729488.1\|	145475	g87193	i0	87.732	69.6923076923077	269	33	99	0	4	272	560	292	Helicosporidium sp. ex Simulium jonesii EF-1 alpha-like protein (efl) mRNA, complete cds	blastn	19026	315	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Helicosporidium	Helicosporidium sp. ex Simulium jonesi
19262285	19262285	PRJEB75230_P_NODE_17896_length_395_cov_2.406832_g17714_i0	PRJEB75230	17896	395	2.406832	9.5069864	Polytomella parva	51329	Plants	Plants	335	3.349999999999999e-87	NTclustered	gi\|1861356233\|gb\|MT377344.1\|	51329	g17714	i0	84.57	89.853164556962	337	52	85	0	59	395	1142	806	Polytomella parva clone 0016303185 chain x, ATP synthase subunit beta (ATP5F1B) mRNA, complete cds; plastid	blastn	35492	335	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Polytomella	Polytomella parva
20538369	20538369	PRJEB75230_P_NODE_55797_length_304_cov_2.246753_g55615_i0	PRJEB75230	55797	304	2.246753	6.83012912	Volvox carteri	3067	Plants	Plants	143	1.63e-29	NTclustered	gi\|302843775\|ref\|XM_002953383.1\|	3068	g55615	i0	84.247	38.4769736842105	146	23	48	0	45	190	210	65	Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_105955), partial mRNA	blastn	11697	143	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri

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