metadata: contig_metadata: 5 rows where bioproject = "PRJNA704949", tax_kingdom = "Thermotogati" and tax

5 rows where bioproject = "PRJNA704949", tax_kingdom = "Thermotogati" and tax_phylum = "Thermotogota"

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
26956181	26956181	PRJNA704949_P_NODE_1067922_length_250_cov_1.293532_g1052586_i0	PRJNA704949	1067922	250	1.293532	3.23383	Petrotoga sp. 8T1HF	2053592	Bacteria	Bacteria	67.4	1.9e-11	NR	WP_202695714.1	1351838	g1052586	i0	41.5	1.968	82	44	98.4	2	1	246	53	130	WP_202695714.1 macro domain-containing protein [Petrotoga sp. 8T1HF07.NaAc.6.1]	diamond	492	67.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Petrotoga	Petrotoga sp. 8T1HF07.NaAc.6.1
27473228	27473228	PRJNA704949_P_NODE_1569003_length_195_cov_1.424658_g1553664_i0	PRJNA704949	1569003	195	1.424658	2.7780831	Bacteria	2	Bacteria	Bacteria	75.1	2.93e-14	NR	HQI79085.1	2819251	g1553664	i0	76.6	13.9846153846154	47	11	72.3	0	53	193	1	47	HQI79085.1 PEP/pyruvate-binding domain-containing protein [Petrotogaceae bacterium]	diamond	2727	75.1	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae		Petrotogaceae bacterium
28599018	28599018	PRJNA704949_P_NODE_1402847_length_210_cov_1.291925_g1387509_i0	PRJNA704949	1402847	210	1.291925	2.7130425	Fervidobacterium sp.	1871331	Bacteria	Bacteria	116	1.07e-30	NR	MDM7321176.1	1871331	g1387509	i0	85.7	1.8	63	9	90	0	1	189	84	146	MDM7321176.1 hypothetical protein [Fervidobacterium sp.]	diamond	378	116	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
30093775	30093775	PRJNA704949_P_NODE_1234072_length_228_cov_1.452514_g1218735_i0	PRJNA704949	1234072	228	1.452514	3.31173192	Bacteria	2	Bacteria	Bacteria	75.1	2.25e-14	NR	WP_047268011.1	1428449	g1218735	i0	52.6	6.60526315789474	76	34	97.4	1	1	222	131	206	WP_047268011.1 (d)CMP kinase [Marinitoga sp. 1197]	diamond	1506	75.5	0.994701986754967	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga sp. 1197
30493999	30493999	PRJNA704949_P_NODE_1990713_length_167_cov_1.322034_g1975374_i0	PRJNA704949	1990713	167	1.322034	2.20779678	Fervidobacterium pennivorans	93466	Bacteria	Bacteria	94.4	1.47e-23	NR	MFN3328124.1	93466	g1975374	i0	81.5	6.79041916167665	54	10	97	0	6	167	21	74	MFN3328124.1 tyrosine-type recombinase/integrase [Fervidobacterium pennivorans]	diamond	1134	94.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans

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