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

9 rows where analysis = "blastn", bioproject = "PRJNA675331" 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
647727	647727	PRJNA675331_P_NODE_8701_length_333_cov_1.380769_g8529_i0	PRJNA675331	8701	333	1.380769	4.59796077	Chitinophaga oryzae	2725414	Bacteria	Bacteria	65.8	4.03e-6	NTclustered	gi\|1832568489\|gb\|CP051205.1\|	2725414	g8529	i0	90	0.396396396396396	50	5	15	0	71	120	4997444	4997493	Chitinophaga oryzae strain 1310 chromosome, complete genome	blastn	132	65.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga oryzae
3198593	3198593	PRJNA675331_P_NODE_10263_length_311_cov_46.273109_g10091_i0	PRJNA675331	10263	311	46.273109	143.90936899	uncultured Bacteroidota bacterium	152509	Bacteria	Bacteria	435	2.47e-117	NTclustered	gi\|698039167\|gb\|KM650332.1\|	152509	g10091	i0	93.836	137.064308681672	292	13	92	1	13	299	779	488	Uncultured Bacteroidetes bacterium clone Pa166_083 16S ribosomal RNA gene, partial sequence	blastn	42627	435	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
3720214	3720214	PRJNA675331_P_NODE_2203_length_618_cov_2.511927_g2037_i0	PRJNA675331	2203	618	2.511927	15.52370886	Candidatus Parvibacillus	2981995	Bacteria	Bacteria	425	3.1299999999999998e-114	NTclustered	gi\|2556922676\|gb\|CP129488.1\|	2202734	g2037	i0	79.556	305.587378640777	631	101	99	23	4	617	3060194	3059575	MAG: Saprospiraceae bacterium isolate cMAG.8 chromosome, complete genome	blastn	188853	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
3720224	3720224	PRJNA675331_P_NODE_5303_length_415_cov_2.026316_g5131_i0	PRJNA675331	5303	415	2.026316	8.4092114	Bacteria	2	Bacteria	Bacteria	756	0	NTclustered	gi\|388541852\|gb\|JQ937370.1\|	512288	g5131	i0	99.518	100.698795180723	415	2	100	0	1	415	439	25	Uncultured Cryomorphaceae bacterium isolate DGGE gel band a-KIN 16S ribosomal RNA gene, partial sequence	blastn	41790	756	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Cryomorphaceae		uncultured Cryomorphaceae bacterium
4475695	4475695	PRJNA675331_P_NODE_11144_length_301_cov_5.333333_g10972_i0	PRJNA675331	11144	301	5.333333	16.05333233	uncultured Flavobacteriia bacterium	212695	Bacteria	Bacteria	457	5.08e-124	NTclustered	gi\|335390855\|gb\|JF947919.1\|	212695	g10972	i0	98.467	96.7940199335548	261	1	86	2	30	289	394	136	Uncultured Flavobacteria bacterium clone Pa18e10 16S ribosomal RNA gene, partial sequence	blastn	29135	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia				uncultured Flavobacteriia bacterium
4996844	4996844	PRJNA675331_P_NODE_10364_length_310_cov_1.552743_g10192_i0	PRJNA675331	10364	310	1.552743	4.8135033	Bacteroidota	976	Bacteria	Bacteria	457	5.25e-124	NTclustered	gi\|2621702112\|emb\|OY760143.1\|	2748031	g10192	i0	93.226	320.970967741936	310	21	100	0	1	310	1474447	1474756	MAG: Paludibacteraceae bacterium isolate 01c8064d-6cbe-49cb-b462-9ef0373b1e27 genome assembly, chromosome: 1	blastn	99501	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae bacterium
11372086	11372086	PRJNA675331_P_NODE_3529_length_499_cov_1.183099_g3358_i0	PRJNA675331	3529	499	1.183099	5.90366401	Haliscomenobacter	2349	Bacteria	Bacteria	588	3.009999999999999e-163	NTclustered	gi\|470488547\|ref\|NR_076877.1\|	2350	g3358	i0	88.73	438.108216432866	488	46	97	9	6	489	366	848	Haliscomenobacter hydrossis strain DSM 1100 23S ribosomal RNA gene, complete sequence	blastn	218616	588	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter hydrossis
19020265	19020265	PRJNA675331_P_NODE_22155_length_244_cov_0.900585_g21983_i0	PRJNA675331	22155	244	0.900585	2.1974274	Fluviicola	332102	Bacteria	Bacteria	401	1.8999999999999998e-107	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g21983	i0	96.68	280.622950819672	241	8	99	0	1	241	1216	1456	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	68472	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
19774566	19774566	PRJNA675331_P_NODE_12236_length_290_cov_1.414747_g12064_i0	PRJNA675331	12236	290	1.414747	4.1027663	Bacteroidales bacterium	2030927	Bacteria	Bacteria	315	3.1e-81	NTclustered	gi\|2621704310\|emb\|OY760906.1\|	2030927	g12064	i0	86.254	344.113793103448	291	39	100	1	1	290	28275	27985	MAG: Bacteroidales bacterium isolate 68ad28d8-9785-4e35-8572-44786b46fd48 genome assembly, chromosome: 1	blastn	99793	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales 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);;