metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA572587" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA572587" 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
559236	559236	PRJNA572587_P_NODE_8141_length_424_cov_114.528000_g7816_i0	PRJNA572587	8141	424	114.528	485.59872	Fervidobacterium pennivorans	93466	Bacteria	Bacteria	688	0	NTclustered	gi\|2793129014\|gb\|CP126982.1\|	3389975	g7816	i0	97.75	26.6179245283019	400	8	94	1	24	422	735391	734992	Fervidobacterium pennivorans subsp. shakshaketiis strain GSH chromosome, complete genome	blastn	11286	688	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
1135975	1135975	PRJNA572587_P_NODE_27621_length_212_cov_12.582822_g27293_i0	PRJNA572587	27621	212	12.582822	26.67558264	Bacteria	2	Bacteria	Bacteria	281	2.18e-71	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g27293	i0	96.471	8.30188679245283	170	6	80	0	27	196	520853	521022	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	1760	281	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
1834233	1834233	PRJNA572587_P_NODE_22042_length_240_cov_28.465969_g21714_i0	PRJNA572587	22042	240	28.465969	68.3183256	Fervidobacterium islandicum	2423	Bacteria	Bacteria	381	2.4199999999999996e-101	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g21714	i0	98.174	13.4208333333333	219	2	90	2	24	240	307922	307704	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	3221	381	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
1834320	1834320	PRJNA572587_P_NODE_27182_length_214_cov_9.715152_g26854_i0	PRJNA572587	27182	214	9.715152	20.79042528	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	357	3.5699999999999996e-94	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g26854	i0	100	0.901869158878505	193	0	90	0	1	193	286123	286315	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	193	357	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
2411319	2411319	PRJNA572587_P_NODE_15202_length_295_cov_17.743902_g14874_i0	PRJNA572587	15202	295	17.743902	52.3445109	Bacteria	2	Bacteria	Bacteria	481	2.95e-131	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g14874	i0	98.529	27.8271186440678	272	4	92	0	1	272	289409	289138	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	8209	481	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
9487050	9487050	PRJNA572587_P_NODE_13508_length_315_cov_8.439850_g13180_i0	PRJNA572587	13508	315	8.43985	26.5855275	Kosmotoga olearia	651457	Bacteria	Bacteria	110	1.73e-19	NTclustered	gi\|239505242\|gb\|CP001634.1\|	521045	g13180	i0	83.333	0.768253968253968	120	18	38	2	71	189	647767	647885	Kosmotoga olearia TBF 19.5.1, complete genome	blastn	242	110	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Kosmotoga	Kosmotoga olearia
11339091	11339091	PRJNA572587_P_NODE_1089_length_1162_cov_27.011680_g989_i0	PRJNA572587	1089	1162	27.01168	313.8757216	Bacteria	2	Bacteria	Bacteria	2032	0	NTclustered	gi\|2793121053\|gb\|CP126498.1\|	44754	g989	i0	98.691	30.8476764199656	1146	13	99	2	6	1151	103856	102713	Fervidobacterium gondwanense strain 13770 chromosome, complete genome	blastn	35845	2032	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
14587534	14587534	PRJNA572587_P_NODE_16872_length_278_cov_9.764192_g16544_i0	PRJNA572587	16872	278	9.764192	27.14445376	Fervidobacterium gondwanense	44754	Bacteria	Bacteria	442	1.2999999999999995e-119	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g16544	i0	97.308	15.8992805755396	260	7	94	0	19	278	522075	521816	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	4420	442	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
21537967	21537967	PRJNA572587_P_NODE_43317_length_166_cov_3.521368_g42989_i0	PRJNA572587	43317	166	3.521368	5.84547088	Bacteria	2	Bacteria	Bacteria	289	9.729999999999999e-74	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g42989	i0	100	12.1626506024096	156	0	94	0	1	156	308267	308112	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	2019	289	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
22813224	22813224	PRJNA572587_P_NODE_36818_length_181_cov_10.477273_g36490_i0	PRJNA572587	36818	181	10.477273	18.96386413	Bacteria	2	Bacteria	Bacteria	281	1.8e-71	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g36490	i0	100	25.6298342541436	152	0	84	0	30	181	289530	289379	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	4639	281	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
24087875	24087875	PRJNA572587_P_NODE_18859_length_262_cov_3.342723_g18531_i0	PRJNA572587	18859	262	3.342723	8.75793426	Bacteria	2	Bacteria	Bacteria	449	7.26e-122	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g18531	i0	98.438	29.324427480916	256	3	97	1	8	262	289144	289399	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	7683	449	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum

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