metadata: contig_metadata: 7 rows where bioproject = "PRJEB39643" and tax

7 rows where bioproject = "PRJEB39643" 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
6092400	6092400	PRJEB39643_P_NODE_10905_length_589_cov_3.339147_g10720_i0	PRJEB39643	10905	589	3.339147	19.66757583	Geotoga	28233	Bacteria	Bacteria	1011	0	NTclustered	gi\|1673217101\|gb\|MK984240.1\|	28234	g10720	i0	97.119	109.704584040747	590	14	99	1	1	587	314	903	Geotoga petraea strain HO-Geo1 16S ribosomal RNA gene, partial sequence	blastn	64616	1011	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Geotoga	Geotoga petraea
29212582	29212582	PRJEB39643_P_NODE_51429_length_285_cov_1.452830_g51236_i0	PRJEB39643	51429	285	1.45283	4.1405655	uncultured Fretibacterium sp.	1678694	Bacteria	Bacteria	187	7.51e-53	NR	WP_299076996.1	1678694	g51236	i0	100	0.989473684210526	94	0	98.9	0	283	2	1300	1393	WP_299076996.1 DNA-directed RNA polymerase subunit beta' [uncultured Fretibacterium sp.]	diamond	282	187	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	uncultured Fretibacterium sp.
29401849	29401849	PRJEB39643_P_NODE_95449_length_263_cov_1.621053_g95256_i0	PRJEB39643	95449	263	1.621053	4.26336939	Trueperaceae bacterium	2026798	Bacteria	Bacteria	41.6	0.0223	NR	MFO8149310.1	2026798	g95256	i0	32.8	0.695817490494297	61	41	69.6	0	184	2	14	74	MFO8149310.1 hypothetical protein [Trueperaceae bacterium]	diamond	183	41.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
29995342	29995342	PRJEB39643_P_NODE_41831_length_291_cov_2.201835_g41638_i0	PRJEB39643	41831	291	2.201835	6.40733985	Bacteria	2	Bacteria	Bacteria	162	7.57e-45	NR	WP_277188353.1	277	g41638	i0	80.4	42.6494845360825	97	15	99	2	3	290	157	250	WP_277188353.1 phosphoenolpyruvate carboxykinase (GTP), partial [Meiothermus ruber]	diamond	12411	162	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
30026915	30026915	PRJEB39643_P_NODE_25131_length_364_cov_4.683849_g24938_i0	PRJEB39643	25131	364	4.683849	17.04921036	root	1	Root_unresolved	Root_unresolved	128	1.6999999999999996e-31	NR	1TAQ_A	271	g24938	i0	95.6	2.24175824175824	68	3	56	0	161	364	490	557	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	816	128	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
32119890	32119890	PRJEB39643_P_NODE_110018_length_256_cov_3.366120_g109825_i0	PRJEB39643	110018	256	3.36612	8.6172672	Thermotogota bacterium	2053689	Bacteria	Bacteria	86.7	3.64e-19	NR	MFP4460652.1	2053689	g109825	i0	51.9	0.94921875	81	38	93.8	1	15	254	17	97	MFP4460652.1 gamma carbonic anhydrase family protein [Thermotogota bacterium]	diamond	243	86.7	1	Bacteria	Thermotogati	Thermotogota					Thermotogota bacterium
32594423	32594423	PRJEB39643_P_NODE_83900_length_269_cov_1.571429_g83707_i0	PRJEB39643	83900	269	1.571429	4.22714401	uncultured Fretibacterium sp.	1678694	Bacteria	Bacteria	167	1.5499999999999998e-48	NR	WP_299301566.1	1678694	g83707	i0	89.9	0.992565055762082	89	9	99.3	0	269	3	81	169	WP_299301566.1 nicotinate-nucleotide--dimethylbenzimidazole phosphoribosyltransferase [uncultured Fretibacterium sp.]	diamond	267	167	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	uncultured Fretibacterium sp.

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