metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1218816" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1218816" 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
1608016	1608016	PRJNA1218816_P_NODE_30862_length_361_cov_1.524306_g30429_i0	PRJNA1218816	30862	361	1.524306	5.50274466	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	514	3.63e-141	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g30429	i0	92.308	307.950138504155	364	24	100	3	1	361	69234	68872	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	111170	514	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
1608220	1608220	PRJNA1218816_P_NODE_56162_length_248_cov_1.691429_g55729_i0	PRJNA1218816	56162	248	1.691429	4.19474392	Deinococcus sp. VB142	3112952	Bacteria	Bacteria	364	2.539999999999999e-96	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g55729	i0	93.145	69.7459677419355	248	17	100	0	1	248	604843	604596	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	17297	364	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
2321597	2321597	PRJNA1218816_P_NODE_49542_length_265_cov_2.005208_g49109_i0	PRJNA1218816	49542	265	2.005208	5.3138012	root	1	Root_unresolved	Root_unresolved	490	4.3299999999999986e-134	NTclustered	gi\|1073549716\|gb\|KX946495.1\|	47478	g49109	i0	100	107.520754716981	265	0	100	0	1	265	773	509	Deinococcus sp. strain FX4 16S ribosomal RNA gene, partial sequence	blastn	28493	490	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
4874363	4874363	PRJNA1218816_P_NODE_29104_length_376_cov_0.891089_g28671_i0	PRJNA1218816	29104	376	0.891089	3.35049464	Deinococcus	1298	Bacteria	Bacteria	398	3.989999999999999e-106	NTclustered	gi\|470487735\|ref\|NR_076834.1\|	309887	g28671	i0	86.133	910.566489361702	375	45	99	5	1	371	1328	957	Deinococcus maricopensis strain LB-34 23S ribosomal RNA gene, complete sequence	blastn	342373	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis
5436675	5436675	PRJNA1218816_P_NODE_49365_length_266_cov_1.492228_g48932_i0	PRJNA1218816	49365	266	1.492228	3.96932648	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	370	5.91e-98	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g48932	i0	91.791	439.172932330827	268	18	100	2	1	266	67866	68131	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	116820	370	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
6149098	6149098	PRJNA1218816_P_NODE_48365_length_270_cov_1.147208_g47932_i0	PRJNA1218816	48365	270	1.147208	3.0974616	Deinococcus	1298	Bacteria	Bacteria	122	1.86e-23	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g47932	i0	80	13.3962962962963	175	28	64	6	95	267	2355439	2355608	Deinococcus gobiensis I-0, complete genome	blastn	3617	122	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
9261252	9261252	PRJNA1218816_P_NODE_2748_length_1766_cov_5.076196_g2595_i0	PRJNA1218816	2748	1766	5.076196	89.64562136	Deinococcus ficus	317577	Bacteria	Bacteria	2438	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g2595	i0	91.653	317.320498301246	1785	114	100	30	1	1766	2341228	2342996	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	560388	2438	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
10537366	10537366	PRJNA1218816_P_NODE_55049_length_250_cov_0.870056_g54616_i0	PRJNA1218816	55049	250	0.870056	2.17514	Deinococcus geothermalis	68909	Bacteria	Bacteria	401	1.9499999999999994e-107	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g54616	i0	95.6	2.544	250	11	100	0	1	250	2385265	2385514	Deinococcus geothermalis DSM 11300, complete genome	blastn	636	401	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
12524968	12524968	PRJNA1218816_P_NODE_58390_length_246_cov_0.890173_g57957_i0	PRJNA1218816	58390	246	0.890173	2.18982558	Deinococcus	1298	Bacteria	Bacteria	196	9.7e-46	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g57957	i0	85.417	1.5609756097561	192	25	77	3	57	246	1010281	1010091	Deinococcus swuensis strain DY59, complete genome	blastn	384	196	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
16910589	16910589	PRJNA1218816_P_NODE_49714_length_265_cov_1.083333_g49281_i0	PRJNA1218816	49714	265	1.083333	2.87083245	Deinococcus geothermalis	68909	Bacteria	Bacteria	379	9.78e-101	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g49281	i0	92.481	189.943396226415	266	18	100	2	1	265	326143	326407	Deinococcus geothermalis DSM 11300, complete genome	blastn	50335	379	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
19459586	19459586	PRJNA1218816_P_NODE_63056_length_241_cov_0.916667_g62623_i0	PRJNA1218816	63056	241	0.916667	2.20916747	Deinococcus taeanensis	2737050	Bacteria	Bacteria	167	7.429999999999999e-37	NTclustered	gi\|2105695065\|gb\|CP083457.1\|	2737050	g62623	i0	79.583	32.0954356846473	240	43	98	5	5	241	12278	12042	Deinococcus taeanensis strain TS293 plasmid p_TS293_3, complete sequence	blastn	7735	167	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
20735017	20735017	PRJNA1218816_P_NODE_61157_length_243_cov_0.905882_g60724_i0	PRJNA1218816	61157	243	0.905882	2.20129326	Trueperaceae bacterium	2026798	Bacteria	Bacteria	350	6.94e-92	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g60724	i0	93.939	427.427983539095	231	14	95	0	12	242	3600638	3600868	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	103865	350	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
22723185	22723185	PRJNA1218816_P_NODE_50458_length_262_cov_1.544974_g50025_i0	PRJNA1218816	50458	262	1.544974	4.04783188	Deinococcus	1298	Bacteria	Bacteria	390	4.4599999999999996e-104	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g50025	i0	94.841	198.778625954198	252	10	96	2	1	252	1793623	1793375	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	52080	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
25272487	25272487	PRJNA1218816_P_NODE_62220_length_242_cov_0.911243_g61787_i0	PRJNA1218816	62220	242	0.911243	2.20520806	Deinococcus	1298	Bacteria	Bacteria	364	2.4699999999999992e-96	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g61787	i0	93.827	96.0123966942149	243	13	100	2	1	242	2118807	2119048	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	23235	364	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans

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