metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA315314" 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
28053376	28053376	PRJNA315314_S_NODE_24645_length_168_cov_17.309353_g24324_i0	PRJNA315314	24645	168	17.309353	29.07971304	Deinococcus soli (ex Cha et al. 2	1309411	Bacteria	Bacteria	110	6.41e-29	NR	WP_188846249.1	1309411	g24324	i0	98.2	0.982142857142857	55	1	98.2	0	3	167	85	139	WP_188846249.1 hypothetical protein [Deinococcus soli (ex Cha et al. 2016)]	diamond	165	110	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
28874346	28874346	PRJNA315314_S_NODE_31008_length_153_cov_1.653226_g30687_i0	PRJNA315314	31008	153	1.653226	2.52943578	Deinococcaceae bacterium	3079796	Bacteria	Bacteria	72	3.27e-13	NR	MFN8509533.1	3079796	g30687	i0	79.5	0.764705882352941	39	8	76.5	0	33	149	72	110	MFN8509533.1 arginine deiminase-related protein [Deinococcaceae bacterium]	diamond	117	72	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae		Deinococcaceae bacterium
29081397	29081397	PRJNA315314_S_NODE_22288_length_176_cov_2.176871_g21967_i0	PRJNA315314	22288	176	2.176871	3.83129296	Marinitoga	160798	Bacteria	Bacteria	77.4	9e-15	NR	WP_014295976.1	160798	g21967	i0	62.5	4.80681818181818	56	21	95.5	0	7	174	281	336	WP_014295976.1 MULTISPECIES: arginine--tRNA ligase [Marinitoga]	diamond	846	77.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga
30642917	30642917	PRJNA315314_S_NODE_29493_length_156_cov_1.968504_g29172_i0	PRJNA315314	29493	156	1.968504	3.07086624	uncultured Deinococcus sp.	158789	Bacteria	Bacteria	95.5	1.5000000000000002e-22	NR	WP_288481000.1	158789	g29172	i0	100	0.980769230769231	51	0	98.1	0	154	2	11	61	WP_288481000.1 hypothetical protein [uncultured Deinococcus sp.]	diamond	153	95.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
31211301	31211301	PRJNA315314_S_NODE_14155_length_217_cov_2.670213_g13834_i0	PRJNA315314	14155	217	2.670213	5.79436221	Deinococcus roseus	392414	Bacteria	Bacteria	102	1.07e-26	NR	GGJ59852.1	392414	g13834	i0	81.3	0.884792626728111	64	1	88.5	1	215	24	11	63	GGJ59852.1 hypothetical protein GCM10008938_52470 [Deinococcus roseus]	diamond	192	102	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus roseus
32760972	32760972	PRJNA315314_S_NODE_23200_length_173_cov_2.611111_g22879_i0	PRJNA315314	23200	173	2.611111	4.51722203	Thermus sp. 2.9	1577051	Bacteria	Bacteria	52	7.81e-6	NR	WP_152607411.1	1577051	g22879	i0	52.2	1.63005780346821	46	22	79.8	0	28	165	46	91	WP_152607411.1 ParB/RepB/Spo0J family partition protein [Thermus sp. 2.9]	diamond	282	52	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. 2.9

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