metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA640350" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA640350" 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
1155879	1155879	PRJNA640350_P_NODE_40661_length_151_cov_1.491803_g40500_i0	PRJNA640350	40661	151	1.491803	2.25262253	Weeksellaceae	2762318	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g40500	i0	100	5.96026490066225	151	0	100	0	1	151	1620751	1620901	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	900	279	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
1886714	1886714	PRJNA640350_P_NODE_38762_length_154_cov_1.464000_g38601_i0	PRJNA640350	38762	154	1.464	2.25456	Prevotella melaninogenica	28132	Bacteria	Bacteria	279	5.33e-71	NTclustered	gi\|2028866082\|gb\|CP072360.1\|	28132	g38601	i0	99.351	4.81168831168831	154	1	100	0	1	154	1856374	1856527	Prevotella melaninogenica strain F0091 chromosome 1, complete sequence	blastn	741	279	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
2430754	2430754	PRJNA640350_P_NODE_1542_length_664_cov_1.653543_g1434_i0	PRJNA640350	1542	664	1.653543	10.97952552	Weeksellaceae	2762318	Bacteria	Bacteria	296	2.7700000000000003e-75	NTclustered	gi\|2235581928\|gb\|CP075338.1\|	1416779	g1434	i0	100	155.900602409639	160	0	32	0	505	664	2242686	2242527	Epilithonimonas zeae strain ZM18 chromosome, complete genome	blastn	103518	296	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas zeae
2430907	2430907	PRJNA640350_P_NODE_2722_length_539_cov_3.988235_g2590_i0	PRJNA640350	2722	539	3.988235	21.49658665	Weeksellaceae	2762318	Bacteria	Bacteria	270	1.34e-67	NTclustered	gi\|2429074367\|gb\|CP115858.1\|	192389	g2590	i0	99.329	210.43599257885	149	1	52	0	238	386	2628210	2628358	Chryseobacterium daecheongense strain PL22-22A chromosome, complete genome	blastn	113425	270	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense
2431010	2431010	PRJNA640350_P_NODE_36622_length_158_cov_1.069767_g36461_i0	PRJNA640350	36622	158	1.069767	1.69023186	Prevotella	838	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|1373670906\|gb\|CP022040.2\|	28132	g36461	i0	100	13	158	0	100	0	1	158	509981	509824	Prevotella melaninogenica strain FDAARGOS_306 chromosome 1, complete sequence	blastn	2054	292	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
3161451	3161451	PRJNA640350_P_NODE_39083_length_153_cov_2.403226_g38922_i0	PRJNA640350	39083	153	2.403226	3.67693578	Capnocytophaga sputigena	1019	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|1242562181\|gb\|CP022385.1\|	1019	g38922	i0	100	3.96078431372549	153	0	100	0	1	153	2120114	2120266	Capnocytophaga sputigena strain KC1668 chromosome, complete genome	blastn	606	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga sputigena
8263642	8263642	PRJNA640350_P_NODE_23667_length_197_cov_1.642857_g23506_i0	PRJNA640350	23667	197	1.642857	3.23642829	Flavihumibacter fluvii	2838157	Bacteria	Bacteria	182	2.09e-41	NTclustered	gi\|2198886192\|gb\|CP092333.1\|	2838157	g23506	i0	84.324	3.31979695431472	185	29	94	0	7	191	2440244	2440428	Flavihumibacter fluvii strain IMCC34837 chromosome, complete genome	blastn	654	182	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavihumibacter	Flavihumibacter fluvii
10814688	10814688	PRJNA640350_P_NODE_30209_length_172_cov_1.286713_g30048_i0	PRJNA640350	30209	172	1.286713	2.21314636	Cloacibacterium normanense	237258	Bacteria	Bacteria	313	5.989999999999998e-81	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g30048	i0	99.419	8.94186046511628	172	1	100	0	1	172	373917	374088	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1538	313	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
12634575	12634575	PRJNA640350_P_NODE_12630_length_336_cov_1.820847_g12469_i0	PRJNA640350	12630	336	1.820847	6.11804592	Weeksellaceae	2762318	Bacteria	Bacteria	195	4.98e-45	NTclustered	gi\|1966888383\|gb\|CP068486.1\|	250	g12469	i0	99.074	239.806547619048	108	1	55	0	229	336	168226	168119	Chryseobacterium gleum strain FDAARGOS_1103 chromosome	blastn	80575	195	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gleum
13364661	13364661	PRJNA640350_P_NODE_33911_length_163_cov_1.365672_g33750_i0	PRJNA640350	33911	163	1.365672	2.22604536	Prevotella melaninogenica	28132	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2028866082\|gb\|CP072360.1\|	28132	g33750	i0	100	9.89570552147239	163	0	100	0	1	163	67296	67134	Prevotella melaninogenica strain F0091 chromosome 1, complete sequence	blastn	1613	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
16458448	16458448	PRJNA640350_P_NODE_27853_length_179_cov_2.006667_g27692_i0	PRJNA640350	27853	179	2.006667	3.59193393	Capnocytophaga	1016	Bacteria	Bacteria	315	1.75e-81	NTclustered	gi\|2797268018\|gb\|CP162011.1\|	327575	g27692	i0	98.324	19.7094972067039	179	3	100	0	1	179	2018771	2018949	Capnocytophaga leadbetteri strain F0087 isolate D204 chromosome, complete genome	blastn	3528	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga leadbetteri
16458591	16458591	PRJNA640350_P_NODE_5653_length_401_cov_2.577957_g5495_i0	PRJNA640350	5653	401	2.577957	10.33760757	Weeksellaceae	2762318	Bacteria	Bacteria	207	7.75e-49	NTclustered	gi\|2461920362\|gb\|CP119595.1\|	172045	g5495	i0	94.161	247.236907730673	137	7	53	1	4	140	306718	306853	Elizabethkingia miricola strain NW-2-4 chromosome, complete genome	blastn	99142	207	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
18462472	18462472	PRJNA640350_P_NODE_20835_length_216_cov_1.417112_g20674_i0	PRJNA640350	20835	216	1.417112	3.06096192	Prevotella melaninogenica	28132	Bacteria	Bacteria	394	2.75e-105	NTclustered	gi\|2028866082\|gb\|CP072360.1\|	28132	g20674	i0	99.537	149.087962962963	216	1	100	0	1	216	538873	539088	Prevotella melaninogenica strain F0091 chromosome 1, complete sequence	blastn	32203	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
18462484	18462484	PRJNA640350_P_NODE_22055_length_207_cov_1.533708_g21894_i0	PRJNA640350	22055	207	1.533708	3.17477556	Prevotella melaninogenica	28132	Bacteria	Bacteria	372	1.2199999999999997e-98	NTclustered	gi\|2028868916\|gb\|CP072362.1\|	28132	g21894	i0	99.034	13.9951690821256	207	2	100	0	1	207	296464	296258	Prevotella melaninogenica strain F0054 chromosome 2, complete sequence	blastn	2897	372	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
21557684	21557684	PRJNA640350_P_NODE_39717_length_152_cov_2.308943_g39556_i0	PRJNA640350	39717	152	2.308943	3.50959336	Alistipes	239759	Bacteria	Bacteria	106	9.41e-19	NTclustered	gi\|2318925898\|gb\|CP107205.1\|	328813	g39556	i0	92	76.0263157894737	75	6	49	0	29	103	674674	674748	MAG: Alistipes onderdonkii isolate KR001_HAM_0061 chromosome, complete genome	blastn	11556	106	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes onderdonkii
22833195	22833195	PRJNA640350_P_NODE_34518_length_161_cov_3.810606_g34357_i0	PRJNA640350	34518	161	3.810606	6.13507566	Hymenobacter	89966	Bacteria	Bacteria	278	2.03e-70	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g34357	i0	98.718	32.9875776397515	156	2	97	0	3	158	1095274	1095429	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	5311	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
23563088	23563088	PRJNA640350_P_NODE_30439_length_171_cov_2.232394_g30278_i0	PRJNA640350	30439	171	2.232394	3.81739374	uncultured Bacteroidota bacterium	152509	Bacteria	Bacteria	241	2.85e-59	NTclustered	gi\|2874253829\|emb\|OY969813.1\|	152509	g30278	i0	92.308	7.43859649122807	169	13	99	0	3	171	1856555	1856723	MAG: uncultured Bacteroidetes bacterium isolate MFD09671.bin.1.97 genome assembly, chromosome: 1	blastn	1272	241	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota 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);;