metadata: contig_metadata: 9 rows where bioproject = "PRJNA326068" and tax

9 rows where bioproject = "PRJNA326068" 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
6172081	6172081	PRJNA326068_P_NODE_2125_length_744_cov_4.117483_g1607_i0	PRJNA326068	2125	744	4.117483	30.63407352	Trebouxia	13786	Plants	Plants	536	1.6899999999999999e-147	NTclustered	gi\|1827552207\|gb\|MT274564.1\|	300846	g1607	i0	94.302	48.0497311827957	351	18	47	2	1	350	196	545	Trebouxia crenulata strain CCAP_219_2 large subunit ribosomal RNA gene, partial sequence; chloroplast	blastn	35749	536	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia crenulata
10593166	10593166	PRJNA326068_P_NODE_9889_length_320_cov_1.824742_g8930_i0	PRJNA326068	9889	320	1.824742	5.8391744	Myrmecia israelensis	3171	Plants	Plants	316	9.64e-82	NTclustered	gi\|723456786\|ref\|NC_025525.1\|	3171	g8930	i0	97.312	79.1625	186	5	58	0	2	187	2254	2439	Myrmecia israelensis culture-collection UTEX:1181 chloroplast, complete genome	blastn	25332	316	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	Myrmecia israelensis
15097010	15097010	PRJNA326068_P_NODE_10292_length_309_cov_38.235714_g9332_i0	PRJNA326068	10292	309	38.235714	118.14835626	Trebouxia	13786	Plants	Plants	488	1.86e-133	NTclustered	gi\|2236816602\|gb\|ON479854.1\|	160068	g9332	i0	95.161	99.9190938511327	310	13	100	2	1	309	12	320	Trebouxia aggregata clone LN-K1 small subunit ribosomal RNA gene, partial sequence	blastn	30875	488	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia aggregata
15692091	15692091	PRJNA326068_P_NODE_17353_length_193_cov_2.176829_g16390_i0	PRJNA326068	17353	193	2.176829	4.20127997	Chlorella vulgaris	3077	Plants	Plants	213	7.21e-51	NTclustered	gi\|77627727\|dbj\|AB237642.1\|	3077	g16390	i0	86.667	102.756476683938	195	23	100	3	1	193	1913	2106	Chlorella vulgaris NIES:227 gene for 28S ribosomal RNA, partial sequence	blastn	19832	213	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
19515299	19515299	PRJNA326068_P_NODE_18436_length_173_cov_3.458333_g17473_i0	PRJNA326068	18436	173	3.458333	5.98291609	Myrmecia israelensis	3171	Plants	Plants	320	3.61e-83	NTclustered	gi\|723456786\|ref\|NC_025525.1\|	3171	g17473	i0	100	137.98265895953801	173	0	100	0	1	173	5106	4934	Myrmecia israelensis culture-collection UTEX:1181 chloroplast, complete genome	blastn	23871	320	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	Myrmecia israelensis
20195276	20195276	PRJNA326068_P_NODE_7816_length_376_cov_102.711816_g6873_i0	PRJNA326068	7816	376	102.711816	386.19642816	Eukaryota	2759	Plants	Plants	673	0	NTclustered	gi\|1714003650\|gb\|MN243923.1\|	3079	g6873	i0	98.936	99.718085106383	376	4	100	0	1	376	871	496	Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence	blastn	37494	673	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sp.
23341344	23341344	PRJNA326068_P_NODE_2119_length_745_cov_5.008380_g1601_i0	PRJNA326068	2119	745	5.00838	37.312431	Trebouxia aggregata	160068	Plants	Plants	459	3.7599999999999996e-124	NTclustered	gi\|162134340\|gb\|EU123979.1\|	160068	g1601	i0	84.156	129.276510067114	486	64	64	11	79	555	2265	1784	Trebouxia aggregata strain SAG 219-1d large subunit ribosomal RNA (rrl) gene, complete sequence; and putative site-specific DNA endonuclease (orf210) and hypothetical protein (orf277) genes, complete cds; chloroplast	blastn	96311	459	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia aggregata
27769803	27769803	PRJNA326068_P_NODE_11564_length_280_cov_2.553785_g10602_i0	PRJNA326068	11564	280	2.553785	7.150598	Trebouxia sp. C	2796353	Plants	Plants	58.9	9.06e-9	NR	KAL0042167.1	2905653	g10602	i0	55.1	0.525	49	21	51.4	1	92	235	17	65	KAL0042167.1 hypothetical protein WJX77_005300 [Trebouxia sp. C0004]	diamond	147	58.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0004
30565492	30565492	PRJNA326068_P_NODE_18053_length_180_cov_1.523179_g17090_i0	PRJNA326068	18053	180	1.523179	2.7417222	Viridiplantae	33090	Plants	Plants	55.8	3.72e-7	NR	KAK9807691.1	41462	g17090	i0	53.3	4.01666666666667	45	21	75	0	44	178	271	315	KAK9807691.1 hypothetical protein WJX72_006212 [[Myrmecia] bisecta]	diamond	723	55.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta

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