metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA1093380" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA1093380" and tax_phylum = "Deinococcota"

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
199203	199203	PRJNA1093380_P_NODE_6481_length_282_cov_1.956938_g6375_i0	PRJNA1093380	6481	282	1.956938	5.51856516	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	483	7.78e-132	NTclustered	gi\|1868564315\|gb\|CP058535.1\|	2755035	g6375	i0	97.518	1	282	7	100	0	1	282	198342	198061	Deinococcus sp. D7000 plasmid p_1, complete sequence	blastn	282	483	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
199248	199248	PRJNA1093380_P_NODE_9341_length_266_cov_1.347150_g9235_i0	PRJNA1093380	9341	266	1.34715	3.583419	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	315	2.81e-81	NTclustered	gi\|1761809506\|gb\|CP044989.1\|	2652443	g9235	i0	87.97	5.66917293233083	266	32	100	0	1	266	347056	346791	Deinococcus sp. AJ005 plasmid p380k, complete sequence	blastn	1508	315	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
2294658	2294658	PRJNA1093380_P_NODE_5662_length_287_cov_1.439252_g5556_i0	PRJNA1093380	5662	287	1.439252	4.13065324	Deinococcus	1298	Bacteria	Bacteria	497	2.84e-136	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g5556	i0	97.909	133.247386759582	287	6	100	0	1	287	2333094	2332808	Deinococcus swuensis strain DY59, complete genome	blastn	38242	497	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
3569783	3569783	PRJNA1093380_P_NODE_16503_length_242_cov_0.911243_g16397_i0	PRJNA1093380	16503	242	0.911243	2.20520806	Deinococcus	1298	Bacteria	Bacteria	414	2.41e-111	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g16397	i0	97.521	2	242	6	100	0	1	242	2846851	2847092	Deinococcus swuensis strain DY59, complete genome	blastn	484	414	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
3569788	3569788	PRJNA1093380_P_NODE_17703_length_231_cov_2.588608_g17597_i0	PRJNA1093380	17703	231	2.588608	5.97968448	Deinococcus	1298	Bacteria	Bacteria	422	1.37e-113	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g17597	i0	99.567	3.14285714285714	231	1	100	0	1	231	404549	404319	Deinococcus swuensis strain DY59, complete genome	blastn	726	422	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
6576987	6576987	PRJNA1093380_P_NODE_12626_length_250_cov_0.870056_g12520_i0	PRJNA1093380	12626	250	0.870056	2.17514	Deinococcus radiopugnans	57497	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g12520	i0	99.6	6.16	250	1	100	0	1	250	244889	245138	Deinococcus swuensis strain DY59, complete genome	blastn	1540	457	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
6577105	6577105	PRJNA1093380_P_NODE_3906_length_314_cov_2.024896_g3800_i0	PRJNA1093380	3906	314	2.024896	6.35817344	Trueperaceae bacterium	2026798	Bacteria	Bacteria	459	1.48e-124	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g3800	i0	92.994	396.863057324841	314	22	100	0	1	314	2559308	2559621	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	124615	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
7851769	7851769	PRJNA1093380_P_NODE_11007_length_256_cov_1.683060_g10901_i0	PRJNA1093380	11007	256	1.68306	4.3086336	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	473	4.189999999999999e-129	NTclustered	gi\|1868561018\|gb\|CP058534.1\|	2755035	g10901	i0	100	2.00390625	256	0	100	0	1	256	1435031	1434776	Deinococcus sp. D7000 chromosome, complete genome	blastn	513	473	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
7851834	7851834	PRJNA1093380_P_NODE_15647_length_244_cov_0.900585_g15541_i0	PRJNA1093380	15647	244	0.900585	2.1974274	Deinococcus sp. VB142	3112952	Bacteria	Bacteria	427	3.13e-115	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g15541	i0	98.354	1.99180327868852	243	4	99	0	1	243	2656831	2657073	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	486	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
9126883	9126883	PRJNA1093380_P_NODE_7668_length_275_cov_1.495050_g7562_i0	PRJNA1093380	7668	275	1.49505	4.1113875	Deinococcus radiopugnans	57497	Bacteria	Bacteria	492	1.26e-134	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g7562	i0	98.909	3.01454545454545	275	3	100	0	1	275	3515823	3516097	Deinococcus swuensis strain DY59, complete genome	blastn	829	492	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
10402435	10402435	PRJNA1093380_P_NODE_17749_length_230_cov_2.700637_g17643_i0	PRJNA1093380	17749	230	2.700637	6.2114651	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	425	1.05e-114	NTclustered	gi\|1868564315\|gb\|CP058535.1\|	2755035	g17643	i0	100	1	230	0	100	0	1	230	53921	53692	Deinococcus sp. D7000 plasmid p_1, complete sequence	blastn	230	425	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
12498026	12498026	PRJNA1093380_P_NODE_11450_length_253_cov_1.711111_g11344_i0	PRJNA1093380	11450	253	1.711111	4.32911083	Deinococcus	1298	Bacteria	Bacteria	440	4.189999999999998e-119	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g11344	i0	98.024	33.4624505928854	253	5	100	0	1	253	1452459	1452711	Deinococcus swuensis strain DY59, complete genome	blastn	8466	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
12952839	12952839	PRJNA1093380_P_NODE_13151_length_249_cov_0.875000_g13045_i0	PRJNA1093380	13151	249	0.875	2.17875	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|1868561018\|gb\|CP058534.1\|	2755035	g13045	i0	98.394	1	249	4	100	0	1	249	2081697	2081449	Deinococcus sp. D7000 chromosome, complete genome	blastn	249	438	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
12952854	12952854	PRJNA1093380_P_NODE_13871_length_247_cov_1.770115_g13765_i0	PRJNA1093380	13871	247	1.770115	4.37218405	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	324	4.2799999999999995e-84	NTclustered	gi\|2905214251\|gb\|CP179946.1\|	3385567	g13765	i0	90.283	20.9392712550607	247	24	100	0	1	247	253046	252800	Deinococcus sp. VB343 chromosome 2, complete sequence	blastn	5172	324	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
12952968	12952968	PRJNA1093380_P_NODE_7151_length_278_cov_1.502439_g7045_i0	PRJNA1093380	7151	278	1.502439	4.17678042	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	492	1.27e-134	NTclustered	gi\|1868564315\|gb\|CP058535.1\|	2755035	g7045	i0	98.561	1	278	4	100	0	1	278	244631	244908	Deinococcus sp. D7000 plasmid p_1, complete sequence	blastn	278	492	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
16776182	16776182	PRJNA1093380_P_NODE_13974_length_247_cov_0.885057_g13868_i0	PRJNA1093380	13974	247	0.885057	2.18609079	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1868561018\|gb\|CP058534.1\|	2755035	g13868	i0	100	25.9392712550607	247	0	100	0	1	247	787928	787682	Deinococcus sp. D7000 chromosome, complete genome	blastn	6407	457	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
16776204	16776204	PRJNA1093380_P_NODE_15314_length_244_cov_2.292398_g15208_i0	PRJNA1093380	15314	244	2.292398	5.59345112	Deinococcus radiopugnans	57497	Bacteria	Bacteria	418	1.8799999999999994e-112	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g15208	i0	97.925	1.98770491803279	241	5	99	0	1	241	1640502	1640742	Deinococcus swuensis strain DY59, complete genome	blastn	485	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
17596971	17596971	PRJNA1093380_P_NODE_18094_length_201_cov_6.273438_g17988_i0	PRJNA1093380	18094	201	6.273438	12.60961038	Deinococcus	1298	Bacteria	Bacteria	233	5.82e-57	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g17988	i0	100	2.87064676616915	126	0	100	0	76	201	2204826	2204701	Deinococcus swuensis strain DY59, complete genome	blastn	577	233	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
21876064	21876064	PRJNA1093380_P_NODE_7998_length_273_cov_1.540000_g7892_i0	PRJNA1093380	7998	273	1.54	4.2042	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	505	1.6e-138	NTclustered	gi\|1868564315\|gb\|CP058535.1\|	2755035	g7892	i0	100	2.11721611721612	273	0	100	0	1	273	162727	162455	Deinococcus sp. D7000 plasmid p_1, complete sequence	blastn	578	505	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
22696126	22696126	PRJNA1093380_P_NODE_15438_length_244_cov_0.900585_g15332_i0	PRJNA1093380	15438	244	0.900585	2.1974274	Deinococcus	1298	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g15332	i0	99.18	2	244	2	100	0	1	244	171911	171668	Deinococcus swuensis strain DY59, complete genome	blastn	488	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
23151549	23151549	PRJNA1093380_P_NODE_8199_length_272_cov_1.547739_g8093_i0	PRJNA1093380	8199	272	1.547739	4.20985008	Deinococcus radiopugnans	57497	Bacteria	Bacteria	497	2.67e-136	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g8093	i0	99.632	4.98161764705882	272	1	100	0	1	272	3303429	3303700	Deinococcus swuensis strain DY59, complete genome	blastn	1355	497	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
23151574	23151574	PRJNA1093380_P_NODE_9439_length_265_cov_1.604167_g9333_i0	PRJNA1093380	9439	265	1.604167	4.25104255	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	106	1.83e-18	NTclustered	gi\|1868561018\|gb\|CP058534.1\|	2755035	g9333	i0	96.875	0.241509433962264	64	1	24	1	203	265	468430	468367	Deinococcus sp. D7000 chromosome, complete genome	blastn	64	106	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
23971573	23971573	PRJNA1093380_P_NODE_9219_length_266_cov_2.341969_g9113_i0	PRJNA1093380	9219	266	2.341969	6.22963754	Deinococcus	1298	Bacteria	Bacteria	475	1.2199999999999997e-129	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g9113	i0	98.876	3.15037593984962	267	1	100	2	1	266	2261161	2261426	Deinococcus swuensis strain DY59, complete genome	blastn	838	475	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
25245539	25245539	PRJNA1093380_P_NODE_1040_length_540_cov_1.922912_g937_i0	PRJNA1093380	1040	540	1.922912	10.3837248	Truepera	332248	Bacteria	Bacteria	640	8.9e-179	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g937	i0	90.141	135.027777777778	497	41	91	7	1	493	1735	1243	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	72915	640	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
25245557	25245557	PRJNA1093380_P_NODE_12920_length_249_cov_0.875000_g12814_i0	PRJNA1093380	12920	249	0.875	2.17875	Truepera	332248	Bacteria	Bacteria	305	1.57e-78	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g12814	i0	88.755	69.6224899598394	249	28	100	0	1	249	2120534	2120286	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	17336	305	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);;