metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJEB20058" and tax

13 rows where analysis = "blastn", bioproject = "PRJEB20058" 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
7363692	7363692	PRJEB20058_S_NODE_7526_length_204_cov_1.272727_g7488_i0	PRJEB20058	7526	204	1.272727	2.59636308	Bacteria	2	Bacteria	Bacteria	361	2.6e-95	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g7488	i0	99.01	30.5882352941176	202	1	99	1	4	204	288207	288006	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	6240	361	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
13739451	13739451	PRJEB20058_S_NODE_971_length_689_cov_16.003185_g936_i0	PRJEB20058	971	689	16.003185	110.26194465	Bacteria	2	Bacteria	Bacteria	1147	0	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g936	i0	98.323	31.2699564586357	656	7	95	2	24	679	305536	304885	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	21545	1153	0.99479618386817	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
25516427	25516427	PRJEB20058_P_NODE_183817_length_271_cov_59.295238_g180994_i0	PRJEB20058	183817	271	59.295238	160.69009498	Fervidobacterium pennivorans subsp. shakshaketiis	3389975	Bacteria	Bacteria	453	5.830000000000001e-123	NTclustered	gi\|2793129014\|gb\|CP126982.1\|	3389975	g180994	i0	99.597	24.4538745387454	248	1	92	0	1	248	734997	735244	Fervidobacterium pennivorans subsp. shakshaketiis strain GSH chromosome, complete genome	blastn	6627	453	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
25612133	25612133	PRJEB20058_P_NODE_120089_length_364_cov_8.528053_g117273_i0	PRJEB20058	120089	364	8.528053	31.04211292	Bacteria	2	Bacteria	Bacteria	577	4.6099999999999986e-160	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g117273	i0	98.471	29.2582417582418	327	5	90	0	24	350	288529	288855	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	10650	582	0.991408934707904	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
25614385	25614385	PRJEB20058_P_NODE_40449_length_661_cov_64.486667_g37807_i0	PRJEB20058	40449	661	64.486667	426.25686887	Fervidobacterium	2422	Bacteria	Bacteria	523	1.1599999999999999e-143	NTclustered	gi\|2793121053\|gb\|CP126498.1\|	44754	g37807	i0	98.013	10.6293494704992	302	4	46	2	354	655	341537	341238	Fervidobacterium gondwanense strain 13770 chromosome, complete genome	blastn	7026	523	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
25750802	25750802	PRJEB20058_P_NODE_47602_length_609_cov_156.425182_g44895_i0	PRJEB20058	47602	609	156.425182	952.62935838	Fervidobacterium	2422	Bacteria	Bacteria	1038	0	NTclustered	gi\|2793121053\|gb\|CP126498.1\|	44754	g44895	i0	99.648	19.5090311986864	568	2	93	0	22	589	340769	340202	Fervidobacterium gondwanense strain 13770 chromosome, complete genome	blastn	11881	1038	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
25751236	25751236	PRJEB20058_P_NODE_69346_length_500_cov_76.646925_g66575_i0	PRJEB20058	69346	500	76.646925	383.234625	Fervidobacterium	2422	Bacteria	Bacteria	505	3.12e-138	NTclustered	gi\|2793121053\|gb\|CP126498.1\|	44754	g66575	i0	97.01	14.262	301	7	60	2	7	307	341238	341536	Fervidobacterium gondwanense strain 13770 chromosome, complete genome	blastn	7131	505	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
25790417	25790417	PRJEB20058_P_NODE_231307_length_230_cov_5.047337_g228482_i0	PRJEB20058	231307	230	5.047337	11.6088751	Pseudothermotoga thermarum DSM 5	119394	Bacteria	Bacteria	285	1.86e-72	NTclustered	gi\|335364163\|gb\|CP002351.1\|	688269	g228482	i0	94.565	0.8	184	10	80	0	25	208	446521	446338	Pseudothermotoga thermarum DSM 5069 chromosome, complete genome	blastn	184	285	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Pseudothermotoga	Pseudothermotoga thermarum
25885734	25885734	PRJEB20058_P_NODE_224203_length_239_cov_4.061798_g221378_i0	PRJEB20058	224203	239	4.061798	9.70769722	Bacteria	2	Bacteria	Bacteria	381	2.4099999999999995e-101	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g221378	i0	96.537	70.6987447698745	231	7	96	1	1	230	521541	521311	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	16897	381	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
25921013	25921013	PRJEB20058_P_NODE_101180_length_404_cov_14.367347_g98373_i0	PRJEB20058	101180	404	14.367347	58.04408188	Fervidobacterium gondwanense	44754	Bacteria	Bacteria	617	3.05e-172	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g98373	i0	97.26	11.299504950495	365	9	90	1	23	386	1154281	1154645	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	4565	617	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
26022687	26022687	PRJEB20058_P_NODE_37684_length_685_cov_12.094551_g35075_i0	PRJEB20058	37684	685	12.094551	82.84767435	Bacteria	2	Bacteria	Bacteria	1230	0	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g35075	i0	99.41	32.8744525547445	678	4	99	0	1	678	304803	305480	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	22519	1230	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
26062116	26062116	PRJEB20058_P_NODE_219973_length_242_cov_9.607735_g217148_i0	PRJEB20058	219973	242	9.607735	23.2507187	Fervidobacterium nodosum Rt17-B1	381764	Bacteria	Bacteria	396	8.739999999999996e-106	NTclustered	gi\|154152641\|gb\|CP000771.1\|	381764	g217148	i0	98.655	0.921487603305785	223	3	92	0	20	242	262838	262616	Fervidobacterium nodosum Rt17-B1, complete genome	blastn	223	396	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
26065524	26065524	PRJEB20058_P_NODE_68157_length_505_cov_8.015766_g65388_i0	PRJEB20058	68157	505	8.015766	40.4796183	Fervidobacterium pennivorans subsp. shakshaketiis	3389975	Bacteria	Bacteria	832	0	NTclustered	gi\|2793129014\|gb\|CP126982.1\|	3389975	g65388	i0	98.925	12.8633663366337	465	5	92	0	22	486	668630	669094	Fervidobacterium pennivorans subsp. shakshaketiis strain GSH chromosome, complete genome	blastn	6496	832	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans

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