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

5 rows where analysis = "blastn", bioproject = "PRJNA493244" and tax_phylum = "Bacillariophyta"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
456177	456177	PRJNA493244_P_NODE_1630141_length_214_cov_1.673203_g1607016_i0	PRJNA493244	1630141	214	1.673203	3.58065442	Chaetoceros pseudocurvisetus	426637	SAR_Eukaryotes	SAR_Eukaryotes	97.1	8.59e-16	NTclustered	gi\|2043890829\|gb\|MZ267684.1\|	426637	g1607016	i0	92.537	11.6775700934579	67	5	31	0	70	136	3233	3299	Chaetoceros pseudocurvisetus isolate CNS00390 large subunit ribosomal RNA gene, partial sequence	blastn	2499	97.1	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros pseudocurvisetus
10658638	10658638	PRJNA493244_P_NODE_1094209_length_367_cov_7.571895_g1071088_i0	PRJNA493244	1094209	367	7.571895	27.78885465	Gomphonema parvulum	97227	SAR_Eukaryotes	SAR_Eukaryotes	270	8.839999999999999e-68	NTclustered	gi\|2444483253\|gb\|OP718170.1\|	97227	g1071088	i0	82.121	5.11716621253406	330	45	89	12	1	325	4216	3896	Gomphonema parvulum mitochondrion, complete genome	blastn	1878	270	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Cymbellales	Gomphonemataceae	Gomphonema	Gomphonema parvulum
15758603	15758603	PRJNA493244_P_NODE_1545133_length_232_cov_3.900585_g1522008_i0	PRJNA493244	1545133	232	3.900585	9.0493572	Plagiogrammopsis vanheurckii	1234821	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.021	NTclustered	gi\|1418587279\|ref\|NC_037997.1\|	1234821	g1522008	i0	96.875	0.137931034482759	32	0	13	1	27	57	93024	92993	Plagiogrammopsis vanheurckii chloroplast, complete genome	blastn	32	52.8	1	Eukaryota	Sar	Bacillariophyta	Mediophyceae	Cymatosirales	Cymatosiraceae	Plagiogrammopsis	Plagiogrammopsis vanheurckii
22776711	22776711	PRJNA493244_P_NODE_1191958_length_331_cov_53.551852_g1168834_i0	PRJNA493244	1191958	331	53.551852	177.25663012	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	163	1.3799999999999998e-35	NTclustered	gi\|2721953992\|gb\|OR464345.1\|	2675857	g1168834	i0	77.739	72.380664652568	283	52	84	10	18	295	55268	55544	Nitzschia reversa mitochondrion, complete genome	blastn	23958	163	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia reversa
23407958	23407958	PRJNA493244_P_NODE_1456119_length_253_cov_4.833333_g1432994_i0	PRJNA493244	1456119	253	4.833333	12.22833249	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	276	1.2499999999999998e-69	NTclustered	gi\|657012566\|gb\|KF302620.1\|	2850	g1432994	i0	87.967	1.90513833992095	241	19	92	7	21	253	274	36	Phaeodactylum tricornutum clone C821 hypothetical protein mRNA, complete cds	blastn	482	276	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum

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