metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA326068" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA326068" 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
2344469	2344469	PRJNA326068_P_NODE_19582_length_156_cov_3.007874_g18619_i0	PRJNA326068	19582	156	3.007874	4.69228344	Deinococcus	1298	Bacteria	Bacteria	241	2.5500000000000002e-59	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g18619	i0	99.248	219.423076923077	133	1	88	0	1	133	3061122	3060990	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	34230	241	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
6172082	6172082	PRJNA326068_P_NODE_2385_length_707_cov_8.536873_g1823_i0	PRJNA326068	2385	707	8.536873	60.35569211	Truepera	332248	Bacteria	Bacteria	826	0	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g1823	i0	87.879	224.019801980198	726	59	99	18	7	707	1839	1118	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	158382	826	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
6767064	6767064	PRJNA326068_P_NODE_9686_length_325_cov_2.435811_g8727_i0	PRJNA326068	9686	325	2.435811	7.91638575	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	562	1.14e-155	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g8727	i0	97.846	223.443076923077	325	7	100	0	1	325	1637705	1637381	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	72619	562	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
9997341	9997341	PRJNA326068_P_NODE_6908_length_409_cov_4.876316_g5983_i0	PRJNA326068	6908	409	4.876316	19.94413244	Deinococcus	1298	Bacteria	Bacteria	701	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g5983	i0	97.561	294.657701711491	410	8	100	2	1	409	73118	72710	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	120515	701	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
13822621	13822621	PRJNA326068_P_NODE_14171_length_231_cov_3.440594_g13208_i0	PRJNA326068	14171	231	3.440594	7.94777214	Deinococcus	1298	Bacteria	Bacteria	422	1.37e-113	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g13208	i0	99.567	198.943722943723	231	1	100	0	1	231	1636992	1636762	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	45956	422	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
13822625	13822625	PRJNA326068_P_NODE_1511_length_867_cov_123.867542_g1109_i0	PRJNA326068	1511	867	123.867542	1073.93158914	Truepera	332248	Bacteria	Bacteria	876	0	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g1109	i0	85.446	426.945790080738	852	113	98	10	1	849	846	3	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	370162	876	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
19515281	19515281	PRJNA326068_P_NODE_11536_length_280_cov_11.673307_g10574_i0	PRJNA326068	11536	280	11.673307	32.6852596	Trueperaceae bacterium	2026798	Bacteria	Bacteria	364	2.919999999999999e-96	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g10574	i0	90.288	376.653571428571	278	27	99	0	3	280	3600491	3600768	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	105463	364	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
20790922	20790922	PRJNA326068_P_NODE_19177_length_162_cov_1.932331_g18214_i0	PRJNA326068	19177	162	1.932331	3.13037622	Meiothermus taiwanensis	172827	Bacteria	Bacteria	195	2.12e-45	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g18214	i0	90.132	193.851851851852	152	12	93	3	12	162	259770	259919	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	31404	195	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
21470909	21470909	PRJNA326068_P_NODE_17937_length_181_cov_1320.171053_g16974_i0	PRJNA326068	17937	181	1320.171053	2389.50960593	Deinococcus	1298	Bacteria	Bacteria	324	2.95e-84	NTclustered	gi\|2113031129\|gb\|OK500351.1\|	47478	g16974	i0	99.438	102.292817679558	178	1	98	0	1	178	466	289	Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence	blastn	18515	324	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
24020967	24020967	PRJNA326068_P_NODE_10619_length_301_cov_7.544118_g9658_i0	PRJNA326068	10619	301	7.544118	22.70779518	Truepera	332248	Bacteria	Bacteria	436	6.619999999999998e-118	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g9658	i0	93	892.78073089701	300	20	99	1	1	300	2650	2948	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	268727	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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