metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax

16 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax_phylum = "Thermotogota"

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
6090462	6090462	PRJEB28062_P_NODE_28465_length_693_cov_29.241935_g26199_i0	PRJEB28062	28465	693	29.241935	202.64660955	Fervidobacterium	2422	Bacteria	Bacteria	1175	0	NTclustered	gi\|2793121053\|gb\|CP126498.1\|	44754	g26199	i0	99.084	19.6695526695527	655	4	94	2	21	673	340202	340856	Fervidobacterium gondwanense strain 13770 chromosome, complete genome	blastn	13631	1175	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
6090587	6090587	PRJEB28062_P_NODE_38425_length_588_cov_16.108738_g36098_i0	PRJEB28062	38425	588	16.108738	94.71937944	Bacteria	2	Bacteria	Bacteria	900	0	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g36098	i0	98.622	3.09863945578231	508	7	86	0	63	570	519217	519724	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	1822	900	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
8640333	8640333	PRJEB28062_P_NODE_17127_length_915_cov_59.040380_g15183_i0	PRJEB28062	17127	915	59.04038	540.219477	Bacteria	2	Bacteria	Bacteria	1448	0	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g15183	i0	99.011	60.5256830601093	809	7	88	1	19	826	522075	521267	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	55381	1448	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
8640750	8640750	PRJEB28062_P_NODE_51467_length_495_cov_56.770142_g49117_i0	PRJEB28062	51467	495	56.770142	281.0122029	Fervidobacterium	2422	Bacteria	Bacteria	638	2.9199999999999994e-178	NTclustered	gi\|2793121053\|gb\|CP126498.1\|	44754	g49117	i0	100	17.8888888888889	345	0	70	0	24	368	341192	341536	Fervidobacterium gondwanense strain 13770 chromosome, complete genome	blastn	8855	638	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
9915822	9915822	PRJEB28062_P_NODE_57528_length_463_cov_24.694872_g55173_i0	PRJEB28062	57528	463	24.694872	114.33725736	Bacteria	2	Bacteria	Bacteria	749	0	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g55173	i0	98.582	7.14470842332613	423	6	91	0	18	440	521022	520600	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	3308	749	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
11501720	11501720	PRJEB28062_P_NODE_112610_length_279_cov_4.330097_g110247_i0	PRJEB28062	112610	279	4.330097	12.08097063	Kosmotoga olearia	651457	Bacteria	Bacteria	104	6.99e-18	NTclustered	gi\|239505242\|gb\|CP001634.1\|	521045	g110247	i0	82.5	0.666666666666667	120	19	43	2	39	157	647885	647767	Kosmotoga olearia TBF 19.5.1, complete genome	blastn	186	104	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Kosmotoga	Kosmotoga olearia
12779321	12779321	PRJEB28062_P_NODE_92571_length_337_cov_2.314394_g90209_i0	PRJEB28062	92571	337	2.314394	7.79950778	Fervidobacterium pennivorans	93466	Bacteria	Bacteria	473	5.729999999999998e-129	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g90209	i0	97.482	23.6409495548961	278	5	82	2	58	333	1129552	1129275	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	7967	473	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
13741076	13741076	PRJEB28062_P_NODE_53871_length_482_cov_13.193154_g51518_i0	PRJEB28062	53871	482	13.193154	63.59100228	Bacteria	2	Bacteria	Bacteria	809	0	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g51518	i0	99.113	38.7344398340249	451	3	94	1	16	466	288855	288406	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	18670	809	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
14052989	14052989	PRJEB28062_P_NODE_44732_length_538_cov_56.197849_g42393_i0	PRJEB28062	44732	538	56.197849	302.34442762	Fervidobacterium gondwanense	44754	Bacteria	Bacteria	870	0	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g42393	i0	98.193	8.97955390334572	498	9	93	0	23	520	1154148	1154645	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	4831	870	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
16290318	16290318	PRJEB28062_P_NODE_58873_length_457_cov_9.544271_g56514_i0	PRJEB28062	58873	457	9.544271	43.61731847	Bacteria	2	Bacteria	Bacteria	784	0	NTclustered	gi\|2793121053\|gb\|CP126498.1\|	44754	g56514	i0	99.307	66.9409190371991	433	3	95	0	10	442	337379	336947	Fervidobacterium gondwanense strain 13770 chromosome, complete genome	blastn	30592	789	0.993662864385298	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
16290534	16290534	PRJEB28062_P_NODE_8453_length_1347_cov_68.075353_g6983_i0	PRJEB28062	8453	1347	68.075353	916.97500491	Bacteria	2	Bacteria	Bacteria	1286	0	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g6983	i0	98.495	20.6095025983667	731	7	54	4	610	1338	771849	771121	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	27761	1286	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
18838937	18838937	PRJEB28062_P_NODE_16955_length_920_cov_55.579693_g15020_i0	PRJEB28062	16955	920	55.579693	511.3331756	Thermotogae	188708	Bacteria	Bacteria	1075	0	NTclustered	gi\|160359135\|gb\|CP000879.1\|	403833	g15020	i0	98.217	41.6304347826087	617	8	67	3	299	914	470509	469895	Petrotoga mobilis SJ95, complete genome	blastn	38300	1085	0.990783410138249	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Petrotoga	Petrotoga mobilis
18839525	18839525	PRJEB28062_P_NODE_73175_length_400_cov_3.749235_g70813_i0	PRJEB28062	73175	400	3.749235	14.99694	Fervidobacterium	2422	Bacteria	Bacteria	695	0	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g70813	i0	98.005	27.0425	401	7	100	1	1	400	722158	721758	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	10817	695	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
22664073	22664073	PRJEB28062_P_NODE_138458_length_196_cov_5.243902_g136094_i0	PRJEB28062	138458	196	5.243902	10.27804792	Fervidobacterium	2422	Bacteria	Bacteria	298	1.97e-76	NTclustered	gi\|2793121053\|gb\|CP126498.1\|	44754	g136094	i0	98.802	20.9897959183673	167	2	85	0	23	189	341370	341536	Fervidobacterium gondwanense strain 13770 chromosome, complete genome	blastn	4114	298	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
22664110	22664110	PRJEB28062_P_NODE_16678_length_928_cov_99.480702_g14754_i0	PRJEB28062	16678	928	99.480702	923.18091456	Bacteria	2	Bacteria	Bacteria	673	0	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g14754	i0	97.475	26.1551724137931	396	7	85	3	479	873	288213	287820	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	24272	678	0.992625368731563	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
22664565	22664565	PRJEB28062_P_NODE_61678_length_444_cov_60.919137_g59318_i0	PRJEB28062	61678	444	60.919137	270.48096828	Bacteria	2	Bacteria	Bacteria	630	4.3399999999999984e-176	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g59318	i0	97.808	3.1509009009009	365	8	82	0	61	425	519360	519724	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	1399	630	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense

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