metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA986481" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA986481" 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
1272156	1272156	PRJNA986481_P_NODE_45981_length_257_cov_0.971154_g45456_i0	PRJNA986481	45981	257	0.971154	2.49586578	Thermus	270	Bacteria	Bacteria	453	5.480000000000001e-123	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g45456	i0	98.444	28.1439688715953	257	4	100	0	1	257	1862074	1862330	Thermus scotoductus SA-01, complete genome	blastn	7233	453	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
3524423	3524423	PRJNA986481_P_NODE_53663_length_248_cov_1.015075_g53138_i0	PRJNA986481	53663	248	1.015075	2.517386	Deinococcus geothermalis	68909	Bacteria	Bacteria	337	5.53e-88	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g53138	i0	91.129	64.1048387096774	248	22	100	0	1	248	827822	827575	Deinococcus geothermalis DSM 11300, complete genome	blastn	15898	337	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
7351665	7351665	PRJNA986481_P_NODE_55666_length_246_cov_1.025381_g55141_i0	PRJNA986481	55666	246	1.025381	2.52243726	Deinococcus sonorensis	309891	Bacteria	Bacteria	287	5.599999999999999e-73	NTclustered	gi\|2745307249\|gb\|CP158299.1\|	694439	g55141	i0	87.854	190.479674796748	247	26	100	4	1	246	337743	337986	Deinococcus sonorensis KR-87 chromosome, complete genome	blastn	46858	287	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sonorensis
7650039	7650039	PRJNA986481_P_NODE_1086_length_1261_cov_17.301980_g337_i1	PRJNA986481	1086	1261	17.30198	218.1779678	Deinococcus	1298	Bacteria	Bacteria	1786	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g337	i1	92.508	202.41712926249	1268	64	99	26	3	1261	2416715	2417960	Deinococcus sp. NW-56 chromosome, complete genome	blastn	255248	1786	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
10200732	10200732	PRJNA986481_P_NODE_428_length_1655_cov_31.421544_g337_i0	PRJNA986481	428	1655	31.421544	520.0265532	Deinococcus	1298	Bacteria	Bacteria	2202	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g337	i0	91.254	211.410271903323	1635	116	98	27	21	1641	2418506	2416885	Deinococcus sp. NW-56 chromosome, complete genome	blastn	349884	2209	0.996831145314622	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
14026047	14026047	PRJNA986481_P_NODE_51851_length_250_cov_1.004975_g51326_i0	PRJNA986481	51851	250	1.004975	2.5124375	Thermus	270	Bacteria	Bacteria	403	5.43e-108	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g51326	i0	95.968	46.688	248	10	99	0	3	250	380165	380412	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	11672	403	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
18825734	18825734	PRJNA986481_P_NODE_60455_length_241_cov_1.052083_g59930_i0	PRJNA986481	60455	241	1.052083	2.53552003	Deinococcus ficus	317577	Bacteria	Bacteria	433	6.63e-117	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g59930	i0	99.167	2.02904564315353	240	2	99	0	1	240	2017915	2018154	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	489	433	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
25199961	25199961	PRJNA986481_P_NODE_47500_length_255_cov_0.980583_g46975_i0	PRJNA986481	47500	255	0.980583	2.50048665	Deinococcus ficus	317577	Bacteria	Bacteria	438	1.52e-118	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g46975	i0	97.647	97.2352941176471	255	6	100	0	1	255	1710129	1709875	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	24795	438	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus

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