metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA934332" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA934332" 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
4738951	4738951	PRJNA934332_P_NODE_6104_length_275_cov_1.475248_g6017_i0	PRJNA934332	6104	275	1.475248	4.056932	Micromonas commoda	296587	Plants	Plants	161	4.02e-35	NTclustered	gi\|255088598\|ref\|XM_002506176.1\|	296587	g6017	i0	84.568	60.6436363636364	162	25	59	0	2	163	711	550	Micromonas commoda H+-or Na+-translocating f-type, v-type and A-type ATPase superfamily partial mRNA	blastn	16677	161	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
6013906	6013906	PRJNA934332_P_NODE_9105_length_247_cov_0.885057_g9018_i0	PRJNA934332	9105	247	0.885057	2.18609079	Mantoniella tinhauana	3097027	Plants	Plants	54.7	0.006	NTclustered	gi\|2735153277\|gb\|CP140062.1\|	3097027	g9018	i0	96.875	0.242914979757085	32	1	13	0	212	243	9007490	9007459	Mantoniella tinhauana isolate LFS chromosome 1	blastn	60	54.7	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Mantoniella	Mantoniella tinhauana
7633552	7633552	PRJNA934332_P_NODE_4986_length_297_cov_1.031250_g4899_i0	PRJNA934332	4986	297	1.03125	3.0628125	Chlorophyta	3041	Plants	Plants	207	5.5600000000000004e-49	NTclustered	gi\|255072180\|ref\|XM_002499719.1\|	296587	g4899	i0	90.446	34.6363636363636	157	15	53	0	141	297	167	323	Micromonas commoda predicted protein mRNA	blastn	10287	207	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
8563563	8563563	PRJNA934332_P_NODE_1967_length_436_cov_1.542700_g1880_i0	PRJNA934332	1967	436	1.5427	6.726172	Mantoniella tinhauana	3097027	Plants	Plants	259	2.31e-64	NTclustered	gi\|2735153277\|gb\|CP140062.1\|	3097027	g1880	i0	80.17	74.3715596330275	353	64	80	5	9	358	8804752	8805101	Mantoniella tinhauana isolate LFS chromosome 1	blastn	32426	259	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Mantoniella	Mantoniella tinhauana
9838580	9838580	PRJNA934332_P_NODE_2088_length_426_cov_2.985836_g2001_i0	PRJNA934332	2088	426	2.985836	12.71966136	Micromonas commoda	296587	Plants	Plants	255	2.92e-63	NTclustered	gi\|255078509\|ref\|XM_002502789.1\|	296587	g2001	i0	87.387	59.9647887323944	222	28	52	0	205	426	223	444	Micromonas commoda predicted protein mRNA	blastn	25545	255	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
11114243	11114243	PRJNA934332_P_NODE_2849_length_374_cov_1.521595_g2762_i0	PRJNA934332	2849	374	1.521595	5.6907653	Chlamydomonas incerta	51695	Plants	Plants	267	1.17e-66	NTclustered	gi\|74272614\|gb\|DQ122872.1\|	51695	g2762	i0	80.627	71.2540106951872	351	62	93	6	27	374	539	192	Chlamydomonas incerta mitochondrial ADP/ATP translocator (ANT) mRNA, complete cds; nuclear gene for mitochondrial product	blastn	26649	267	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
12389756	12389756	PRJNA934332_P_NODE_2830_length_375_cov_1.298013_g2743_i0	PRJNA934332	2830	375	1.298013	4.86754875	Auxenochlorella protothecoides	3075	Plants	Plants	121	9.65e-23	NTclustered	gi\|760449190\|ref\|XM_011403362.1\|	3075	g2743	i0	82.069	1.496	145	22	38	3	173	315	282	140	Auxenochlorella protothecoides 60S ribosomal protein L35-2 partial mRNA	blastn	561	121	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
13664184	13664184	PRJNA934332_P_NODE_1151_length_563_cov_2.524490_g1066_i0	PRJNA934332	1151	563	2.52449	14.2128787	Chlorella variabilis	554065	Plants	Plants	250	1.83e-61	NTclustered	gi\|552841436\|ref\|XM_005850245.1\|	554065	g1066	i0	80.878	32.3179396092362	319	59	56	2	1	318	43	360	Chlorella variabilis hypothetical protein (CHLNCDRAFT_30036) mRNA, complete cds	blastn	18195	250	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
16213631	16213631	PRJNA934332_P_NODE_3873_length_332_cov_0.861004_g3786_i0	PRJNA934332	3873	332	0.861004	2.85853328	Monoraphidium neglectum	145388	Plants	Plants	326	1.67e-84	NTclustered	gi\|926773841\|ref\|XM_014039941.1\|	145388	g3786	i0	86.942	84.2078313253012	291	36	87	2	43	332	58	347	Monoraphidium neglectum 40S ribosomal protein S23 mRNA	blastn	27957	326	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
17488867	17488867	PRJNA934332_P_NODE_1194_length_553_cov_2.287500_g1109_i0	PRJNA934332	1194	553	2.2875	12.649875	Auxenochlorella protothecoides	3075	Plants	Plants	364	6.159999999999998e-96	NTclustered	gi\|760444702\|ref\|XM_011401118.1\|	3075	g1109	i0	84.89	57.3236889692586	364	51	65	3	61	422	124	485	Auxenochlorella protothecoides 40S ribosomal protein S23-2 partial mRNA	blastn	31700	364	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
17488885	17488885	PRJNA934332_P_NODE_3394_length_348_cov_2.254545_g3307_i0	PRJNA934332	3394	348	2.254545	7.8458166	Chloropicon roscoffensis	1461544	Plants	Plants	150	1.1399999999999999e-31	NTclustered	gi\|2863410610\|gb\|CP145446.1\|	1461544	g3307	i0	80.303	19.1436781609195	198	39	57	0	23	220	566256	566453	Chloropicon roscoffensis strain CCMP1998 chromosome 6	blastn	6662	150	1	Eukaryota		Viridiplantae	Chlorophyta	Chloropicophyceae	Chloropicales	Chloropicaceae	Chloropicon	Chloropicon roscoffensis
18762266	18762266	PRJNA934332_P_NODE_1135_length_566_cov_1.910751_g1050_i0	PRJNA934332	1135	566	1.910751	10.81485066	Micromonas commoda	296587	Plants	Plants	422	3.69e-113	NTclustered	gi\|255078509\|ref\|XM_002502789.1\|	296587	g1050	i0	83.263	76.5742049469965	472	66	82	8	1	464	594	128	Micromonas commoda predicted protein mRNA	blastn	43341	422	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
18762274	18762274	PRJNA934332_P_NODE_2195_length_417_cov_2.828488_g2108_i0	PRJNA934332	2195	417	2.828488	11.79479496	Chlamydomonas reinhardtii	3055	Plants	Plants	267	1.3199999999999998e-66	NTclustered	gi\|2082263148\|ref\|XM_001693658.2\|	3055	g2108	i0	78.333	46.3309352517986	420	85	100	5	1	417	634	218	Chlamydomonas reinhardtii ribosomal protein S3a (CHLRE_13g568650v5), mRNA	blastn	19320	267	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
18762286	18762286	PRJNA934332_P_NODE_3675_length_338_cov_1.962264_g3588_i0	PRJNA934332	3675	338	1.962264	6.63245232	Micromonas pusilla	38833	Plants	Plants	191	6.48e-44	NTclustered	gi\|303277714\|ref\|XM_003058105.1\|	564608	g3588	i0	85.484	7.33727810650888	186	23	54	4	1	184	422	239	Micromonas pusilla CCMP1545 uncharacterized protein (MICPUCDRAFT_49549), mRNA	blastn	2480	191	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas pusilla
21312702	21312702	PRJNA934332_P_NODE_6637_length_266_cov_1.595855_g6550_i0	PRJNA934332	6637	266	1.595855	4.2449743	Mantoniella tinhauana	3097027	Plants	Plants	54.7	0.007	NTclustered	gi\|2735153293\|gb\|CP140078.1\|	3097027	g6550	i0	96.97	0.12406015037594	33	0	12	1	86	118	370541	370510	Mantoniella tinhauana isolate LFS chromosome 17	blastn	33	54.7	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Mantoniella	Mantoniella tinhauana
22587587	22587587	PRJNA934332_P_NODE_3478_length_345_cov_1.841912_g3391_i0	PRJNA934332	3478	345	1.841912	6.3545964	Chlamydomonas reinhardtii	3055	Plants	Plants	241	6.490000000000001e-59	NTclustered	gi\|2082238813\|ref\|XM_001701728.2\|	3055	g3391	i0	80.363	6.35652173913043	331	54	94	10	17	340	228	554	Chlamydomonas reinhardtii ribosomal protein L15 (CHLRE_02g091100v5), mRNA	blastn	2193	241	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
23862943	23862943	PRJNA934332_P_NODE_1879_length_445_cov_1.381720_g1792_i0	PRJNA934332	1879	445	1.38172	6.148654	Monoraphidium neglectum	145388	Plants	Plants	148	5.339999999999999e-31	NTclustered	gi\|926772141\|ref\|XM_014039091.1\|	145388	g1792	i0	81.72	18.0314606741573	186	26	41	7	263	444	188	7	Monoraphidium neglectum hypothetical protein mRNA	blastn	8024	148	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
23863014	23863014	PRJNA934332_P_NODE_9379_length_246_cov_0.890173_g9292_i0	PRJNA934332	9379	246	0.890173	2.18982558	Auxenochlorella protothecoides	3075	Plants	Plants	182	2.72e-41	NTclustered	gi\|760443020\|ref\|XM_011400277.1\|	3075	g9292	i0	95.575	0.845528455284553	113	5	46	0	1	113	59	171	Auxenochlorella protothecoides hypothetical protein partial mRNA	blastn	208	182	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
25136749	25136749	PRJNA934332_P_NODE_1340_length_523_cov_2.564444_g1255_i0	PRJNA934332	1340	523	2.564444	13.41204212	Micromonas commoda	296587	Plants	Plants	379	2.07e-100	NTclustered	gi\|255081970\|ref\|XM_002508158.1\|	296587	g1255	i0	81.316	89.0669216061185	471	84	90	4	24	492	509	41	Micromonas commoda predicted protein mRNA	blastn	46582	379	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
25136807	25136807	PRJNA934332_P_NODE_8060_length_250_cov_0.870056_g7973_i0	PRJNA934332	8060	250	0.870056	2.17514	Micromonas commoda	296587	Plants	Plants	63.9	1.05e-5	NTclustered	gi\|255080983\|ref\|XM_002504012.1\|	296587	g7973	i0	88.889	8.228	54	3	21	3	151	202	648	700	Micromonas commoda predicted protein mRNA	blastn	2057	63.9	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda
25136814	25136814	PRJNA934332_P_NODE_8840_length_248_cov_0.880000_g8753_i0	PRJNA934332	8840	248	0.88	2.1824	Chlamydomonas reinhardtii	3055	Plants	Plants	106	1.7e-18	NTclustered	gi\|2082250963\|ref\|XM_001692342.2\|	3055	g8753	i0	91.026	0.870967741935484	78	7	31	0	166	243	697	774	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_07g340050v5), mRNA	blastn	216	106	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii

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