metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1118794" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1118794" 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
1505603	1505603	PRJNA1118794_P_NODE_50602_length_250_cov_1.576271_g49852_i0	PRJNA1118794	50602	250	1.576271	3.9406775	Thermus scotoductus	37636	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g49852	i0	99.2	5.96	250	2	100	0	1	250	2244397	2244646	Thermus scotoductus SA-01, complete genome	blastn	1490	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
4853015	4853015	PRJNA1118794_P_NODE_47504_length_253_cov_1.300000_g46754_i0	PRJNA1118794	47504	253	1.3	3.289	Thermus	270	Bacteria	Bacteria	398	2.5599999999999996e-106	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g46754	i0	95.219	24.0632411067194	251	12	99	0	1	251	1131494	1131744	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	6088	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
7402851	7402851	PRJNA1118794_P_NODE_54626_length_249_cov_0.875000_g53876_i0	PRJNA1118794	54626	249	0.875	2.17875	Thermus	270	Bacteria	Bacteria	416	6.939999999999999e-112	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g53876	i0	96.787	43.7630522088353	249	8	100	0	1	249	853475	853227	Thermus scotoductus SA-01, complete genome	blastn	10897	416	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
7883861	7883861	PRJNA1118794_P_NODE_58527_length_247_cov_0.885057_g57777_i0	PRJNA1118794	58527	247	0.885057	2.18609079	Deinococcus proteolyticus	55148	Bacteria	Bacteria	163	9.88e-36	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g57777	i0	78.884	1.01619433198381	251	45	100	7	1	247	1504204	1503958	Deinococcus proteolyticus MRP, complete genome	blastn	251	163	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
9158536	9158536	PRJNA1118794_P_NODE_4348_length_682_cov_2.247947_g3633_i0	PRJNA1118794	4348	682	2.247947	15.33099854	Deinococcus caeni	569127	Bacteria	Bacteria	1230	0	NTclustered	gi\|343198716\|ref\|NR_043473.1\|	569127	g3633	i0	99.267	100.070381231672	682	4	100	1	1	682	689	9	Deinococcus caeni strain Ho-08 16S ribosomal RNA, partial sequence	blastn	68248	1230	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus caeni
11709722	11709722	PRJNA1118794_P_NODE_64370_length_245_cov_0.895349_g63620_i0	PRJNA1118794	64370	245	0.895349	2.19360505	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	337	5.45e-88	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g63620	i0	91.498	396.542857142857	247	17	100	2	1	245	67907	68151	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	97153	337	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
14259622	14259622	PRJNA1118794_P_NODE_3332_length_795_cov_3.040166_g2641_i0	PRJNA1118794	3332	795	3.040166	24.1693197	Deinococcus aquaticus	328692	Bacteria	Bacteria	1267	0	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g2641	i0	95.511	336.908176100629	802	21	100	12	1	795	714647	715440	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	267842	1267	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
14259963	14259963	PRJNA1118794_P_NODE_62192_length_245_cov_1.790698_g61442_i0	PRJNA1118794	62192	245	1.790698	4.3872101	Deinococcus radiophilus	32062	Bacteria	Bacteria	359	1.16e-94	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g61442	i0	93.388	3.95510204081633	242	16	99	0	3	244	600724	600965	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	969	359	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
16808040	16808040	PRJNA1118794_P_NODE_59274_length_247_cov_0.885057_g58524_i0	PRJNA1118794	59274	247	0.885057	2.18609079	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	418	1.9099999999999998e-112	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g58524	i0	97.166	42.4898785425101	247	7	100	0	1	247	2106666	2106420	Thermus sp. NEB1569 chromosome, complete genome	blastn	10495	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
20151424	20151424	PRJNA1118794_P_NODE_48196_length_251_cov_2.146067_g47446_i0	PRJNA1118794	48196	251	2.146067	5.38662817	Deinococcus	1298	Bacteria	Bacteria	457	4.13e-124	NTclustered	gi\|1142915234\|gb\|KX832182.1\|	47478	g47446	i0	99.6	100.298804780876	250	1	99	0	2	251	471	222	Deinococcus sp. strain 311:FR1_AP2_32 16S ribosomal RNA gene, partial sequence	blastn	25175	457	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
23182757	23182757	PRJNA1118794_P_NODE_25079_length_313_cov_1.183333_g24329_i0	PRJNA1118794	25079	313	1.183333	3.70383229	Thermus caldilimi	2483360	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1608424790\|gb\|CP038452.1\|	2483360	g24329	i0	100	0.0894568690095847	28	0	9	0	276	303	1721197	1721224	Thermus caldilimi strain YIM 78456 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus caldilimi

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