metadata: contig_metadata: 14 rows where bioproject = "PRJNA207343" and tax

14 rows where bioproject = "PRJNA207343" 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
366805	366805	PRJNA207343_S_NODE_1_length_19322_cov_37.551620_g0_i0	PRJNA207343	1	19322	37.55162	7255.7240164	Bacteroidaceae bacterium	2212467	Bacteria	Bacteria	1576	0	NR	MBO6253027.1	2212467	g0	i0	80.4	0.155884484007867	1004	156	15.3	6	16204	19155	1	983	MBO6253027.1 PriCT-2 domain-containing protein [Bacteroidaceae bacterium]	diamond	3012	1576	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium
2331302	2331302	PRJNA207343_S_NODE_9002_length_183_cov_1.739726_g8465_i0	PRJNA207343	9002	183	1.739726	3.18369858	Hymenobacter	89966	Bacteria	Bacteria	243	8.619999999999999e-60	NTclustered	gi\|1686076296\|gb\|CP040936.1\|	2584940	g8465	i0	92.353	79.5081967213115	170	13	93	0	9	178	272450	272619	Hymenobacter sp. DG01 chromosome, complete genome	blastn	14550	243	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG01
3606471	3606471	PRJNA207343_S_NODE_7883_length_204_cov_8.538922_g7346_i0	PRJNA207343	7883	204	8.538922	17.41940088	Flavobacteriales	200644	Bacteria	Bacteria	326	9.5e-85	NTclustered	gi\|1540124464\|emb\|LR134441.1\|	266748	g7346	i0	95.61	297.421568627451	205	6	100	3	1	204	1982058	1982260	Chryseobacterium antarcticum strain NCTC13489 genome assembly, chromosome: 1	blastn	60674	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella antarctica
5470389	5470389	PRJNA207343_S_NODE_8725_length_187_cov_1475.060000_g8188_i0	PRJNA207343	8725	187	1475.06	2758.3622	Epilithonimonas sp. UC225_85	3350167	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|2813966234\|gb\|CP170547.1\|	3350167	g8188	i0	100	439.272727272727	187	0	100	0	1	187	2619	2805	Epilithonimonas sp. UC225_85 chromosome, complete genome	blastn	82144	346	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas sp. UC225_85
6744685	6744685	PRJNA207343_S_NODE_9306_length_178_cov_2.851064_g8769_i0	PRJNA207343	9306	178	2.851064	5.07489392	Hymenobacter sp. DG01	2584940	Bacteria	Bacteria	291	2.93e-74	NTclustered	gi\|1686076296\|gb\|CP040936.1\|	2584940	g8769	i0	96.067	320.561797752809	178	7	100	0	1	178	271603	271426	Hymenobacter sp. DG01 chromosome, complete genome	blastn	57060	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG01
8020463	8020463	PRJNA207343_S_NODE_9627_length_173_cov_2.485294_g9090_i0	PRJNA207343	9627	173	2.485294	4.29955862	Bacteroidota bacterium	1898104	Bacteria	Bacteria	224	2.91e-54	NTclustered	gi\|1869352625\|gb\|CP058707.1\|	1898104	g9090	i0	90.23	88.7919075144509	174	14	100	3	1	173	649446	649275	Bacteroidetes bacterium isolate SSA2 chromosome	blastn	15361	224	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
8708516	8708516	PRJNA207343_S_NODE_10167_length_166_cov_1.465116_g9630_i0	PRJNA207343	10167	166	1.465116	2.43209256	Fluviicola	332102	Bacteria	Bacteria	228	2.1499999999999997e-55	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g9630	i0	94.595	319.28313253012	148	6	89	2	10	156	1677	1531	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	53001	228	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
10570930	10570930	PRJNA207343_S_NODE_3789_length_404_cov_2.528610_g3253_i0	PRJNA207343	3789	404	2.52861	10.2155844	Chitinophaga pollutisoli	3133966	Bacteria	Bacteria	267	1.27e-66	NTclustered	gi\|2719394264\|gb\|CP149822.1\|	3133966	g3253	i0	82.736	303.641089108911	307	46	75	7	60	362	4041165	4040862	Chitinophaga pollutisoli strain GPA1 chromosome, complete genome	blastn	122671	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga pollutisoli
12534615	12534615	PRJNA207343_S_NODE_8570_length_190_cov_4.156863_g8033_i0	PRJNA207343	8570	190	4.156863	7.8980397	Fluviicola	332102	Bacteria	Bacteria	278	2.47e-70	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g8033	i0	94.944	501.321052631579	178	8	93	1	4	180	819	642	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	95251	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
12534622	12534622	PRJNA207343_S_NODE_8910_length_184_cov_5.809524_g8373_i0	PRJNA207343	8910	184	5.809524	10.68952416	Polaribacter	52959	Bacteria	Bacteria	285	1.42e-72	NTclustered	gi\|330751977\|emb\|FQ032801.1\|	174711	g8373	i0	95.531	423.630434782609	179	6	97	2	7	184	17405	17228	Uncultured Sphingobacteria bacterium, whole genome shotgun sequence	blastn	77948	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	uncultured Polaribacter sp.
18218538	18218538	PRJNA207343_S_NODE_3695_length_413_cov_2.792553_g3160_i0	PRJNA207343	3695	413	2.792553	11.53324389	Flavihumibacter fluvii	2838157	Bacteria	Bacteria	518	3.26e-142	NTclustered	gi\|2198886192\|gb\|CP092333.1\|	2838157	g3160	i0	89.731	307.239709443099	409	36	98	6	1	406	209836	209431	Flavihumibacter fluvii strain IMCC34837 chromosome, complete genome	blastn	126890	518	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavihumibacter	Flavihumibacter fluvii
22043599	22043599	PRJNA207343_S_NODE_8518_length_191_cov_3.129870_g7981_i0	PRJNA207343	8518	191	3.12987	5.9780517	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	207	3.31e-49	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g7981	i0	88.439	276.068062827225	173	19	91	1	11	183	1075503	1075674	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	52729	207	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
25282083	25282083	PRJNA207343_S_NODE_8760_length_187_cov_2.740000_g8223_i0	PRJNA207343	8760	187	2.74	5.1238	Fluviicola	332102	Bacteria	Bacteria	302	1.44e-77	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g8223	i0	96.196	460.299465240642	184	7	98	0	1	184	1371	1554	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	86076	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
30737343	30737343	PRJNA207343_S_NODE_5594_length_280_cov_5.382716_g5057_i0	PRJNA207343	5594	280	5.382716	15.0716048	Paludibacteraceae bacterium	2748031	Bacteria	Bacteria	49.7	1.29e-5	NR	MBO5013845.1	2748031	g5057	i0	61.1	0.385714285714286	36	14	38.6	0	173	280	4	39	MBO5013845.1 hypothetical protein [Paludibacteraceae bacterium]	diamond	108	49.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae bacterium

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