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

5 rows where bioproject = "PRJNA382357", 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
22751525	22751525	PRJNA382357_P_NODE_146478_length_206_cov_0.896552_g145739_i0	PRJNA382357	146478	206	0.896552	1.84689712	Pyramidobacter	638847	Bacteria	Bacteria	60.2	1.08e-4	NTclustered	gi\|2188906985\|dbj\|AP025585.1\|	638849	g145739	i0	90.909	0.815533980582524	44	4	21	0	113	156	1866555	1866598	Pyramidobacter piscolens CE91-St28 DNA, complete genome	blastn	168	60.2	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter piscolens
27328085	27328085	PRJNA382357_P_NODE_59683_length_303_cov_6.884298_g58944_i0	PRJNA382357	59683	303	6.884298	20.85942294	Thermovirga lienii DSM 17291	580340	Bacteria	Bacteria	106	3.75e-24	NR	AER66996.1	580340	g58944	i0	67.5	0.762376237623762	77	24	76.2	1	286	56	469	544	AER66996.1 Protein of unknown function DUF2044, membrane [Thermovirga lienii DSM 17291]	diamond	231	106	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Thermovirgaceae	Thermovirga	Thermovirga lienii
29302535	29302535	PRJNA382357_P_NODE_112049_length_230_cov_1.881657_g111310_i0	PRJNA382357	112049	230	1.881657	4.3278111	root	1	Root_unresolved	Root_unresolved	55.8	7.39e-7	NR	HQK25924.1	2053624	g111310	i0	42.2	5.4	64	37	83.5	0	222	31	262	325	HQK25924.1 Hsp70 family protein [Synergistaceae bacterium]	diamond	1242	56.2	0.99288256227758	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29506583	29506583	PRJNA382357_P_NODE_95410_length_247_cov_1.747312_g94671_i0	PRJNA382357	95410	247	1.747312	4.31586064	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	58.2	1.41e-7	NR	WP_015555829.1	651822	g94671	i0	79.4	0.412955465587045	34	7	41.3	0	102	1	1	34	WP_015555829.1 efflux RND transporter periplasmic adaptor subunit [Fretibacterium fastidiosum]	diamond	102	58.2	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
31117436	31117436	PRJNA382357_P_NODE_133075_length_212_cov_1.291391_g132336_i0	PRJNA382357	133075	212	1.291391	2.73774892	uncultured Fretibacterium sp.	1678694	Bacteria	Bacteria	72.8	9.69e-14	NR	WP_299299478.1	1678694	g132336	i0	76.6	0.665094339622642	47	11	66.5	0	4	144	150	196	WP_299299478.1 hypothetical protein, partial [uncultured Fretibacterium sp.]	diamond	141	72.8	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	uncultured Fretibacterium sp.

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