metadata: contig_metadata: 11 rows where bioproject = "PRJNA835051" and tax

11 rows where bioproject = "PRJNA835051" 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
3376416	3376416	PRJNA835051_S_NODE_12963_length_306_cov_2.136882_g12667_i0	PRJNA835051	12963	306	2.136882	6.53885892	Stigeoclonium helveticum	55999	Plants	Plants	65.8	3.67e-6	NTclustered	gi\|115349964\|ref\|NC_008372.1\|	55999	g12667	i0	91.667	0.457516339869281	48	2	15	2	239	284	138568	138615	Stigeoclonium helveticum chloroplast, complete genome	blastn	140	65.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chaetophorales	Chaetophoraceae	Stigeoclonium	Stigeoclonium helveticum
4654215	4654215	PRJNA835051_S_NODE_26144_length_259_cov_1.768519_g25848_i0	PRJNA835051	26144	259	1.768519	4.58046421	Trebouxia sp. SL0000003	3350044	Plants	Plants	52.8	0.024	NTclustered	gi\|2917929696\|emb\|OZ234923.1\|	3350044	g25848	i0	100	0.108108108108108	28	0	11	0	18	45	1605063	1605036	Trebouxia sp. SL0000003 genome assembly, chromosome: 18	blastn	28	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. SL0000003
5928885	5928885	PRJNA835051_S_NODE_2325_length_495_cov_10.586283_g2038_i0	PRJNA835051	2325	495	10.586283	52.40210085	Trebouxia sp. SL0000003	3350044	Plants	Plants	58.4	0.001	NTclustered	gi\|2917929625\|emb\|OZ234913.1\|	3350044	g2038	i0	100	0.125252525252525	31	0	6	0	23	53	2994134	2994164	Trebouxia sp. SL0000003 genome assembly, chromosome: 8	blastn	62	58.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. SL0000003
9754405	9754405	PRJNA835051_S_NODE_69668_length_194_cov_1.894040_g69372_i0	PRJNA835051	69668	194	1.89404	3.6744376	Prototheca tumulicola	1737639	Plants	Plants	52.8	0.017	NTclustered	gi\|2692959847\|ref\|NC_086913.1\|	1737639	g69372	i0	96.875	0.164948453608247	32	0	16	1	150	181	41821	41851	Prototheca tumulicola strain JCM 31123 plastid, complete genome	blastn	32	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca tumulicola
23778474	23778474	PRJNA835051_S_NODE_45559_length_223_cov_1.444444_g45263_i0	PRJNA835051	45559	223	1.444444	3.22111012	Trebouxia sp. SL0000003	3350044	Plants	Plants	52.8	0.02	NTclustered	gi\|2917929628\|emb\|OZ234916.1\|	3350044	g45263	i0	100	0.125560538116592	28	0	13	0	15	42	1156528	1156501	Trebouxia sp. SL0000003 genome assembly, chromosome: 11	blastn	28	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. SL0000003
27117626	27117626	PRJNA835051_S_NODE_65722_length_198_cov_2.064516_g65426_i0	PRJNA835051	65722	198	2.064516	4.08774168	Micractinium tetrahymenae	2728915	Plants	Plants	42	0.0376	NR	KAL4439770.1	2728915	g65426	i0	36.4	1	66	37	93.9	2	188	3	294	358	KAL4439770.1 hypothetical protein ABPG75_002771 [Micractinium tetrahymenae]	diamond	198	42	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium tetrahymenae
27591939	27591939	PRJNA835051_S_NODE_3964_length_416_cov_49.619303_g3671_i0	PRJNA835051	3964	416	49.619303	206.41630048	Chlorophyceae sp. KF-2	2589020	Plants	Plants	45.4	0.028	NR	WLG71258.1	3068301	g3671	i0	30.2	0.764423076923077	106	58	71.4	4	321	25	485	581	WLG71258.1 hypothetical chloroplast protein RF1 [Johansenicoccus eremophilus]	diamond	318	45.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales		Johansenicoccus	Johansenicoccus eremophilus
28412750	28412750	PRJNA835051_S_NODE_72106_length_192_cov_1.261745_g71810_i0	PRJNA835051	72106	192	1.261745	2.4225504	Symbiochloris irregularis	706552	Plants	Plants	41.6	0.0353	NR	KAK9808269.1	706552	g71810	i0	35.2	0.84375	54	30	76.6	1	150	4	28	81	KAK9808269.1 hypothetical protein WJX73_005405 [Symbiochloris irregularis]	diamond	162	41.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Symbiochloris	Symbiochloris irregularis
29865044	29865044	PRJNA835051_S_NODE_107371_length_164_cov_1.950413_g107075_i0	PRJNA835051	107371	164	1.950413	3.19867732	Astrephomene gubernaculifera	47775	Plants	Plants	42.7	0.0129	NR	GFR50098.1	47775	g107075	i0	43.4	0.969512195121951	53	25	87.8	1	20	163	686	738	GFR50098.1 hypothetical protein Agub_g12243 [Astrephomene gubernaculifera]	diamond	159	42.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Astrephomenaceae	Astrephomene	Astrephomene gubernaculifera
30718029	30718029	PRJNA835051_S_NODE_103094_length_167_cov_1.879032_g102798_i0	PRJNA835051	103094	167	1.879032	3.13798344	Micractinium sp. CCAP 211/92	554058	Plants	Plants	41.6	0.0348	NR	KAL4442104.1	554058	g102798	i0	40.4	0.934131736526946	52	31	93.4	0	9	164	702	753	KAL4442104.1 hypothetical protein ABPG77_011365 [Micractinium sp. CCAP 211/92]	diamond	156	41.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium sp. CCAP 211/92
31010937	31010937	PRJNA835051_S_NODE_31734_length_246_cov_2.724138_g31438_i0	PRJNA835051	31734	246	2.724138	6.70137948	Trebouxia	13786	Plants	Plants	45.1	0.00567	NR	KAA6420057.1	2608996	g31438	i0	66.7	0.951219512195122	39	13	47.6	0	4	120	259	297	KAA6420057.1 MAG: hypothetical protein FRX49_09906 [Trebouxia sp. A1-2]	diamond	234	45.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. A1-2

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