metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1186363" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1186363" 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
319696	319696	PRJNA1186363_P_NODE_11321_length_610_cov_1.536313_g10439_i0	PRJNA1186363	11321	610	1.536313	9.3715093	Tenacibaculum maritimum	107401	Bacteria	Bacteria	56.5	0.005	NTclustered	gi\|2863875894\|gb\|CP137255.1\|	107401	g10439	i0	89.362	2.05573770491803	47	2	8	3	116	162	3148241	3148198	Tenacibaculum maritimum strain CCCM 101 chromosome, complete genome	blastn	1254	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	Tenacibaculum maritimum
2870427	2870427	PRJNA1186363_P_NODE_13943_length_536_cov_2.224622_g13059_i0	PRJNA1186363	13943	536	2.224622	11.92397392	Seonamhaeicola sp. ML3	2937786	Bacteria	Bacteria	67.6	1.88e-6	NTclustered	gi\|2235330891\|gb\|CP096884.1\|	2937786	g13059	i0	81.395	0.360074626865672	86	13	15	2	43	125	1586302	1586387	Seonamhaeicola sp. ML3 chromosome, complete genome	blastn	193	67.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Seonamhaeicola	Seonamhaeicola sp. ML3
2870505	2870505	PRJNA1186363_P_NODE_23263_length_382_cov_1.838188_g22375_i0	PRJNA1186363	23263	382	1.838188	7.02187816	Flavobacterium tructae	1114873	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|2801935888\|gb\|CP166110.1\|	1114873	g22375	i0	100	0.0732984293193717	28	0	7	0	245	272	62663	62636	Flavobacterium tructae strain CF-01 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium tructae
4870092	4870092	PRJNA1186363_P_NODE_19144_length_436_cov_1.179063_g18256_i0	PRJNA1186363	19144	436	1.179063	5.14071468	Chitinophagaceae	563835	Bacteria	Bacteria	647	0	NTclustered	gi\|1721657344\|gb\|CP042435.1\|	1813871	g18256	i0	96.203	224.628440366972	395	15	91	0	1	395	1673184	1672790	Panacibacter ginsenosidivorans strain Gsoil1550 chromosome, complete genome	blastn	97938	647	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter ginsenosidivorans
6697646	6697646	PRJNA1186363_P_NODE_29166_length_324_cov_0.928287_g28278_i0	PRJNA1186363	29166	324	0.928287	3.00764988	Tenacibaculum pacificus	3018314	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|2429882145\|gb\|CP115917.1\|	3018314	g28278	i0	96.875	0.0987654320987654	32	0	10	1	273	304	602492	602522	Tenacibaculum sp. 18-2881-A chromosome, complete genome	blastn	32	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	Tenacibaculum pacificus
7972982	7972982	PRJNA1186363_P_NODE_25907_length_354_cov_1.181495_g25019_i0	PRJNA1186363	25907	354	1.181495	4.1824923	Hymenobacter sp. YIM 151858-1	2987688	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2324829864\|gb\|CP110136.1\|	2987688	g25019	i0	96.97	0.0932203389830508	33	1	9	0	31	63	1482569	1482537	Hymenobacter sp. YIM 151858-1 chromosome 1, complete sequence	blastn	33	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. YIM 151858-1
10523494	10523494	PRJNA1186363_P_NODE_38449_length_253_cov_0.866667_g37561_i0	PRJNA1186363	38449	253	0.866667	2.19266751	Hymenobacter cellulosivorans	2932249	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2221893832\|gb\|CP095049.1\|	2932249	g37561	i0	100	0.110671936758893	28	0	11	0	29	56	2395947	2395920	Hymenobacter cellulosivorans strain 5116 S-27 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter cellulosivorans
16896864	16896864	PRJNA1186363_P_NODE_26274_length_351_cov_0.823741_g25386_i0	PRJNA1186363	26274	351	0.823741	2.89133091	Mucilaginibacter sp. 5C4	3048589	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2634156855\|gb\|CP133775.1\|	3048589	g25386	i0	100	0.404558404558405	30	0	9	0	317	346	3601206	3601177	Mucilaginibacter sp. 5C4 chromosome, complete genome	blastn	142	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp. 5C4
18893503	18893503	PRJNA1186363_P_NODE_9195_length_689_cov_1.831169_g8336_i0	PRJNA1186363	9195	689	1.831169	12.61675441	Pseudomonadati	3379134	Bacteria	Bacteria	54.7	0.019	NTclustered	gi\|2487265598\|gb\|CP121685.1\|	3028318	g8336	i0	94.444	0.0943396226415094	36	1	5	1	318	352	1702573	1702538	Olleya sp. YS chromosome, complete genome	blastn	65	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Olleya	Olleya sp. YS

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