metadata: contig_metadata: 9 rows where bioproject = "PRJEB81171" and tax

9 rows where bioproject = "PRJEB81171" 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
139449	139449	PRJEB81171_P_NODE_7861_length_252_cov_0.871508_g7734_i0	PRJEB81171	7861	252	0.871508	2.19620016	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	416	7.029999999999999e-112	NTclustered	gi\|2238962615\|gb\|CP097154.1\|	2939437	g7734	i0	96.429	1	252	9	100	0	1	252	59273	59524	Deinococcus sp. QL22 plasmid unnamed6, complete sequence	blastn	252	416	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
139481	139481	PRJEB81171_P_NODE_9521_length_244_cov_0.912281_g9394_i0	PRJEB81171	9521	244	0.912281	2.22596564	Allomeiothermus silvanus	52022	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g9394	i0	99.18	6.93032786885246	244	2	100	0	1	244	1983728	1983485	Meiothermus silvanus DSM 9946, complete genome	blastn	1691	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
1414070	1414070	PRJEB81171_P_NODE_722_length_765_cov_1.609827_g607_i0	PRJEB81171	722	765	1.609827	12.31517655	Trueperaceae bacterium	2026798	Bacteria	Bacteria	1033	0	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g607	i0	91.123	450.681045751634	766	62	100	6	1	765	3601169	3600409	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	344771	1033	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
13750089	13750089	PRJEB81171_P_NODE_9071_length_246_cov_0.901734_g8944_i0	PRJEB81171	9071	246	0.901734	2.21826564	Fervidobacterium	2422	Bacteria	Bacteria	366	6.99e-97	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g8944	i0	93.827	3.97967479674797	243	15	99	0	1	243	1355856	1356098	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	979	366	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
20540391	20540391	PRJEB81171_P_NODE_7217_length_259_cov_2.086022_g7090_i0	PRJEB81171	7217	259	2.086022	5.40279698	Deinococcus gobiensis	502394	Bacteria	Bacteria	374	4.4299999999999994e-99	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g7090	i0	92.776	239.702702702703	263	12	100	7	1	259	112459	112200	Deinococcus gobiensis I-0, complete genome	blastn	62083	374	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
23091452	23091452	PRJEB81171_P_NODE_8779_length_248_cov_0.880000_g8652_i0	PRJEB81171	8779	248	0.88	2.1824	Deinococcus aquaticus	328692	Bacteria	Bacteria	436	5.3e-118	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g8652	i0	98.387	2	248	4	100	0	1	248	2262377	2262624	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	496	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
26844620	26844620	PRJEB81171_P_NODE_7561_length_254_cov_1.077348_g7434_i0	PRJEB81171	7561	254	1.077348	2.73646392	Deinococcus roseus	392414	Bacteria	Bacteria	117	1.94e-28	NR	WP_189001606.1	392414	g7434	i0	65.1	5.88188976377953	83	29	98	0	252	4	22	104	WP_189001606.1 phosphoenolpyruvate carboxykinase (GTP) [Deinococcus roseus]	diamond	1494	117	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus roseus
29971080	29971080	PRJEB81171_P_NODE_6471_length_272_cov_1.060302_g6344_i0	PRJEB81171	6471	272	1.060302	2.88402144	Meiothermus hypogaeus	884155	Bacteria	Bacteria	43.5	0.0226	NR	WP_119342060.1	884155	g6344	i0	42.6	0.518382352941177	47	27	51.8	0	1	141	2	48	WP_119342060.1 lysophospholipid acyltransferase family protein [Meiothermus hypogaeus]	diamond	141	43.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus hypogaeus
32500544	32500544	PRJEB81171_P_NODE_9939_length_242_cov_0.923077_g9812_i0	PRJEB81171	9939	242	0.923077	2.23384634	Deinococcus budaensis	1665626	Bacteria	Bacteria	132	3.5000000000000003e-34	NR	WP_184027744.1	1665626	g9812	i0	91.3	0.991735537190083	80	7	99.2	0	240	1	382	461	WP_184027744.1 hypothetical protein [Deinococcus budaensis]	diamond	240	132	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis

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