metadata: contig_metadata: 12 rows where bioproject = "PRJNA725806" and tax

12 rows where bioproject = "PRJNA725806" 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
711914	711914	PRJNA725806_P_NODE_51441_length_246_cov_5.282297_g51144_i0	PRJNA725806	51441	246	5.282297	12.99445062	Tepiditoga spiralis	2108365	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1898704378\|dbj\|AP018712.1\|	2108365	g51144	i0	100	0.113821138211382	28	0	11	0	43	70	2047958	2047931	Tepiditoga spiralis sy52 DNA, complete genome	blastn	28	52.8	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Tepiditoga	Tepiditoga spiralis
3263061	3263061	PRJNA725806_P_NODE_137223_length_175_cov_1.398551_g136921_i0	PRJNA725806	137223	175	1.398551	2.44746425	Deinococcus aquaticus	328692	Bacteria	Bacteria	237	3.7900000000000005e-58	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g136921	i0	95.302	0.851428571428571	149	7	85	0	26	174	3055690	3055542	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	149	237	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
6298583	6298583	PRJNA725806_P_NODE_725_length_791_cov_2858.694960_g572_i0	PRJNA725806	725	791	2858.69496	22612.2771336	Bacteria	2	Bacteria	Bacteria	883	0	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g572	i0	100	58.4778761061947	478	0	89	0	39	516	604	127	Thermus aquaticus DNA polymerase (PolI) gene	blastn	46256	883	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
9640231	9640231	PRJNA725806_P_NODE_111028_length_190_cov_1.000000_g110726_i0	PRJNA725806	111028	190	1	1.9	Deinococcus radiomollis	468916	Bacteria	Bacteria	211	2.54e-50	NTclustered	gi\|2865414619\|gb\|CP129909.1\|	468916	g110726	i0	86.772	12.9263157894737	189	25	99	0	1	189	71157	70969	Deinococcus radiomollis strain PO-04-20-132 plasmid unnamed3, complete sequence	blastn	2456	211	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiomollis
10915881	10915881	PRJNA725806_P_NODE_177549_length_157_cov_1.216667_g177247_i0	PRJNA725806	177549	157	1.216667	1.91016719	Aminobacterium sp. MB27-C1	3070661	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2569590977\|gb\|CP133089.1\|	3070661	g177247	i0	100	0.191082802547771	30	0	19	0	87	116	1565292	1565263	Aminobacterium sp. MB27-C1 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminobacterium	Aminobacterium sp. MB27-C1
17289720	17289720	PRJNA725806_P_NODE_109114_length_191_cov_2.467532_g108812_i0	PRJNA725806	109114	191	2.467532	4.71298612	Deinococcus altitudinis	468914	Bacteria	Bacteria	320	4.08e-83	NTclustered	gi\|2865404944\|gb\|CP129415.1\|	468914	g108812	i0	96.891	486.895287958115	193	2	100	4	1	191	413725	413535	Deinococcus altitudinis strain LMG 24022 chromosome, complete genome	blastn	92997	320	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
27589507	27589507	PRJNA725806_P_NODE_103224_length_195_cov_2.481013_g102922_i0	PRJNA725806	103224	195	2.481013	4.83797535	Deinococcus altitudinis	468914	Bacteria	Bacteria	72.8	4.9e-13	NR	WP_407568778.1	468914	g102922	i0	61.4	2.6	57	22	87.7	0	3	173	270	326	WP_407568778.1 PRC-barrel domain-containing protein [Deinococcus altitudinis]	diamond	507	72.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
28599895	28599895	PRJNA725806_P_NODE_138727_length_174_cov_2.649635_g138425_i0	PRJNA725806	138727	174	2.649635	4.6103649	Deinococcus antarcticus	1298767	Bacteria	Bacteria	115	2.05e-28	NR	WP_380079338.1	1298767	g138425	i0	100	0.982758620689655	57	0	98.3	0	2	172	52	108	WP_380079338.1 sensor histidine kinase [Deinococcus antarcticus]	diamond	171	115	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
31252935	31252935	PRJNA725806_P_NODE_184835_length_154_cov_1.931624_g184533_i0	PRJNA725806	184835	154	1.931624	2.97470096	Deinococcus cavernae	2320857	Bacteria	Bacteria	99.8	2.8e-25	NR	WP_119763139.1	2320857	g184533	i0	88	2.96103896103896	50	6	97.4	0	154	5	13	62	WP_119763139.1 IS200/IS605 family transposase [Deinococcus cavernae]	diamond	456	99.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cavernae
31316212	31316212	PRJNA725806_P_NODE_24895_length_301_cov_2.037879_g24598_i0	PRJNA725806	24895	301	2.037879	6.13401579	Deinococcus	1298	Bacteria	Bacteria	190	3.4799999999999996e-56	NR	WP_135230441.1	1298	g24598	i0	100	0.926910299003322	93	0	92.7	0	1	279	230	322	WP_135230441.1 MULTISPECIES: apolipoprotein N-acyltransferase [Deinococcus]	diamond	279	190	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus
31980402	31980402	PRJNA725806_P_NODE_38198_length_269_cov_2.245690_g37901_i0	PRJNA725806	38198	269	2.24569	6.0409061	uncultured Meiothermus sp.	157471	Bacteria	Bacteria	43.5	0.018	NR	WP_299430388.1	157471	g37901	i0	38.6	0.95910780669145	44	27	49.1	0	132	1	71	114	WP_299430388.1 YIP1 family protein [uncultured Meiothermus sp.]	diamond	258	43.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	uncultured Meiothermus sp.
32043746	32043746	PRJNA725806_P_NODE_143398_length_172_cov_1.259259_g143096_i0	PRJNA725806	143398	172	1.259259	2.16592548	Deinococcus altitudinis	468914	Bacteria	Bacteria	74.3	1.04e-13	NR	WP_407572892.1	468914	g143096	i0	68.4	0.994186046511628	57	18	99.4	0	1	171	221	277	WP_407572892.1 PRC-barrel domain-containing protein [Deinococcus altitudinis]	diamond	171	74.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis

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