metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA177642" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA177642" 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
365489	365489	PRJNA177642_P_NODE_18141_length_164_cov_1.044444_g16916_i0	PRJNA177642	18141	164	1.044444	1.71288816	Elizabethkingia meningoseptica	238	Bacteria	Bacteria	198	1.66e-46	NTclustered	gi\|1154260111\|gb\|CP014338.1\|	238	g16916	i0	88.485	19.6890243902439	165	18	100	1	1	164	2351668	2351832	Elizabethkingia meningoseptica strain KC1913 chromosome, complete genome	blastn	3229	198	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia meningoseptica
365644	365644	PRJNA177642_P_NODE_6741_length_517_cov_2.006148_g5586_i0	PRJNA177642	6741	517	2.006148	10.37178516	Flavobacterium psychrophilum	96345	Bacteria	Bacteria	250	1.67e-61	NTclustered	gi\|1057916935\|gb\|CP012388.1\|	96345	g5586	i0	75.422	324.261121856867	533	101	99	27	3	516	2973427	2972906	Flavobacterium psychrophilum strain Z1, complete genome	blastn	167643	250	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium psychrophilum
3605541	3605541	PRJNA177642_P_NODE_14323_length_214_cov_2.567568_g13098_i0	PRJNA177642	14323	214	2.567568	5.49459552	Emticicia	312278	Bacteria	Bacteria	324	3.62e-84	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g13098	i0	94.366	313.093457943925	213	9	99	3	3	214	717	507	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	67002	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
4192610	4192610	PRJNA177642_P_NODE_17924_length_165_cov_1.036765_g16699_i0	PRJNA177642	17924	165	1.036765	1.71066225	Flavobacterium cyclinae	2895947	Bacteria	Bacteria	243	7.63e-60	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g16699	i0	93.293	10.3151515151515	164	11	99	0	2	165	925331	925494	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	1702	243	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
6157869	6157869	PRJNA177642_P_NODE_18225_length_163_cov_2.119403_g17000_i0	PRJNA177642	18225	163	2.119403	3.45462689	Bacteroidota	976	Bacteria	Bacteria	158	2.8e-34	NTclustered	gi\|2621717819\|emb\|OY776216.1\|	1618115	g17000	i0	88.462	319.239263803681	130	15	82	0	31	160	5528038	5528167	MAG: uncultured Saccharicrinis sp. isolate 1ff51e6b-9ef2-4a18-b850-43072ca9d896 genome assembly, chromosome: 1	blastn	52036	158	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinilabiliaceae	Saccharicrinis	uncultured Saccharicrinis sp.
8018885	8018885	PRJNA177642_P_NODE_18567_length_162_cov_1.082707_g17342_i0	PRJNA177642	18567	162	1.082707	1.75398534	Candidatus Kaistella beijingensis	2820270	Bacteria	Bacteria	289	9.44e-74	NTclustered	gi\|2097156165\|gb\|CP071953.1\|	2820270	g17342	i0	98.765	1	162	2	100	0	1	162	2763432	2763593	Candidatus Kaistella beijingensis strain PM-38 chromosome, complete genome	blastn	162	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Candidatus Kaistella beijingensis
8707833	8707833	PRJNA177642_P_NODE_14687_length_204_cov_1.634286_g13462_i0	PRJNA177642	14687	204	1.634286	3.33394344	Emticicia	312278	Bacteria	Bacteria	294	2.68e-75	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g13462	i0	92.647	23.4754901960784	204	15	100	0	1	204	1304	1507	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	4789	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
9293554	9293554	PRJNA177642_P_NODE_16628_length_171_cov_1.014085_g15403_i0	PRJNA177642	16628	171	1.014085	1.73408535	Chryseobacterium scophthalmum	59733	Bacteria	Bacteria	298	1.67e-76	NTclustered	gi\|2653363380\|gb\|CP142423.1\|	59733	g15403	i0	98.235	3.9766081871345	170	3	99	0	2	171	3128100	3127931	Chryseobacterium scophthalmum strain JUb44 chromosome	blastn	680	298	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium scophthalmum
9293571	9293571	PRJNA177642_P_NODE_17448_length_167_cov_1.014493_g16223_i0	PRJNA177642	17448	167	1.014493	1.69420331	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	305	9.74e-79	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g16223	i0	100	215.808383233533	165	0	99	0	2	166	55310	55474	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	36040	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
10569560	10569560	PRJNA177642_P_NODE_17689_length_166_cov_1.021898_g16464_i0	PRJNA177642	17689	166	1.021898	1.6963506800000001	Bacteroides ovatus	28116	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|2032952970\|gb\|CP072244.1\|	28116	g16464	i0	99.398	8.00602409638554	166	1	100	0	1	166	1632920	1633085	Bacteroides ovatus strain CL06T03C20 chromosome, complete genome	blastn	1329	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides ovatus
11844020	11844020	PRJNA177642_P_NODE_15310_length_190_cov_1.658385_g14085_i0	PRJNA177642	15310	190	1.658385	3.1509315	Bacteroides uniformis	820	Bacteria	Bacteria	350	5.169999999999999e-92	NTclustered	gi\|2884834938\|gb\|CP176641.1\|	820	g14085	i0	100	2.98421052631579	189	0	99	0	2	190	2118809	2118621	Bacteroides uniformis strain SFAD16 chromosome, complete genome	blastn	567	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides uniformis
12533785	12533785	PRJNA177642_P_NODE_19010_length_154_cov_3.312000_g17785_i0	PRJNA177642	19010	154	3.312	5.10048	Bacteroidales	171549	Bacteria	Bacteria	285	1.14e-72	NTclustered	gi\|2290582439\|gb\|CP103096.1\|	817	g17785	i0	100	68.448051948052	154	0	100	0	1	154	3445101	3444948	Bacteroides fragilis strain BFG-634 chromosome	blastn	10541	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides fragilis
14394566	14394566	PRJNA177642_P_NODE_15432_length_187_cov_1.873418_g14207_i0	PRJNA177642	15432	187	1.873418	3.50329166	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	244	2.4599999999999999e-60	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g14207	i0	90.374	424.438502673797	187	16	100	2	1	187	112752	112568	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	79370	244	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3
15668313	15668313	PRJNA177642_P_NODE_16533_length_171_cov_2.028169_g15308_i0	PRJNA177642	16533	171	2.028169	3.46816899	Tellurirhabdus rosea	2674997	Bacteria	Bacteria	185	1.3499999999999997e-42	NTclustered	gi\|2336996033\|gb\|CP111085.1\|	2674997	g15308	i0	86.286	22.9122807017544	175	19	100	4	1	171	255728	255901	Tellurirhabdus rosea strain U15T chromosome, complete genome	blastn	3918	185	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Tellurirhabdus	Tellurirhabdus rosea
15668331	15668331	PRJNA177642_P_NODE_17593_length_166_cov_1.051095_g16368_i0	PRJNA177642	17593	166	1.051095	1.7448177	Spirosoma linguale	108	Bacteria	Bacteria	213	6.03e-51	NTclustered	gi\|283814236\|gb\|CP001769.1\|	504472	g16368	i0	89.759	1.95180722891566	166	17	100	0	1	166	3627144	3627309	Spirosoma linguale DSM 74, complete genome	blastn	324	213	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma linguale
20767020	20767020	PRJNA177642_P_NODE_17117_length_168_cov_1.553957_g15892_i0	PRJNA177642	17117	168	1.553957	2.61064776	Hymenobacter nivis	1850093	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1391209682\|gb\|CP029145.1\|	1850093	g15892	i0	100	0.166666666666667	28	0	17	0	130	157	3947552	3947525	Hymenobacter nivis strain NBRC 111535 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter nivis
20767052	20767052	PRJNA177642_P_NODE_18417_length_163_cov_1.037313_g17192_i0	PRJNA177642	18417	163	1.037313	1.69082019	Cloacibacterium caeni	2004710	Bacteria	Bacteria	283	4.43e-72	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g17192	i0	98.148	4.14723926380368	162	3	99	0	2	163	2205685	2205846	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	676	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
22042095	22042095	PRJNA177642_P_NODE_16458_length_172_cov_1.006993_g15233_i0	PRJNA177642	16458	172	1.006993	1.73202796	Segatella copri	165179	Bacteria	Bacteria	307	2.79e-79	NTclustered	gi\|2784148841\|gb\|CP156891.1\|	165179	g15233	i0	98.837	18.9825581395349	172	2	100	0	1	172	2988388	2988217	Segatella copri strain HDC01 chromosome 1	blastn	3265	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
22042105	22042105	PRJNA177642_P_NODE_16958_length_169_cov_1.028571_g15733_i0	PRJNA177642	16958	169	1.028571	1.73828499	Flavobacterium sp. Sr18	935222	Bacteria	Bacteria	104	3.84e-18	NTclustered	gi\|1818223938\|gb\|CP049329.1\|	935222	g15733	i0	79.73	3.55029585798817	148	26	86	4	16	161	2022240	2022385	Flavobacterium sp. Sr18 chromosome, complete genome	blastn	600	104	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. Sr18
22042117	22042117	PRJNA177642_P_NODE_17638_length_166_cov_1.051095_g16413_i0	PRJNA177642	17638	166	1.051095	1.7448177	Capnocytophaga leadbetteri	327575	Bacteria	Bacteria	285	1.26e-72	NTclustered	gi\|1242560045\|gb\|CP022384.1\|	327575	g16413	i0	97.59	4.39156626506024	166	4	100	0	1	166	2470440	2470275	Capnocytophaga leadbetteri strain H6253 chromosome, complete genome	blastn	729	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga leadbetteri

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