metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA998413" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA998413" 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
2254393	2254393	PRJNA998413_S_NODE_3142_length_316_cov_3.849802_g3111_i0	PRJNA998413	3142	316	3.849802	12.16537432	Flavobacterium dauae	1563479	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2557430891\|gb\|CP130821.1\|	1563479	g3111	i0	100	0.0949367088607595	30	0	9	0	47	76	1161438	1161409	Flavobacterium dauae strain TCH3-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium dauae
13732744	13732744	PRJNA998413_S_NODE_9851_length_223_cov_1.575000_g9820_i0	PRJNA998413	9851	223	1.575	3.51225	Flavobacterium cerinum	2502784	Bacteria	Bacteria	379	7.999999999999999e-101	NTclustered	gi\|2279330881\|gb\|CP101751.1\|	2502784	g9820	i0	97.309	1.30044843049327	223	6	100	0	1	223	463261	463483	Flavobacterium cerinum strain C1 chromosome, complete genome	blastn	290	379	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
19125307	19125307	PRJNA998413_S_NODE_5375_length_268_cov_3.697561_g5344_i0	PRJNA998413	5375	268	3.697561	9.90946348	Flavobacterium	237	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|2279330881\|gb\|CP101751.1\|	2502784	g5344	i0	100	623.007462686567	268	0	100	0	1	268	717834	718101	Flavobacterium cerinum strain C1 chromosome, complete genome	blastn	166966	496	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
20105721	20105721	PRJNA998413_S_NODE_5276_length_270_cov_0.971014_g5245_i0	PRJNA998413	5276	270	0.971014	2.6217378	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	350	7.84e-92	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g5245	i0	91.732	280.844444444444	254	17	97	4	18	270	1076632	1076382	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	75828	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
23931573	23931573	PRJNA998413_S_NODE_3299_length_312_cov_1.357430_g3268_i0	PRJNA998413	3299	312	1.35743	4.2351816	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	431	3.21e-116	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g3268	i0	91.64	246.605769230769	311	26	99	0	1	311	786699	786389	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	76941	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis

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