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

9 rows where analysis = "blastn", bioproject = "PRJNA1108487" 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
213437	213437	PRJNA1108487_P_NODE_8461_length_253_cov_0.866667_g8395_i0	PRJNA1108487	8461	253	0.866667	2.19266751	uncultured Marinilabiliaceae bacterium	860784	Bacteria	Bacteria	89.8	1.75e-13	NTclustered	gi\|921059837\|gb\|KP887622.1\|	860784	g8395	i0	94.737	57.0513833992095	57	3	23	0	1	57	1547	1491	Uncultured Marinilabiaceae bacterium clone 797_WTL 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	14434	89.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinilabiliaceae		uncultured Marinilabiliaceae bacterium
4040207	4040207	PRJNA1108487_P_NODE_3044_length_389_cov_5.427215_g2978_i0	PRJNA1108487	3044	389	5.427215	21.11186635	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	104	1.01e-17	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g2978	i0	87.912	4.13624678663239	91	7	23	4	32	120	2303421	2303333	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	1609	104	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3
15048286	15048286	PRJNA1108487_P_NODE_5492_length_303_cov_1.382609_g5426_i0	PRJNA1108487	5492	303	1.382609	4.18930527	Emticicia	312278	Bacteria	Bacteria	499	8.389999999999998e-137	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g5426	i0	96.37	245.257425742574	303	11	100	0	1	303	873	1175	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	74313	499	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
16790599	16790599	PRJNA1108487_P_NODE_9134_length_250_cov_0.881356_g9068_i0	PRJNA1108487	9134	250	0.881356	2.20339	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	95.3	3.71e-15	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g9068	i0	92.537	0.268	67	3	26	2	123	188	1370745	1370680	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	67	95.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3
18065099	18065099	PRJNA1108487_P_NODE_2895_length_398_cov_1.633846_g2829_i0	PRJNA1108487	2895	398	1.633846	6.50270708	Flavobacterium sp.	239	Bacteria	Bacteria	725	0	NTclustered	gi\|1819764890\|gb\|MT160391.1\|	239	g2829	i0	99.497	166.93969849246201	398	2	100	0	1	398	926	1323	Flavobacterium sp. strain FW305-C-10-5 16S ribosomal RNA gene, partial sequence	blastn	66442	725	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
20146938	20146938	PRJNA1108487_P_NODE_1456_length_553_cov_3.377083_g1391_i0	PRJNA1108487	1456	553	3.377083	18.67526899	Saprospiraceae	89374	Bacteria	Bacteria	682	0	NTclustered	gi\|378573745\|gb\|CP002831.1\|	984262	g1391	i0	89.888	234.419529837251	534	49	99	4	15	547	1963818	1963289	Saprospira grandis str. Lewin, complete genome	blastn	129634	684	0.997076023391813	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Saprospira	Saprospira grandis
21422633	21422633	PRJNA1108487_P_NODE_7797_length_260_cov_2.791444_g7731_i0	PRJNA1108487	7797	260	2.791444	7.2577544	Flavobacterium	237	Bacteria	Bacteria	475	1.1899999999999999e-129	NTclustered	gi\|2679314462\|gb\|CP085725.1\|	1176532	g7731	i0	99.615	668.469230769231	260	1	100	0	1	260	5078	5337	Flavobacterium hankyongi strain KTce-4 chromosome, complete genome	blastn	173802	475	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium hankyongi
23165740	23165740	PRJNA1108487_P_NODE_2599_length_420_cov_3.498559_g2533_i0	PRJNA1108487	2599	420	3.498559	14.6939478	uncultured Microscilla sp.	432653	Bacteria	Bacteria	571	2.5099999999999993e-158	NTclustered	gi\|192804281\|emb\|FM175083.1\|	432653	g2533	i0	91.232	97.3642857142857	422	33	100	4	1	420	423	4	Uncultured Microscilla sp. partial 16S rRNA gene, clone BF.S12	blastn	40893	571	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Microscillaceae	Microscilla	uncultured Microscilla sp.
23972882	23972882	PRJNA1108487_P_NODE_10759_length_244_cov_0.912281_g10693_i0	PRJNA1108487	10759	244	0.912281	2.22596564	Emticicia	312278	Bacteria	Bacteria	390	4.11e-104	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g10693	i0	95.492	20.2008196721311	244	11	100	0	1	244	490	247	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	4929	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica

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