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

5 rows where bioproject = "PRJNA695273", tax_kingdom = "Thermotogati" and tax_phylum = "Synergistota"

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
677192	677192	PRJNA695273_P_NODE_143741_length_246_cov_0.890173_g142983_i0	PRJNA695273	143741	246	0.890173	2.18982558	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	427	3.16e-115	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g142983	i0	97.967	137.682926829268	246	5	100	0	1	246	69216	69461	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	33870	427	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
2457144	2457144	PRJNA695273_P_NODE_124522_length_251_cov_1.730337_g123764_i0	PRJNA695273	124522	251	1.730337	4.34314587	Acetomicrobium mobile DSM 13181	891968	Bacteria	Bacteria	58.5	1.02e-7	NR	AFM22532.1	891968	g123764	i0	51	1.74501992031873	49	24	58.6	0	250	104	297	345	AFM22532.1 leucyl aminopeptidase (aminopeptidase T) [Acetomicrobium mobile DSM 13181]	diamond	438	58.5	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile
27208907	27208907	PRJNA695273_P_NODE_141362_length_246_cov_1.780347_g140604_i0	PRJNA695273	141362	246	1.780347	4.37965362	Pyramidobacter piscolens	638849	Bacteria	Bacteria	95.5	9.33e-21	NR	WP_321822916.1	638849	g140604	i0	53.8	0.975609756097561	80	37	97.6	0	242	3	362	441	WP_321822916.1 phage portal protein [Pyramidobacter piscolens]	diamond	240	95.5	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter piscolens
27599620	27599620	PRJNA695273_P_NODE_98884_length_281_cov_1.317308_g98126_i0	PRJNA695273	98884	281	1.317308	3.70163548	Bacteria	2	Bacteria	Bacteria	125	5.36e-35	NR	MDR1622529.1	2053624	g98126	i0	81.1	2.45551601423488	74	14	79	0	223	2	11	84	MDR1622529.1 type II toxin-antitoxin system PemK/MazF family toxin [Synergistaceae bacterium]	diamond	690	126	0.992063492063492	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32800636	32800636	PRJNA695273_P_NODE_59280_length_355_cov_1.634752_g58522_i0	PRJNA695273	59280	355	1.634752	5.8033696	Synergistaceae bacterium	2053624	Bacteria	Bacteria	50.8	1.73e-4	NR	MBQ6774128.1	2053624	g58522	i0	36.1	0.608450704225352	72	43	58.3	1	127	333	3	74	MBQ6774128.1 hypothetical protein [Synergistaceae bacterium]	diamond	216	50.8	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);;