metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA1214993" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA1214993" 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
12524060	12524060	PRJNA1214993_P_NODE_17210_length_270_cov_1.365482_g17024_i0	PRJNA1214993	17210	270	1.365482	3.6868014	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	420	5.89e-113	NTclustered	gi\|2328365172\|ref\|NC_067848.1\|	97227	g17024	i0	94.815	194.785185185185	270	12	100	2	1	270	70565	70832	Gomphonema parvulum voucher personal collection:A.Bruce Cahoon:diatom-2021-A chloroplast, complete genome	blastn	52592	424	0.990566037735849	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Cymbellales	Gomphonemataceae	Gomphonema	Gomphonema parvulum
13798773	13798773	PRJNA1214993_P_NODE_14391_length_291_cov_1.573394_g14205_i0	PRJNA1214993	14391	291	1.573394	4.57857654	Naviculales	38748	SAR_Eukaryotes	SAR_Eukaryotes	398	3.0099999999999996e-106	NTclustered	gi\|146762526\|gb\|EF553458.1\|	2850	g14205	i0	91.667	77.446735395189	288	22	99	2	1	287	4231	4517	Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	22537	398	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
14359278	14359278	PRJNA1214993_P_NODE_14992_length_287_cov_0.887850_g14806_i0	PRJNA1214993	14992	287	0.88785	2.5481295	Thalassiosira pseudonana	35128	SAR_Eukaryotes	SAR_Eukaryotes	209	1.49e-49	NTclustered	gi\|223996056\|ref\|XM_002287666.1\|	296543	g14806	i0	85.859	7.95121951219512	198	26	69	2	85	281	1	197	Thalassiosira pseudonana CCMP1335 vacuolar ATP synthase (VAT4), partial mRNA	blastn	2282	209	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira pseudonana
22007213	22007213	PRJNA1214993_P_NODE_8398_length_374_cov_7.056478_g8212_i0	PRJNA1214993	8398	374	7.056478	26.39122772	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	193	2.01e-44	NTclustered	gi\|219128855\|ref\|XM_002184583.1\|	556484	g8212	i0	79.225	1.85294117647059	284	54	75	4	16	295	18	300	Phaeodactylum tricornutum CCAP 1055/1 protein fucoxanthin chlorophyll a/c protein (Lhcf11), mRNA	blastn	693	193	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);;