metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA1010780" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA1010780" 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
1001556	1001556	PRJNA1010780_S_NODE_55521_length_163_cov_1.695312_g54232_i0	PRJNA1010780	55521	163	1.695312	2.76335856	Chryseobacterium	59732	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|2039848361\|gb\|CP074372.1\|	253	g54232	i0	98.773	98.2883435582822	163	2	100	0	1	163	3898073	3897911	Chryseobacterium indologenes strain PgBE177 chromosome, complete genome	blastn	16021	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
2276725	2276725	PRJNA1010780_S_NODE_56302_length_161_cov_3.047619_g55013_i0	PRJNA1010780	56302	161	3.047619	4.90666659	Weeksellaceae	2762318	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|1966888383\|gb\|CP068486.1\|	250	g55013	i0	100	349.534161490683	161	0	100	0	1	161	168979	169139	Chryseobacterium gleum strain FDAARGOS_1103 chromosome	blastn	56275	298	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gleum
4829548	4829548	PRJNA1010780_S_NODE_40204_length_206_cov_1.777778_g38915_i0	PRJNA1010780	40204	206	1.777778	3.66222268	Weeksellaceae	2762318	Bacteria	Bacteria	381	2.0199999999999994e-101	NTclustered	gi\|2831273061\|gb\|CP171011.1\|	1118202	g38915	i0	100	34.9077669902913	206	0	100	0	1	206	347185	347390	Cruoricaptor ignavus strain WGS2074 chromosome, complete genome	blastn	7191	381	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cruoricaptor	Cruoricaptor ignavus
5257997	5257997	PRJNA1010780_S_NODE_26985_length_294_cov_2.119691_g25696_i0	PRJNA1010780	26985	294	2.119691	6.23189154	Aureispira sp. CCB-E	3051121	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2575713897\|gb\|CP133671.1\|	3051121	g25696	i0	100	0.0952380952380952	28	0	10	0	29	56	3563998	3564025	Aureispira sp. CCB-E chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Aureispira	Aureispira sp. CCB-E
5258042	5258042	PRJNA1010780_S_NODE_36825_length_221_cov_2.075269_g35536_i0	PRJNA1010780	36825	221	2.075269	4.58634449	Christiangramia sp. LLG6405-1	3160832	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2858555897\|gb\|CP159330.1\|	3160832	g35536	i0	100	0.126696832579186	28	0	13	0	4	31	629248	629275	Christiangramia sp. LLG6405-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Christiangramia	Christiangramia sp. LLG6405-1
7807625	7807625	PRJNA1010780_S_NODE_21827_length_366_cov_1.169184_g20538_i0	PRJNA1010780	21827	366	1.169184	4.27921344	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	660	0	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g20538	i0	99.18	99.9180327868852	366	3	100	0	1	366	3585492	3585857	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	36570	660	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
9082710	9082710	PRJNA1010780_S_NODE_50468_length_174_cov_1.568345_g49179_i0	PRJNA1010780	50468	174	1.568345	2.7289203	Chryseobacterium capnotolerans	2759528	Bacteria	Bacteria	76.8	8.69e-10	NTclustered	gi\|2169822356\|gb\|CP065589.1\|	2759528	g49179	i0	89.831	0.339080459770115	59	6	34	0	5	63	3033115	3033173	Chryseobacterium capnotolerans isolate DH-B6 chromosome, complete genome	blastn	59	76.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium capnotolerans
9082743	9082743	PRJNA1010780_S_NODE_58688_length_157_cov_1.959016_g57399_i0	PRJNA1010780	58688	157	1.959016	3.07565512	Marinilabiliaceae bacterium	2053574	Bacteria	Bacteria	80.5	5.94e-11	NTclustered	gi\|2621704345\|emb\|OY760941.1\|	2053574	g57399	i0	82	0.636942675159236	100	12	64	4	54	153	2639691	2639598	MAG: Marinilabiliaceae bacterium isolate 2264d8ac-961e-4ead-949a-d386559d349b genome assembly, chromosome: 1	blastn	100	80.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinilabiliaceae		Marinilabiliaceae bacterium
9082751	9082751	PRJNA1010780_S_NODE_60708_length_154_cov_1.512605_g59419_i0	PRJNA1010780	60708	154	1.512605	2.3294117	Chryseobacterium sp. PMSZPI	1033900	Bacteria	Bacteria	279	5.33e-71	NTclustered	gi\|2894512347\|gb\|CP178384.1\|	1033900	g59419	i0	99.351	99.974025974026	154	1	100	0	1	154	2655872	2656025	Chryseobacterium sp. PMSZPI chromosome, complete genome	blastn	15396	279	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. PMSZPI
10358296	10358296	PRJNA1010780_S_NODE_41749_length_200_cov_2.018182_g40460_i0	PRJNA1010780	41749	200	2.018182	4.036364	Formosa sp. L2A11	2686363	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|1787406671\|gb\|CP047028.1\|	2686363	g40460	i0	100	0.14	28	0	14	0	81	108	1250025	1249998	Formosa sp. L2A11 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Formosa	Formosa sp. L2A11
11633731	11633731	PRJNA1010780_S_NODE_31950_length_250_cov_1.837209_g30661_i0	PRJNA1010780	31950	250	1.837209	4.5930225	Bacteroides helcogenes	290053	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|319414919\|gb\|CP002352.1\|	693979	g30661	i0	100	0.228	29	0	12	0	93	121	648138	648166	Bacteroides helcogenes P 36-108, complete genome	blastn	57	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides helcogenes
12480371	12480371	PRJNA1010780_S_NODE_49610_length_176_cov_1.574468_g48321_i0	PRJNA1010780	49610	176	1.574468	2.77106368	Pedobacter	84567	Bacteria	Bacteria	303	3.71e-78	NTclustered	gi\|1272249552\|gb\|CP024091.1\|	363852	g48321	i0	97.727	408.676136363636	176	4	100	0	1	176	49899	49724	Pedobacter ginsengisoli strain T01R-27 chromosome, complete genome	blastn	71927	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter ginsengisoli
12908785	12908785	PRJNA1010780_S_NODE_24891_length_318_cov_3.816254_g23602_i0	PRJNA1010780	24891	318	3.816254	12.13568772	Blattabacterium punctulatus	164514	Bacteria	Bacteria	159	1.7099999999999996e-34	NTclustered	gi\|1402102991\|gb\|CP029810.1\|	164514	g23602	i0	77.852	113.833333333333	298	38	88	23	12	291	285141	284854	Blattabacterium punctulatus strain CPUsm chromosome, complete genome	blastn	36199	159	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Blattabacteriaceae	Blattabacterium	Blattabacterium punctulatus
12908839	12908839	PRJNA1010780_S_NODE_36831_length_221_cov_2.032258_g35542_i0	PRJNA1010780	36831	221	2.032258	4.49129018	Candidatus Pseudobacter hemicellulosilyticus	3121375	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2457544586\|gb\|CP119311.1\|	3121375	g35542	i0	96.774	0.14027149321267	31	1	14	0	172	202	5301902	5301872	MAG: Candidatus Pseudobacter hemicellulosilyticus isolate MAG_7 chromosome, complete genome	blastn	31	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudobacter	Candidatus Pseudobacter hemicellulosilyticus
14183784	14183784	PRJNA1010780_S_NODE_33592_length_239_cov_1.901961_g32303_i0	PRJNA1010780	33592	239	1.901961	4.54568679	Parabacteroides absconsus	2951805	Bacteria	Bacteria	206	1.5599999999999994e-48	NTclustered	gi\|2695680047\|gb\|CP146284.1\|	2951805	g32303	i0	82.231	234.589958158996	242	39	100	4	1	239	3664204	3663964	Parabacteroides absconsus strain AD58 chromosome, complete genome	blastn	56067	206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides absconsus
16732017	16732017	PRJNA1010780_S_NODE_30614_length_260_cov_2.182222_g29325_i0	PRJNA1010780	30614	260	2.182222	5.6737772	Flavobacterium sp. MDT1-60	1979344	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1913467924\|gb\|CP062159.1\|	1979344	g29325	i0	100	0.107692307692308	28	0	11	0	56	83	4056026	4055999	Flavobacterium sp. MDT1-60 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. MDT1-60
16732121	16732121	PRJNA1010780_S_NODE_5794_length_1114_cov_3.489342_g5223_i0	PRJNA1010780	5794	1114	3.489342	38.87126988	Flavobacterium pectinovorum	29533	Bacteria	Bacteria	54.7	0.032	NTclustered	gi\|2548195263\|gb\|CP130042.1\|	29533	g5223	i0	100	0.026032315978456	29	0	3	0	455	483	4250754	4250782	Flavobacterium pectinovorum strain ZE23VCel01 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium pectinovorum
18006910	18006910	PRJNA1010780_S_NODE_36995_length_220_cov_2.367568_g35706_i0	PRJNA1010780	36995	220	2.367568	5.2086496	Leeuwenhoekiella obamensis	3119018	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2679193633\|dbj\|AP029251.1\|	3119018	g35706	i0	96.875	0.145454545454545	32	1	15	0	12	43	1808225	1808256	Leeuwenhoekiella sp. FRT2 DNA, complete genome	blastn	32	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Leeuwenhoekiella	Leeuwenhoekiella obamensis
18006938	18006938	PRJNA1010780_S_NODE_45175_length_188_cov_2.254902_g43886_i0	PRJNA1010780	45175	188	2.254902	4.2392157600000004	uncultured Sunxiuqinia sp.	1573825	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2907625748\|emb\|OZ223308.1\|	1573825	g43886	i0	100	0.148936170212766	28	0	15	0	105	132	549756	549783	MAG: uncultured Sunxiuqinia sp. isolate ca0ff389-0d66-4f98-8792-5b2e3713dedf genome assembly, chromosome: 2	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae	Sunxiuqinia	uncultured Sunxiuqinia sp.
18006939	18006939	PRJNA1010780_S_NODE_45615_length_187_cov_1.625000_g44326_i0	PRJNA1010780	45615	187	1.625	3.03875	Chryseobacterium lactis	1241981	Bacteria	Bacteria	339	1.1e-88	NTclustered	gi\|1519559429\|gb\|CP033925.1\|	1241981	g44326	i0	100	498.149732620321	183	0	98	0	1	183	603521	603339	Chryseobacterium lactis strain G0197 chromosome, complete genome	blastn	93154	339	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium lactis
19280719	19280719	PRJNA1010780_S_NODE_48696_length_178_cov_2.335664_g47407_i0	PRJNA1010780	48696	178	2.335664	4.15748192	Fulvivirga ulvae	2904245	Bacteria	Bacteria	99	1.91e-16	NTclustered	gi\|2174454039\|gb\|CP089981.1\|	2904245	g47407	i0	85.87	27.7303370786517	92	13	52	0	72	163	3357158	3357249	Fulvivirga ulvae strain SS9-22 chromosome, complete genome	blastn	4936	99	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Fulvivirga	Fulvivirga ulvae
19280748	19280748	PRJNA1010780_S_NODE_57576_length_159_cov_1.951613_g56287_i0	PRJNA1010780	57576	159	1.951613	3.10306467	Chryseobacterium gambrini	373672	Bacteria	Bacteria	289	9.22e-74	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g56287	i0	99.371	97.3270440251572	159	1	100	0	1	159	3373215	3373373	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	15475	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
21831877	21831877	PRJNA1010780_S_NODE_26558_length_298_cov_15.019011_g25269_i0	PRJNA1010780	26558	298	15.019011	44.75665278	Epilithonimonas sp. UC225_85	3350167	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2813966234\|gb\|CP170547.1\|	3350167	g25269	i0	100	0.0939597315436242	28	0	9	0	158	185	557828	557801	Epilithonimonas sp. UC225_85 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas sp. UC225_85
21831981	21831981	PRJNA1010780_S_NODE_51318_length_172_cov_1.547445_g50029_i0	PRJNA1010780	51318	172	1.547445	2.6616054	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g50029	i0	100	99.8488372093023	172	0	100	0	1	172	3584893	3584722	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	17174	318	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
22678343	22678343	PRJNA1010780_S_NODE_15718_length_517_cov_6.004149_g14490_i0	PRJNA1010780	15718	517	6.004149	31.04145033	Phocaeicola	909656	Bacteria	Bacteria	73.1	3.89e-8	NTclustered	gi\|1966883226\|gb\|CP068488.1\|	821	g14490	i0	90.741	1.9458413926499	54	5	10	0	322	375	774134	774081	Phocaeicola vulgatus strain FDAARGOS_1098 chromosome	blastn	1006	73.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola vulgatus
24381168	24381168	PRJNA1010780_S_NODE_32740_length_244_cov_3.645933_g31451_i0	PRJNA1010780	32740	244	3.645933	8.89607652	Chryseobacterium sp. MYb264	2745153	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2653376484\|gb\|CP142422.1\|	2745153	g31451	i0	100	0.114754098360656	28	0	11	0	217	244	3222602	3222629	Chryseobacterium sp. MYb264 chromosome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. MYb264

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