metadata: contig_metadata: 9 rows where bioproject = "PRJNA763718" and tax

9 rows where bioproject = "PRJNA763718" and tax_clade = "FCB group"

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
3757171	3757171	PRJNA763718_S_NODE_6683_length_169_cov_3.522727_g6475_i0	PRJNA763718	6683	169	3.522727	5.95340863	Flavobacterium	237	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|2243410383\|gb\|CP097434.1\|	907046	g6475	i0	100	380.508875739645	169	0	100	0	1	169	24196	24028	Flavobacterium sp. B183 chromosome	blastn	64306	313	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. B183
6309472	6309472	PRJNA763718_S_NODE_8625_length_151_cov_1.780702_g8417_i0	PRJNA763718	8625	151	1.780702	2.68886002	Flavobacterium	237	Bacteria	Bacteria	274	2.42e-69	NTclustered	gi\|2548195263\|gb\|CP130042.1\|	29533	g8417	i0	99.338	504.105960264901	151	1	100	0	1	151	1416527	1416677	Flavobacterium pectinovorum strain ZE23VCel01 chromosome, complete genome	blastn	76120	274	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium pectinovorum
7122909	7122909	PRJNA763718_S_NODE_4066_length_218_cov_1.773481_g3858_i0	PRJNA763718	4066	218	1.773481	3.86618858	Flavobacterium eburneipallidum	3003263	Bacteria	Bacteria	353	4.72e-93	NTclustered	gi\|2493280413\|gb\|CP114291.2\|	3003263	g3858	i0	95.872	491.701834862385	218	9	100	0	1	218	1345520	1345737	Flavobacterium eburneipallidum strain IMCC36793 chromosome, complete genome	blastn	107191	353	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium eburneipallidum
7122914	7122914	PRJNA763718_S_NODE_4906_length_198_cov_1.372671_g4698_i0	PRJNA763718	4906	198	1.372671	2.71788858	Cloacibacterium	501783	Bacteria	Bacteria	72	9.66e-13	NR	MEN9487606.1	1898104	g4698	i0	55.2	6.09090909090909	67	28	98.5	1	2	196	817	883	MEN9487606.1 hypothetical protein [Bacteroidota bacterium]	diamond	1206	72	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
18595837	18595837	PRJNA763718_S_NODE_4515_length_206_cov_4.260355_g4307_i0	PRJNA763718	4515	206	4.260355	8.7763313	Flavobacterium sp. PS2	3384157	Bacteria	Bacteria	353	4.41e-93	NTclustered	gi\|2872578279\|gb\|CP176426.1\|	3384157	g4307	i0	97.573	537.854368932039	206	5	100	0	1	206	3706795	3707000	Flavobacterium sp. PS2 chromosome	blastn	110798	353	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. PS2
18595850	18595850	PRJNA763718_S_NODE_6715_length_169_cov_1.537879_g6507_i0	PRJNA763718	6715	169	1.537879	2.59901551	Myroides sp. JBRI-B21084	3119977	Bacteria	Bacteria	296	5.9e-76	NTclustered	gi\|2552842630\|gb\|CP120653.1\|	3119977	g6507	i0	98.225	502.786982248521	169	3	100	0	1	169	374597	374429	Myroides sp. JBRI-B21084 chromosome, complete genome	blastn	84971	296	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides sp. JBRI-B21084
25432048	25432048	PRJNA763718_S_NODE_3840_length_225_cov_2.287234_g3632_i0	PRJNA763718	3840	225	2.287234	5.1462765	Flavobacterium	237	Bacteria	Bacteria	405	1.33e-108	NTclustered	gi\|2482055250\|gb\|CP121111.1\|	992289	g3632	i0	99.111	553.124444444444	225	2	100	0	1	225	42168	42392	Flavobacterium nitratireducens strain JCM 17678 chromosome, complete genome	blastn	124453	405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium nitratireducens
28726989	28726989	PRJNA763718_S_NODE_7587_length_160_cov_0.934959_g7379_i0	PRJNA763718	7587	160	0.934959	1.4959344	Flammeovirga yaeyamensis	367791	Bacteria	Bacteria	41.6	0.00663	NR	ACA05074.1	367791	g7379	i0	57.1	0.7875	42	18	78.8	0	126	1	13	54	ACA05074.1 hypothetical protein, partial [Flammeovirga yaeyamensis]	diamond	126	41.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae	Flammeovirga	Flammeovirga yaeyamensis
29326763	29326763	PRJNA763718_S_NODE_3889_length_224_cov_1.465241_g3681_i0	PRJNA763718	3889	224	1.465241	3.28213984	Bacteroidia bacterium	2044936	Bacteria	Bacteria	42.7	0.0299	NR	MBT8260500.1	2044936	g3681	i0	40.9	0.589285714285714	44	26	58.9	0	192	61	28	71	MBT8260500.1 caspase family protein [Bacteroidia bacterium]	diamond	132	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia 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);;