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

25 rows where analysis = "blastn", bioproject = "PRJNA928559" 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
2178344	2178344	PRJNA928559_P_NODE_178282_length_260_cov_3.294118_g176713_i0	PRJNA928559	178282	260	3.294118	8.5647068	Deinococcus peraridilitoris	432329	Bacteria	Bacteria	226	1.32e-54	NTclustered	gi\|429128598\|gb\|CP003382.1\|	937777	g176713	i0	82.836	398.023076923077	268	30	99	12	3	260	1140312	1140573	Deinococcus peraridilitoris DSM 19664, complete genome	blastn	103486	226	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
2178544	2178544	PRJNA928559_P_NODE_191262_length_251_cov_4.910112_g189693_i0	PRJNA928559	191262	251	4.910112	12.32438112	Deinococcus radiophilus	32062	Bacteria	Bacteria	436	5.369999999999999e-118	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g189693	i0	98.008	89.5219123505976	251	5	100	0	1	251	202884	202634	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	22470	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
2179249	2179249	PRJNA928559_P_NODE_34042_length_565_cov_57.268293_g32496_i0	PRJNA928559	34042	565	57.268293	323.56585545	Deinococcus metallilatus	1211322	Bacteria	Bacteria	861	0	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g32496	i0	94.211	109.030088495575	570	24	100	9	1	565	413758	413193	Deinococcus metallilatus strain MA1002 chromosome	blastn	61602	861	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
3453275	3453275	PRJNA928559_P_NODE_136983_length_302_cov_17.755459_g135414_i0	PRJNA928559	136983	302	17.755459	53.62148618	Deinococcus ficus	317577	Bacteria	Bacteria	344	4.14e-90	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g135414	i0	88.581	161.390728476821	289	26	94	7	18	302	2342736	2343021	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	48740	344	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
3454379	3454379	PRJNA928559_P_NODE_214583_length_242_cov_0.923077_g213014_i0	PRJNA928559	214583	242	0.923077	2.23384634	Deinococcus aquaticus	328692	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g213014	i0	98.347	42.5454545454545	242	4	100	0	1	242	1054269	1054510	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	10296	425	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
4733128	4733128	PRJNA928559_P_NODE_9724_length_980_cov_277.819184_g770_i24	PRJNA928559	9724	980	277.819184	2722.6280032	Deinococcus aquaticus	328692	Bacteria	Bacteria	1531	0	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g770	i24	94.934	276.117346938775	987	35	100	14	1	980	715710	714732	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	270595	1531	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
6005612	6005612	PRJNA928559_P_NODE_137085_length_302_cov_3.340611_g135516_i0	PRJNA928559	137085	302	3.340611	10.08864522	Thermus aquaticus	271	Bacteria	Bacteria	169	2.68e-37	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g135516	i0	86.842	25.294701986755	152	18	50	2	75	225	45623	45773	Thermus aquaticus Y51MC23, complete genome	blastn	7639	169	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
6007611	6007611	PRJNA928559_P_NODE_7245_length_1120_cov_94.213945_g6240_i0	PRJNA928559	7245	1120	94.213945	1055.196184	Deinococcus ficus	317577	Bacteria	Bacteria	1897	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g6240	i0	97.651	219.3375	1107	22	99	3	1	1105	2341917	2343021	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	245658	1897	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
8556812	8556812	PRJNA928559_P_NODE_37347_length_544_cov_7.252654_g35795_i0	PRJNA928559	37347	544	7.252654	39.45443776	Deinococcus ficus	317577	Bacteria	Bacteria	654	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g35795	i0	88.665	262.757352941176	547	48	100	13	1	544	2342486	2343021	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	142940	654	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
8905624	8905624	PRJNA928559_P_NODE_16947_length_762_cov_85.162554_g6240_i3	PRJNA928559	16947	762	85.162554	648.93866148	Deinococcus	1298	Bacteria	Bacteria	1094	0	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g6240	i3	92.549	211.133858267717	765	53	100	3	1	762	343	1106	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	160884	1098	0.996357012750455	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
8905875	8905875	PRJNA928559_P_NODE_27507_length_618_cov_105.587156_g6240_i4	PRJNA928559	27507	618	105.587156	652.52862408	Deinococcus	1298	Bacteria	Bacteria	1059	0	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g6240	i4	97.581	219.118122977346	620	11	100	3	1	618	1454376	1454993	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	135415	1059	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
11456835	11456835	PRJNA928559_P_NODE_34909_length_559_cov_128.899177_g33360_i0	PRJNA928559	34909	559	128.899177	720.54639943	Deinococcus	1298	Bacteria	Bacteria	893	0	NTclustered	gi\|686203029\|dbj\|LC002535.1\|	158789	g33360	i0	96	101.261180679785	550	20	98	2	10	558	1	549	Uncultured Deinococcus sp. gene for 16S ribosomal RNA, partial sequence, clone: 12Sz1000-16	blastn	56605	902	0.990022172949002	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
14931521	14931521	PRJNA928559_P_NODE_217912_length_237_cov_37.432927_g216343_i0	PRJNA928559	217912	237	37.432927	88.71603699	Deinococcus grandis	57498	Bacteria	Bacteria	433	6.5e-117	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g216343	i0	99.578	191.7805907173	237	1	100	0	1	237	74878	75114	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	45452	433	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
15280666	15280666	PRJNA928559_P_NODE_136872_length_303_cov_1.195652_g135303_i0	PRJNA928559	136872	303	1.195652	3.62282556	Bacteria	2	Bacteria	Bacteria	560	3.79e-155	NTclustered	gi\|2866351997\|gb\|PQ721879.1\|	47478	g135303	i0	100	103.392739273927	303	0	100	0	1	303	756	454	Deinococcus sp. strain L174 16S ribosomal RNA gene, partial sequence	blastn	31328	560	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
16555066	16555066	PRJNA928559_P_NODE_100293_length_356_cov_2.314488_g98724_i0	PRJNA928559	100293	356	2.314488	8.23957728	Deinococcus	1298	Bacteria	Bacteria	363	1.3699999999999999e-95	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g98724	i0	85.47	190.676966292135	351	47	99	4	4	353	881118	881465	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	67881	363	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
16555618	16555618	PRJNA928559_P_NODE_47753_length_493_cov_6.190476_g46191_i0	PRJNA928559	47753	493	6.190476	30.51904668	Deinococcus	1298	Bacteria	Bacteria	809	0	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g46191	i0	96.356	196.949290060852	494	14	100	4	1	493	2672390	2672880	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	97096	809	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
17480335	17480335	PRJNA928559_P_NODE_125334_length_317_cov_11.397541_g123765_i0	PRJNA928559	125334	317	11.397541	36.13020497	Deinococcus metallilatus	1211322	Bacteria	Bacteria	412	1.1799999999999999e-110	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g123765	i0	90.343	190.725552050473	321	22	100	7	1	317	329657	329342	Deinococcus metallilatus strain MA1002 chromosome	blastn	60460	412	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
17480470	17480470	PRJNA928559_P_NODE_133854_length_306_cov_3.081545_g132285_i0	PRJNA928559	133854	306	3.081545	9.4295277	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	377	4.15e-100	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g132285	i0	92.164	153.264705882353	268	19	87	2	1	267	1362374	1362108	Deinococcus sp. QL22 chromosome, complete genome	blastn	46899	377	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
21304081	21304081	PRJNA928559_P_NODE_112277_length_336_cov_4.904943_g110708_i0	PRJNA928559	112277	336	4.904943	16.48060848	Trueperaceae bacterium	2026798	Bacteria	Bacteria	455	2.0700000000000003e-123	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g110708	i0	91.15	636.333333333333	339	25	100	5	1	336	6843	6507	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	213808	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
21305542	21305542	PRJNA928559_P_NODE_212377_length_243_cov_0.917647_g210808_i0	PRJNA928559	212377	243	0.917647	2.22988221	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|1819263661\|gb\|CP049358.1\|	1288484	g210808	i0	98.354	2	243	4	100	0	1	243	286771	287013	Deinococcus wulumuqiensis R12 plasmid unnamed1, complete sequence	blastn	486	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
21655247	21655247	PRJNA928559_P_NODE_217437_length_238_cov_3.769697_g215868_i0	PRJNA928559	217437	238	3.769697	8.97187886	Deinococcus	1298	Bacteria	Bacteria	268	1.95e-67	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g215868	i0	88.987	183.352941176471	227	12	93	10	6	226	1409	1190	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	43638	268	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
21655493	21655493	PRJNA928559_P_NODE_94997_length_365_cov_152.910959_g93428_i0	PRJNA928559	94997	365	152.910959	558.12500035	Deinococcus	1298	Bacteria	Bacteria	640	5.809999999999999e-179	NTclustered	gi\|145033\|gb\|M21413.1\|DEIRGDA	1299	g93428	i0	100	127.309589041096	346	0	95	0	1	346	462	807	D.radiodurans 16S ribosomal RNA gene	blastn	46468	640	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
23855885	23855885	PRJNA928559_P_NODE_218939_length_236_cov_2.012270_g217370_i0	PRJNA928559	218939	236	2.01227	4.7489572	Deinococcus ficus	317577	Bacteria	Bacteria	283	6.889999999999999e-72	NTclustered	gi\|1220364820\|gb\|CP021082.1\|	317577	g217370	i0	88.306	9.1271186440678	248	13	100	11	1	236	383742	383985	Deinococcus ficus strain CC-FR2-10 plasmid pDFI1, complete sequence	blastn	2154	283	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
23855966	23855966	PRJNA928559_P_NODE_223499_length_227_cov_6.987013_g221930_i0	PRJNA928559	223499	227	6.987013	15.86051951	Deinococcus taeanensis	2737050	Bacteria	Bacteria	348	2.3e-91	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g221930	i0	94.273	198.73127753304	227	13	100	0	1	227	2676	2902	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	45112	348	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
25128596	25128596	PRJNA928559_P_NODE_14580_length_817_cov_79.784946_g6240_i2	PRJNA928559	14580	817	79.784946	651.84300882	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	1365	0	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g6240	i2	96.829	209.009791921665	820	20	100	5	1	817	57959	57143	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	170761	1365	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081

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