metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1122875" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1122875" 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
277803	277803	PRJNA1122875_P_NODE_42241_length_253_cov_3.222222_g42017_i0	PRJNA1122875	42241	253	3.222222	8.15222166	Deinococcus radiomollis	468916	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2865409981\|gb\|CP129906.1\|	468916	g42017	i0	100	0.110671936758893	28	0	11	0	114	141	2390560	2390533	Deinococcus radiomollis strain PO-04-20-132 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiomollis
1552524	1552524	PRJNA1122875_P_NODE_5542_length_670_cov_2.232831_g5331_i0	PRJNA1122875	5542	670	2.232831	14.9599677	uncultured Deinococcus sp.	158789	Bacteria	Bacteria	1072	0	NTclustered	gi\|389546733\|gb\|JQ401661.1\|	158789	g5331	i0	95.529	106.646268656716	671	29	100	1	1	670	21	691	Uncultured Deinococcus sp. clone CNY_01829 16S ribosomal RNA gene, partial sequence	blastn	71453	1072	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
4104757	4104757	PRJNA1122875_P_NODE_35824_length_277_cov_1.372549_g35600_i0	PRJNA1122875	35824	277	1.372549	3.80196073	Meiothermus taiwanensis	172827	Bacteria	Bacteria	507	4.53e-139	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g35600	i0	99.639	14.072202166065	277	1	100	0	1	277	244900	244624	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	3898	507	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
7930726	7930726	PRJNA1122875_P_NODE_45547_length_249_cov_0.875000_g45323_i0	PRJNA1122875	45547	249	0.875	2.17875	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g45323	i0	100	164.385542168675	249	0	100	0	1	249	543562	543314	Deinococcus sp. NW-56 chromosome, complete genome	blastn	40932	460	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
20155179	20155179	PRJNA1122875_P_NODE_46036_length_248_cov_1.451429_g45812_i0	PRJNA1122875	46036	248	1.451429	3.59954392	Deinococcus	1298	Bacteria	Bacteria	71.3	6.19e-8	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g45812	i0	87.097	1.47177419354839	62	8	25	0	139	200	1213442	1213381	Deinococcus proteolyticus MRP, complete genome	blastn	365	71.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
20679044	20679044	PRJNA1122875_P_NODE_2817_length_867_cov_1.797229_g2649_i0	PRJNA1122875	2817	867	1.797229	15.58197543	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	1351	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g2649	i0	94.828	217.462514417532	870	38	100	6	1	867	3086463	3085598	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	188540	1351	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
24503686	24503686	PRJNA1122875_P_NODE_42500_length_252_cov_3.005587_g42276_i0	PRJNA1122875	42500	252	3.005587	7.57407924	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g42276	i0	100	213.551587301587	252	0	100	0	1	252	544624	544875	Deinococcus sp. NW-56 chromosome, complete genome	blastn	53815	466	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);;