metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA557895" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA557895" 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
536315	536315	PRJNA557895_P_NODE_37061_length_162_cov_0.902655_g36706_i0	PRJNA557895	37061	162	0.902655	1.4623011	Sphingobacterium spiritivorum	258	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|1958211526\|gb\|CP068082.1\|	258	g36706	i0	100	0.518518518518518	28	0	17	0	131	158	385625	385652	Sphingobacterium spiritivorum strain FDAARGOS_1146 chromosome, complete genome	blastn	84	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium spiritivorum
1811367	1811367	PRJNA557895_P_NODE_12142_length_265_cov_0.944444_g11787_i0	PRJNA557895	12142	265	0.944444	2.5027766	Winogradskyella sp. PAMC22761	2762324	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1896702836\|gb\|CP060297.1\|	2762324	g11787	i0	100	0.113207547169811	30	0	11	0	1	30	2721675	2721704	Winogradskyella sp. PAMC22761 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Winogradskyella	Winogradskyella sp. PAMC22761
2403762	2403762	PRJNA557895_P_NODE_3362_length_530_cov_2.076923_g3018_i0	PRJNA557895	3362	530	2.076923	11.0076919	Cloacibacterium	501783	Bacteria	Bacteria	929	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g3018	i0	98.302	430.503773584906	530	9	100	0	1	530	131642	131113	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	228167	929	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
4956375	4956375	PRJNA557895_P_NODE_23944_length_189_cov_1.635714_g23589_i0	PRJNA557895	23944	189	1.635714	3.09149946	Cloacibacterium	501783	Bacteria	Bacteria	344	2.39e-90	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g23589	i0	99.471	527.216931216931	189	1	100	0	1	189	130460	130272	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	99644	344	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
12607324	12607324	PRJNA557895_P_NODE_29130_length_169_cov_1.275000_g28775_i0	PRJNA557895	29130	169	1.275	2.15475	Weeksellaceae	2762318	Bacteria	Bacteria	285	1.28e-72	NTclustered	gi\|1750497007\|gb\|CP043634.1\|	247	g28775	i0	97.041	635.970414201183	169	5	100	0	1	169	228920	229088	Empedobacter brevis strain SE1-3 chromosome, complete genome	blastn	107479	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter brevis
17706289	17706289	PRJNA557895_P_NODE_32254_length_165_cov_1.887931_g31899_i0	PRJNA557895	32254	165	1.887931	3.11508615	Cloacibacterium	501783	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g31899	i0	100	465.666666666667	165	0	100	0	1	165	129639	129475	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	76835	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
18387916	18387916	PRJNA557895_P_NODE_23495_length_191_cov_1.436620_g23140_i0	PRJNA557895	23495	191	1.43662	2.7439442	Blattabacterium cuenoti	1653831	Bacteria	Bacteria	108	3.46e-19	NTclustered	gi\|1403290361\|dbj\|AP014608.1\|	1457030	g23140	i0	90.244	47.7486910994764	82	8	43	0	20	101	418074	417993	Blattabacterium cuenoti STAT DNA, complete genome, strain: STAT	blastn	9120	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Blattabacteriaceae	Blattabacterium	Blattabacterium cuenoti
22213233	22213233	PRJNA557895_P_NODE_30458_length_167_cov_0.864407_g30103_i0	PRJNA557895	30458	167	0.864407	1.44355969	Winogradskyella forsetii	2686077	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1866746736\|gb\|CP053350.1\|	2686077	g30103	i0	100	0.167664670658683	28	0	17	0	117	144	3305451	3305424	Winogradskyella forsetii strain SW133 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Winogradskyella	Winogradskyella forsetii
22805499	22805499	PRJNA557895_P_NODE_23058_length_193_cov_1.416667_g22703_i0	PRJNA557895	23058	193	1.416667	2.73416731	Ornithobacterium	28250	Bacteria	Bacteria	296	6.96e-76	NTclustered	gi\|1560269301\|gb\|CP035107.1\|	28251	g22703	i0	94.301	443.580310880829	193	11	100	0	1	193	365641	365833	Ornithobacterium rhinotracheale strain FARPER-174b chromosome, complete genome	blastn	85611	296	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Ornithobacterium	Ornithobacterium rhinotracheale
24762491	24762491	PRJNA557895_P_NODE_3380_length_528_cov_1.396660_g3036_i0	PRJNA557895	3380	528	1.39666	7.3743648	Weeksellaceae bacterium	2823802	Bacteria	Bacteria	662	0	NTclustered	gi\|2488203225\|emb\|OX460916.1\|	2823802	g3036	i0	91.207	287.030303030303	489	40	99	3	42	528	4890	4403	Weeksellaceae bacterium strain MIP2422 genome assembly, chromosome: MIP2422_c1	blastn	151552	662	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae		Weeksellaceae bacterium
25354605	25354605	PRJNA557895_P_NODE_2660_length_621_cov_2.629371_g2325_i0	PRJNA557895	2660	621	2.629371	16.32839391	Cloacibacterium	501783	Bacteria	Bacteria	1125	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g2325	i0	99.356	474.636070853462	621	4	100	0	1	621	2157700	2158320	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	294749	1125	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense

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