metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA609258" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA609258" and tax_phylum = "Bacteroidota"

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
587960	587960	PRJNA609258_P_NODE_57561_length_245_cov_0.906977_g57176_i0	PRJNA609258	57561	245	0.906977	2.22209365	Cloacibacterium caeni	2004710	Bacteria	Bacteria	387	5.34e-103	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g57176	i0	95.122	5.95510204081633	246	11	100	1	1	245	582942	583187	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	1459	387	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
2422572	2422572	PRJNA609258_P_NODE_55042_length_247_cov_0.896552_g54657_i0	PRJNA609258	55042	247	0.896552	2.21448344	Cloacibacterium	501783	Bacteria	Bacteria	390	4.1699999999999997e-104	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g54657	i0	95.142	5.88663967611336	247	12	100	0	1	247	412946	412700	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1454	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
5691084	5691084	PRJNA609258_P_NODE_42405_length_280_cov_1.468599_g42020_i0	PRJNA609258	42405	280	1.468599	4.1120772	Aureibaculum algae	2584122	Bacteria	Bacteria	291	5.02e-74	NTclustered	gi\|1678494258\|gb\|CP040749.1\|	2584122	g42020	i0	85.357	1	280	41	100	0	1	280	557509	557788	Aureibaculum algae strain 10Alg 115 chromosome, complete genome	blastn	280	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aureibaculum	Aureibaculum algae
6966279	6966279	PRJNA609258_P_NODE_57366_length_245_cov_0.906977_g56981_i0	PRJNA609258	57366	245	0.906977	2.22209365	Cloacibacterium normanense	237258	Bacteria	Bacteria	414	2.45e-111	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g56981	i0	97.143	4.73877551020408	245	7	100	0	1	245	575626	575870	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1161	414	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
8241046	8241046	PRJNA609258_P_NODE_58527_length_244_cov_0.859649_g58142_i0	PRJNA609258	58527	244	0.859649	2.09754356	Hymenobacter canadensis	2999067	Bacteria	Bacteria	122	1.6499999999999995e-23	NTclustered	gi\|2417460668\|gb\|CP114767.1\|	2999067	g58142	i0	79.661	7.2172131147541	177	30	71	6	46	219	252028	251855	Hymenobacter canadensis strain PAMC 29467 chromosome, complete genome	blastn	1761	122	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter canadensis
10792184	10792184	PRJNA609258_P_NODE_57889_length_244_cov_0.912281_g57504_i0	PRJNA609258	57889	244	0.912281	2.22596564	Chryseobacterium carnipullorum	1124835	Bacteria	Bacteria	285	1.99e-72	NTclustered	gi\|1519519019\|gb\|CP033920.1\|	1124835	g57504	i0	88.285	18.0532786885246	239	27	98	1	1	238	1485109	1485347	Chryseobacterium carnipullorum strain G0188 chromosome, complete genome	blastn	4405	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium carnipullorum
12067226	12067226	PRJNA609258_P_NODE_53250_length_249_cov_0.886364_g52865_i0	PRJNA609258	53250	249	0.886364	2.20704636	Elizabethkingia anophelis	1117645	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2269436631\|gb\|CP071542.1\|	1117645	g52865	i0	100	23	249	0	100	0	1	249	1681177	1681425	Elizabethkingia anophelis strain 347-10 chromosome, complete genome	blastn	5727	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
13341777	13341777	PRJNA609258_P_NODE_49971_length_253_cov_0.866667_g49586_i0	PRJNA609258	49971	253	0.866667	2.19266751	Chryseobacterium shandongense	1493872	Bacteria	Bacteria	446	9.01e-121	NTclustered	gi\|1519510996\|gb\|CP033915.1\|	1493872	g49586	i0	98.419	3	253	4	100	0	1	253	1876921	1877173	Chryseobacterium shandongense strain G0207 chromosome, complete genome	blastn	759	446	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium shandongense
14616718	14616718	PRJNA609258_P_NODE_50652_length_252_cov_0.871508_g50267_i0	PRJNA609258	50652	252	0.871508	2.19620016	Bacteroides graminisolvens	477666	Bacteria	Bacteria	394	3.3e-105	NTclustered	gi\|2621703509\|emb\|OY762556.1\|	477666	g50267	i0	94.841	5.99206349206349	252	13	100	0	1	252	1293903	1293652	MAG: Bacteroides graminisolvens isolate c2c85108-0b76-4fb4-8ed9-98fc9390ecb6 genome assembly, chromosome: 1	blastn	1510	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides graminisolvens
17165678	17165678	PRJNA609258_P_NODE_54174_length_248_cov_0.891429_g53789_i0	PRJNA609258	54174	248	0.891429	2.21074392	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	346	9.19e-91	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g53789	i0	93.534	0.935483870967742	232	15	94	0	17	248	868039	867808	Pedobacter sp. SL55 chromosome	blastn	232	346	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
17725264	17725264	PRJNA609258_P_NODE_56994_length_245_cov_0.906977_g56609_i0	PRJNA609258	56994	245	0.906977	2.22209365	Bacteroidota	976	Bacteria	Bacteria	331	2.5400000000000002e-86	NTclustered	gi\|2126046227\|gb\|CP085529.1\|	253	g56609	i0	91.02	24.1183673469388	245	22	100	0	1	245	2368756	2368512	Chryseobacterium indologenes strain 742 chromosome, complete genome	blastn	5909	331	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
20990212	20990212	PRJNA609258_P_NODE_53437_length_249_cov_0.886364_g53052_i0	PRJNA609258	53437	249	0.886364	2.20704636	Hoylesella enoeca	76123	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|953017979\|gb\|CP013195.1\|	76123	g53052	i0	98.394	1	249	4	100	0	1	249	1326451	1326203	Hoylesella enoeca strain F0113 chromosome, complete genome	blastn	249	438	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella enoeca
20990433	20990433	PRJNA609258_P_NODE_60137_length_242_cov_0.923077_g59752_i0	PRJNA609258	60137	242	0.923077	2.23384634	Chryseobacterium daecheongense	192389	Bacteria	Bacteria	176	1.24e-39	NTclustered	gi\|2222664923\|gb\|CP095185.1\|	192389	g59752	i0	82.126	5.78925619834711	207	35	85	2	4	209	993479	993274	Chryseobacterium daecheongense strain F23 chromosome, complete genome	blastn	1401	176	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense
22265048	22265048	PRJNA609258_P_NODE_56298_length_246_cov_0.901734_g55913_i0	PRJNA609258	56298	246	0.901734	2.21826564	Chryseobacterium cucumeris	1813611	Bacteria	Bacteria	278	3.37e-70	NTclustered	gi\|1969464399\|gb\|CP068760.1\|	1813611	g55913	i0	86.992	14.0406504065041	246	32	100	0	1	246	58720	58965	Chryseobacterium cucumeris strain MW-6 chromosome	blastn	3454	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium cucumeris

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