metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1233317" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1233317" and tax_phylum = "Bacteroidota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
335606	335606	PRJNA1233317_S_NODE_12661_length_218_cov_1.150943_g12625_i0	PRJNA1233317	12661	218	1.150943	2.50905574	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	303	4.82e-78	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g12625	i0	95.288	0.876146788990826	191	9	88	0	26	216	2483786	2483976	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	191	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
2886493	2886493	PRJNA1233317_S_NODE_10383_length_241_cov_4.840659_g10347_i0	PRJNA1233317	10383	241	4.840659	11.66598819	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	412	8.64e-111	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g10347	i0	97.51	1.95850622406639	241	6	100	0	1	241	830232	830472	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	472	412	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
2886561	2886561	PRJNA1233317_S_NODE_4163_length_334_cov_4.760000_g4127_i0	PRJNA1233317	4163	334	4.76	15.8984	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	562	1.18e-155	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g4127	i0	97.561	3.75149700598802	328	8	98	0	1	328	3206719	3206392	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	1253	562	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
6150008	6150008	PRJNA1233317_S_NODE_7405_length_281_cov_2.459459_g7369_i0	PRJNA1233317	7405	281	2.459459	6.91107979	Flavobacterium	237	Bacteria	Bacteria	520	5.909999999999999e-143	NTclustered	gi\|1608347023\|gb\|MK757666.1\|	239	g7369	i0	100	116.007117437722	281	0	100	0	1	281	1207	927	Flavobacterium sp. strain 816OP8 16S ribosomal RNA gene, partial sequence	blastn	32598	520	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
7989067	7989067	PRJNA1233317_S_NODE_3287_length_353_cov_4.561224_g3251_i0	PRJNA1233317	3287	353	4.561224	16.10112072	Sphingobacteriaceae bacterium GW460-11-11-14-LB5	1986952	Bacteria	Bacteria	440	6.099999999999998e-119	NTclustered	gi\|1195002891\|gb\|CP021237.1\|	1986952	g3251	i0	89.235	82.5155807365439	353	36	99	2	2	353	4242172	4242523	Sphingobacteriaceae bacterium GW460-11-11-14-LB5, complete genome	blastn	29128	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae		Sphingobacteriaceae bacterium GW460-11-11-14-LB5
9263750	9263750	PRJNA1233317_S_NODE_9628_length_250_cov_3.806283_g9592_i0	PRJNA1233317	9628	250	3.806283	9.5157075	Prevotella melaninogenica	28132	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|2028867418\|gb\|CP072361.1\|	28132	g9592	i0	99.2	34.564	250	2	100	0	1	250	1508714	1508963	Prevotella melaninogenica strain F0054 chromosome 1, complete sequence	blastn	8641	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
10539459	10539459	PRJNA1233317_S_NODE_11189_length_232_cov_4.849711_g11153_i0	PRJNA1233317	11189	232	4.849711	11.25132952	Prevotella intermedia	28131	Bacteria	Bacteria	424	3.82e-114	NTclustered	gi\|1276670087\|gb\|CP024728.1\|	28131	g11153	i0	99.569	279.168103448276	232	1	100	0	1	232	274058	273827	Prevotella intermedia strain KCOM 1949 chromosome 2, complete sequence	blastn	64767	424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
10539460	10539460	PRJNA1233317_S_NODE_11209_length_232_cov_3.526012_g11173_i0	PRJNA1233317	11209	232	3.526012	8.18034784	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	318	1.8499999999999998e-82	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g11173	i0	91.703	0.987068965517241	229	19	99	0	1	229	3210225	3210453	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	229	318	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
13089281	13089281	PRJNA1233317_S_NODE_15431_length_195_cov_4.647059_g15395_i0	PRJNA1233317	15431	195	4.647059	9.06176505	Candidatus Karelsulcia muelleri	336810	Bacteria	Bacteria	62.1	2.8e-5	NTclustered	gi\|2717309477\|emb\|OZ032149.1\|	336810	g15395	i0	97.222	0.184615384615385	36	1	18	0	107	142	226053	226088	Candidatus Karelsulcia muelleri isolate 1d4c07cd-1054-4c54-98f9-64159b4f6ee4 genome assembly, chromosome: 1	blastn	36	62.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales		Candidatus Karelsulcia	Candidatus Karelsulcia muelleri
14364671	14364671	PRJNA1233317_S_NODE_8952_length_259_cov_2.415000_g8916_i0	PRJNA1233317	8952	259	2.415	6.25485	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	425	1.21e-114	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g8916	i0	96.498	3.31274131274131	257	9	99	0	3	259	2949500	2949756	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	858	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
15638573	15638573	PRJNA1233317_S_NODE_2693_length_370_cov_3.829582_g2657_i0	PRJNA1233317	2693	370	3.829582	14.1694534	Capnocytophaga sputigena	1019	Bacteria	Bacteria	684	0	NTclustered	gi\|1242548571\|gb\|CP022379.1\|	1019	g2657	i0	100	4.99459459459459	370	0	100	0	1	370	342684	342315	Capnocytophaga sputigena strain D1179 chromosome, complete genome	blastn	1848	684	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga sputigena
16912750	16912750	PRJNA1233317_S_NODE_5374_length_312_cov_2.652174_g5338_i0	PRJNA1233317	5374	312	2.652174	8.27478288	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	529	1.1099999999999996e-145	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g5338	i0	99.654	88.3717948717949	289	1	93	0	24	312	972801	973089	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	27572	529	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
18187178	18187178	PRJNA1233317_S_NODE_2615_length_372_cov_7.099042_g2579_i0	PRJNA1233317	2615	372	7.099042	26.40843624	Flavobacterium dauae	1563479	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2557430891\|gb\|CP130821.1\|	1563479	g2579	i0	100	0.0806451612903226	30	0	8	0	293	322	1161409	1161438	Flavobacterium dauae strain TCH3-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium dauae
18187223	18187223	PRJNA1233317_S_NODE_795_length_489_cov_6.816279_g759_i0	PRJNA1233317	795	489	6.816279	33.33160431	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	898	0	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g759	i0	99.796	479.01226993865	489	1	100	0	1	489	669937	670425	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	234237	898	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
19461652	19461652	PRJNA1233317_S_NODE_3956_length_338_cov_5.014337_g3920_i0	PRJNA1233317	3956	338	5.014337	16.94845906	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	584	2.539999999999999e-162	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g3920	i0	97.929	444.452662721893	338	6	100	1	1	338	516980	517316	Pedobacter sp. SL55 chromosome	blastn	150225	584	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
24561802	24561802	PRJNA1233317_S_NODE_14300_length_203_cov_3.222222_g14264_i0	PRJNA1233317	14300	203	3.222222	6.54111066	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	326	9.44e-85	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g14264	i0	95.61	332.192118226601	205	6	100	3	1	203	517600	517803	Pedobacter sp. SL55 chromosome	blastn	67435	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
24561887	24561887	PRJNA1233317_S_NODE_9580_length_251_cov_1.906250_g9544_i0	PRJNA1233317	9580	251	1.90625	4.7846875	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	294	3.4200000000000003e-75	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g9544	i0	88.095	3.14342629482072	252	25	100	3	1	251	3760324	3760077	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	789	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3

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