metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA498309" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA498309" 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
4936868	4936868	PRJNA498309_P_NODE_24704_length_580_cov_11.401473_g22780_i0	PRJNA498309	24704	580	11.401473	66.1285434	Fervidobacterium	2422	Bacteria	Bacteria	952	0	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g22780	i0	98.699	25.3172413793103	538	3	92	3	23	558	766553	766018	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	14684	952	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
6858373	6858373	PRJNA498309_P_NODE_38406_length_448_cov_5.082725_g36329_i0	PRJNA498309	38406	448	5.082725	22.770608	Fervidobacterium gondwanense	44754	Bacteria	Bacteria	763	0	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g36329	i0	98.611	10.4888392857143	432	5	96	1	1	431	1154214	1154645	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	4699	763	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
7486770	7486770	PRJNA498309_P_NODE_29286_length_526_cov_16.615542_g27302_i0	PRJNA498309	29286	526	16.615542	87.397750919999993	Bacteria	2	Bacteria	Bacteria	900	0	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g27302	i0	99.395	12.2414448669202	496	3	94	0	13	508	308397	307902	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	6439	900	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
7486835	7486835	PRJNA498309_P_NODE_35546_length_470_cov_7.568129_g33494_i0	PRJNA498309	35546	470	7.568129	35.5702063	Bacteria	2	Bacteria	Bacteria	785	0	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g33494	i0	99.537	37.6617021276596	432	1	92	1	16	447	770479	770909	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	17701	785	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
8134476	8134476	PRJNA498309_P_NODE_80927_length_247_cov_13.200000_g78778_i0	PRJNA498309	80927	247	13.2	32.604	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	135	2.15e-27	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g78778	i0	83.007	9.35627530364373	153	23	61	3	75	225	42646	42495	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	2311	135	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
11311788	11311788	PRJNA498309_P_NODE_23469_length_596_cov_10.393560_g21570_i0	PRJNA498309	23469	596	10.39356	61.9456176	Fervidobacterium	2422	Bacteria	Bacteria	1005	0	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g21570	i0	98.932	30.9664429530201	562	6	94	0	12	573	304885	305446	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	18456	1005	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
11312416	11312416	PRJNA498309_P_NODE_91949_length_214_cov_2.954802_g89800_i0	PRJNA498309	91949	214	2.954802	6.32327628	Fervidobacterium	2422	Bacteria	Bacteria	121	5.089999999999999e-23	NTclustered	gi\|2793121053\|gb\|CP126498.1\|	44754	g89800	i0	98.529	23.4532710280374	68	1	32	0	147	214	339948	340015	Fervidobacterium gondwanense strain 13770 chromosome, complete genome	blastn	5019	121	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
13862440	13862440	PRJNA498309_P_NODE_33691_length_485_cov_13.502232_g31657_i0	PRJNA498309	33691	485	13.502232	65.4858252	Fervidobacterium	2422	Bacteria	Bacteria	512	1.8e-140	NTclustered	gi\|2793121053\|gb\|CP126498.1\|	44754	g31657	i0	97.659	14.2556701030928	299	6	62	1	6	304	341238	341535	Fervidobacterium gondwanense strain 13770 chromosome, complete genome	blastn	6914	512	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
13862717	13862717	PRJNA498309_P_NODE_63271_length_313_cov_2.126812_g61123_i0	PRJNA498309	63271	313	2.126812	6.65692156	Fervidobacterium	2422	Bacteria	Bacteria	562	1.09e-155	NTclustered	gi\|2793121053\|gb\|CP126498.1\|	44754	g61123	i0	99.042	13.0063897763578	313	3	100	0	1	313	340531	340219	Fervidobacterium gondwanense strain 13770 chromosome, complete genome	blastn	4071	562	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
14510412	14510412	PRJNA498309_P_NODE_95192_length_206_cov_1.585799_g93043_i0	PRJNA498309	95192	206	1.585799	3.26674594	uncultured Thermotogae bacterium	453412	Bacteria	Bacteria	67.6	6.43e-7	NTclustered	gi\|2621705100\|emb\|OY763325.1\|	453412	g93043	i0	83.562	0.742718446601942	73	11	35	1	19	90	73043	73115	MAG: uncultured Thermotogae bacterium isolate fcbefaaa-1511-4f39-b5ed-7dc52d8fa8ec genome assembly, chromosome: 1	blastn	153	67.6	1	Bacteria	Thermotogati	Thermotogota	Thermotogae				uncultured Thermotogae 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);;