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

11 rows where analysis = "blastn", bioproject = "PRJNA728642" 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
2470272	2470272	PRJNA728642_P_NODE_16502_length_249_cov_0.875000_g16231_i0	PRJNA728642	16502	249	0.875	2.17875	Deinococcus	1298	Bacteria	Bacteria	366	7.09e-97	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g16231	i0	94.167	189.449799196787	240	14	96	0	3	242	543720	543481	Deinococcus sp. NW-56 chromosome, complete genome	blastn	47173	368	0.994565217391304	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
3264115	3264115	PRJNA728642_P_NODE_16443_length_249_cov_1.443182_g16172_i0	PRJNA728642	16443	249	1.443182	3.59352318	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	444	3.18e-120	NTclustered	gi\|1868561018\|gb\|CP058534.1\|	2755035	g16172	i0	98.795	2	249	3	100	0	1	249	1349300	1349548	Deinococcus sp. D7000 chromosome, complete genome	blastn	498	444	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
4541221	4541221	PRJNA728642_P_NODE_17524_length_246_cov_1.433526_g17253_i0	PRJNA728642	17524	246	1.433526	3.52647396	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	385	1.93e-102	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g17253	i0	94.779	215.613821138211	249	9	100	3	1	246	544620	544867	Deinococcus sp. NW-56 chromosome, complete genome	blastn	53041	385	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
6299160	6299160	PRJNA728642_P_NODE_6765_length_394_cov_1.165109_g6494_i0	PRJNA728642	6765	394	1.165109	4.59052946	Deinococcus	1298	Bacteria	Bacteria	617	2.96e-172	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g6494	i0	94.937	184.187817258883	395	18	100	2	1	394	69513	69120	Deinococcus swuensis strain DY59, complete genome	blastn	72570	617	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
8847903	8847903	PRJNA728642_P_NODE_12067_length_290_cov_1.331797_g11796_i0	PRJNA728642	12067	290	1.331797	3.8622113	Truepera	332248	Bacteria	Bacteria	224	5.38e-54	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g11796	i0	80.756	120.61724137931	291	52	99	4	1	289	1586104	1585816	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	34979	224	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
8848049	8848049	PRJNA728642_P_NODE_2567_length_649_cov_1.977431_g2303_i0	PRJNA728642	2567	649	1.977431	12.83352719	Deinococcus	1298	Bacteria	Bacteria	1103	0	NTclustered	gi\|369724608\|gb\|JN792321.1\|	158789	g2303	i0	97.377	105.842835130971	648	17	99	0	1	648	864	217	Uncultured Deinococcus sp. clone PLYFP55 16S ribosomal RNA gene, partial sequence	blastn	68692	1109	0.994589720468891	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
9641409	9641409	PRJNA728642_P_NODE_19268_length_242_cov_0.911243_g18997_i0	PRJNA728642	19268	242	0.911243	2.20520806	Allomeiothermus silvanus	52022	Bacteria	Bacteria	431	2.4e-116	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g18997	i0	98.76	1	242	3	100	0	1	242	2985668	2985427	Meiothermus silvanus DSM 9946, complete genome	blastn	242	431	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
10123610	10123610	PRJNA728642_P_NODE_4768_length_473_cov_2.017500_g4497_i0	PRJNA728642	4768	473	2.0175	9.542775	Deinococcus	1298	Bacteria	Bacteria	747	0	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g4497	i0	95.148	398.513742071882	474	21	100	2	1	473	1461	989	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	188497	747	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
13466559	13466559	PRJNA728642_P_NODE_17111_length_247_cov_3.045977_g16840_i0	PRJNA728642	17111	247	3.045977	7.52356319	Deinococcus gobiensis	502394	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g16840	i0	99.595	298.040485829959	247	1	100	0	1	247	112111	111865	Deinococcus gobiensis I-0, complete genome	blastn	73616	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
23665937	23665937	PRJNA728642_P_NODE_3279_length_577_cov_4.857143_g3010_i0	PRJNA728642	3279	577	4.857143	28.02571511	uncultured Truepera sp.	543023	Bacteria	Bacteria	959	0	NTclustered	gi\|389547087\|gb\|JQ402015.1\|	543023	g3010	i0	99.432	89.7209705372617	528	3	92	0	1	528	528	1	Uncultured Truepera sp. clone CNY_02272 16S ribosomal RNA gene, partial sequence	blastn	51769	959	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
24146697	24146697	PRJNA728642_P_NODE_7459_length_374_cov_2.564784_g7188_i0	PRJNA728642	7459	374	2.564784	9.59229216	Deinococcus	1298	Bacteria	Bacteria	568	2.8599999999999993e-157	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g7188	i0	94.149	194.772727272727	376	16	100	4	1	374	584	955	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	72845	568	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis

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