metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA874604" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA874604" 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
2128184	2128184	PRJNA874604_P_NODE_91362_length_244_cov_0.900585_g91010_i0	PRJNA874604	91362	244	0.900585	2.1974274	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	252	2.02e-62	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g91010	i0	85.537	19.3770491803279	242	33	99	2	2	242	2219666	2219906	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	4728	252	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
4680869	4680869	PRJNA874604_P_NODE_75424_length_249_cov_0.875000_g75072_i0	PRJNA874604	75424	249	0.875	2.17875	Deinococcus aetherius	200252	Bacteria	Bacteria	209	1.26e-49	NTclustered	gi\|2281898193\|dbj\|AP026561.1\|	200252	g75072	i0	84.689	0.839357429718876	209	32	84	0	31	239	398109	397901	Deinococcus aetherius ST0316 plasmid pDAETH-1 DNA, complete genome	blastn	209	209	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
7230770	7230770	PRJNA874604_P_NODE_77946_length_248_cov_0.880000_g77594_i0	PRJNA874604	77946	248	0.88	2.1824	Deinococcus grandis	57498	Bacteria	Bacteria	414	2.48e-111	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g77594	i0	96.774	55.1733870967742	248	8	100	0	1	248	289439	289192	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	13683	414	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
8505273	8505273	PRJNA874604_P_NODE_66627_length_254_cov_1.519337_g66275_i0	PRJNA874604	66627	254	1.519337	3.85911598	Deinococcus aetherius	200252	Bacteria	Bacteria	315	2.66e-81	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g66275	i0	89.243	7.56692913385827	251	27	99	0	2	252	1989845	1989595	Deinococcus aetherius ST0316 DNA, complete genome	blastn	1922	315	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
9780236	9780236	PRJNA874604_P_NODE_68488_length_251_cov_1.382022_g68136_i0	PRJNA874604	68488	251	1.382022	3.46887522	Thermus thermophilus	274	Bacteria	Bacteria	436	5.369999999999999e-118	NTclustered	gi\|2701837056\|dbj\|AP031332.1\|	274	g68136	i0	98.008	65.5737051792829	251	5	100	0	1	251	85272	85522	Thermus thermophilus TF27 DNA, complete genome	blastn	16459	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
11055644	11055644	PRJNA874604_P_NODE_44749_length_296_cov_0.959641_g44397_i0	PRJNA874604	44749	296	0.959641	2.84053736	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	405	1.83e-108	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g44397	i0	95.038	186.72972972973	262	5	87	8	1	258	1886014	1886271	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	55272	405	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
12330394	12330394	PRJNA874604_P_NODE_101330_length_234_cov_2.440994_g100978_i0	PRJNA874604	101330	234	2.440994	5.71192596	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	422	1.39e-113	NTclustered	gi\|1819263661\|gb\|CP049358.1\|	1288484	g100978	i0	99.145	8.55982905982906	234	2	100	0	1	234	173541	173774	Deinococcus wulumuqiensis R12 plasmid unnamed1, complete sequence	blastn	2003	422	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
14880503	14880503	PRJNA874604_P_NODE_74832_length_249_cov_0.875000_g74480_i0	PRJNA874604	74832	249	0.875	2.17875	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	195	3.5399999999999996e-45	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g74480	i0	81.008	2.39357429718876	258	37	100	7	1	249	550151	550405	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	596	195	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
17430263	17430263	PRJNA874604_P_NODE_53114_length_278_cov_1.502439_g52762_i0	PRJNA874604	53114	278	1.502439	4.17678042	Deinococcus metallilatus	1211322	Bacteria	Bacteria	254	6.54e-63	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g52762	i0	87.387	5.63669064748201	222	26	79	2	57	277	2429657	2429437	Deinococcus metallilatus strain MA1002 chromosome	blastn	1567	254	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
17430832	17430832	PRJNA874604_P_NODE_81894_length_247_cov_0.885057_g81542_i0	PRJNA874604	81894	247	0.885057	2.18609079	Cloacibacillus porcorum	1197717	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1050315908\|gb\|CP016757.1\|	1197717	g81542	i0	100	1	247	0	100	0	1	247	1094983	1095229	Cloacibacillus porcorum strain CL-84 chromosome, complete genome	blastn	247	457	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Cloacibacillus	Cloacibacillus porcorum
19089191	19089191	PRJNA874604_P_NODE_14735_length_457_cov_1.734375_g14383_i0	PRJNA874604	14735	457	1.734375	7.92609375	Deinococcus	1298	Bacteria	Bacteria	634	3.4599999999999992e-177	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g14383	i0	91.868	271.781181619256	455	35	99	2	3	457	1455235	1454783	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	124204	634	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
19979530	19979530	PRJNA874604_P_NODE_91676_length_244_cov_0.900585_g91324_i0	PRJNA874604	91676	244	0.900585	2.1974274	Deinococcus aquaticus	328692	Bacteria	Bacteria	374	4.1399999999999986e-99	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g91324	i0	94.262	1	244	14	100	0	1	244	242255	242498	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	244	374	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
22529604	22529604	PRJNA874604_P_NODE_92898_length_243_cov_0.905882_g92546_i0	PRJNA874604	92898	243	0.905882	2.20129326	Deinococcus irradiatisoli	2202254	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1392964945\|gb\|CP029494.1\|	2202254	g92546	i0	100	0.123456790123457	30	0	12	0	23	52	933349	933320	Deinococcus irradiatisoli strain 17bor-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus irradiatisoli
24189529	24189529	PRJNA874604_P_NODE_48639_length_287_cov_1.102804_g48287_i0	PRJNA874604	48639	287	1.102804	3.16504748	Deinococcus	1298	Bacteria	Bacteria	464	2.8799999999999993e-126	NTclustered	gi\|2706840606\|gb\|CP149783.1\|	3112952	g48287	i0	96.127	1.97909407665505	284	11	99	0	4	287	65520	65237	Deinococcus sp. VB142 chromosome 2, complete sequence	blastn	568	464	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
24189610	24189610	PRJNA874604_P_NODE_57359_length_271_cov_1.025253_g57007_i0	PRJNA874604	57359	271	1.025253	2.77843563	Deinococcus	1298	Bacteria	Bacteria	440	4.539999999999998e-119	NTclustered	gi\|545344372\|gb\|KF507604.1\|	158789	g57007	i0	95.956	105.033210332103	272	10	100	1	1	271	472	201	Uncultured Deinococcus sp. clone 7270 16S ribosomal RNA gene, partial sequence	blastn	28464	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
25078583	25078583	PRJNA874604_P_NODE_75040_length_249_cov_0.875000_g74688_i0	PRJNA874604	75040	249	0.875	2.17875	Deinococcus grandis	57498	Bacteria	Bacteria	195	3.5399999999999996e-45	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g74688	i0	81.25	23.6787148594378	240	45	96	0	1	240	110012	109773	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	5896	195	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis

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