metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA393181" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA393181" and tax_kingdom = "Thermotogati"

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
410980	410980	PRJNA393181_S_NODE_7181_length_443_cov_2.312808_g7075_i0	PRJNA393181	7181	443	2.312808	10.24573944	Pseudothermotoga hypogea	57487	Bacteria	Bacteria	60.2	2.56e-4	NTclustered	gi\|744795267\|gb\|CP007141.1\|	1123384	g7075	i0	100	1.00677200902935	32	0	7	0	412	443	1961313	1961344	Pseudothermotoga hypogea DSM 11164 = NBRC 106472 chromosome, complete genome	blastn	446	60.2	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Pseudothermotoga	Pseudothermotoga hypogea
8063517	8063517	PRJNA393181_S_NODE_19507_length_267_cov_2.543478_g19401_i0	PRJNA393181	19507	267	2.543478	6.79108626	Trueperaceae bacterium	2026798	Bacteria	Bacteria	134	8.480000000000001e-27	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g19401	i0	78.404	0.797752808988764	213	40	79	6	5	214	2655718	2655509	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	213	134	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
9339146	9339146	PRJNA393181_S_NODE_7588_length_432_cov_2.916456_g7482_i0	PRJNA393181	7588	432	2.916456	12.59908992	Deinococcus yunweiensis	367282	Bacteria	Bacteria	183	1.42e-41	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g7482	i0	79.245	0.613425925925926	265	53	61	2	23	286	3247467	3247730	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	265	183	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
10006663	10006663	PRJNA393181_S_NODE_37068_length_178_cov_1.900709_g36962_i0	PRJNA393181	37068	178	1.900709	3.38326202	Deinococcus	1298	Bacteria	Bacteria	113	6.81e-21	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g36962	i0	85.714	57.9943820224719	112	11	61	4	2	110	1311129	1311238	Deinococcus swuensis strain DY59, complete genome	blastn	10323	113	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
24637139	24637139	PRJNA393181_S_NODE_4000_length_556_cov_2.416185_g3241_i1	PRJNA393181	4000	556	2.416185	13.4339886	Oceanithermus profundus	187137	Bacteria	Bacteria	388	3.67e-103	NTclustered	gi\|313151615\|gb\|CP002361.1\|	670487	g3241	i1	81	96.9370503597122	500	85	89	9	46	540	746568	746074	Oceanithermus profundus DSM 14977, complete genome	blastn	53897	388	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Oceanithermus	Oceanithermus profundus

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