metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA431371" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA431371" 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
27377014	27377014	PRJNA431371_P_NODE_643_length_1068_cov_6.336683_g587_i0	PRJNA431371	643	1068	6.336683	67.67577444	Deinococci	188787	Bacteria	Bacteria	300	1.43e-94	NR	RTG94146.1	37636	g587	i0	55.7	15.9887640449438	327	126	91.9	7	998	18	80	387	RTG94146.1 peptidase S8 [Thermus scotoductus]	diamond	17076	303	0.99009900990099	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
27770949	27770949	PRJNA431371_P_NODE_29204_length_247_cov_0.885057_g29131_i0	PRJNA431371	29204	247	0.885057	2.18609079	Thermus brockianus	56956	Bacteria	Bacteria	43.9	0.015	NR	WP_071676650.1	56956	g29131	i0	41.7	0.728744939271255	60	28	71.7	2	36	212	493	546	WP_071676650.1 hypothetical protein [Thermus brockianus]	diamond	180	43.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
30675917	30675917	PRJNA431371_P_NODE_27813_length_249_cov_0.875000_g27740_i0	PRJNA431371	27813	249	0.875	2.17875	Deinococcus budaensis	1665626	Bacteria	Bacteria	132	7.189999999999999e-34	NR	WP_184030208.1	1665626	g27740	i0	88.9	0.975903614457831	81	9	97.6	0	245	3	142	222	WP_184030208.1 helix-hairpin-helix domain-containing protein [Deinococcus budaensis]	diamond	243	132	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis
31909059	31909059	PRJNA431371_P_NODE_11017_length_377_cov_2.782895_g10944_i0	PRJNA431371	11017	377	2.782895	10.49151415	Synergistaceae bacterium	2053624	Bacteria	Bacteria	52.4	1.94e-5	NR	MBQ6001342.1	2053624	g10944	i0	68.6	0.86737400530504	35	11	27.9	0	8	112	4	38	MBQ6001342.1 sel1 repeat family protein [Synergistaceae bacterium]	diamond	327	52.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae 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);;