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

5 rows where analysis = "blastn", bioproject = "PRJNA1218818" and tax_phylum = "Streptophyta"

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
5436857	5436857	PRJNA1218818_P_NODE_10645_length_374_cov_1.524917_g10578_i0	PRJNA1218818	10645	374	1.524917	5.70318958	Taxillus matsudae	2805424	Plants	Plants	126	2.07e-24	NTclustered	gi\|1970150767\|gb\|MW555625.1\|	2805424	g10578	i0	84.375	5.49465240641711	128	20	34	0	17	144	2895	3022	Taxillus matsudae voucher Su138 large subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	2055	126	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Santalales	Loranthaceae	Taxillus	Taxillus matsudae
5436912	5436912	PRJNA1218818_P_NODE_15085_length_319_cov_1.252033_g15018_i0	PRJNA1218818	15085	319	1.252033	3.99398527	Oryza sativa	4530	Plants	Plants	584	2.38e-162	NTclustered	gi\|32969792\|dbj\|AK059774.1\|	39947	g15018	i0	99.687	14.846394984326	319	1	100	0	1	319	378	60	Oryza sativa Japonica Group cDNA clone:006-204-A02, full insert sequence	blastn	4736	584	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
22010496	22010496	PRJNA1218818_P_NODE_24958_length_249_cov_0.875000_g24891_i0	PRJNA1218818	24958	249	0.875	2.17875	Oryza sativa	4530	Plants	Plants	344	3.32e-90	NTclustered	gi\|116640654\|emb\|CT836596.1\|	39946	g24891	i0	91.566	84.6907630522088	249	21	100	0	1	249	324	76	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA116N01, full insert sequence	blastn	21088	344	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
24559823	24559823	PRJNA1218818_P_NODE_15520_length_315_cov_1.057851_g15453_i0	PRJNA1218818	15520	315	1.057851	3.33223065	Entransia fimbriata	130991	Plants	Plants	163	1.31e-35	NTclustered	gi\|1767162941\|gb\|MN585748.1\|	130991	g15453	i0	92.105	42.2761904761905	114	8	36	1	202	315	4352	4240	Entransia fimbriata isolate UTEX 2353 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	13317	163	1	Eukaryota		Viridiplantae	Streptophyta	Klebsormidiophyceae	Entransiales	Entransiaceae	Entransia	Entransia fimbriata
24559956	24559956	PRJNA1218818_P_NODE_25120_length_249_cov_0.875000_g25053_i0	PRJNA1218818	25120	249	0.875	2.17875	Nymphaea colorata	210225	Plants	Plants	154	6.01e-33	NTclustered	gi\|1750920968\|emb\|LR722126.1\|	210225	g25053	i0	78.226	2.51004016064257	248	48	98	4	4	248	3749	3993	XXX	blastn	625	154	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Nymphaeales	Nymphaeaceae	Nymphaea	Nymphaea colorata

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