metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA379145" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA379145" 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
1675748	1675748	PRJNA379145_P_NODE_56782_length_201_cov_1.922619_g54628_i0	PRJNA379145	56782	201	1.922619	3.86446419	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	296	7.31e-76	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g54628	i0	93.878	151.706467661692	196	12	98	0	6	201	55995	56190	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	30493	296	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
3624755	3624755	PRJNA379145_P_NODE_36343_length_337_cov_3.526316_g34195_i0	PRJNA379145	36343	337	3.526316	11.88368492	Deinococcus	1298	Bacteria	Bacteria	355	2.16e-93	NTclustered	gi\|485099143\|ref\|NR_102538.1\|	432329	g34195	i0	85.924	197.46587537092	341	39	99	8	2	337	636	972	Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence	blastn	66546	355	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
4228314	4228314	PRJNA379145_P_NODE_66404_length_168_cov_3.000000_g64250_i0	PRJNA379145	66404	168	3	5.04	Deinococcus sonorensis	309891	Bacteria	Bacteria	211	2.2e-50	NTclustered	gi\|2745307249\|gb\|CP158299.1\|	694439	g64250	i0	92.517	184.261904761905	147	11	88	0	1	147	336156	336010	Deinococcus sonorensis KR-87 chromosome, complete genome	blastn	30956	211	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sonorensis
6176945	6176945	PRJNA379145_P_NODE_27625_length_451_cov_7.308612_g25547_i0	PRJNA379145	27625	451	7.308612	32.96184012	Truepera	332248	Bacteria	Bacteria	268	3.989999999999999e-67	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g25547	i0	91	103.181818181818	200	16	80	1	1	198	1959	1760	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	46535	268	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
7451994	7451994	PRJNA379145_P_NODE_62346_length_181_cov_1.250000_g60192_i0	PRJNA379145	62346	181	1.25	2.2625	Meiothermus	65551	Bacteria	Bacteria	292	8.32e-75	NTclustered	gi\|470485054\|ref\|NR_076682.1\|	277	g60192	i0	96.133	105.132596685083	181	4	100	2	1	181	2232	2055	Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence	blastn	19029	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
7452003	7452003	PRJNA379145_P_NODE_65406_length_171_cov_2.101449_g63252_i0	PRJNA379145	65406	171	2.101449	3.59347779	Thermus	270	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|470468782\|ref\|NR_076136.1\|	37636	g63252	i0	100	140.795321637427	171	0	100	0	1	171	1179	1349	Thermus scotoductus strain SA-01 23S ribosomal RNA gene, complete sequence	blastn	24076	316	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
11277274	11277274	PRJNA379145_P_NODE_64329_length_174_cov_8.297872_g62175_i0	PRJNA379145	64329	174	8.297872	14.43829728	Truepera	332248	Bacteria	Bacteria	250	4.84e-62	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g62175	i0	92.529	281.649425287356	174	13	100	0	1	174	13	186	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	49007	250	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
11277287	11277287	PRJNA379145_P_NODE_71169_length_157_cov_1.193548_g69014_i0	PRJNA379145	71169	157	1.193548	1.87387036	Allomeiothermus	2935559	Bacteria	Bacteria	291	2.52e-74	NTclustered	gi\|470486339\|ref\|NR_076751.1\|	52022	g69014	i0	100	15.6815286624204	157	0	100	0	1	157	300	456	Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence	blastn	2462	291	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
12552534	12552534	PRJNA379145_P_NODE_25530_length_486_cov_16.902870_g23489_i0	PRJNA379145	25530	486	16.90287	82.1479482	Deinococcus	1298	Bacteria	Bacteria	728	0	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g23489	i0	93.865	211.40329218107	489	20	99	8	1	485	329948	329466	Deinococcus metallilatus strain MA1002 chromosome	blastn	102742	728	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
13154901	13154901	PRJNA379145_P_NODE_73031_length_152_cov_4.294118_g70876_i0	PRJNA379145	73031	152	4.294118	6.52705936	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	165	1.5300000000000002e-36	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g70876	i0	86.986	141.013157894737	146	19	96	0	1	146	544420	544275	Deinococcus sp. NW-56 chromosome, complete genome	blastn	21434	165	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
14429744	14429744	PRJNA379145_P_NODE_51652_length_224_cov_6.183246_g49498_i0	PRJNA379145	51652	224	6.183246	13.85047104	Deinococcus yunweiensis	367282	Bacteria	Bacteria	331	2.28e-86	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g49498	i0	93.333	186.321428571429	225	14	100	1	1	224	2670295	2670519	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	41736	331	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
15703836	15703836	PRJNA379145_P_NODE_66753_length_168_cov_1.088889_g64599_i0	PRJNA379145	66753	168	1.088889	1.82933352	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	300	4.56e-77	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g64599	i0	98.81	77.6190476190476	168	2	100	0	1	168	69271	69438	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	13040	300	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
17651655	17651655	PRJNA379145_P_NODE_52314_length_221_cov_1.898936_g50160_i0	PRJNA379145	52314	221	1.898936	4.19664856	Meiothermus	65551	Bacteria	Bacteria	387	4.729999999999998e-103	NTclustered	gi\|470485054\|ref\|NR_076682.1\|	277	g50160	i0	98.19	174.506787330317	221	4	100	0	1	221	1505	1285	Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence	blastn	38566	387	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
18252257	18252257	PRJNA379145_P_NODE_18355_length_636_cov_2.621891_g16565_i0	PRJNA379145	18355	636	2.621891	16.67522676	Trueperaceae bacterium	2026798	Bacteria	Bacteria	599	1.799999999999999e-166	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g16565	i0	87.194	324.12893081761	531	62	83	6	53	579	2560307	2559779	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	206146	599	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
18252595	18252595	PRJNA379145_P_NODE_47135_length_250_cov_3.377880_g44982_i0	PRJNA379145	47135	250	3.37788	8.4447	Trueperaceae bacterium	2026798	Bacteria	Bacteria	350	7.17e-92	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g44982	i0	91.968	381.132	249	20	99	0	1	249	3600523	3600771	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	95283	350	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
19526867	19526867	PRJNA379145_P_NODE_53796_length_214_cov_1.596685_g51642_i0	PRJNA379145	53796	214	1.596685	3.4169059	Thermus brockianus	56956	Bacteria	Bacteria	374	3.539999999999999e-99	NTclustered	gi\|1102955210\|gb\|CP016312.1\|	56956	g51642	i0	98.578	144.981308411215	211	3	100	0	1	211	696991	697201	Thermus brockianus strain GE-1 chromosome, complete genome	blastn	31026	374	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
22077184	22077184	PRJNA379145_P_NODE_21478_length_562_cov_8.589792_g19558_i0	PRJNA379145	21478	562	8.589792	48.27463104	Deinococcus taeanensis	2737050	Bacteria	Bacteria	808	0	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g19558	i0	93.285	211.355871886121	551	32	98	5	6	553	1402	1950	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	118782	808	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
22077574	22077574	PRJNA379145_P_NODE_6038_length_1234_cov_10.269775_g5301_i0	PRJNA379145	6038	1234	10.269775	126.7290235	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	1243	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g5301	i0	93.653	254.378444084279	835	47	90	5	1	833	74300	73470	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	313903	1243	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
24025784	24025784	PRJNA379145_P_NODE_39599_length_306_cov_4.520147_g37448_i0	PRJNA379145	39599	306	4.520147	13.83164982	Thermus	270	Bacteria	Bacteria	231	3.42e-56	NTclustered	gi\|2894814231\|gb\|CP178485.1\|	56957	g37448	i0	80.892	139.199346405229	314	42	99	17	1	305	1853102	1853406	Thermus oshimai strain Blanco chromosome, complete genome	blastn	42595	231	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai

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