metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA1004255" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA1004255" 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
1000963	1000963	PRJNA1004255_S_NODE_7981_length_221_cov_3.146067_g7773_i0	PRJNA1004255	7981	221	3.146067	6.95280807	Hoylesella	2974257	Bacteria	Bacteria	292	1.06e-74	NTclustered	gi\|2127571982\|gb\|CP085926.1\|	28127	g7773	i0	90.498	369.674208144796	221	21	100	0	1	221	209808	210028	Hoylesella buccalis strain FDAARGOS_1588 chromosome, complete genome	blastn	81698	292	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella buccalis
2276076	2276076	PRJNA1004255_S_NODE_122_length_1166_cov_29.617097_g35_i0	PRJNA1004255	122	1166	29.617097	345.33535102	Sediminibacterium	504481	Bacteria	Bacteria	1696	0	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g35	i0	92.912	233.481132075472	1171	76	100	5	1	1166	54677	55845	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	272239	1707	0.993555946104277	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
2703472	2703472	PRJNA1004255_S_NODE_203_length_841_cov_27.121554_g88_i0	PRJNA1004255	203	841	27.121554	228.09226914	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	1136	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g88	i0	91.829	299.859690844233	820	60	97	5	27	841	2977605	2978422	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	252182	1136	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
3551584	3551584	PRJNA1004255_S_NODE_8823_length_212_cov_1.946746_g8615_i0	PRJNA1004255	8823	212	1.946746	4.12710152	Dysgonomonas	156973	Bacteria	Bacteria	263	7.909999999999999e-66	NTclustered	gi\|1821115267\|gb\|CP049857.1\|	2714926	g8615	i0	92.021	500.268867924528	188	14	88	1	26	212	349362	349175	Dysgonomonas sp. HDW5A chromosome, complete genome	blastn	106057	263	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Dysgonomonas	Dysgonomonas sp. HDW5A
3979695	3979695	PRJNA1004255_S_NODE_844_length_476_cov_33.896074_g636_i0	PRJNA1004255	844	476	33.896074	161.34531224	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	728	0	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g636	i0	95.796	218.426470588235	452	18	95	1	1	451	56370	55919	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	103971	728	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
6104141	6104141	PRJNA1004255_S_NODE_3085_length_309_cov_2.887218_g2877_i0	PRJNA1004255	3085	309	2.887218	8.92150362	Pedobacter	84567	Bacteria	Bacteria	532	8.45e-147	NTclustered	gi\|2738722518\|gb\|CP157278.1\|	1503925	g2877	i0	98.35	341.071197411003	303	5	98	0	1	303	2592471	2592773	Pedobacter lusitanus strain NL19 chromosome, complete genome	blastn	105391	532	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter lusitanus
6531398	6531398	PRJNA1004255_S_NODE_12446_length_182_cov_5.517986_g12238_i0	PRJNA1004255	12446	182	5.517986	10.04273452	Sphingobacterium psychroaquaticum	561061	Bacteria	Bacteria	287	3.9e-73	NTclustered	gi\|1601834842\|gb\|CP038029.1\|	561061	g12238	i0	95.055	332.967032967033	182	9	100	0	1	182	27312	27493	Sphingobacterium psychroaquaticum strain SJ-25 chromosome, complete genome	blastn	60600	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium psychroaquaticum
7805827	7805827	PRJNA1004255_S_NODE_4987_length_263_cov_5.222727_g4779_i0	PRJNA1004255	4987	263	5.222727	13.73577201	Hymenobacter canadensis	2999067	Bacteria	Bacteria	387	5.79e-103	NTclustered	gi\|2417460668\|gb\|CP114767.1\|	2999067	g4779	i0	93.462	12.7528517110266	260	17	99	0	1	260	2037006	2037265	Hymenobacter canadensis strain PAMC 29467 chromosome, complete genome	blastn	3354	387	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter canadensis
9928979	9928979	PRJNA1004255_S_NODE_6948_length_233_cov_1.752632_g6740_i0	PRJNA1004255	6948	233	1.752632	4.08363256	Mucilaginibacter	423349	Bacteria	Bacteria	431	2.2899999999999996e-116	NTclustered	gi\|1804505538\|gb\|CP048115.1\|	2703789	g6740	i0	100	2	233	0	100	0	1	233	1409831	1409599	Mucilaginibacter sp. 14171R-50 chromosome, complete genome	blastn	466	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp. 14171R-50
11204271	11204271	PRJNA1004255_S_NODE_18129_length_153_cov_2.136364_g17921_i0	PRJNA1004255	18129	153	2.136364	3.26863692	root	1	Root_unresolved	Root_unresolved	283	4.0799999999999995e-72	NTclustered	gi\|1139267046\|emb\|LT681377.1\|	28132	g17921	i0	100	100	153	0	100	0	1	153	177	25	Prevotella melaninogenica partial 16S rRNA gene, isolate W135N_6791	blastn	15300	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
11631789	11631789	PRJNA1004255_S_NODE_12870_length_180_cov_1.189781_g12662_i0	PRJNA1004255	12870	180	1.189781	2.1416058	Bacteroides sp. CG01	3096000	Bacteria	Bacteria	196	6.67e-46	NTclustered	gi\|2896030615\|gb\|CP178179.1\|	3096000	g12662	i0	88.095	265.761111111111	168	17	92	3	15	180	825494	825660	Bacteroides sp. CG01 chromosome, complete genome	blastn	47837	196	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp. CG01
13754381	13754381	PRJNA1004255_S_NODE_16891_length_158_cov_3.678261_g16683_i0	PRJNA1004255	16891	158	3.678261	5.81165238	Dyadobacter	120831	Bacteria	Bacteria	268	1.1899999999999998e-67	NTclustered	gi\|1768674615\|emb\|LR735258.1\|	538966	g16683	i0	97.468	247.398734177215	158	3	100	1	1	158	3565959	3565803	Dyadobacter sp. 32 isolate Dyadobacter sp. 32 sample 2 genome assembly, chromosome: 1	blastn	39089	270	0.992592592592593	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sp. 32
15028778	15028778	PRJNA1004255_S_NODE_3952_length_285_cov_2.611570_g3744_i0	PRJNA1004255	3952	285	2.61157	7.4429745	Prevotella	838	Bacteria	Bacteria	527	3.59e-145	NTclustered	gi\|965692493\|dbj\|AP014597.1\|	28131	g3744	i0	100	198.364912280702	285	0	100	0	1	285	1259268	1258984	Prevotella intermedia DNA, complete genome, strain: OMA14, chromosome: I	blastn	56534	527	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
15455912	15455912	PRJNA1004255_S_NODE_4593_length_271_cov_2.135965_g4385_i0	PRJNA1004255	4593	271	2.135965	5.78846515	Hymenobacter canadensis	2999067	Bacteria	Bacteria	401	2.1399999999999994e-107	NTclustered	gi\|2417460668\|gb\|CP114767.1\|	2999067	g4385	i0	94.615	214.210332103321	260	13	96	1	1	259	2162627	2162886	Hymenobacter canadensis strain PAMC 29467 chromosome, complete genome	blastn	58051	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter canadensis
16303482	16303482	PRJNA1004255_S_NODE_1793_length_370_cov_6.461774_g1585_i0	PRJNA1004255	1793	370	6.461774	23.9085638	Prevotella	838	Bacteria	Bacteria	267	1.15e-66	NTclustered	gi\|2028832481\|gb\|CP072330.1\|	28137	g1585	i0	80	211.718918918919	370	67	99	7	1	365	70505	70138	Prevotella veroralis strain F0319 chromosome 1, complete sequence	blastn	78336	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella veroralis
16303493	16303493	PRJNA1004255_S_NODE_4273_length_278_cov_2.034043_g4065_i0	PRJNA1004255	4273	278	2.034043	5.65463954	Mucilaginibacter	423349	Bacteria	Bacteria	508	1.26e-139	NTclustered	gi\|1804505538\|gb\|CP048115.1\|	2703789	g4065	i0	99.64	2	278	1	100	0	1	278	1404164	1404441	Mucilaginibacter sp. 14171R-50 chromosome, complete genome	blastn	556	508	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp. 14171R-50
17578795	17578795	PRJNA1004255_S_NODE_11334_length_190_cov_3.836735_g11126_i0	PRJNA1004255	11334	190	3.836735	7.2897965	Cytophaga	978	Bacteria	Bacteria	285	1.4799999999999998e-72	NTclustered	gi\|507148283\|ref\|NR_103089.1\|	985	g11126	i0	93.684	239.768421052632	190	12	100	0	1	190	1149	960	Cytophaga hutchinsonii strain ATCC 33406 23S ribosomal RNA gene, complete sequence	blastn	45556	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Cytophaga	Cytophaga hutchinsonii
18004953	18004953	PRJNA1004255_S_NODE_11075_length_192_cov_3.785235_g10867_i0	PRJNA1004255	11075	192	3.785235	7.2676512	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	270	4.19e-68	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g10867	i0	93.011	240.083333333333	186	11	96	2	1	185	442610	442426	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	46096	270	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
18004969	18004969	PRJNA1004255_S_NODE_13895_length_174_cov_1.435115_g13687_i0	PRJNA1004255	13895	174	1.435115	2.4971001	Dyadobacter sp. NIV53	2861765	Bacteria	Bacteria	322	1.01e-83	NTclustered	gi\|2084058630\|gb\|CP081299.1\|	2861765	g13687	i0	100	414.063218390805	174	0	100	0	1	174	3850917	3850744	Dyadobacter sp. NIV53 chromosome, complete genome	blastn	72047	322	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sp. NIV53
19278795	19278795	PRJNA1004255_S_NODE_15096_length_167_cov_2.653226_g14888_i0	PRJNA1004255	15096	167	2.653226	4.43088742	Flavobacterium psychrophilum	96345	Bacteria	Bacteria	259	7.69e-65	NTclustered	gi\|1057916935\|gb\|CP012388.1\|	96345	g14888	i0	94.611	552.658682634731	167	9	100	0	1	167	2974281	2974447	Flavobacterium psychrophilum strain Z1, complete genome	blastn	92294	259	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium psychrophilum
20127424	20127424	PRJNA1004255_S_NODE_3276_length_303_cov_5.003846_g3068_i0	PRJNA1004255	3276	303	5.003846	15.16165338	Panacibacter	1874621	Bacteria	Bacteria	527	3.8499999999999985e-145	NTclustered	gi\|1721657344\|gb\|CP042435.1\|	1813871	g3068	i0	98.02	260.76897689769	303	6	100	0	1	303	1671274	1671576	Panacibacter ginsenosidivorans strain Gsoil1550 chromosome, complete genome	blastn	79013	527	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter ginsenosidivorans
20554419	20554419	PRJNA1004255_S_NODE_1937_length_360_cov_4.170347_g1729_i0	PRJNA1004255	1937	360	4.170347	15.0132492	Prevotella sp.	59823	Bacteria	Bacteria	311	5.1e-80	NTclustered	gi\|2580284204\|gb\|OR338521.1\|	59823	g1729	i0	82.451	295.688888888889	359	60	99	3	3	360	1665	1309	Prevotella sp. strain k141_12813 hypothetical protein gene, complete cds	blastn	106448	311	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
21403087	21403087	PRJNA1004255_S_NODE_6157_length_244_cov_3.144279_g5949_i0	PRJNA1004255	6157	244	3.144279	7.67204076	Empedobacter	59734	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1750497007\|gb\|CP043634.1\|	247	g5949	i0	100	500.606557377049	244	0	100	0	1	244	228513	228270	Empedobacter brevis strain SE1-3 chromosome, complete genome	blastn	122148	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter brevis
22677821	22677821	PRJNA1004255_S_NODE_2758_length_321_cov_5.039568_g2550_i0	PRJNA1004255	2758	321	5.039568	16.17701328	Empedobacter	59734	Bacteria	Bacteria	577	4.02e-160	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g2550	i0	99.065	323.576323987539	321	3	100	0	1	321	522432	522112	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	103868	582	0.991408934707904	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
22677823	22677823	PRJNA1004255_S_NODE_3418_length_299_cov_5.785156_g3210_i0	PRJNA1004255	3418	299	5.785156	17.29761644	Empedobacter	59734	Bacteria	Bacteria	547	2.9099999999999987e-151	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g3210	i0	99.666	292.250836120401	299	1	100	0	1	299	523531	523233	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	87383	547	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
23105542	23105542	PRJNA1004255_S_NODE_9919_length_202_cov_1.773585_g9711_i0	PRJNA1004255	9919	202	1.773585	3.5826417	Chryseobacterium scophthalmum	59733	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|2653363380\|gb\|CP142423.1\|	59733	g9711	i0	100	468.064356435644	202	0	100	0	1	202	1096502	1096301	Chryseobacterium scophthalmum strain JUb44 chromosome	blastn	94549	374	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium scophthalmum
24379220	24379220	PRJNA1004255_S_NODE_10080_length_200_cov_6.528662_g9872_i0	PRJNA1004255	10080	200	6.528662	13.057324	Prevotella melaninogenica	28132	Bacteria	Bacteria	370	4.22e-98	NTclustered	gi\|2028866082\|gb\|CP072360.1\|	28132	g9872	i0	100	232.64	200	0	100	0	1	200	249893	250092	Prevotella melaninogenica strain F0091 chromosome 1, complete sequence	blastn	46528	370	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
24379236	24379236	PRJNA1004255_S_NODE_12100_length_185_cov_1.450704_g11892_i0	PRJNA1004255	12100	185	1.450704	2.6838024	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	169	1.5e-37	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g11892	i0	86.709	123.248648648649	158	13	85	6	30	183	1237319	1237166	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	22801	169	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
24379259	24379259	PRJNA1004255_S_NODE_2080_length_351_cov_9.577922_g1872_i0	PRJNA1004255	2080	351	9.577922	33.61850622	Empedobacter stercoris	1628248	Bacteria	Bacteria	603	7.299999999999998e-168	NTclustered	gi\|2304450266\|gb\|CP104209.1\|	1628248	g1872	i0	100	422.609686609687	326	0	93	0	1	326	1406851	1407176	Empedobacter stercoris strain SCVM0123 chromosome, complete genome	blastn	148336	603	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter stercoris
25227164	25227164	PRJNA1004255_S_NODE_15880_length_163_cov_2.350000_g15672_i0	PRJNA1004255	15880	163	2.35	3.8305	Dyadobacter	120831	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1768674615\|emb\|LR735258.1\|	538966	g15672	i0	100	256.773006134969	163	0	100	0	1	163	3565478	3565316	Dyadobacter sp. 32 isolate Dyadobacter sp. 32 sample 2 genome assembly, chromosome: 1	blastn	41854	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sp. 32

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