metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA270367" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA270367" 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
370166	370166	PRJNA270367_P_NODE_42581_length_166_cov_0.888889_g42376_i0	PRJNA270367	42581	166	0.888889	1.47555574	Monoraphidium neglectum	145388	Plants	Plants	60.2	8.31e-5	NTclustered	gi\|926787970\|ref\|XM_014047005.1\|	145388	g42376	i0	97.143	22.0602409638554	35	1	21	0	20	54	2138	2104	Monoraphidium neglectum hypothetical protein mRNA	blastn	3662	60.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
2920522	2920522	PRJNA270367_P_NODE_1323_length_1238_cov_2.084945_g1177_i0	PRJNA270367	1323	1238	2.084945	25.8116191	Polytomella parva	51329	Plants	Plants	660	0	NTclustered	gi\|1861356263\|gb\|MT377359.1\|	51329	g1177	i0	81.546	59.2520193861066	802	142	65	4	440	1238	803	5	Polytomella parva clone 0016301625 beta-2 tubulin (TUBB2) mRNA, partial cds; plastid	blastn	73354	660	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Polytomella	Polytomella parva
2920773	2920773	PRJNA270367_P_NODE_38423_length_172_cov_1.268293_g38218_i0	PRJNA270367	38423	172	1.268293	2.18146396	Monoraphidium neglectum	145388	Plants	Plants	119	1.4000000000000002e-22	NTclustered	gi\|926770371\|ref\|XM_014038206.1\|	145388	g38218	i0	79.191	23.9709302325581	173	34	100	2	1	172	266	95	Monoraphidium neglectum solute carrier family 25 partial mRNA	blastn	4123	119	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
2920828	2920828	PRJNA270367_P_NODE_44403_length_164_cov_0.904348_g44198_i0	PRJNA270367	44403	164	0.904348	1.48313072	Chlamydomonas reinhardtii	3055	Plants	Plants	126	7.9499999999999995e-25	NTclustered	gi\|2082260551\|ref\|XM_001702928.2\|	3055	g44198	i0	82	11.2682926829268	150	25	91	2	1	149	215	363	Chlamydomonas reinhardtii ribosomal protein S11 (CHLRE_12g514500v5), mRNA	blastn	1848	126	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
14398913	14398913	PRJNA270367_P_NODE_15552_length_322_cov_1.139194_g15347_i0	PRJNA270367	15552	322	1.139194	3.66820468	Monoraphidium neglectum	145388	Plants	Plants	217	1.01e-51	NTclustered	gi\|926787363\|ref\|XM_014046702.1\|	145388	g15347	i0	80.488	18.2608695652174	287	52	89	3	35	319	954	670	Monoraphidium neglectum Calreticulin Flags: Precursor mRNA	blastn	5880	217	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
14398918	14398918	PRJNA270367_P_NODE_16192_length_313_cov_1.575758_g15987_i0	PRJNA270367	16192	313	1.575758	4.93212254	Chlamydomonas incerta	51695	Plants	Plants	178	4.63e-40	NTclustered	gi\|74272704\|gb\|DQ122917.1\|	51695	g15987	i0	81.818	67.4600638977636	220	33	70	6	11	228	146	360	Chlamydomonas incerta S-adenosyl-L-homocystein hydrolase (SAHH) mRNA, partial cds	blastn	21115	178	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
14398995	14398995	PRJNA270367_P_NODE_2332_length_912_cov_11.330243_g2164_i0	PRJNA270367	2332	912	11.330243	103.33181616	Polytomella parva	51329	Plants	Plants	357	1.7399999999999997e-93	NTclustered	gi\|1861356367\|gb\|MT377411.1\|	51329	g2164	i0	77.632	52.5986842105263	608	123	66	13	124	724	698	97	Polytomella parva clone 0016300147 40S ribosomal protein S2 (RPS2) mRNA, complete cds; plastid	blastn	47970	357	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Polytomella	Polytomella parva
15672849	15672849	PRJNA270367_P_NODE_40153_length_168_cov_1.949580_g39948_i0	PRJNA270367	40153	168	1.94958	3.2752944	Chlamydomonas reinhardtii	3055	Plants	Plants	137	3.79e-28	NTclustered	gi\|2082242708\|ref\|XM_043061004.1\|	3055	g39948	i0	82.581	45.2619047619048	155	27	92	0	4	158	1541	1695	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g178650v5), mRNA	blastn	7604	137	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
22046448	22046448	PRJNA270367_P_NODE_16478_length_309_cov_1.950000_g16273_i0	PRJNA270367	16478	309	1.95	6.0255	Chlamydomonas reinhardtii	3055	Plants	Plants	283	9.400000000000001e-72	NTclustered	gi\|2082247947\|ref\|XM_001698013.2\|	3055	g16273	i0	84.859	83.8673139158576	284	39	91	3	25	306	719	438	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g278222v5), mRNA	blastn	25915	283	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);;