metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA454503" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA454503" 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
15745050	15745050	PRJNA454503_P_NODE_39733_length_227_cov_1.566265_g39404_i0	PRJNA454503	39733	227	1.566265	3.55542155	Deinococcus	1298	Bacteria	Bacteria	137	9.64e-36	NR	WP_353542649.1	457454	g39404	i0	87.8	3.95154185022026	74	9	97.8	0	5	226	329	402	WP_353542649.1 ATP-binding protein [Deinococcus xinjiangensis]	diamond	897	137	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xinjiangensis
22119498	22119498	PRJNA454503_P_NODE_85518_length_202_cov_0.921986_g85189_i0	PRJNA454503	85518	202	0.921986	1.86241172	Deinococcus budaensis	1665626	Bacteria	Bacteria	107	9.36e-27	NR	WP_184024893.1	1665626	g85189	i0	77.4	1.9009900990099	62	14	92.1	0	16	201	1	62	WP_184024893.1 aminoglycoside phosphotransferase family protein [Deinococcus budaensis]	diamond	384	107	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis
26696190	26696190	PRJNA454503_P_NODE_7701_length_405_cov_1.700581_g7372_i0	PRJNA454503	7701	405	1.700581	6.88735305	Synergistaceae bacterium	2053624	Bacteria	Bacteria	152	5.999999999999998e-42	NR	MBR0278362.1	2053624	g7372	i0	60.3	1.86666666666667	126	48	92.6	2	405	31	207	331	MBR0278362.1 transposase [Synergistaceae bacterium]	diamond	756	152	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
28055142	28055142	PRJNA454503_P_NODE_75045_length_205_cov_0.902778_g74716_i0	PRJNA454503	75045	205	0.902778	1.8506949	Deinococcus fonticola	2528713	Bacteria	Bacteria	147	2.74e-39	NR	WP_240738441.1	2528713	g74716	i0	97.1	0.995121951219512	68	2	99.5	0	205	2	236	303	WP_240738441.1 glycoside hydrolase family 20 zincin-like fold domain-containing protein [Deinococcus fonticola]	diamond	204	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus fonticola
28592127	28592127	PRJNA454503_P_NODE_48707_length_217_cov_1.487179_g48378_i0	PRJNA454503	48707	217	1.487179	3.22717843	uncultured Truepera sp.	543023	Bacteria	Bacteria	126	1.04e-31	NR	CAA9586279.1	543023	g48378	i0	87.5	1.99078341013825	72	9	99.5	0	2	217	502	573	CAA9586279.1 MAG: Polyribonucleotide nucleotidyltransferase [uncultured Truepera sp.]	diamond	432	126	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
28687027	28687027	PRJNA454503_P_NODE_86447_length_202_cov_0.921986_g86118_i0	PRJNA454503	86447	202	0.921986	1.86241172	Deinococcus aquatilis	519440	Bacteria	Bacteria	107	3.69e-25	NR	WP_019012367.1	519440	g86118	i0	88.1	0.995049504950495	67	7	99.5	1	2	202	94	159	WP_019012367.1 type I restriction enzyme subunit R domain-containing protein [Deinococcus aquatilis]	diamond	201	107	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquatilis
30455644	30455644	PRJNA454503_P_NODE_73553_length_205_cov_1.805556_g73224_i0	PRJNA454503	73553	205	1.805556	3.7013898	Deinococcus caeni	569127	Bacteria	Bacteria	140	1.29e-36	NR	WP_345443678.1	569127	g73224	i0	97.1	0.995121951219512	68	2	99.5	0	2	205	396	463	WP_345443678.1 HD domain-containing phosphohydrolase [Deinococcus caeni]	diamond	204	140	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus caeni
30518475	30518475	PRJNA454503_P_NODE_62753_length_209_cov_0.878378_g62424_i0	PRJNA454503	62753	209	0.878378	1.83581002	Deinococcus ficus	317577	Bacteria	Bacteria	55.8	5.13e-7	NR	WP_051307608.1	317577	g62424	i0	67.4	0.617224880382775	43	14	61.7	0	145	17	3	45	WP_051307608.1 NUDIX domain-containing protein [Deinococcus ficus]	diamond	129	55.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
31530049	31530049	PRJNA454503_P_NODE_63776_length_208_cov_1.761905_g63447_i0	PRJNA454503	63776	208	1.761905	3.6647624	Deinococcus sp. Leaf326	1736338	Bacteria	Bacteria	93.6	2.99e-20	NR	WP_056299193.1	1736338	g63447	i0	67.6	0.980769230769231	68	22	98.1	0	5	208	779	846	WP_056299193.1 VirB4 family type IV secretion system protein [Deinococcus sp. Leaf326]	diamond	204	93.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. Leaf326
32099246	32099246	PRJNA454503_P_NODE_26298_length_246_cov_0.886486_g25969_i0	PRJNA454503	26298	246	0.886486	2.18075556	Meiothermus hypogaeus	884155	Bacteria	Bacteria	44.3	0.00913	NR	WP_119342060.1	884155	g25969	i0	42.6	1.14634146341463	47	27	57.3	0	4	144	2	48	WP_119342060.1 lysophospholipid acyltransferase family protein [Meiothermus hypogaeus]	diamond	282	44.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus hypogaeus

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