metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1035005" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1035005" 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
24394887	24394887	PRJNA1035005_P_NODE_38040_length_272_cov_1.512563_g37634_i0	PRJNA1035005	38040	272	1.512563	4.11417136	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	150	1.1399999999999997e-42	NR	WP_386845986.1	536443	g37634	i0	100	0.871323529411765	79	0	87.1	0	35	271	1	79	WP_386845986.1 NAD(P)-dependent oxidoreductase [Deinococcus taklimakanensis]	diamond	237	150	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
26591710	26591710	PRJNA1035005_P_NODE_45681_length_262_cov_1.650794_g45275_i0	PRJNA1035005	45681	262	1.650794	4.32508028	Deinococcus reticulitermitis	856736	Bacteria	Bacteria	99.8	1.37e-23	NR	WP_092265650.1	856736	g45275	i0	57.6	0.973282442748092	85	36	97.3	0	5	259	105	189	WP_092265650.1 hypothetical protein [Deinococcus reticulitermitis]	diamond	255	99.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus reticulitermitis
26932270	26932270	PRJNA1035005_P_NODE_76362_length_245_cov_0.906977_g75956_i0	PRJNA1035005	76362	245	0.906977	2.22209365	Synergistales	649776	Bacteria	Bacteria	114	2.54e-28	NR	WP_302364743.1	638849	g75956	i0	66.7	6.8938775510204104	81	27	99.2	0	243	1	24	104	WP_302364743.1 baseplate assembly protein [Pyramidobacter piscolens]	diamond	1689	114	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter piscolens
28038015	28038015	PRJNA1035005_P_NODE_67565_length_248_cov_0.891429_g67159_i0	PRJNA1035005	67565	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	60.1	3.07e-8	NR	NLV81954.1	2053624	g67159	i0	48.2	1.35483870967742	56	29	67.7	0	247	80	620	675	NLV81954.1 type I restriction endonuclease subunit R [Synergistaceae bacterium]	diamond	336	60.5	0.993388429752066	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29782466	29782466	PRJNA1035005_P_NODE_57771_length_252_cov_0.871508_g57365_i0	PRJNA1035005	57771	252	0.871508	2.19620016	Truepera radiovictrix	332249	Bacteria	Bacteria	55.5	1.36e-6	NR	WP_013177855.1	332249	g57365	i0	41.2	1.01190476190476	85	48	98.8	1	3	251	129	213	WP_013177855.1 hypothetical protein [Truepera radiovictrix]	diamond	255	55.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
29837532	29837532	PRJNA1035005_P_NODE_52531_length_254_cov_1.292818_g52125_i0	PRJNA1035005	52531	254	1.292818	3.28375772	Thermus	270	Bacteria	Bacteria	46.6	0.0016	NR	WP_287930650.1	275	g52125	i0	35.7	1.65354330708661	70	45	82.7	0	253	44	167	236	WP_287930650.1 HD domain-containing protein, partial [Thermus sp.]	diamond	420	46.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
32113666	32113666	PRJNA1035005_P_NODE_29678_length_283_cov_1.347619_g29272_i0	PRJNA1035005	29678	283	1.347619	3.81376177	Deinococcus	1298	Bacteria	Bacteria	169	3.51e-49	NR	WP_353544200.1	457454	g29272	i0	98.9	1.99293286219081	94	1	99.6	0	282	1	197	290	WP_353544200.1 MFS transporter [Deinococcus xinjiangensis]	diamond	564	170	0.994117647058824	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xinjiangensis
32248446	32248446	PRJNA1035005_P_NODE_3918_length_541_cov_2.079060_g3520_i0	PRJNA1035005	3918	541	2.07906	11.2477146	Trueperaceae bacterium	2026798	Bacteria	Bacteria	137	1.25e-33	NR	MFA5567487.1	2026798	g3520	i0	43.5	1.02033271719039	184	93	98.2	5	541	11	375	554	MFA5567487.1 hypothetical protein [Trueperaceae bacterium]	diamond	552	137	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium

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