metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA922890" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA922890" 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
898713	898713	PRJNA922890_P_NODE_81001_length_229_cov_0.912500_g80591_i0	PRJNA922890	81001	229	0.9125	2.089625	Chryseobacterium indologenes	253	Bacteria	Bacteria	424	3.76e-114	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g80591	i0	100	20.4978165938865	229	0	100	0	1	229	3815411	3815183	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	4694	424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
1252029	1252029	PRJNA922890_P_NODE_73841_length_233_cov_0.878049_g73431_i0	PRJNA922890	73841	233	0.878049	2.04585417	Bacteroides	816	Bacteria	Bacteria	425	1.07e-114	NTclustered	gi\|2742316049\|gb\|CP119600.1\|	817	g73431	i0	99.571	18.3648068669528	233	1	100	0	1	233	3410210	3410442	Bacteroides fragilis strain MDR_U01 chromosome, complete genome	blastn	4279	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides fragilis
2172954	2172954	PRJNA922890_P_NODE_18702_length_441_cov_2.459677_g18292_i0	PRJNA922890	18702	441	2.459677	10.84717557	Candidatus Ornithobacterium hominis	2497989	Bacteria	Bacteria	606	7.259999999999997e-169	NTclustered	gi\|2502739559\|emb\|OX579588.1\|	2497989	g18292	i0	91.629	338.027210884354	442	32	100	3	1	441	647049	647486	Candidatus Ornithobacterium hominis strain MSHR-COH1 genome assembly, chromosome: 1	blastn	149070	606	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Ornithobacterium	Candidatus Ornithobacterium hominis
2174068	2174068	PRJNA922890_P_NODE_80042_length_230_cov_0.894410_g79632_i0	PRJNA922890	80042	230	0.89441	2.057143	Hymenobacter sp. APR13	1356852	Bacteria	Bacteria	255	1.46e-63	NTclustered	gi\|670934364\|gb\|CP006587.1\|	1356852	g79632	i0	86.842	5.44782608695652	228	30	99	0	3	230	865880	866107	Hymenobacter sp. APR13, complete genome	blastn	1253	255	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. APR13
3449469	3449469	PRJNA922890_P_NODE_74943_length_232_cov_0.895706_g74533_i0	PRJNA922890	74943	232	0.895706	2.07803792	Lacibacter sp. MH-610	3020883	Bacteria	Bacteria	171	5.49e-38	NTclustered	gi\|2865359271\|gb\|CP116002.1\|	3020883	g74533	i0	80.349	0.987068965517241	229	41	98	4	4	230	17990	17764	Lacibacter sp. MH-610 chromosome	blastn	229	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
3803920	3803920	PRJNA922890_P_NODE_26223_length_372_cov_1.656766_g25813_i0	PRJNA922890	26223	372	1.656766	6.16316952	Spirosoma	107	Bacteria	Bacteria	444	4.999999999999999e-120	NTclustered	gi\|1823150813\|gb\|CP050063.1\|	2692134	g25813	i0	88.679	104.282258064516	371	33	99	8	1	370	444744	445106	Spirosoma aureum strain BT328 chromosome, complete genome	blastn	38793	446	0.995515695067265	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma aureum
4727081	4727081	PRJNA922890_P_NODE_72184_length_234_cov_0.872727_g71774_i0	PRJNA922890	72184	234	0.872727	2.04218118	Hymenobacter sp. APR13	1356852	Bacteria	Bacteria	202	1.9699999999999998e-47	NTclustered	gi\|670934364\|gb\|CP006587.1\|	1356852	g71774	i0	82.609	2.42735042735043	230	39	98	1	5	234	813080	812852	Hymenobacter sp. APR13, complete genome	blastn	568	202	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. APR13
6001215	6001215	PRJNA922890_P_NODE_44645_length_291_cov_1.630631_g44235_i0	PRJNA922890	44645	291	1.630631	4.74513621	Hymenobacter sp. NBH84	2596915	Bacteria	Bacteria	331	3.09e-86	NTclustered	gi\|1890948146\|gb\|CP043644.1\|	2596915	g44235	i0	87.415	392.694158075601	294	30	99	5	1	287	44496	44789	Hymenobacter sp. NBH84 chromosome, complete genome	blastn	114274	331	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. NBH84
6001640	6001640	PRJNA922890_P_NODE_67145_length_237_cov_0.869048_g66735_i0	PRJNA922890	67145	237	0.869048	2.05964376	Spirosoma sp. KNUC1025	2894082	Bacteria	Bacteria	339	1.4599999999999998e-88	NTclustered	gi\|2153997481\|gb\|CP087139.1\|	2894082	g66735	i0	92.437	326.236286919831	238	17	100	1	1	237	2585	2348	Spirosoma sp. KNUC1025 chromosome, complete genome	blastn	77318	339	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma sp. KNUC1025
11101938	11101938	PRJNA922890_P_NODE_62709_length_246_cov_1.192090_g62299_i0	PRJNA922890	62709	246	1.19209	2.9325414	Nibribacter ruber	2698458	Bacteria	Bacteria	206	1.61e-48	NTclustered	gi\|1799458161\|gb\|CP047897.1\|	2698458	g62299	i0	82.645	150.784552845528	242	32	98	6	1	241	1504800	1504568	Nibribacter ruber strain BT10 chromosome, complete genome	blastn	37093	206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Nibribacter	Nibribacter ruber
11102058	11102058	PRJNA922890_P_NODE_68609_length_235_cov_1.698795_g68199_i0	PRJNA922890	68609	235	1.698795	3.99216825	Larkinella insperata	332158	Bacteria	Bacteria	429	8.33e-116	NTclustered	gi\|2333213665\|gb\|CP110973.1\|	332158	g68199	i0	99.574	281.285106382979	235	1	100	0	1	235	2050311	2050545	Larkinella insperata strain LMG22510 chromosome, complete genome	blastn	66102	429	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Larkinella	Larkinella insperata
12377669	12377669	PRJNA922890_P_NODE_71850_length_234_cov_0.872727_g71440_i0	PRJNA922890	71850	234	0.872727	2.04218118	Hymenobacter sp. BT18	2835648	Bacteria	Bacteria	329	8.65e-86	NTclustered	gi\|1829874072\|gb\|CP050954.1\|	2835648	g71440	i0	96.482	198.978632478632	199	7	98	0	1	199	1254353	1254551	Hymenobacter sp. BT18 chromosome, complete genome	blastn	46561	329	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BT18
18750408	18750408	PRJNA922890_P_NODE_84695_length_218_cov_3.630872_g84285_i0	PRJNA922890	84695	218	3.630872	7.91530096	Flavobacterium johnsoniae	986	Bacteria	Bacteria	359	1.01e-94	NTclustered	gi\|1735479352\|gb\|CP031763.1\|	986	g84285	i0	96.33	6.8256880733945	218	8	100	0	1	218	5069970	5069753	Flavobacterium johnsoniae strain FJ001 chromosome	blastn	1488	359	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium johnsoniae
20024294	20024294	PRJNA922890_P_NODE_20996_length_416_cov_2.383285_g20586_i0	PRJNA922890	20996	416	2.383285	9.9144656	Larkinella insperata	332158	Bacteria	Bacteria	686	0	NTclustered	gi\|2333213665\|gb\|CP110973.1\|	332158	g20586	i0	96.403	232.276442307692	417	14	100	1	1	416	2050929	2050513	Larkinella insperata strain LMG22510 chromosome, complete genome	blastn	96627	686	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Larkinella	Larkinella insperata
20025228	20025228	PRJNA922890_P_NODE_70096_length_235_cov_0.867470_g69686_i0	PRJNA922890	70096	235	0.86747	2.0385545	Phocaeicola coprophilus	387090	Bacteria	Bacteria	379	8.509999999999998e-101	NTclustered	gi\|1985970415\|gb\|CP069440.1\|	387090	g69686	i0	95.745	553.668085106383	235	10	100	0	1	235	128788	129022	Phocaeicola coprophilus strain FDAARGOS_1220 chromosome, complete genome	blastn	130112	379	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola coprophilus
20025301	20025301	PRJNA922890_P_NODE_73416_length_233_cov_0.878049_g73006_i0	PRJNA922890	73416	233	0.878049	2.04585417	Chryseobacterium gambrini	373672	Bacteria	Bacteria	154	5.56e-33	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g73006	i0	86.806	1.09871244635193	144	12	61	6	93	233	4397948	4397809	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	256	154	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
21300428	21300428	PRJNA922890_P_NODE_65057_length_240_cov_2.730994_g64647_i0	PRJNA922890	65057	240	2.730994	6.5543856	Larkinella insperata	332158	Bacteria	Bacteria	375	1.1299999999999998e-99	NTclustered	gi\|2333213665\|gb\|CP110973.1\|	332158	g64647	i0	94.979	198.758333333333	239	12	99	0	1	239	2049415	2049653	Larkinella insperata strain LMG22510 chromosome, complete genome	blastn	47702	375	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Larkinella	Larkinella insperata
21654200	21654200	PRJNA922890_P_NODE_62777_length_246_cov_0.813559_g62367_i0	PRJNA922890	62777	246	0.813559	2.00135514	Cloacibacterium	501783	Bacteria	Bacteria	339	1.5199999999999998e-88	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g62367	i0	91.498	535.60162601626	247	19	100	2	1	246	130211	130456	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	131758	339	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
25124628	25124628	PRJNA922890_P_NODE_72020_length_234_cov_0.872727_g71610_i0	PRJNA922890	72020	234	0.872727	2.04218118	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	309	1.13e-79	NTclustered	gi\|1869340971\|gb\|CP058703.1\|	2099675	g71610	i0	90.558	2.73931623931624	233	22	99	0	1	233	1470292	1470060	MAG: Cyclobacteriaceae bacterium isolate SSA6 chromosome	blastn	641	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
25124687	25124687	PRJNA922890_P_NODE_75500_length_232_cov_0.883436_g75090_i0	PRJNA922890	75500	232	0.883436	2.04957152	Phocaeicola massiliensis	204516	Bacteria	Bacteria	424	3.82e-114	NTclustered	gi\|2581912160\|emb\|OY726001.1\|	204516	g75090	i0	99.569	1	232	1	100	0	1	232	61203	60972	Phocaeicola massiliensis strain Bacteroides massiliensis TSDC17.2-1.1 genome assembly, plasmid: 27	blastn	232	424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola massiliensis
25478553	25478553	PRJNA922890_P_NODE_51140_length_273_cov_1.093137_g50730_i0	PRJNA922890	51140	273	1.093137	2.98426401	Dyadobacter	120831	Bacteria	Bacteria	359	1.32e-94	NTclustered	gi\|470484375\|ref\|NR_076644.1\|	94254	g50730	i0	91.954	361.245421245421	261	13	95	6	1	258	595	340	Dyadobacter fermentans strain NS114 23S ribosomal RNA gene, complete sequence	blastn	98620	359	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter fermentans

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