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

4 rows where analysis = "diamond", bioproject = "PRJNA1146029" 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
27280835	27280835	PRJNA1146029_P_NODE_14083_length_264_cov_1.345550_g13802_i0	PRJNA1146029	14083	264	1.34555	3.552252	Deinococci	188787	Bacteria	Bacteria	100	4.289999999999999e-23	NR	WP_027891833.1	52023	g13802	i0	55	2.81818181818182	80	35	90.9	1	1	240	169	247	WP_027891833.1 tRNA dihydrouridine(20/20a) synthase DusA [Calidithermus chliarophilus]	diamond	744	100	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Calidithermus	Calidithermus chliarophilus
27576105	27576105	PRJNA1146029_P_NODE_12664_length_274_cov_1.164179_g12383_i0	PRJNA1146029	12664	274	1.164179	3.18985046	Meiothermus hypogaeus	884155	Bacteria	Bacteria	46.2	0.00248	NR	WP_119342060.1	884155	g12383	i0	41.4	0.635036496350365	58	30	63.5	1	65	238	2	55	WP_119342060.1 lysophospholipid acyltransferase family protein [Meiothermus hypogaeus]	diamond	174	46.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus hypogaeus
28270532	28270532	PRJNA1146029_P_NODE_18366_length_247_cov_1.327586_g18085_i0	PRJNA1146029	18366	247	1.327586	3.27913742	Deinococcus alpinitundrae	468913	Bacteria	Bacteria	62	6.04e-9	NR	WP_161883928.1	468913	g18085	i0	60.4	2.24696356275304	53	20	63.2	1	5	160	145	197	WP_161883928.1 phage recombination protein Bet [Deinococcus alpinitundrae]	diamond	555	62	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus alpinitundrae
28512214	28512214	PRJNA1146029_P_NODE_10307_length_288_cov_1.767442_g10026_i0	PRJNA1146029	10307	288	1.767442	5.09023296	FCB group	1783270	Bacteria	Bacteria	101	1.74e-22	NR	WP_146889270.1	401558	g10026	i0	48.4	2.94791666666667	95	49	99	0	2	286	621	715	WP_146889270.1 hypothetical protein [Deinococcus cellulosilyticus]	diamond	849	102	0.990196078431373	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cellulosilyticus

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