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

5 rows where analysis = "blastn", bioproject = "PRJNA793147" 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
3767631	3767631	PRJNA793147_P_NODE_36343_length_279_cov_1.333333_g36077_i0	PRJNA793147	36343	279	1.333333	3.71999907	Bacteria	2	Bacteria	Bacteria	470	5.99e-128	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g36077	i0	99.231	63.1290322580645	260	2	93	0	1	260	385	126	Thermus aquaticus DNA polymerase (PolI) gene	blastn	17613	470	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
8869208	8869208	PRJNA793147_P_NODE_59687_length_228_cov_0.905660_g59421_i0	PRJNA793147	59687	228	0.90566	2.0649048	Deinococcus	1298	Bacteria	Bacteria	368	1.78e-97	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g59421	i0	96.035	185.706140350877	227	7	99	2	1	226	1274	1499	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	42341	368	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
9706179	9706179	PRJNA793147_P_NODE_4468_length_878_cov_2.918418_g4257_i0	PRJNA793147	4468	878	2.918418	25.62371004	Thermus aquaticus	271	Bacteria	Bacteria	1622	0	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g4257	i0	100	78.126423690205	878	0	100	0	1	878	2334	1457	Thermus aquaticus DNA polymerase (PolI) gene	blastn	68595	1622	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
12257475	12257475	PRJNA793147_P_NODE_42550_length_258_cov_2.243386_g42284_i0	PRJNA793147	42550	258	2.243386	5.78793588	Thermus aquaticus	271	Bacteria	Bacteria	429	9.29e-116	NTclustered	gi\|507890\|dbj\|D32013.1\|TTHDNAP	271	g42284	i0	99.163	4.60077519379845	239	0	92	2	21	258	2774	2537	Thermus aquaticus gene for DNA polymerase, complete cds	blastn	1187	429	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
23731115	23731115	PRJNA793147_P_NODE_59639_length_228_cov_0.905660_g59373_i0	PRJNA793147	59639	228	0.90566	2.0649048	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	390	3.7899999999999996e-104	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g59373	i0	97.391	198.140350877193	230	4	100	1	1	228	543708	543479	Deinococcus sp. NW-56 chromosome, complete genome	blastn	45176	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56

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