metadata: contig_metadata: 5 rows where bioproject = "PRJNA453567" and tax

5 rows where bioproject = "PRJNA453567" 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
15744541	15744541	PRJNA453567_P_NODE_6673_length_384_cov_1.899135_g6437_i0	PRJNA453567	6673	384	1.899135	7.2926784	Deinococcus sp.	47478	Bacteria	Bacteria	118	6.84e-28	NR	WP_293915296.1	47478	g6437	i0	50.4	7.640625	125	58	96.1	3	11	379	381	503	WP_293915296.1 penicillin acylase family protein [Deinococcus sp.]	diamond	2934	118	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
20843525	20843525	PRJNA453567_P_NODE_237_length_1934_cov_8.717449_g218_i0	PRJNA453567	237	1934	8.717449	168.59546366	FCB group	1783270	Bacteria	Bacteria	610	7.549999999999998e-212	NR	WP_276955884.1	52022	g218	i0	63.2	51.2807652533609	505	154	77.6	7	1763	264	3	480	WP_276955884.1 NADP-dependent isocitrate dehydrogenase [Allomeiothermus silvanus]	diamond	99177	615	0.991869918699187	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
27518512	27518512	PRJNA453567_P_NODE_13863_length_245_cov_1.865385_g13626_i0	PRJNA453567	13863	245	1.865385	4.57019325	Deinococcus roseus	392414	Bacteria	Bacteria	56.6	4.78e-7	NR	WP_189001765.1	392414	g13626	i0	47.2	1.31020408163265	53	28	64.9	0	159	1	124	176	WP_189001765.1 ammonium transporter [Deinococcus roseus]	diamond	321	56.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus roseus
27708381	27708381	PRJNA453567_P_NODE_8584_length_329_cov_1.866438_g8347_i0	PRJNA453567	8584	329	1.866438	6.14058102	Deinococcus aestuarii	2774531	Bacteria	Bacteria	56.2	1.77e-6	NR	WP_216318403.1	2774531	g8347	i0	54	0.455927051671733	50	23	45.6	0	1	150	84	133	WP_216318403.1 cytochrome P450 [Deinococcus aestuarii]	diamond	150	56.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aestuarii
30629278	30629278	PRJNA453567_P_NODE_29473_length_161_cov_1.725806_g29236_i0	PRJNA453567	29473	161	1.725806	2.77854766	Oceanithermus	208447	Bacteria	Bacteria	73.2	2.25e-13	NR	HGY08470.1	187137	g29236	i0	64.2	5.92546583850932	53	15	98.8	1	2	160	136	184	HGY08470.1 penicillin acylase family protein [Oceanithermus profundus]	diamond	954	73.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Oceanithermus	Oceanithermus profundus

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