metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1198392" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1198392" 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
1043787	1043787	PRJNA1198392_P_NODE_15701_length_251_cov_0.971910_g15560_i0	PRJNA1198392	15701	251	0.97191	2.4394941	Truepera	332248	Bacteria	Bacteria	270	5.77e-68	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g15560	i0	86.345	70.4103585657371	249	32	99	2	3	250	173	420	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	17673	270	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
1599103	1599103	PRJNA1198392_P_NODE_122_length_1935_cov_5.009130_g81_i0	PRJNA1198392	122	1935	5.00913	96.9266655	Deinococcus taeanensis	2737050	Bacteria	Bacteria	2802	0	NTclustered	gi\|2105692036\|gb\|CP083455.1\|	2737050	g81	i0	93.438	287.049612403101	1905	99	98	23	1	1892	32720	30829	Deinococcus taeanensis strain TS293 chromosome, complete genome	blastn	555441	2802	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
6146583	6146583	PRJNA1198392_P_NODE_16825_length_249_cov_0.903409_g16684_i0	PRJNA1198392	16825	249	0.903409	2.24948841	Deinococcus	1298	Bacteria	Bacteria	361	3.3e-95	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g16684	i0	92.857	198.827309236948	252	13	100	4	1	249	2597	2846	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	49508	361	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
6146584	6146584	PRJNA1198392_P_NODE_17205_length_249_cov_0.875000_g17064_i0	PRJNA1198392	17205	249	0.875	2.17875	Deinococcus	1298	Bacteria	Bacteria	182	2.75e-41	NTclustered	gi\|2745307249\|gb\|CP158299.1\|	694439	g17064	i0	91.176	172.377510040161	136	9	98	3	115	249	337523	337656	Deinococcus sonorensis KR-87 chromosome, complete genome	blastn	42922	183	0.994535519125683	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sonorensis
6702543	6702543	PRJNA1198392_P_NODE_4346_length_373_cov_1.523333_g4205_i0	PRJNA1198392	4346	373	1.523333	5.68203209	Trueperaceae bacterium	2026798	Bacteria	Bacteria	462	1.38e-125	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g4205	i0	89.218	85.9731903485255	371	39	99	1	4	373	7773	8143	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	32068	462	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
9252770	9252770	PRJNA1198392_P_NODE_9248_length_286_cov_1.230047_g9107_i0	PRJNA1198392	9248	286	1.230047	3.51793442	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	427	3.76e-115	NTclustered	gi\|2905211496\|gb\|CP179945.1\|	3385567	g9107	i0	99.156	16.4125874125874	237	2	83	0	1	237	1910430	1910194	Deinococcus sp. VB343 chromosome 1, complete sequence	blastn	4694	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
15071457	15071457	PRJNA1198392_P_NODE_14732_length_257_cov_1.673913_g14591_i0	PRJNA1198392	14732	257	1.673913	4.30195641	Deinococcus	1298	Bacteria	Bacteria	390	4.359999999999999e-104	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g14591	i0	94.186	173.24513618677	258	12	100	3	1	257	1384	1639	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	44524	392	0.994897959183674	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
15627523	15627523	PRJNA1198392_P_NODE_5873_length_332_cov_3.563707_g5732_i0	PRJNA1198392	5873	332	3.563707	11.83150724	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	198	3.8e-46	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g5732	i0	93.284	63.2590361445783	134	9	97	0	184	317	69613	69746	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	21002	198	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
17621546	17621546	PRJNA1198392_P_NODE_2174_length_503_cov_1.781395_g2033_i0	PRJNA1198392	2174	503	1.781395	8.96041685	Truepera	332248	Bacteria	Bacteria	708	0	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g2033	i0	92.048	678.936381709742	503	40	100	0	1	503	1032	530	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	341505	708	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
17621550	17621550	PRJNA1198392_P_NODE_3114_length_427_cov_3.183616_g2973_i0	PRJNA1198392	3114	427	3.183616	13.59404032	Deinococcus	1298	Bacteria	Bacteria	577	5.489999999999998e-160	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g2973	i0	91.121	203.866510538642	428	34	100	4	1	427	1793144	1793568	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	87051	577	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
18895209	18895209	PRJNA1198392_P_NODE_13455_length_265_cov_1.416667_g13314_i0	PRJNA1198392	13455	265	1.416667	3.75416755	Deinococcus	1298	Bacteria	Bacteria	435	2.06e-117	NTclustered	gi\|2706841266\|gb\|CP149784.1\|	3112952	g13314	i0	96.226	11.211320754717	265	10	100	0	1	265	40501	40765	Deinococcus sp. VB142 plasmid p1, complete sequence	blastn	2971	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142

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