metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA674048" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA674048" 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
643087	643087	PRJNA674048_P_NODE_31521_length_163_cov_1.473684_g31318_i0	PRJNA674048	31521	163	1.473684	2.40210492	Allomeiothermus silvanus	52022	Bacteria	Bacteria	257	2.68e-64	NTclustered	gi\|296852006\|gb\|CP002043.1\|	526227	g31318	i0	95.092	2.17177914110429	163	8	100	0	1	163	35797	35959	Meiothermus silvanus DSM 9946 plasmid pMESIL01, complete sequence	blastn	354	257	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
1165838	1165838	PRJNA674048_P_NODE_13101_length_251_cov_2.232673_g12898_i0	PRJNA674048	13101	251	2.232673	5.60400923	Deinococcus	1298	Bacteria	Bacteria	350	7.2e-92	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g12898	i0	94.69	193.06374501992	226	10	90	2	26	251	1530423	1530200	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	48459	350	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
7543776	7543776	PRJNA674048_P_NODE_15346_length_228_cov_1.905028_g15143_i0	PRJNA674048	15346	228	1.905028	4.34346384	Deinococcus	1298	Bacteria	Bacteria	405	1.35e-108	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g15143	i0	98.684	15.3859649122807	228	3	100	0	1	228	426521	426748	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	3508	409	0.990220048899755	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
8296476	8296476	PRJNA674048_P_NODE_31667_length_163_cov_0.912281_g31464_i0	PRJNA674048	31667	163	0.912281	1.48701803	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g31464	i0	100	19.0184049079755	163	0	100	0	1	163	2379032	2378870	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	3100	302	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
11369733	11369733	PRJNA674048_P_NODE_6149_length_409_cov_2.891667_g5946_i0	PRJNA674048	6149	409	2.891667	11.82691803	Deinococcus	1298	Bacteria	Bacteria	734	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g5946	i0	99.022	100.672371638142	409	4	100	0	1	409	122156	121748	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	41175	734	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
12122491	12122491	PRJNA674048_P_NODE_690_length_1344_cov_8.878764_g211_i1	PRJNA674048	690	1344	8.878764	119.33058816	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	2182	0	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g211	i1	96.068	260.844494047619	1348	38	100	12	1	1344	1638476	1637140	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	350575	2182	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
12645267	12645267	PRJNA674048_P_NODE_21630_length_189_cov_1.792857_g21427_i0	PRJNA674048	21630	189	1.792857	3.38849973	Deinococcus	1298	Bacteria	Bacteria	327	2.41e-85	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g21427	i0	97.895	154.78835978836	190	2	100	2	1	189	1792024	1792212	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	29255	327	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
13397193	13397193	PRJNA674048_P_NODE_21491_length_190_cov_1.106383_g21288_i0	PRJNA674048	21491	190	1.106383	2.1021277	Allomeiothermus silvanus	52022	Bacteria	Bacteria	344	2.3999999999999993e-90	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g21288	i0	99.471	0.994736842105263	189	1	99	0	2	190	478285	478097	Meiothermus silvanus DSM 9946, complete genome	blastn	189	344	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
13397285	13397285	PRJNA674048_P_NODE_34191_length_152_cov_2.019417_g33988_i0	PRJNA674048	34191	152	2.019417	3.06951384	Allomeiothermus silvanus	52022	Bacteria	Bacteria	261	1.9e-65	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g33988	i0	98.649	0.973684210526316	148	1	97	1	2	149	2753646	2753792	Meiothermus silvanus DSM 9946, complete genome	blastn	148	261	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
14672212	14672212	PRJNA674048_P_NODE_32132_length_163_cov_0.912281_g31929_i0	PRJNA674048	32132	163	0.912281	1.48701803	Allomeiothermus silvanus	52022	Bacteria	Bacteria	263	5.77e-66	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g31929	i0	95.706	1	163	7	100	0	1	163	1056493	1056331	Meiothermus silvanus DSM 9946, complete genome	blastn	163	263	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
17221176	17221176	PRJNA674048_P_NODE_27794_length_168_cov_0.873950_g27591_i0	PRJNA674048	27794	168	0.87395	1.468236	Allomeiothermus silvanus	52022	Bacteria	Bacteria	281	1.65e-71	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g27591	i0	97.024	1	168	4	100	1	1	168	1727772	1727938	Meiothermus silvanus DSM 9946, complete genome	blastn	168	281	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
17221204	17221204	PRJNA674048_P_NODE_30394_length_165_cov_0.896552_g30191_i0	PRJNA674048	30394	165	0.896552	1.4793108	Thermus antranikianii	88190	Bacteria	Bacteria	250	4.5599999999999996e-62	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g30191	i0	93.939	1	165	10	100	0	1	165	2398226	2398390	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	165	250	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
24869350	24869350	PRJNA674048_P_NODE_29860_length_165_cov_1.793103_g29657_i0	PRJNA674048	29860	165	1.793103	2.95861995	Allomeiothermus silvanus	52022	Bacteria	Bacteria	294	2.08e-75	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g29657	i0	98.788	1	165	2	100	0	1	165	2340108	2339944	Meiothermus silvanus DSM 9946, complete genome	blastn	165	294	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus

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