metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA550047" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA550047" and tax_phylum = "Rhodothermota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1794294	1794294	PRJNA550047_P_NODE_80502_length_345_cov_10.639706_g78542_i0	PRJNA550047	80502	345	10.639706	36.7069857	Roseithermus sacchariphilus	2893045	Bacteria	Bacteria	130	1.47e-25	NTclustered	gi\|1417721500\|gb\|CP030158.1\|	2893045	g78542	i0	84.328	2.56811594202899	134	19	39	2	1	133	394589	394457	Roseithermus sacchariphilus strain MEBiC09517 chromosome, complete genome	blastn	886	130	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salisaetaceae	Roseithermus	Roseithermus sacchariphilus
6895796	6895796	PRJNA550047_P_NODE_562546_length_209_cov_15.294118_g560573_i0	PRJNA550047	562546	209	15.294118	31.96470662	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	189	1.3399999999999996e-43	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g560573	i0	91.304	1.89473684210526	138	12	66	0	3	140	1449585	1449722	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	396	189	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
8166311	8166311	PRJNA550047_P_NODE_189587_length_344_cov_10.841328_g187626_i0	PRJNA550047	189587	344	10.841328	37.29416832	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	87.9	8.92e-13	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g187626	i0	92.188	0.372093023255814	64	2	18	3	1	63	2092215	2092276	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	128	87.9	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
10050242	10050242	PRJNA550047_P_NODE_483408_length_236_cov_5.822086_g481435_i0	PRJNA550047	483408	236	5.822086	13.74012296	Salinibacter	146918	Bacteria	Bacteria	122	1.5899999999999995e-23	NTclustered	gi\|147883235\|gb\|EF554306.1\|	146919	g481435	i0	77.103	17.4194915254237	214	47	90	2	24	236	300	512	Salinibacter ruber isolate E7 translation elongation factor Tu (tuf) gene, partial cds	blastn	4111	122	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber
10721669	10721669	PRJNA550047_P_NODE_527569_length_221_cov_8.472973_g525596_i0	PRJNA550047	527569	221	8.472973	18.72527033	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	191	3.98e-44	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g525596	i0	84.737	6.10859728506787	190	29	86	0	32	221	1059008	1058819	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	1350	191	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
10723067	10723067	PRJNA550047_P_NODE_95949_length_345_cov_8.830882_g93989_i0	PRJNA550047	95949	345	8.830882	30.4665429	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	180	1.44e-40	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g93989	i0	89.437	1.71304347826087	142	15	85	0	10	151	4124536	4124395	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	591	180	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
11993847	11993847	PRJNA550047_P_NODE_318170_length_294_cov_22.751131_g316200_i0	PRJNA550047	318170	294	22.751131	66.88832514	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	121	7.37e-23	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g316200	i0	83.333	41.9659863945578	132	20	45	2	164	294	3822112	3822242	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	12338	121	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
13268303	13268303	PRJNA550047_P_NODE_275911_length_299_cov_7.115044_g273942_i0	PRJNA550047	275911	299	7.115044	21.27398156	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	122	2.0899999999999994e-23	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g273942	i0	81.935	0.518394648829431	155	18	50	10	1	150	1639607	1639756	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	155	122	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
14543451	14543451	PRJNA550047_P_NODE_291012_length_298_cov_6.471111_g289043_i0	PRJNA550047	291012	298	6.471111	19.28391078	Salinibacter ruber	146919	Bacteria	Bacteria	165	3.41e-36	NTclustered	gi\|1419235469\|gb\|CP030716.1\|	146919	g289043	i0	87.417	14.8322147651007	151	9	49	9	153	298	919633	919778	Salinibacter ruber strain P13 chromosome, complete genome	blastn	4420	165	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber
17091880	17091880	PRJNA550047_P_NODE_271454_length_299_cov_10.570796_g269485_i0	PRJNA550047	271454	299	10.570796	31.60668004	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	281	3.26e-71	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g269485	i0	83.974	1.04347826086957	312	31	99	8	2	296	212076	212385	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	312	281	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
20916899	20916899	PRJNA550047_P_NODE_304837_length_296_cov_21.147982_g302868_i0	PRJNA550047	304837	296	21.147982	62.59802672	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	135	2.6500000000000004e-27	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g302868	i0	90.385	0.699324324324324	104	8	35	2	8	110	3654935	3654833	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	207	135	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
24072559	24072559	PRJNA550047_P_NODE_245879_length_300_cov_11.603524_g243910_i0	PRJNA550047	245879	300	11.603524	34.810572	Rhodothermales	1853224	Bacteria	Bacteria	182	3.41e-41	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g243910	i0	91.045	42.2733333333333	134	12	45	0	165	298	4352401	4352268	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	12682	182	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
24074190	24074190	PRJNA550047_P_NODE_583919_length_203_cov_4.061538_g581946_i0	PRJNA550047	583919	203	4.061538	8.24492214	Rubrivirga	1434037	Bacteria	Bacteria	239	1.27e-58	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g581946	i0	89.062	82.0147783251231	192	21	95	0	1	192	2792800	2792991	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	16649	241	0.991701244813278	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
24744083	24744083	PRJNA550047_P_NODE_561120_length_210_cov_6.401460_g559147_i0	PRJNA550047	561120	210	6.40146	13.443066	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	71.3	5.09e-8	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g559147	i0	84.722	0.342857142857143	72	9	34	2	16	86	1840777	1840847	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	72	71.3	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium

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