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

5 rows where analysis = "blastn", bioproject = "PRJNA980587" and tax_kingdom = "Thermotogati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1269596	1269596	PRJNA980587_P_NODE_72001_length_265_cov_1.552083_g71208_i0	PRJNA980587	72001	265	1.552083	4.11301995	Deinococcus	1298	Bacteria	Bacteria	466	7.2999999999999995e-127	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g71208	i0	98.491	226.637735849057	265	2	99	2	2	265	1791865	1792128	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	60059	466	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
4784556	4784556	PRJNA980587_P_NODE_93784_length_242_cov_0.911243_g92991_i0	PRJNA980587	93784	242	0.911243	2.20520806	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	233	7.25e-57	NTclustered	gi\|1868561018\|gb\|CP058534.1\|	2755035	g92991	i0	84.167	9.57438016528926	240	38	99	0	2	241	947017	946778	Deinococcus sp. D7000 chromosome, complete genome	blastn	2317	233	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
7333952	7333952	PRJNA980587_P_NODE_84666_length_247_cov_0.885057_g83873_i0	PRJNA980587	84666	247	0.885057	2.18609079	Thermus scotoductus	37636	Bacteria	Bacteria	344	3.29e-90	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g83873	i0	92.827	21.1943319838057	237	17	96	0	1	237	1388644	1388408	Thermus scotoductus SA-01, complete genome	blastn	5235	344	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
9884220	9884220	PRJNA980587_P_NODE_78328_length_251_cov_1.258427_g77535_i0	PRJNA980587	78328	251	1.258427	3.15865177	Trueperaceae bacterium	2026798	Bacteria	Bacteria	268	2.07e-67	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g77535	i0	86	111.91235059761	250	35	99	0	1	250	3600067	3599818	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	28090	268	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
12434715	12434715	PRJNA980587_P_NODE_34150_length_407_cov_0.928144_g33357_i0	PRJNA980587	34150	407	0.928144	3.77754608	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	667	0	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g33357	i0	96.985	206.223587223587	398	11	98	1	7	403	1508449	1508052	Deinococcus sp. QL22 chromosome, complete genome	blastn	83933	667	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22

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