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

11 rows where analysis = "blastn", bioproject = "PRJNA399133" 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
413225	413225	PRJNA399133_P_NODE_6481_length_206_cov_2.222222_g6393_i0	PRJNA399133	6481	206	2.222222	4.57777732	Allomeiothermus silvanus	52022	Bacteria	Bacteria	217	6.029999999999999e-52	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g6393	i0	99.167	1.60194174757282	120	1	100	0	87	206	5859	5978	Meiothermus silvanus DSM 9946, complete genome	blastn	330	217	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
413267	413267	PRJNA399133_P_NODE_8421_length_181_cov_1.095890_g8333_i0	PRJNA399133	8421	181	1.09589	1.9835609	Allomeiothermus silvanus	52022	Bacteria	Bacteria	324	2.95e-84	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g8333	i0	98.895	1	181	2	100	0	1	181	3079002	3079182	Meiothermus silvanus DSM 9946, complete genome	blastn	181	324	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
2963935	2963935	PRJNA399133_P_NODE_11003_length_159_cov_1.870968_g10915_i0	PRJNA399133	11003	159	1.870968	2.97483912	uncultured Deinococcales bacterium	310703	Bacteria	Bacteria	276	7.18e-70	NTclustered	gi\|297362341\|gb\|HM092217.1\|	310703	g10915	i0	98.113	106.616352201258	159	2	100	1	1	159	22	179	Uncultured Deinococcales bacterium clone NR128A269 16S ribosomal RNA gene, partial sequence	blastn	16952	276	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales			uncultured Deinococcales bacterium
2964028	2964028	PRJNA399133_P_NODE_4943_length_229_cov_2.278351_g4855_i0	PRJNA399133	4943	229	2.278351	5.21742379	Allomeiothermus silvanus	52022	Bacteria	Bacteria	134	7.090000000000001e-27	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g4855	i0	98.667	1.31004366812227	75	1	66	0	155	229	3204190	3204116	Meiothermus silvanus DSM 9946, complete genome	blastn	300	134	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
9341408	9341408	PRJNA399133_P_NODE_4308_length_244_cov_1.430622_g4220_i0	PRJNA399133	4308	244	1.430622	3.49071768	Deinococcus irradiatisoli	2202254	Bacteria	Bacteria	313	9.139999999999999e-81	NTclustered	gi\|1392964945\|gb\|CP029494.1\|	2202254	g4220	i0	90.041	202.967213114754	241	24	100	0	4	244	397501	397261	Deinococcus irradiatisoli strain 17bor-2 chromosome, complete genome	blastn	49524	313	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus irradiatisoli
10617148	10617148	PRJNA399133_P_NODE_3769_length_260_cov_1.880000_g3681_i0	PRJNA399133	3769	260	1.88	4.888	Allomeiothermus silvanus	52022	Bacteria	Bacteria	145	3.8e-30	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g3681	i0	92.157	27.0269230769231	102	8	72	0	159	260	522681	522580	Meiothermus silvanus DSM 9946, complete genome	blastn	7027	145	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
10617165	10617165	PRJNA399133_P_NODE_4549_length_238_cov_2.216749_g4461_i0	PRJNA399133	4549	238	2.216749	5.27586262	Allomeiothermus silvanus	52022	Bacteria	Bacteria	161	3.3999999999999997e-35	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g4461	i0	100	0.705882352941177	87	0	71	0	152	238	1048806	1048720	Meiothermus silvanus DSM 9946, complete genome	blastn	168	161	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
12559578	12559578	PRJNA399133_P_NODE_7470_length_192_cov_1.783439_g7382_i0	PRJNA399133	7470	192	1.783439	3.42420288	Deinococcus	1298	Bacteria	Bacteria	239	1.18e-58	NTclustered	gi\|470487735\|ref\|NR_076834.1\|	309887	g7382	i0	89.062	139.651041666667	192	21	100	0	1	192	1228	1419	Deinococcus maricopensis strain LB-34 23S ribosomal RNA gene, complete sequence	blastn	26813	239	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis
13166938	13166938	PRJNA399133_P_NODE_10431_length_163_cov_1.875000_g10343_i0	PRJNA399133	10431	163	1.875	3.05625	Allomeiothermus silvanus	52022	Bacteria	Bacteria	263	5.77e-66	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g10343	i0	98.013	0.926380368098159	151	3	93	0	1	151	1382283	1382133	Meiothermus silvanus DSM 9946, complete genome	blastn	151	263	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
22089726	22089726	PRJNA399133_P_NODE_4038_length_251_cov_1.972222_g3950_i0	PRJNA399133	4038	251	1.972222	4.95027722	Allomeiothermus silvanus	52022	Bacteria	Bacteria	191	4.62e-44	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g3950	i0	97.321	0.848605577689243	112	3	85	0	1	112	3246108	3246219	Meiothermus silvanus DSM 9946, complete genome	blastn	213	191	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
24032655	24032655	PRJNA399133_P_NODE_6399_length_207_cov_2.982558_g6311_i0	PRJNA399133	6399	207	2.982558	6.17389506	Bacteria	2	Bacteria	Bacteria	237	4.66e-58	NTclustered	gi\|2866351997\|gb\|PQ721879.1\|	47478	g6311	i0	100	70.9661835748792	128	0	100	0	80	207	626	499	Deinococcus sp. strain L174 16S ribosomal RNA gene, partial sequence	blastn	14690	237	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.

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