metadata: contig_metadata: 18 rows where bioproject = "PRJEB80557", tax_kingdom = "Thermotogati" and tax

18 rows where bioproject = "PRJEB80557", tax_kingdom = "Thermotogati" 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
3965205	3965205	PRJEB80557_S_NODE_19264_length_216_cov_1.550898_g18868_i0	PRJEB80557	19264	216	1.550898	3.34993968	Fervidobacterium gondwanense	44754	Bacteria	Bacteria	351	1.68e-92	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g18868	i0	98.492	13.8611111111111	199	3	92	0	1	199	1154363	1154561	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	2994	351	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
4824621	4824621	PRJEB80557_S_NODE_29944_length_177_cov_1.210938_g29548_i0	PRJEB80557	29944	177	1.210938	2.14336026	Fervidobacterium	2422	Bacteria	Bacteria	307	2.89e-79	NTclustered	gi\|2793125101\|gb\|CP126499.1\|	2423	g29548	i0	98.837	2.91525423728814	172	2	97	0	1	172	2069885	2069714	Fervidobacterium islandicum strain H-21 chromosome, complete genome	blastn	516	307	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
8649740	8649740	PRJEB80557_S_NODE_3087_length_461_cov_1.978155_g2692_i0	PRJEB80557	3087	461	1.978155	9.11929455	Bacteria	2	Bacteria	Bacteria	691	0	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g2692	i0	97.297	62.9240780911063	407	11	88	0	1	407	521673	521267	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	29008	693	0.997113997113997	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
13749916	13749916	PRJEB80557_S_NODE_17891_length_223_cov_2.229885_g17495_i0	PRJEB80557	17891	223	2.229885	4.97264355	Fervidobacterium	2422	Bacteria	Bacteria	331	2.2700000000000002e-86	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g17495	i0	96.535	31.8654708520179	202	4	90	3	1	200	304758	304958	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	7106	331	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
15024431	15024431	PRJEB80557_S_NODE_23872_length_196_cov_1.408163_g23476_i0	PRJEB80557	23872	196	1.408163	2.75999948	Bacteria	2	Bacteria	Bacteria	357	3.2099999999999996e-94	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g23476	i0	99.49	11	196	1	100	0	1	196	787326	787131	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	2156	357	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
15024462	15024462	PRJEB80557_S_NODE_3252_length_452_cov_1.637717_g2857_i0	PRJEB80557	3252	452	1.637717	7.40248084	Bacteria	2	Bacteria	Bacteria	739	0	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g2857	i0	97.279	30.7610619469027	441	2	95	2	22	452	305648	305208	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	13904	739	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
16299229	16299229	PRJEB80557_S_NODE_25093_length_192_cov_1.615385_g24697_i0	PRJEB80557	25093	192	1.615385	3.1015392	Bacteria	2	Bacteria	Bacteria	113	5.01e-31	NR	MDK2812087.1	2053592	g24697	i0	96.5	1.78125	57	2	89.1	0	22	192	1	57	MDK2812087.1 UDP-glucose 4-epimerase [Petrotoga sp.]	diamond	342	113	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Petrotoga	Petrotoga sp.
16715974	16715974	PRJEB80557_S_NODE_7554_length_325_cov_1.840580_g7158_i0	PRJEB80557	7554	325	1.84058	5.981885	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	499	9.07e-137	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g7158	i0	98.246	21.0461538461538	285	5	88	0	23	307	1218006	1217722	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	6840	499	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
20123056	20123056	PRJEB80557_S_NODE_27476_length_184_cov_1.770370_g27080_i0	PRJEB80557	27476	184	1.77037	3.2574808	Bacteria	2	Bacteria	Bacteria	281	1.84e-71	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g27080	i0	98.148	10.3695652173913	162	2	88	1	23	184	782443	782603	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	1908	281	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
26717265	26717265	PRJEB80557_S_NODE_22441_length_201_cov_2.532895_g22045_i0	PRJEB80557	22441	201	2.532895	5.09111895	Fervidobacterium sp.	1871331	Bacteria	Bacteria	102	5.4499999999999996e-24	NR	MFN3692050.1	1871331	g22045	i0	82.5	0.940298507462687	63	11	94	0	13	201	81	143	MFN3692050.1 hypothetical protein [Fervidobacterium sp.]	diamond	189	102	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
27539903	27539903	PRJEB80557_S_NODE_31484_length_173_cov_1.233871_g31088_i0	PRJEB80557	31484	173	1.233871	2.13459683	Marinitoga litoralis	570855	Bacteria	Bacteria	59.3	1.98e-8	NR	WP_205099561.1	570855	g31088	i0	58	7.04046242774566	50	21	86.7	0	151	2	73	122	WP_205099561.1 ABC transporter ATP-binding protein [Marinitoga litoralis]	diamond	1218	59.3	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga litoralis
27761137	27761137	PRJEB80557_S_NODE_22924_length_199_cov_2.860000_g22528_i0	PRJEB80557	22924	199	2.86	5.6914	Pseudothermotoga lettingae	177758	Bacteria	Bacteria	44.3	0.00169	NR	KUK20993.1	177758	g22528	i0	65.7	0.527638190954774	35	12	52.8	0	106	2	5	39	KUK20993.1 MAG: Paclitaxel/taxanoid biosynthesis susceptibility protein TS1 [Pseudothermotoga lettingae]	diamond	105	44.3	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Pseudothermotoga	Pseudothermotoga lettingae
28834319	28834319	PRJEB80557_S_NODE_11748_length_269_cov_1.540909_g11352_i0	PRJEB80557	11748	269	1.540909	4.14504521	Thermosipho sp. (in: thermotogales)	1968895	Bacteria	Bacteria	45.4	0.00188	NR	MBO8161161.1	1968895	g11352	i0	48.7	0.434944237918216	39	20	43.5	0	152	268	1	39	MBO8161161.1 LysM peptidoglycan-binding domain-containing protein [Thermosipho sp. (in: thermotogales)]	diamond	117	45.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho sp. (in: thermotogales)
28953592	28953592	PRJEB80557_S_NODE_4708_length_393_cov_2.456395_g4312_i0	PRJEB80557	4708	393	2.456395	9.65363235	Bacteria	2	Bacteria	Bacteria	142	9.48e-37	NR	WP_121957787.1	1434328	g4312	i0	54.9	2.7175572519084	113	50	86.3	1	341	3	428	539	WP_121957787.1 amylo-alpha-1,6-glucosidase [Petrotoga sp. 9PWA.NaAc.5.4]	diamond	1068	143	0.993006993006993	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Petrotoga	Petrotoga sp. 9PWA.NaAc.5.4
30027098	30027098	PRJEB80557_S_NODE_9971_length_289_cov_1.941667_g9575_i0	PRJEB80557	9971	289	1.941667	5.61141763	Bacteria	2	Bacteria	Bacteria	107	2.45e-25	NR	WP_103875928.1	28236	g9575	i0	57	5.26297577854671	86	37	89.3	0	8	265	305	390	WP_103875928.1 MULTISPECIES: glycosyltransferase [Petrotoga]	diamond	1521	107	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Petrotoga
30500920	30500920	PRJEB80557_S_NODE_28053_length_182_cov_2.323308_g27657_i0	PRJEB80557	28053	182	2.323308	4.22842056	Thermosipho	2420	Bacteria	Bacteria	83.6	4.88e-17	NR	WP_126994205.1	380685	g27657	i0	75	1.76373626373626	52	13	85.7	0	23	178	213	264	WP_126994205.1 glycosyltransferase family 4 protein [Thermosipho globiformans]	diamond	321	84.3	0.991696322657177	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho globiformans
31709381	31709381	PRJEB80557_S_NODE_8217_length_314_cov_2.343396_g7821_i0	PRJEB80557	8217	314	2.343396	7.35826344	Thermosipho sp. (in: thermotogales)	1968895	Bacteria	Bacteria	74.7	2.08e-14	NR	MBO8160634.1	1968895	g7821	i0	46.8	0.592356687898089	62	33	59.2	0	1	186	82	143	MBO8160634.1 hypothetical protein [Thermosipho sp. (in: thermotogales)]	diamond	186	74.7	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho sp. (in: thermotogales)
32468930	32468930	PRJEB80557_S_NODE_2959_length_468_cov_2.718377_g2565_i0	PRJEB80557	2959	468	2.718377	12.72200436	Thermotoga petrophila	93929	Bacteria	Bacteria	160	2.98e-44	NR	WP_334100517.1	93929	g2565	i0	54.4	2.88461538461538	149	66	94.9	2	11	454	64	211	WP_334100517.1 glycosyltransferase family 4 protein [Thermotoga petrophila]	diamond	1350	160	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga petrophila

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