metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1245487" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1245487" 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
1625909	1625909	PRJNA1245487_P_NODE_7662_length_444_cov_3.253369_g7325_i0	PRJNA1245487	7662	444	3.253369	14.44495836	Aminobacterium sp. MB27-C1	3070661	Bacteria	Bacteria	353	1.05e-92	NTclustered	gi\|2569590977\|gb\|CP133089.1\|	3070661	g7325	i0	81.375	86.3355855855856	451	68	100	14	1	444	1310364	1309923	Aminobacterium sp. MB27-C1 chromosome, complete genome	blastn	38333	353	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminobacterium	Aminobacterium sp. MB27-C1
4178289	4178289	PRJNA1245487_P_NODE_15904_length_282_cov_1.502392_g15566_i0	PRJNA1245487	15904	282	1.502392	4.23674544	Aminobacterium sp. MB27-C1	3070661	Bacteria	Bacteria	279	1.1e-70	NTclustered	gi\|2569590977\|gb\|CP133089.1\|	3070661	g15566	i0	84.698	94.6205673758865	281	41	99	2	1	281	1311597	1311319	Aminobacterium sp. MB27-C1 chromosome, complete genome	blastn	26683	279	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminobacterium	Aminobacterium sp. MB27-C1
5454475	5454475	PRJNA1245487_P_NODE_11225_length_351_cov_5.226619_g10887_i0	PRJNA1245487	11225	351	5.226619	18.34543269	Synergistales bacterium	2268201	Bacteria	Bacteria	457	6.02e-124	NTclustered	gi\|2621703689\|emb\|OY762654.1\|	2268201	g10887	i0	90.141	186.11396011396	355	29	100	6	1	351	236251	236603	MAG: Synergistales bacterium isolate e2a2af2a-30b9-47e3-8e03-f1be080e1666 genome assembly, chromosome: 1	blastn	65326	457	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium
5454508	5454508	PRJNA1245487_P_NODE_13605_length_311_cov_1.764706_g13267_i0	PRJNA1245487	13605	311	1.764706	5.48823566	Deinococcus aetherius	200252	Bacteria	Bacteria	411	4.159999999999999e-110	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g13267	i0	90.85	27.3022508038585	306	28	98	0	1	306	2708686	2708991	Deinococcus aetherius ST0316 DNA, complete genome	blastn	8491	411	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
6153888	6153888	PRJNA1245487_P_NODE_10365_length_369_cov_2.817568_g10027_i0	PRJNA1245487	10365	369	2.817568	10.39682592	Deinococcus	1298	Bacteria	Bacteria	510	4.81e-140	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g10027	i0	91.622	196.850948509485	370	29	100	2	1	369	1453774	1454142	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	72638	510	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
6154176	6154176	PRJNA1245487_P_NODE_4085_length_621_cov_5.733577_g3757_i0	PRJNA1245487	4085	621	5.733577	35.60551317	Truepera	332248	Bacteria	Bacteria	806	0	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g3757	i0	90.774	108.850241545894	607	50	97	5	1	603	1847	1243	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	67596	806	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
7429273	7429273	PRJNA1245487_P_NODE_22866_length_230_cov_2.019108_g22528_i0	PRJNA1245487	22866	230	2.019108	4.6439484	Deinococcus	1298	Bacteria	Bacteria	372	1.39e-98	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g22528	i0	96.07	197.673913043478	229	7	99	2	1	229	1455464	1455238	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	45465	372	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
9279417	9279417	PRJNA1245487_P_NODE_5128_length_553_cov_5.789583_g4793_i0	PRJNA1245487	5128	553	5.789583	32.01639399	uncultured Deinococcus sp.	158789	Bacteria	Bacteria	1011	0	NTclustered	gi\|164453669\|gb\|EU341276.1\|	158789	g4793	i0	99.638	97.8462929475588	553	2	100	0	1	553	553	1	Uncultured Deinococcus sp. clone AV_8S-D03 16S ribosomal RNA gene, partial sequence	blastn	54109	1011	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
10555278	10555278	PRJNA1245487_P_NODE_5949_length_511_cov_4.328767_g5613_i0	PRJNA1245487	5949	511	4.328767	22.11999937	Trueperaceae bacterium	2026798	Bacteria	Bacteria	723	0	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g5613	i0	93.595	510.317025440313	484	31	95	0	27	510	2559754	2559271	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	260772	723	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
11829783	11829783	PRJNA1245487_P_NODE_23150_length_221_cov_13.574324_g22812_i0	PRJNA1245487	23150	221	13.574324	29.99925604	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	329	8.08e-86	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g22812	i0	93.665	247.176470588235	221	12	100	2	1	221	543365	543147	Deinococcus sp. NW-56 chromosome, complete genome	blastn	54626	329	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
13804818	13804818	PRJNA1245487_P_NODE_22951_length_228_cov_4.283871_g22613_i0	PRJNA1245487	22951	228	4.283871	9.76722588	Deinococcus	1298	Bacteria	Bacteria	355	1.38e-93	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g22613	i0	94.76	202.078947368421	229	10	100	2	1	228	69659	69886	Deinococcus puniceus strain DY1, complete genome	blastn	46074	355	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
13804949	13804949	PRJNA1245487_P_NODE_7011_length_466_cov_8.300254_g6675_i0	PRJNA1245487	7011	466	8.300254	38.67918364	Deinococcus	1298	Bacteria	Bacteria	702	0	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g6675	i0	93.991	345.145922746781	466	24	99	3	3	466	71628	72091	Deinococcus puniceus strain DY1, complete genome	blastn	160838	708	0.991525423728814	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
15654038	15654038	PRJNA1245487_P_NODE_12793_length_324_cov_1.227092_g12455_i0	PRJNA1245487	12793	324	1.227092	3.97577808	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	505	1.9399999999999995e-138	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g12455	i0	94.769	213.407407407407	325	15	100	2	1	324	2417337	2417660	Deinococcus sp. NW-56 chromosome, complete genome	blastn	69144	505	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
20752561	20752561	PRJNA1245487_P_NODE_14777_length_294_cov_11.728507_g14439_i0	PRJNA1245487	14777	294	11.728507	34.48181058	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	394	3.93e-105	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g14439	i0	90.878	184.418367346939	296	23	100	4	1	294	544551	544258	Deinococcus sp. NW-56 chromosome, complete genome	blastn	54219	394	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
25277460	25277460	PRJNA1245487_P_NODE_17980_length_262_cov_2.788360_g17642_i0	PRJNA1245487	17980	262	2.78836	7.3055032	Truepera	332248	Bacteria	Bacteria	440	4.369999999999998e-119	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g17642	i0	96.947	185.885496183206	262	8	100	0	1	262	1863	2124	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	48702	440	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);;