metadata: contig_metadata: 16 rows where bioproject = "PRJNA314497" and tax

16 rows where bioproject = "PRJNA314497" 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
2340467	2340467	PRJNA314497_S_NODE_682_length_286_cov_17.568093_g659_i0	PRJNA314497	682	286	17.568093	50.24474598	Thermotoga	2335	Bacteria	Bacteria	505	1.69e-138	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g659	i0	100	17.4510489510489	273	0	95	0	14	286	1124573	1124845	Thermotoga maritima strain Tma100, complete genome	blastn	4991	505	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
3615816	3615816	PRJNA314497_S_NODE_883_length_251_cov_383.617117_g860_i0	PRJNA314497	883	251	383.617117	962.87896367	Thermotoga	2335	Bacteria	Bacteria	309	1.22e-79	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g860	i0	98.295	30.5856573705179	176	3	70	0	76	251	1112539	1112714	Thermotoga maritima strain Tma100, complete genome	blastn	7677	309	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
6168030	6168030	PRJNA314497_S_NODE_1665_length_170_cov_4.425532_g1642_i0	PRJNA314497	1665	170	4.425532	7.5234044	Thermotoga	2335	Bacteria	Bacteria	313	5.91e-81	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g1642	i0	100	10.9117647058824	169	0	99	0	1	169	1478502	1478670	Thermotoga maritima strain Tma100, complete genome	blastn	1855	313	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
8717809	8717809	PRJNA314497_S_NODE_747_length_273_cov_12.672131_g724_i0	PRJNA314497	747	273	12.672131	34.59491763	Thermotoga	2335	Bacteria	Bacteria	503	5.76e-138	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g724	i0	100	10.959706959707	272	0	99	0	2	273	1589412	1589141	Thermotoga maritima strain Tma100, complete genome	blastn	2992	503	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
12543717	12543717	PRJNA314497_S_NODE_550_length_324_cov_12.610169_g527_i0	PRJNA314497	550	324	12.610169	40.85694756	Thermotoga	2335	Bacteria	Bacteria	599	8.67e-167	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g527	i0	100	18.0246913580247	324	0	100	0	1	324	532019	531696	Thermotoga maritima strain Tma100, complete genome	blastn	5840	599	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
16367743	16367743	PRJNA314497_S_NODE_653_length_293_cov_336.007576_g630_i0	PRJNA314497	653	293	336.007576	984.50219768	Thermotoga	2335	Bacteria	Bacteria	379	1.0999999999999998e-100	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g630	i0	97.321	29.4368600682594	224	4	76	2	72	293	504455	504678	Thermotoga maritima strain Tma100, complete genome	blastn	8625	379	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
17642849	17642849	PRJNA314497_S_NODE_674_length_288_cov_353.698842_g651_i0	PRJNA314497	674	288	353.698842	1018.65266496	Thermotoga	2335	Bacteria	Bacteria	377	3.87e-100	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g651	i0	98.598	28.2326388888889	214	2	74	1	76	288	919810	920023	Thermotoga maritima strain Tma100, complete genome	blastn	8131	377	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
18916665	18916665	PRJNA314497_S_NODE_895_length_250_cov_406.357466_g872_i0	PRJNA314497	895	250	406.357466	1015.893665	Thermotoga	2335	Bacteria	Bacteria	305	1.57e-78	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g872	i0	100	30.368	165	0	66	0	1	165	310196	310032	Thermotoga maritima strain Tma100, complete genome	blastn	7592	305	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
20191291	20191291	PRJNA314497_S_NODE_516_length_335_cov_279.101307_g493_i0	PRJNA314497	516	335	279.101307	934.98937845	Thermotoga	2335	Bacteria	Bacteria	464	3.4199999999999996e-126	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g493	i0	99.606	25.6208955223881	254	1	76	0	82	335	1827475	1827222	Thermotoga maritima strain Tma100, complete genome	blastn	8583	464	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
20191292	20191292	PRJNA314497_S_NODE_856_length_256_cov_3.277533_g833_i0	PRJNA314497	856	256	3.277533	8.39048448	Thermotoga	2335	Bacteria	Bacteria	473	4.189999999999999e-129	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g833	i0	100	10.28125	256	0	100	0	1	256	503563	503818	Thermotoga maritima strain Tma100, complete genome	blastn	2632	473	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
20191293	20191293	PRJNA314497_S_NODE_996_length_233_cov_21.950980_g973_i0	PRJNA314497	996	233	21.95098	51.1457834	Thermotoga	2335	Bacteria	Bacteria	387	5.03e-103	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g973	i0	100	46.2961373390558	209	0	90	0	1	209	1827016	1827224	Thermotoga maritima strain Tma100, complete genome	blastn	10787	387	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
22742041	22742041	PRJNA314497_S_NODE_978_length_236_cov_4.009662_g955_i0	PRJNA314497	978	236	4.009662	9.46280232	Thermotoga	2335	Bacteria	Bacteria	436	4.999999999999999e-118	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g955	i0	100	9.99576271186441	236	0	100	0	1	236	503355	503590	Thermotoga maritima strain Tma100, complete genome	blastn	2359	436	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
24017057	24017057	PRJNA314497_S_NODE_1639_length_171_cov_4.450704_g1616_i0	PRJNA314497	1639	171	4.450704	7.61070384	Thermotoga	2335	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g1616	i0	100	11	171	0	100	0	1	171	494656	494826	Thermotoga maritima strain Tma100, complete genome	blastn	1881	316	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
24017059	24017059	PRJNA314497_S_NODE_679_length_287_cov_5.980620_g656_i0	PRJNA314497	679	287	5.98062	17.1643794	Thermotoga	2335	Bacteria	Bacteria	531	2.799999999999999e-146	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g656	i0	100	12.205574912892	287	0	100	0	1	287	503808	504094	Thermotoga maritima strain Tma100, complete genome	blastn	3503	531	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
25291344	25291344	PRJNA314497_S_NODE_800_length_264_cov_4.302128_g777_i0	PRJNA314497	800	264	4.302128	11.35761792	Thermotoga	2335	Bacteria	Bacteria	484	2.0099999999999994e-132	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g777	i0	100	10.7234848484848	262	0	99	0	1	262	502877	503138	Thermotoga maritima strain Tma100, complete genome	blastn	2831	484	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima
25291345	25291345	PRJNA314497_S_NODE_900_length_250_cov_3.434389_g877_i0	PRJNA314497	900	250	3.434389	8.5859725	Thermotoga	2335	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|811641277\|gb\|CP011108.1\|	2336	g877	i0	100	9.992	250	0	100	0	1	250	503116	503365	Thermotoga maritima strain Tma100, complete genome	blastn	2498	462	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga maritima

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