metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA484127" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA484127" and tax_phylum = "Chlorophyta"

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
8101579	8101579	PRJNA484127_P_NODE_24367_length_273_cov_1.560000_g24218_i0	PRJNA484127	24367	273	1.56	4.2588	Monoraphidium neglectum	145388	Plants	Plants	231	3e-56	NTclustered	gi\|926777793\|ref\|XM_014041917.1\|	145388	g24218	i0	85.398	61.9523809523809	226	29	82	3	20	243	242	19	Monoraphidium neglectum heat shock 70kDa protein 1/8 mRNA	blastn	16913	231	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
16399889	16399889	PRJNA484127_P_NODE_37253_length_244_cov_0.912281_g37104_i0	PRJNA484127	37253	244	0.912281	2.22596564	Eukaryota	2759	Plants	Plants	58.4	4.73e-4	NTclustered	gi\|2082241338\|ref\|XM_043060459.1\|	3055	g37104	i0	100	12.4508196721311	31	0	13	0	77	107	5993	5963	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g146567v5), mRNA	blastn	3038	58.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
18300415	18300415	PRJNA484127_P_NODE_8515_length_407_cov_2.700599_g8366_i0	PRJNA484127	8515	407	2.700599	10.99143793	Micromonas pusilla	38833	Plants	Plants	254	9.98e-63	NTclustered	gi\|303282132\|ref\|XM_003060312.1\|	564608	g8366	i0	78.68	18.4520884520885	394	74	96	9	1	389	156	544	Micromonas pusilla CCMP1545 uncharacterized protein (MICPUCDRAFT_49648), mRNA	blastn	7510	254	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas pusilla
19574373	19574373	PRJNA484127_P_NODE_29776_length_253_cov_0.866667_g29627_i0	PRJNA484127	29776	253	0.866667	2.19266751	Coccomyxa subellipsoidea	248742	Plants	Plants	158	4.729999999999999e-34	NTclustered	gi\|545356038\|ref\|XM_005643719.1\|	574566	g29627	i0	78.125	3.71541501976285	256	50	100	4	1	253	886	1138	Coccomyxa subellipsoidea C-169 nuclear RNA helicase-like protein Bat1 mRNA	blastn	940	158	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
21499135	21499135	PRJNA484127_P_NODE_30177_length_252_cov_1.743017_g30028_i0	PRJNA484127	30177	252	1.743017	4.39240284	Chlorophyta	3041	Plants	Plants	228	3.5399999999999984e-55	NTclustered	gi\|255085001\|ref\|XM_002504886.1\|	296587	g30028	i0	84.034	84.7698412698413	238	36	94	2	6	242	529	765	Micromonas commoda predicted protein mRNA	blastn	21362	228	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas commoda

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