metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA811237" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA811237" 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
3359736	3359736	PRJNA811237_S_NODE_28823_length_166_cov_0.871795_g28583_i0	PRJNA811237	28823	166	0.871795	1.4471797	Spirosoma taeanense	2735870	Bacteria	Bacteria	126	8.08e-25	NTclustered	gi\|1843765704\|gb\|CP053435.1\|	2735870	g28583	i0	87.963	18.6987951807229	108	11	64	2	59	165	830927	831033	Spirosoma taeanense strain TS118 chromosome, complete genome	blastn	3104	126	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma taeanense
12288133	12288133	PRJNA811237_S_NODE_2710_length_441_cov_1.785714_g2470_i0	PRJNA811237	2710	441	1.785714	7.87499874	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	52.8	0.043	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g2470	i0	96.774	0.0702947845804989	31	1	7	0	258	288	2407454	2407424	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	31	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
16111260	16111260	PRJNA811237_S_NODE_33133_length_163_cov_0.894737_g32893_i0	PRJNA811237	33133	163	0.894737	1.45842131	Rufibacter sp. DG15C	1379909	Bacteria	Bacteria	95.3	2.23e-15	NTclustered	gi\|1001988277\|gb\|CP010776.1\|	1379909	g32893	i0	80.153	6.87730061349693	131	23	80	3	19	148	768628	768500	Rufibacter sp. DG15C, complete genome	blastn	1121	95.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Rufibacter	Rufibacter sp. DG15C
17387141	17387141	PRJNA811237_S_NODE_22714_length_180_cov_1.557252_g22474_i0	PRJNA811237	22714	180	1.557252	2.8030536	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	209	8.56e-50	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g22474	i0	90.123	99.2111111111111	162	14	89	2	1	161	2314459	2314619	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	17858	209	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19075222	19075222	PRJNA811237_S_NODE_21835_length_183_cov_1.268657_g21595_i0	PRJNA811237	21835	183	1.268657	2.32164231	Bacteroidota	976	Bacteria	Bacteria	339	1.07e-88	NTclustered	gi\|343201407\|ref\|NR_042133.1\|	984	g21595	i0	100	100	183	0	100	0	1	183	316	134	Pedobacter heparinus strain DSM 2366 16S ribosomal RNA, partial sequence	blastn	18300	339	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter heparinus
21210999	21210999	PRJNA811237_S_NODE_23097_length_179_cov_1.261538_g22857_i0	PRJNA811237	23097	179	1.261538	2.25815302	Hymenobacter sp. APR13	1356852	Bacteria	Bacteria	167	5.189999999999999e-37	NTclustered	gi\|670934364\|gb\|CP006587.1\|	1356852	g22857	i0	85.897	7.40782122905028	156	22	87	0	24	179	2103112	2102957	Hymenobacter sp. APR13, complete genome	blastn	1326	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. APR13
22901167	22901167	PRJNA811237_S_NODE_27238_length_167_cov_1.720339_g26998_i0	PRJNA811237	27238	167	1.720339	2.87296613	Chryseobacterium	59732	Bacteria	Bacteria	303	3.5e-78	NTclustered	gi\|1576720794\|emb\|LR215974.1\|	1141221	g26998	i0	99.401	482.005988023952	167	1	100	0	1	167	1233593	1233427	Chryseobacterium taihuense strain 3012STDY6944375 genome assembly, chromosome: 1	blastn	80495	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taihuense

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