metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA949785" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA949785" 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
3483789	3483789	PRJNA949785_P_NODE_15403_length_252_cov_1.044693_g15206_i0	PRJNA949785	15403	252	1.044693	2.63262636	Antarcticibacterium flavum	2058175	Bacteria	Bacteria	446	8.969999999999998e-121	NTclustered	gi\|1679650456\|gb\|CP040812.1\|	2058175	g15206	i0	99.19	243.543650793651	247	2	98	0	1	247	536217	535971	Antarcticibacterium flavum strain KCTC 52984 chromosome, complete genome	blastn	61373	446	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Antarcticibacterium	Antarcticibacterium flavum
3483798	3483798	PRJNA949785_P_NODE_16203_length_249_cov_0.875000_g16006_i0	PRJNA949785	16203	249	0.875	2.17875	Sphingobacterium thalpophilum	259	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2647208394\|gb\|CP141191.1\|	259	g16006	i0	100	3	249	0	100	0	1	249	244907	244659	Sphingobacterium thalpophilum strain YX-3 chromosome, complete genome	blastn	747	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
7311138	7311138	PRJNA949785_P_NODE_11146_length_308_cov_1.310638_g10949_i0	PRJNA949785	11146	308	1.310638	4.03676504	Thermoflavifilum sp.	1968839	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1919310413\|gb\|CP063141.1\|	1968839	g10949	i0	97.059	0.11038961038961	34	0	11	1	172	204	302638	302605	Thermoflavifilum sp. isolate Bu77 chromosome	blastn	34	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Thermoflavifilum	Thermoflavifilum sp.
8586134	8586134	PRJNA949785_P_NODE_15467_length_251_cov_1.348315_g15270_i0	PRJNA949785	15467	251	1.348315	3.38427065	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	387	5.489999999999998e-103	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g15270	i0	94.422	22.8685258964143	251	14	100	0	1	251	519111	519361	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	5740	387	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
9861161	9861161	PRJNA949785_P_NODE_12368_length_289_cov_1.425926_g12171_i0	PRJNA949785	12368	289	1.425926	4.12092614	Prevotella intermedia	28131	Bacteria	Bacteria	508	1.32e-139	NTclustered	gi\|1276663706\|gb\|CP024723.1\|	28131	g12171	i0	98.606	107.204152249135	287	4	100	0	1	287	1057059	1056773	Prevotella intermedia strain KCOM 2837 chromosome 1, complete sequence	blastn	30982	508	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
9861189	9861189	PRJNA949785_P_NODE_15968_length_250_cov_0.870056_g15771_i0	PRJNA949785	15968	250	0.870056	2.17514	uncultured Bacteroides sp.	162156	Bacteria	Bacteria	78.7	3.74e-10	NTclustered	gi\|2907625629\|emb\|OZ223189.1\|	162156	g15771	i0	97.778	0.18	45	1	18	0	203	247	620895	620939	MAG: uncultured Bacteroides sp. isolate 83517295-f76d-485f-aefc-f1c63b392a70 genome assembly, chromosome: 1	blastn	45	78.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	uncultured Bacteroides sp.
11136783	11136783	PRJNA949785_P_NODE_15169_length_254_cov_1.701657_g14972_i0	PRJNA949785	15169	254	1.701657	4.32220878	Sphingobacterium sp. R2	3112958	Bacteria	Bacteria	470	5.37e-128	NTclustered	gi\|2771686122\|gb\|CP142884.1\|	3112958	g14972	i0	100	13.7913385826772	254	0	100	0	1	254	405749	406002	Sphingobacterium sp. R2 chromosome, complete genome	blastn	3503	470	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium sp. R2
11136832	11136832	PRJNA949785_P_NODE_369_length_1667_cov_5.248432_g322_i0	PRJNA949785	369	1667	5.248432	87.49136144	Flavobacterium faecale	1355330	Bacteria	Bacteria	54.7	0.048	NTclustered	gi\|2922046464\|gb\|CP182943.1\|	1355330	g322	i0	100	0.0173965206958608	29	0	2	0	1609	1637	3558426	3558398	Flavobacterium faecale strain WV33 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium faecale
12412301	12412301	PRJNA949785_P_NODE_18770_length_242_cov_0.911243_g18573_i0	PRJNA949785	18770	242	0.911243	2.20520806	Chitinophaga horti	2920382	Bacteria	Bacteria	246	9.32e-61	NTclustered	gi\|2321485370\|gb\|CP107006.1\|	2920382	g18573	i0	85.356	1.90082644628099	239	33	98	2	5	242	5184287	5184050	Chitinophaga horti strain R8 chromosome, complete genome	blastn	460	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga horti
19113350	19113350	PRJNA949785_P_NODE_15135_length_255_cov_0.895604_g14938_i0	PRJNA949785	15135	255	0.895604	2.2837902	Weeksellaceae	2762318	Bacteria	Bacteria	462	9.03e-126	NTclustered	gi\|1576720794\|emb\|LR215974.1\|	1141221	g14938	i0	99.222	490.43137254902	257	0	100	2	1	255	1233040	1233296	Chryseobacterium taihuense strain 3012STDY6944375 genome assembly, chromosome: 1	blastn	125060	466	0.991416309012876	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taihuense
19113360	19113360	PRJNA949785_P_NODE_16695_length_247_cov_5.258621_g16498_i0	PRJNA949785	16695	247	5.258621	12.98879387	Blattabacterium	34098	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|460838101\|dbj\|AP012548.1\|	1229512	g16498	i0	100	2.23076923076923	29	0	12	0	202	230	538311	538283	Blattabacterium cuenoti BPAA DNA, complete genome	blastn	551	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Blattabacteriaceae	Blattabacterium	Blattabacterium cuenoti
20059822	20059822	PRJNA949785_P_NODE_13396_length_276_cov_1.374384_g13199_i0	PRJNA949785	13396	276	1.374384	3.79329984	Flavobacterium sp. W1B	3394146	Bacteria	Bacteria	339	1.7399999999999995e-88	NTclustered	gi\|2898193883\|gb\|CP178845.1\|	3394146	g13199	i0	89.051	74.6050724637681	274	28	99	2	3	275	3300843	3300571	Flavobacterium sp. W1B chromosome	blastn	20591	339	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. W1B
20059848	20059848	PRJNA949785_P_NODE_15656_length_251_cov_0.865169_g15459_i0	PRJNA949785	15656	251	0.865169	2.17157419	Bacteroides xylanisolvens	371601	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2032857078\|gb\|CP072212.1\|	371601	g15459	i0	100	46.9003984063745	251	0	100	0	1	251	6274265	6274515	Bacteroides xylanisolvens strain CL11T00C41 chromosome, complete genome	blastn	11772	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides xylanisolvens
21335257	21335257	PRJNA949785_P_NODE_15977_length_250_cov_0.870056_g15780_i0	PRJNA949785	15977	250	0.870056	2.17514	Empedobacter falsenii	343874	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g15780	i0	98.8	93.24	250	3	100	0	1	250	492017	492266	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	23310	446	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
21335265	21335265	PRJNA949785_P_NODE_16497_length_248_cov_0.880000_g16300_i0	PRJNA949785	16497	248	0.88	2.1824	Empedobacter brevis	247	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|1750497007\|gb\|CP043634.1\|	247	g16300	i0	99.194	26.6370967741935	248	2	100	0	1	248	3397846	3397599	Empedobacter brevis strain SE1-3 chromosome, complete genome	blastn	6606	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter brevis
22610117	22610117	PRJNA949785_P_NODE_11758_length_298_cov_1.328889_g11561_i0	PRJNA949785	11758	298	1.328889	3.96008922	Hymenobacter sp. 5317J-9	2932250	Bacteria	Bacteria	425	1.42e-114	NTclustered	gi\|2221939013\|gb\|CP095050.1\|	2932250	g11561	i0	92.359	241.852348993289	301	19	99	2	2	298	595588	595288	Hymenobacter sp. 5317J-9 chromosome, complete genome	blastn	72072	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. 5317J-9
24213620	24213620	PRJNA949785_P_NODE_13019_length_281_cov_0.860577_g12822_i0	PRJNA949785	13019	281	0.860577	2.41822137	Cytophagales	768507	Bacteria	Bacteria	350	8.2e-92	NTclustered	gi\|2634447873\|gb\|CP139724.1\|	333140	g12822	i0	89.085	276.103202846975	284	27	100	2	1	281	2112035	2111753	Roseivirga spongicola strain OXR-11 chromosome, complete genome	blastn	77585	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Roseivirgaceae	Roseivirga	Roseivirga spongicola
24213630	24213630	PRJNA949785_P_NODE_14459_length_263_cov_1.068421_g14262_i0	PRJNA949785	14459	263	1.068421	2.80994723	Cytophagales	768507	Bacteria	Bacteria	307	4.6400000000000006e-79	NTclustered	gi\|2333213665\|gb\|CP110973.1\|	332158	g14262	i0	88.077	238.349809885932	260	30	99	1	1	260	2050169	2049911	Larkinella insperata strain LMG22510 chromosome, complete genome	blastn	62686	309	0.993527508090615	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Larkinella	Larkinella insperata

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