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

11 rows where bioproject = "PRJNA1248424" 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
8006797	8006797	PRJNA1248424_P_NODE_80187_length_241_cov_0.916667_g74118_i0	PRJNA1248424	80187	241	0.916667	2.20916747	Chlamydomonas reinhardtii	3055	Plants	Plants	193	1.23e-44	NTclustered	gi\|2082252626\|ref\|XM_001701274.2\|	3055	g74118	i0	82.533	58.3526970954357	229	31	93	7	18	241	1782	1558	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_08g372100v5), mRNA	blastn	14063	193	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
9281478	9281478	PRJNA1248424_P_NODE_73328_length_247_cov_0.885057_g67259_i0	PRJNA1248424	73328	247	0.885057	2.18609079	Volvocaceae	3065	Plants	Plants	93.2	3.13e-20	NR	KAG2484242.1	47281	g67259	i0	58	4.08097165991903	69	29	83.8	0	2	208	310	378	KAG2484242.1 hypothetical protein HYH03_016976 [Edaphochlamys debaryana]	diamond	1008	93.6	0.995726495726496	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales		Edaphochlamys	Edaphochlamys debaryana
12530516	12530516	PRJNA1248424_P_NODE_61250_length_272_cov_1.547739_g55182_i0	PRJNA1248424	61250	272	1.547739	4.20985008	Micractinium tetrahymenae	2728915	Plants	Plants	110	1.11e-25	NR	KAL4425974.1	2728915	g55182	i0	75.3	0.805147058823529	73	18	80.5	0	1	219	952	1024	KAL4425974.1 hypothetical protein ABPG75_009990 [Micractinium tetrahymenae]	diamond	219	110	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium tetrahymenae
19478853	19478853	PRJNA1248424_P_NODE_48876_length_316_cov_1.012346_g42809_i0	PRJNA1248424	48876	316	1.012346	3.19901336	Raphidocelis subcapitata	307507	Plants	Plants	145	4.369999999999999e-42	NR	GBF93448.1	307507	g42809	i0	71.7	1.00632911392405	106	27	98.7	2	4	315	35	139	GBF93448.1 ribosomal protein S1 [Raphidocelis subcapitata]	diamond	318	145	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Raphidocelis	Raphidocelis subcapitata
22029938	22029938	PRJNA1248424_P_NODE_69298_length_251_cov_0.865169_g63229_i0	PRJNA1248424	69298	251	0.865169	2.17157419	Parietochloris pseudoalveolaris	3102	Plants	Plants	52.8	0.023	NTclustered	gi\|725650801\|ref\|NC_025532.1\|	3102	g63229	i0	100	0.111553784860558	28	0	11	0	172	199	65055	65082	Ettlia pseudoalveolaris culture-collection UTEX:975 chloroplast, complete genome	blastn	28	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Parietochloris	Parietochloris pseudoalveolaris
24579284	24579284	PRJNA1248424_P_NODE_57160_length_283_cov_1.219048_g51092_i0	PRJNA1248424	57160	283	1.219048	3.44990584	Monoraphidium neglectum	145388	Plants	Plants	126	4.96e-32	NR	XP_013903537.1	145388	g51092	i0	65.9	3.6678445229682	85	29	90.1	0	25	279	137	221	XP_013903537.1 superoxide dismutase 2 [Monoraphidium neglectum]	diamond	1038	126	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
27610802	27610802	PRJNA1248424_P_NODE_70464_length_250_cov_0.870056_g64395_i0	PRJNA1248424	70464	250	0.870056	2.17514	Gonium pectorale	33097	Plants	Plants	101	6.11e-23	NR	KXZ56552.1	33097	g64395	i0	85.7	0.672	56	8	67.2	0	81	248	1	56	KXZ56552.1 hypothetical protein GPECTOR_1g496 [Gonium pectorale]	diamond	168	101	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Gonium	Gonium pectorale
28670838	28670838	PRJNA1248424_P_NODE_73587_length_247_cov_0.885057_g67518_i0	PRJNA1248424	73587	247	0.885057	2.18609079	Chlorophyta	3041	Plants	Plants	92.8	2.68e-22	NR	PRW20673.1	3076	g67518	i0	68.8	11.2226720647773	77	24	93.5	0	232	2	7	83	PRW20673.1 40S ribosomal S25-3 [Chlorella sorokiniana]	diamond	2772	92.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
29712272	29712272	PRJNA1248424_P_NODE_71730_length_249_cov_0.875000_g65661_i0	PRJNA1248424	71730	249	0.875	2.17875	Chlorophyta	3041	Plants	Plants	115	2.87e-28	NR	KAJ9514070.1	44745	g65661	i0	68.3	4.93975903614458	82	26	98.8	0	2	247	203	284	KAJ9514070.1 hypothetical protein QJQ45_021162 [Haematococcus lacustris]	diamond	1230	116	0.991379310344828	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
29789159	29789159	PRJNA1248424_P_NODE_58291_length_280_cov_1.314010_g52223_i0	PRJNA1248424	58291	280	1.31401	3.679228	Dunaliella salina	3046	Plants	Plants	43.9	0.0232	NR	KAF5827254.1	3046	g52223	i0	40.7	0.578571428571429	54	30	57.9	1	258	97	632	683	KAF5827254.1 hypothetical protein DUNSADRAFT_1061 [Dunaliella salina]	diamond	162	43.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Dunaliellaceae	Dunaliella	Dunaliella salina
32368214	32368214	PRJNA1248424_P_NODE_33559_length_449_cov_1.582447_g27504_i0	PRJNA1248424	33559	449	1.582447	7.10518703	Chlorellaceae	35461	Plants	Plants	199	2.8499999999999997e-61	NR	PRW39386.1	3076	g27504	i0	63.7	12.6681514476615	146	53	97.6	0	438	1	14	159	PRW39386.1 40S ribosomal S3a-2 isoform B [Chlorella sorokiniana]	diamond	5688	199	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana

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