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

18 rows where analysis = "blastn", bioproject = "PRJNA1101946" 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
1019803	1019803	PRJNA1101946_S_NODE_14721_length_210_cov_1.900621_g14622_i0	PRJNA1101946	14721	210	1.900621	3.9913041	Dysgonomonas	156973	Bacteria	Bacteria	272	1.3e-68	NTclustered	gi\|1821115267\|gb\|CP049857.1\|	2714926	g14622	i0	90.431	213.009523809524	209	16	99	4	1	207	349538	349744	Dysgonomonas sp. HDW5A chromosome, complete genome	blastn	44732	272	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Dysgonomonas	Dysgonomonas sp. HDW5A
1019823	1019823	PRJNA1101946_S_NODE_2061_length_393_cov_8.305233_g1962_i0	PRJNA1101946	2061	393	8.305233	32.63956569	Chryseobacterium	59732	Bacteria	Bacteria	721	0	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g1962	i0	99.746	551.852417302799	393	1	100	0	1	393	2444041	2443649	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	216878	726	0.993112947658402	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
2761944	2761944	PRJNA1101946_S_NODE_1623_length_420_cov_4.409704_g1524_i0	PRJNA1101946	1623	420	4.409704	18.5207568	Flavobacterium dauae	1563479	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2557430891\|gb\|CP130821.1\|	1563479	g1524	i0	100	0.0714285714285714	30	0	7	0	280	309	1161409	1161438	Flavobacterium dauae strain TCH3-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium dauae
4037956	4037956	PRJNA1101946_S_NODE_104_length_1046_cov_9.244734_g3_i6	PRJNA1101946	104	1046	9.244734	96.69991764	Chryseobacterium gambrini	373672	Bacteria	Bacteria	1882	0	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g3	i6	99.14	474.63862332696	1047	7	100	2	1	1046	1782893	1783938	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	496472	1882	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
4038029	4038029	PRJNA1101946_S_NODE_8384_length_264_cov_3.306977_g8285_i0	PRJNA1101946	8384	264	3.306977	8.73041928	Chryseobacterium gambrini	373672	Bacteria	Bacteria	455	1.57e-123	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g8285	i0	97.727	1	264	6	100	0	1	264	3420010	3420273	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	264	455	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
6589381	6589381	PRJNA1101946_S_NODE_24886_length_162_cov_1.353982_g24787_i0	PRJNA1101946	24886	162	1.353982	2.19345084	Hymenobacter tibetensis	497967	Bacteria	Bacteria	250	4.45e-62	NTclustered	gi\|2218432809\|gb\|CP094673.1\|	497967	g24787	i0	94.444	302.487654320988	162	9	100	0	1	162	58954	58793	Hymenobacter tibetensis strain KACC 21982 plasmid unnamed4, complete sequence	blastn	49003	250	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter tibetensis
7863999	7863999	PRJNA1101946_S_NODE_9427_length_253_cov_5.495098_g9328_i0	PRJNA1101946	9427	253	5.495098	13.90259794	Lacibacter sp. MH-610	3020883	Bacteria	Bacteria	457	4.16e-124	NTclustered	gi\|2865359271\|gb\|CP116002.1\|	3020883	g9328	i0	99.209	87.6600790513834	253	2	100	0	1	253	3295826	3296078	Lacibacter sp. MH-610 chromosome	blastn	22178	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
8673126	8673126	PRJNA1101946_S_NODE_14427_length_212_cov_2.269939_g14328_i0	PRJNA1101946	14427	212	2.269939	4.81227068	Hymenobacter	89966	Bacteria	Bacteria	303	4.66e-78	NTclustered	gi\|586953861\|gb\|CP007145.1\|	1227739	g14328	i0	95.789	266.433962264151	190	5	89	3	1	188	504490	504302	Hymenobacter swuensis DY53, complete genome	blastn	56484	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter swuensis
9948066	9948066	PRJNA1101946_S_NODE_2208_length_386_cov_8.952522_g2109_i0	PRJNA1101946	2208	386	8.952522	34.55673492	Empedobacter	59734	Bacteria	Bacteria	708	0	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g2109	i0	99.741	294.189119170984	386	1	100	0	1	386	523665	523280	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	113557	708	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
9948100	9948100	PRJNA1101946_S_NODE_48_length_1737_cov_37.912322_g8_i0	PRJNA1101946	48	1737	37.912322	658.53703314	Sediminibacterium	504481	Bacteria	Bacteria	1456	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g8	i0	95.987	243.427173287277	897	35	98	1	817	1712	2980392	2979496	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	422833	1467	0.992501704158146	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
15047602	15047602	PRJNA1101946_S_NODE_5612_length_301_cov_4.333333_g5513_i0	PRJNA1101946	5612	301	4.333333	13.04333233	Sphingobacterium	28453	Bacteria	Bacteria	551	2.2699999999999992e-152	NTclustered	gi\|2306435172\|gb\|CP094931.1\|	34087	g5513	i0	99.668	436.893687707641	301	1	100	0	1	301	228986	228686	Sphingobacterium faecium strain WB1 chromosome, complete genome	blastn	131505	551	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium faecium
16322405	16322405	PRJNA1101946_S_NODE_353_length_662_cov_10.515498_g3_i9	PRJNA1101946	353	662	10.515498	69.61259676	Empedobacter	59734	Bacteria	Bacteria	1155	0	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g3	i9	98.19	413.716012084592	663	9	99	3	1	661	523235	522574	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	273880	1155	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
18062966	18062966	PRJNA1101946_S_NODE_435_length_626_cov_3.623917_g357_i0	PRJNA1101946	435	626	3.623917	22.68572042	Empedobacter falsenii	343874	Bacteria	Bacteria	1079	0	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g357	i0	98.845	497.482428115016	606	5	97	2	1	606	522050	522653	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	311424	1079	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
18871511	18871511	PRJNA1101946_S_NODE_4755_length_314_cov_24.494340_g4656_i0	PRJNA1101946	4755	314	24.49434	76.9122276	Pedobacter	84567	Bacteria	Bacteria	366	9.24e-97	NTclustered	gi\|1717444187\|gb\|CP031708.1\|	332999	g4656	i0	89.726	326.869426751592	292	23	92	7	27	314	3691810	3692098	Pedobacter suwonensis strain Fj_001 chromosome, complete genome	blastn	102637	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter suwonensis
19337082	19337082	PRJNA1101946_S_NODE_2656_length_367_cov_6.022013_g2557_i0	PRJNA1101946	2656	367	6.022013	22.10078771	Hymenobacter sp. DG01	2584940	Bacteria	Bacteria	619	7.62e-173	NTclustered	gi\|1686076296\|gb\|CP040936.1\|	2584940	g2557	i0	97.26	307.681198910082	365	10	99	0	1	365	272773	272409	Hymenobacter sp. DG01 chromosome, complete genome	blastn	112919	619	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG01
21421939	21421939	PRJNA1101946_S_NODE_21197_length_175_cov_2.023810_g21098_i0	PRJNA1101946	21197	175	2.02381	3.5416675	Dysgonomonas	156973	Bacteria	Bacteria	268	1.34e-67	NTclustered	gi\|1821115267\|gb\|CP049857.1\|	2714926	g21098	i0	94.286	233.097142857143	175	10	100	0	1	175	349635	349809	Dysgonomonas sp. HDW5A chromosome, complete genome	blastn	40792	268	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Dysgonomonas	Dysgonomonas sp. HDW5A
23163585	23163585	PRJNA1101946_S_NODE_18399_length_188_cov_2.258993_g18300_i0	PRJNA1101946	18399	188	2.258993	4.24690684	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	235	1.49e-57	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g18300	i0	92.638	299.037234042553	163	12	87	0	1	163	1589	1751	Pedobacter sp. SL55 chromosome	blastn	56219	235	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
24437163	24437163	PRJNA1101946_S_NODE_23240_length_167_cov_1.728814_g23141_i0	PRJNA1101946	23240	167	1.728814	2.88711938	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	265	1.65e-66	NTclustered	gi\|1958116195\|gb\|CP065012.1\|	1869212	g23141	i0	97.419	118.275449101796	155	4	93	0	1	155	2394717	2394563	MAG: Chitinophagaceae bacterium isolate Rand_18-Q3-R56-63_BAT3C.147_cln chromosome, complete genome	blastn	19752	265	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium

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