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

6 rows where analysis = "diamond", bioproject = "PRJNA1180292" 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
9245700	9245700	PRJNA1180292_P_NODE_10588_length_247_cov_0.896552_g10456_i0	PRJNA1180292	10588	247	0.896552	2.21448344	Deinococcus aetherius	200252	Bacteria	Bacteria	113	2.26e-28	NR	WP_264775767.1	200252	g10456	i0	83.6	0.813765182186235	67	11	81.4	0	236	36	64	130	WP_264775767.1 PRC and DUF2382 domain-containing protein [Deinococcus aetherius]	diamond	201	113	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
27166874	27166874	PRJNA1180292_P_NODE_9342_length_250_cov_0.881356_g9210_i0	PRJNA1180292	9342	250	0.881356	2.20339	Fervidobacterium sp.	1871331	Bacteria	Bacteria	123	3.0999999999999996e-32	NR	HUM43420.1	1871331	g9210	i0	69.9	0.996	83	25	99.6	0	1	249	22	104	HUM43420.1 hypothetical protein [Fervidobacterium sp.]	diamond	249	123	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
28588293	28588293	PRJNA1180292_P_NODE_12027_length_244_cov_0.912281_g11895_i0	PRJNA1180292	12027	244	0.912281	2.22596564	Thermotogaceae bacterium	2268206	Bacteria	Bacteria	53.5	5.71e-6	NR	HEW91548.1	2268206	g11895	i0	32.5	1.02049180327869	83	50	95.9	2	7	240	264	345	HEW91548.1 glycosyltransferase [Thermotogaceae bacterium]	diamond	249	53.5	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae		Thermotogaceae bacterium
30596748	30596748	PRJNA1180292_P_NODE_10113_length_248_cov_0.891429_g9981_i0	PRJNA1180292	10113	248	0.891429	2.21074392	Bacteria candidate phyla	1783234	Bacteria	Bacteria	111	1.69e-26	NR	HCI29861.1	1871331	g9981	i0	72.6	2.66129032258065	73	20	88.3	0	222	4	1	73	HCI29861.1 helicase [Fervidobacterium sp.]	diamond	660	111	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
32000425	32000425	PRJNA1180292_P_NODE_12658_length_243_cov_0.917647_g12526_i0	PRJNA1180292	12658	243	0.917647	2.22988221	Allomeiothermus silvanus	52022	Bacteria	Bacteria	71.6	1.85e-12	NR	WP_013159700.1	52022	g12526	i0	68.9	0.555555555555556	45	14	55.6	0	143	9	43	87	WP_013159700.1 putative CRISPR-associated protein [Allomeiothermus silvanus]	diamond	135	71.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
32538551	32538551	PRJNA1180292_P_NODE_5439_length_299_cov_1.769912_g5307_i0	PRJNA1180292	5439	299	1.769912	5.29203688	Deinococcus aetherius	200252	Bacteria	Bacteria	48.9	4.66e-4	NR	WP_264778178.1	200252	g5307	i0	78.6	0.280936454849498	28	6	28.1	0	212	295	372	399	WP_264778178.1 hypothetical protein [Deinococcus aetherius]	diamond	84	48.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius

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