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

14 rows where analysis = "blastn", bioproject = "PRJNA206070" 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
6158392	6158392	PRJNA206070_S_NODE_24725_length_174_cov_6.102190_g22849_i0	PRJNA206070	24725	174	6.10219	10.6178106	root	1	Root_unresolved	Root_unresolved	283	4.769999999999999e-72	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g22849	i0	95.977	132.609195402299	174	7	100	0	1	174	919318	919491	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	23074	283	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
9294713	9294713	PRJNA206070_S_NODE_6388_length_578_cov_23.619224_g2116_i3	PRJNA206070	6388	578	23.619224	136.51911472	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	963	0	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g2116	i3	96.718	336.493079584775	579	17	100	2	1	578	1638267	1637690	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	194493	963	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
9983636	9983636	PRJNA206070_S_NODE_14588_length_271_cov_8.230769_g12712_i0	PRJNA206070	14588	271	8.230769	22.30538399	Deinococcus	1298	Bacteria	Bacteria	468	2.08e-127	NTclustered	gi\|1095429301\|gb\|KY056229.1\|	47478	g12712	i0	99.609	108.822878228782	256	1	94	0	16	271	722	467	Deinococcus sp. strain 6004 16S ribosomal RNA gene, partial sequence	blastn	29491	468	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
10570191	10570191	PRJNA206070_S_NODE_12489_length_312_cov_3.498182_g10613_i0	PRJNA206070	12489	312	3.498182	10.91432784	Thermotoga profunda	1508420	Bacteria	Bacteria	82.4	3.72e-11	NTclustered	gi\|597439398\|dbj\|AP014510.1\|	1408160	g10613	i0	78.261	0.442307692307692	138	22	43	7	126	258	2163812	2163678	Thermotoga profunda AZM34c06 DNA, complete genome	blastn	138	82.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga profunda
10570692	10570692	PRJNA206070_S_NODE_6509_length_568_cov_24.037665_g2116_i4	PRJNA206070	6509	568	24.037665	136.5339372	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	937	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g2116	i4	96.479	363.49823943662	568	18	100	2	1	568	74361	73796	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	206467	937	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
15083225	15083225	PRJNA206070_S_NODE_26232_length_167_cov_2.900000_g24356_i0	PRJNA206070	26232	167	2.9	4.843	Truepera	332248	Bacteria	Bacteria	241	2.79e-59	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g24356	i0	92.771	6.88023952095808	166	12	99	0	1	166	1737	1572	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	1149	241	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
15669086	15669086	PRJNA206070_S_NODE_18833_length_216_cov_2.770950_g16957_i0	PRJNA206070	18833	216	2.77095	5.985252	Trueperaceae bacterium	2026798	Bacteria	Bacteria	222	1.37e-53	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g16957	i0	85.253	80.537037037037	217	31	100	1	1	216	3600037	3599821	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	17396	222	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
16358152	16358152	PRJNA206070_S_NODE_3693_length_1103_cov_23.760788_g2116_i0	PRJNA206070	3693	1103	23.760788	262.08149164	Deinococcus	1298	Bacteria	Bacteria	1666	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g2116	i0	94.128	235.078875793291	1107	46	100	14	1	1103	1792918	1791827	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	259292	1677	0.993440667859273	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
18907137	18907137	PRJNA206070_S_NODE_26755_length_165_cov_2.265625_g24879_i0	PRJNA206070	26755	165	2.265625	3.73828125	Truepera	332248	Bacteria	Bacteria	215	1.66e-51	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g24879	i0	90.741	313.515151515152	162	13	97	1	1	160	1753	1914	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	51730	215	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
20181787	20181787	PRJNA206070_S_NODE_3716_length_1094_cov_24.627247_g2116_i1	PRJNA206070	3716	1094	24.627247	269.42208218	Deinococcus	1298	Bacteria	Bacteria	1836	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g2116	i1	96.986	305.382998171846	1095	29	100	3	1	1094	1791827	1792918	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	334089	1842	0.996742671009772	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
20767583	20767583	PRJNA206070_S_NODE_10337_length_371_cov_9.967066_g8462_i0	PRJNA206070	10337	371	9.967066	36.97781486	Deinococcus ficus	317577	Bacteria	Bacteria	381	3.959999999999999e-101	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g8462	i0	85.333	197.5525606469	375	48	100	7	1	371	2342577	2342948	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	73292	381	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
24007684	24007684	PRJNA206070_S_NODE_30779_length_152_cov_1.904348_g28903_i0	PRJNA206070	30779	152	1.904348	2.89460896	Deinococcus	1298	Bacteria	Bacteria	254	3.17e-63	NTclustered	gi\|2581867323\|gb\|OR600233.1\|	47478	g28903	i0	96.711	97.0789473684211	152	5	100	0	1	152	167	16	Deinococcus sp. strain RM 16S ribosomal RNA gene, partial sequence	blastn	14756	254	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
24007768	24007768	PRJNA206070_S_NODE_8639_length_434_cov_10.032746_g6766_i0	PRJNA206070	8639	434	10.032746	43.54211764	Deinococcus	1298	Bacteria	Bacteria	429	1.66e-115	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g6766	i0	86.582	87.2972350230415	395	45	90	8	37	428	990	1379	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	37887	431	0.995359628770302	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
24007771	24007771	PRJNA206070_S_NODE_8739_length_430_cov_9.636132_g6866_i0	PRJNA206070	8739	430	9.636132	41.4353676	Deinococcus	1298	Bacteria	Bacteria	704	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g6866	i0	96.27	199.090697674419	429	16	99	0	2	430	1793644	1793216	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	85609	704	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis

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