metadata: contig_metadata: 17 rows where bioproject = "PRJNA493828" and tax

17 rows where bioproject = "PRJNA493828" 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
474975	474975	PRJNA493828_P_NODE_44121_length_226_cov_2.830065_g43702_i0	PRJNA493828	44121	226	2.830065	6.3959469	Chlorosarcinopsis eremi	332213	Plants	Plants	416	6.189999999999998e-112	NTclustered	gi\|1642525901\|ref\|NC_042250.1\|	332213	g43702	i0	100	134.561946902655	225	0	99	0	1	225	131358	131134	Chlorosarcinopsis eremi culture UTEX:1186 chloroplast, complete genome	blastn	30411	416	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlorosarcinales	Chlorosarcinaceae	Chlorosarcinopsis	Chlorosarcinopsis eremi
1106655	1106655	PRJNA493828_P_NODE_7601_length_406_cov_12.834835_g7186_i0	PRJNA493828	7601	406	12.834835	52.1094301	Eukaryota	2759	Plants	Plants	747	0	NTclustered	gi\|1201359271\|gb\|MF040793.1\|	3078	g7186	i0	100	100.036945812808	404	0	99	0	3	406	50	453	Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence	blastn	40615	747	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella pyrenoidosa
3657588	3657588	PRJNA493828_P_NODE_19683_length_288_cov_14.055814_g19264_i0	PRJNA493828	19683	288	14.055814	40.48074432	Eukaryota	2759	Plants	Plants	527	3.63e-145	NTclustered	gi\|1201359270\|gb\|MF040792.1\|	3078	g19264	i0	99.653	100	288	1	100	0	1	288	79	366	Auxenochlorella pyrenoidosa isolate HIT9 18S ribosomal RNA gene, partial sequence	blastn	28800	532	0.990601503759398	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella pyrenoidosa
4301809	4301809	PRJNA493828_P_NODE_44624_length_222_cov_5.557047_g44205_i0	PRJNA493828	44624	222	5.557047	12.33664434	Chlamydomonas noctigama	28456	Plants	Plants	329	8.12e-86	NTclustered	gi\|17028277\|gb\|L43353.1\|CRECPRRNLD	28456	g44205	i0	93.665	129.662162162162	221	12	99	1	1	221	1691	1473	Chlamydomonas geitleri chloroplast large subunit ribosomal RNA (rrnL) gene	blastn	28785	329	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas noctigama
5578544	5578544	PRJNA493828_P_NODE_48265_length_198_cov_5.568000_g47846_i0	PRJNA493828	48265	198	5.568	11.02464	Chloroidium ellipsoideum	63676	Plants	Plants	191	3.49e-44	NTclustered	gi\|535783\|dbj\|D17810.1\|CHLLSURRNA	63676	g47846	i0	93.701	29.7323232323232	127	8	64	0	4	130	3793	3667	Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron	blastn	5887	191	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Watanabeales	Watanabeaceae	Chloroidium	Chloroidium ellipsoideum
6210011	6210011	PRJNA493828_P_NODE_34885_length_247_cov_1.545977_g34466_i0	PRJNA493828	34885	247	1.545977	3.81856319	Trebouxiophyceae	75966	Plants	Plants	305	1.55e-78	NTclustered	gi\|725650801\|ref\|NC_025532.1\|	3102	g34466	i0	90.476	526.676113360324	231	22	94	0	15	245	122091	121861	Ettlia pseudoalveolaris culture-collection UTEX:975 chloroplast, complete genome	blastn	130089	305	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Parietochloris	Parietochloris pseudoalveolaris
6210219	6210219	PRJNA493828_P_NODE_9685_length_365_cov_10.565068_g9267_i0	PRJNA493828	9685	365	10.565068	38.5624982	Eukaryota	2759	Plants	Plants	647	0	NTclustered	gi\|1201359271\|gb\|MF040793.1\|	3078	g9267	i0	98.634	91.6602739726027	366	3	100	2	1	365	1083	719	Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence	blastn	33456	652	0.992331288343558	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella pyrenoidosa
11309907	11309907	PRJNA493828_P_NODE_7069_length_420_cov_1.443804_g6658_i0	PRJNA493828	7069	420	1.443804	6.0639768	Trebouxiophyceae	75966	Plants	Plants	63.9	1.87e-5	NTclustered	gi\|371782132\|emb\|HE610164.1\|	33092	g6658	i0	95	15.5452380952381	40	2	10	0	16	55	76	37	Koliella longiseta plastid partial 23S rRNA gene, strain SAG 470-1	blastn	6529	63.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Koliellaceae	Koliella	Koliella longiseta
20232973	20232973	PRJNA493828_P_NODE_30976_length_253_cov_3.055556_g30557_i0	PRJNA493828	30976	253	3.055556	7.73055668	Chlamydomonadales	3042	Plants	Plants	324	4.41e-84	NTclustered	gi\|66864302\|gb\|DQ015757.1\|	158507	g30557	i0	89.804	74.1660079051383	255	22	100	4	1	253	3204	2952	Oogamochlamys gigantea strain SAG 44.91 26S ribosomal RNA gene, partial sequence	blastn	18764	324	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Oogamochlamys	Oogamochlamys gigantea
20876574	20876574	PRJNA493828_P_NODE_37397_length_244_cov_0.900585_g36978_i0	PRJNA493828	37397	244	0.900585	2.1974274	Chlorella variabilis	554065	Plants	Plants	174	4.5e-39	NTclustered	gi\|552825898\|ref\|XM_005846851.1\|	554065	g36978	i0	85.714	16.0450819672131	168	20	68	4	1	166	1266	1431	Chlorella variabilis hypothetical protein (CHLNCDRAFT_31463) mRNA, complete cds	blastn	3915	174	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
22151544	22151544	PRJNA493828_P_NODE_47818_length_200_cov_7.007874_g47399_i0	PRJNA493828	47818	200	7.007874	14.015748	Haematococcus lacustris	44745	Plants	Plants	220	4.5e-53	NTclustered	gi\|1279575454\|gb\|MF683078.1\|	44745	g47399	i0	86.567	139.665	201	25	99	2	1	199	3475	3675	Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast	blastn	27933	220	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
26760261	26760261	PRJNA493828_P_NODE_36841_length_244_cov_3.771930_g36422_i0	PRJNA493828	36841	244	3.77193	9.2035092	Chlorella vulgaris	3077	Plants	Plants	70.5	6.58e-12	NR	KAL4853478.1	3077	g36422	i0	43.1	1.77049180327869	72	38	87.3	2	228	16	287	356	KAL4853478.1 Pre-mRNA-processing factor 19 [Chlorella vulgaris]	diamond	432	70.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
26981972	26981972	PRJNA493828_P_NODE_19602_length_289_cov_1.384259_g19183_i0	PRJNA493828	19602	289	1.384259	4.00050851	Scenedesmus sp. PABB	2909984	Plants	Plants	132	2.12e-33	NR	KAF8073244.1	2742167	g19183	i0	63.9	1.85813148788927	83	30	86.2	0	1	249	251	333	KAF8073244.1 coatomer subunit beta-1 [Scenedesmus sp. PABB004]	diamond	537	132	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
27961290	27961290	PRJNA493828_P_NODE_34305_length_248_cov_0.880000_g33886_i0	PRJNA493828	34305	248	0.88	2.1824	Bryopsis sp. KO-2	3115439	Plants	Plants	53.5	3.5e-6	NR	GMH36766.1	3041901	g33886	i0	51	0.592741935483871	49	22	56.9	1	166	26	12	60	GMH36766.1 hypothetical protein BSKO_04639 [Bryopsis sp. KO-2023]	diamond	147	53.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Bryopsidaceae	Bryopsis	Bryopsis sp. KO-2023
28450683	28450683	PRJNA493828_P_NODE_40966_length_237_cov_2.817073_g40547_i0	PRJNA493828	40966	237	2.817073	6.67646301	Chlamydomonadales	3042	Plants	Plants	90.5	5.34e-19	NR	KAJ9525669.1	44745	g40547	i0	63.6	10.5443037974684	66	24	83.5	0	227	30	1290	1355	KAJ9525669.1 hypothetical protein QJQ45_003499 [Haematococcus lacustris]	diamond	2499	90.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
32448340	32448340	PRJNA493828_P_NODE_32159_length_251_cov_0.865169_g31740_i0	PRJNA493828	32159	251	0.865169	2.17157419	Coccomyxa viridis	1274662	Plants	Plants	55.1	2.87e-7	NR	CAK0782895.1	1274662	g31740	i0	50	0.669322709163347	56	24	62.2	1	5	160	53	108	CAK0782895.1 40S ribosomal protein S25-4 [Coccomyxa viridis]	diamond	168	55.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis
32479918	32479918	PRJNA493828_P_NODE_12139_length_333_cov_1.480769_g11720_i0	PRJNA493828	12139	333	1.480769	4.93096077	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	143	5.27e-38	NR	KAH7624923.1	1650286	g11720	i0	63.4	2.01801801801802	112	37	99.1	3	332	3	160	269	KAH7624923.1 putative Elongation factor 1-alpha [Chlorella desiccata (nom. nud.)]	diamond	672	143	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'

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