metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA685060" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA685060" 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
13930041	13930041	PRJNA685060_P_NODE_6711_length_368_cov_1.044068_g6621_i0	PRJNA685060	6711	368	1.044068	3.84217024	Paludibacter	346096	Bacteria	Bacteria	158	7.2e-34	NTclustered	gi\|470487156\|ref\|NR_076804.1\|	185300	g6621	i0	84.906	7.28804347826087	159	20	43	4	211	367	869	713	Paludibacter propionicigenes strain WB4 23S ribosomal RNA gene, complete sequence	blastn	2682	158	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae	Paludibacter	Paludibacter propionicigenes
15968840	15968840	PRJNA685060_P_NODE_15973_length_245_cov_0.895349_g15883_i0	PRJNA685060	15973	245	0.895349	2.19360505	Adhaeribacter swui	2086471	Bacteria	Bacteria	281	2.59e-71	NTclustered	gi\|1891112286\|gb\|CP055156.1\|	2086471	g15883	i0	87.449	1.00816326530612	247	27	100	4	1	245	1706545	1706301	Adhaeribacter swui strain KCTC 52873 chromosome, complete genome	blastn	247	281	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter swui
19793103	19793103	PRJNA685060_P_NODE_15456_length_246_cov_0.890173_g15366_i0	PRJNA685060	15456	246	0.890173	2.18982558	Hymenobacter sublimis	2933777	Bacteria	Bacteria	311	3.32e-80	NTclustered	gi\|2230260579\|gb\|CP095848.1\|	2933777	g15366	i0	89.431	4.45934959349593	246	26	100	0	1	246	3535683	3535928	Hymenobacter sublimis strain 5516 S-25 chromosome, complete genome	blastn	1097	311	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sublimis
21578255	21578255	PRJNA685060_P_NODE_15597_length_246_cov_0.890173_g15507_i0	PRJNA685060	15597	246	0.890173	2.18982558	Flavobacterium	237	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|1145600863\|gb\|KX832991.2\|	239	g15507	i0	98.374	99.5650406504065	246	4	100	0	1	246	492	737	Flavobacterium sp. strain 2PKS3051 16S ribosomal RNA gene, partial sequence	blastn	24493	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
23618995	23618995	PRJNA685060_P_NODE_13499_length_251_cov_0.865169_g13409_i0	PRJNA685060	13499	251	0.865169	2.17157419	Chryseobacterium shandongense	1493872	Bacteria	Bacteria	222	1.64e-53	NTclustered	gi\|1519499628\|gb\|CP033914.1\|	1493872	g13409	i0	84.322	2.8207171314741	236	28	91	6	23	251	1633660	1633427	Chryseobacterium shandongense strain G0239 chromosome, complete genome	blastn	708	222	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium shandongense
24128047	24128047	PRJNA685060_P_NODE_9339_length_310_cov_1.729958_g9249_i0	PRJNA685060	9339	310	1.729958	5.3628698	Haliscomenobacter	2349	Bacteria	Bacteria	379	1.17e-100	NTclustered	gi\|470488547\|ref\|NR_076877.1\|	2350	g9249	i0	88.782	415.896774193548	312	31	100	4	1	310	345	654	Haliscomenobacter hydrossis strain DSM 1100 23S ribosomal RNA gene, complete sequence	blastn	128928	379	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter hydrossis

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