metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA745553" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA745553" 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
2000075	2000075	PRJNA745553_S_NODE_13042_length_341_cov_1.548507_g12847_i0	PRJNA745553	13042	341	1.548507	5.28040887	Deinococci	188787	Bacteria	Bacteria	179	6.61e-53	NR	MCL4454247.1	47478	g12847	i0	81.3	3.36950146627566	96	18	84.5	0	288	1	106	201	MCL4454247.1 aldo/keto reductase [Deinococcus sp.]	diamond	1149	179	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
11402384	11402384	PRJNA745553_S_NODE_17609_length_294_cov_2.158371_g17414_i0	PRJNA745553	17609	294	2.158371	6.34561074	Deinococcota bacterium	1913990	Bacteria	Bacteria	114	9.919999999999999e-28	NR	NBC96936.1	1913990	g17414	i0	73.4	0.806122448979592	79	21	80.6	0	239	3	316	394	NBC96936.1 3-phosphoshikimate 1-carboxyvinyltransferase [Deinococcota bacterium]	diamond	237	114	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
17776398	17776398	PRJNA745553_S_NODE_23534_length_255_cov_1.159341_g23339_i0	PRJNA745553	23534	255	1.159341	2.95631955	Bacteria	2	Bacteria	Bacteria	119	1.56e-32	NR	WP_013179441.1	332249	g23339	i0	87.1	1.64705882352941	70	9	82.4	0	212	3	1	70	WP_013179441.1 NADH-quinone oxidoreductase subunit A [Truepera radiovictrix]	diamond	420	119	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
27526696	27526696	PRJNA745553_S_NODE_28203_length_231_cov_3.784810_g28008_i0	PRJNA745553	28203	231	3.78481	8.7429111	Truepera radiovictrix	332249	Bacteria	Bacteria	57.4	2.11e-7	NR	WP_013177478.1	332249	g28008	i0	48.4	0.831168831168831	64	29	83.1	2	20	211	372	431	WP_013177478.1 CHRD domain-containing protein [Truepera radiovictrix]	diamond	192	57.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
27716545	27716545	PRJNA745553_S_NODE_25884_length_244_cov_4.233918_g25689_i0	PRJNA745553	25884	244	4.233918	10.33075992	uncultured Truepera sp.	543023	Bacteria	Bacteria	104	2.8399999999999998e-25	NR	CAA9568103.1	543023	g25689	i0	90.2	0.627049180327869	51	5	62.7	0	226	74	205	255	CAA9568103.1 MAG: hypothetical protein AVDCRST_MAG86-1267 [uncultured Truepera sp.]	diamond	153	104	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
27757995	27757995	PRJNA745553_S_NODE_6424_length_461_cov_3.569588_g6230_i0	PRJNA745553	6424	461	3.569588	16.45580068	Bacteria	2	Bacteria	Bacteria	183	5.68e-56	NR	WP_110991060.1	1184398	g6230	i0	63.2	10.5422993492408	136	48	88.5	1	459	52	50	183	WP_110991060.1 MULTISPECIES: peptide deformylase [unclassified Mesotoga]	diamond	4860	184	0.994565217391304	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga
28189529	28189529	PRJNA745553_S_NODE_21106_length_269_cov_2.489796_g20911_i0	PRJNA745553	21106	269	2.489796	6.69755124	uncultured Truepera sp.	543023	Bacteria	Bacteria	50.1	1.32e-4	NR	CAA9553562.1	543023	g20911	i0	62.5	0.446096654275093	40	15	44.6	0	228	109	485	524	CAA9553562.1 MAG: Uncharacterized MFS-type transporter [uncultured Truepera sp.]	diamond	120	50.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
29389711	29389711	PRJNA745553_S_NODE_13129_length_340_cov_1.044944_g12934_i0	PRJNA745553	13129	340	1.044944	3.5528096	Trueperaceae bacterium	2026798	Bacteria	Bacteria	128	1.43e-35	NR	MDZ7703536.1	2026798	g12934	i0	65.9	0.75	85	29	75	0	3	257	34	118	MDZ7703536.1 holo-ACP synthase [Trueperaceae bacterium]	diamond	255	128	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
30021331	30021331	PRJNA745553_S_NODE_7911_length_424_cov_18.507123_g7716_i0	PRJNA745553	7911	424	18.507123	78.47020152	Deinococcus carri	1211323	Bacteria	Bacteria	82.8	2.9e-15	NR	WP_345464179.1	1211323	g7716	i0	55	1.13915094339623	80	35	55.9	1	407	171	1463	1542	WP_345464179.1 DEAD/DEAH box helicase [Deinococcus carri]	diamond	483	82.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus carri
31158233	31158233	PRJNA745553_S_NODE_22055_length_263_cov_4.568421_g21860_i0	PRJNA745553	22055	263	4.568421	12.01494723	uncultured Truepera sp.	543023	Bacteria	Bacteria	112	1.51e-30	NR	CAA9582165.1	543023	g21860	i0	83.9	0.707224334600761	62	10	70.7	0	206	21	1	62	CAA9582165.1 MAG: LSU ribosomal protein L32p @ LSU ribosomal protein L32p, zinc-dependent [uncultured Truepera sp.]	diamond	186	112	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
31632911	31632911	PRJNA745553_S_NODE_26676_length_241_cov_3.642857_g26481_i0	PRJNA745553	26676	241	3.642857	8.77928537	Truepera radiovictrix	332249	Bacteria	Bacteria	97.1	3.4099999999999995e-24	NR	WP_013179383.1	332249	g26481	i0	83.9	0.697095435684647	56	9	69.7	0	224	57	40	95	WP_013179383.1 co-chaperone GroES [Truepera radiovictrix]	diamond	168	97.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
32107500	32107500	PRJNA745553_S_NODE_3298_length_572_cov_19.685371_g3115_i0	PRJNA745553	3298	572	19.685371	112.60032212	Thermotoga sp. TBYP3.1.4.1	1587550	Bacteria	Bacteria	87.4	8.16e-17	NR	AJA38639.1	1587550	g3115	i0	40	0.944055944055944	180	102	93.4	4	4	537	135	310	AJA38639.1 hypothetical protein [Thermotoga sp. TBYP3.1.4.1]	diamond	540	87.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga sp. TBYP3.1.4.1
32275917	32275917	PRJNA745553_S_NODE_19498_length_280_cov_3.647343_g19303_i0	PRJNA745553	19498	280	3.647343	10.2125604	Deinococcus	1298	Bacteria	Bacteria	141	4.11e-38	NR	WP_103131023.1	200253	g19303	i0	89.7	3.34285714285714	78	8	83.6	0	257	24	70	147	WP_103131023.1 low temperature requirement protein A [Deinococcus aerius]	diamond	936	142	0.992957746478873	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aerius

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