metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1101048" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1101048" 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
1019772	1019772	PRJNA1101048_P_NODE_6661_length_257_cov_1.597826_g6605_i0	PRJNA1101048	6661	257	1.597826	4.10641282	Capnocytophaga	1016	Bacteria	Bacteria	459	1.18e-124	NTclustered	gi\|1242557346\|gb\|CP022383.1\|	1019	g6605	i0	98.833	2	257	3	100	0	1	257	144985	145241	Capnocytophaga sputigena strain H4486 chromosome, complete genome	blastn	514	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga sputigena
8673100	8673100	PRJNA1101048_P_NODE_307_length_854_cov_3.825864_g271_i0	PRJNA1101048	307	854	3.825864	32.67287856	Bacteroidales	171549	Bacteria	Bacteria	147	3.84e-30	NTclustered	gi\|470487156\|ref\|NR_076804.1\|	185300	g271	i0	83.766	29.1639344262295	154	25	18	0	27	180	700	853	Paludibacter propionicigenes strain WB4 23S ribosomal RNA gene, complete sequence	blastn	24906	147	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae	Paludibacter	Paludibacter propionicigenes
14239986	14239986	PRJNA1101048_P_NODE_7772_length_249_cov_1.255682_g7716_i0	PRJNA1101048	7772	249	1.255682	3.12664818	Capnocytophaga leadbetteri	327575	Bacteria	Bacteria	405	1.5e-108	NTclustered	gi\|1242560045\|gb\|CP022384.1\|	327575	g7716	i0	95.984	3	249	10	100	0	1	249	1900991	1901239	Capnocytophaga leadbetteri strain H6253 chromosome, complete genome	blastn	747	405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga leadbetteri
15047518	15047518	PRJNA1101048_P_NODE_1572_length_445_cov_17.440860_g1516_i0	PRJNA1101048	1572	445	17.44086	77.611827	Cytophagales	768507	Bacteria	Bacteria	268	3.929999999999999e-67	NTclustered	gi\|2548624267\|gb\|CP119422.1\|	1397264	g1516	i0	86.561	454.54606741573	253	23	99	8	196	443	2989587	2989341	Catalinimonas niigatensis strain NBRC 109829 chromosome, complete genome	blastn	202273	270	0.992592592592593	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Catalimonadaceae	Catalinimonas	Catalinimonas niigatensis
15047522	15047522	PRJNA1101048_P_NODE_4872_length_290_cov_1.838710_g4816_i0	PRJNA1101048	4872	290	1.83871	5.332259	FCB group	1783270	Bacteria	Bacteria	224	5.38e-54	NTclustered	gi\|55978580\|gb\|AY661855.1\|	28188	g4816	i0	89.888	216.513793103448	178	13	60	5	113	287	1546	1721	Capnocytophaga canimorsus strain 24231 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	62789	226	0.991150442477876	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga canimorsus
16788357	16788357	PRJNA1101048_P_NODE_7214_length_252_cov_0.871508_g7158_i0	PRJNA1101048	7214	252	0.871508	2.19620016	Capnocytophaga gingivalis	1017	Bacteria	Bacteria	387	5.519999999999998e-103	NTclustered	gi\|1242564872\|gb\|CP022386.1\|	1017	g7158	i0	99.07	1.02777777777778	215	2	100	0	1	215	134539	134753	Capnocytophaga gingivalis strain H1496 chromosome, complete genome	blastn	259	387	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga gingivalis
18062901	18062901	PRJNA1101048_P_NODE_7715_length_250_cov_0.875706_g7659_i0	PRJNA1101048	7715	250	0.875706	2.189265	Flavobacterium sp. TR2	2977321	Bacteria	Bacteria	431	2.489999999999999e-116	NTclustered	gi\|2304704138\|gb\|CP104307.1\|	2977321	g7659	i0	99.578	16.624	237	0	95	1	7	243	1246690	1246455	Flavobacterium sp. TR2 chromosome, complete genome	blastn	4156	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. TR2
21888034	21888034	PRJNA1101048_P_NODE_5638_length_275_cov_1.346535_g5582_i0	PRJNA1101048	5638	275	1.346535	3.70297125	Ferruginibacter albus	2875540	Bacteria	Bacteria	374	4.7499999999999996e-99	NTclustered	gi\|2096325587\|gb\|CP083388.1\|	2875540	g5582	i0	96.087	238.08	230	8	99	1	2	230	768478	768249	Ferruginibacter albus strain KIS38-8 chromosome, complete genome	blastn	65472	374	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter albus
21888037	21888037	PRJNA1101048_P_NODE_6218_length_264_cov_4.193717_g6162_i0	PRJNA1101048	6218	264	4.193717	11.07141288	Runella sp. SP2	2268026	Bacteria	Bacteria	488	1.5499999999999999e-133	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g6162	i0	100	261.965909090909	264	0	100	0	1	264	5735053	5735316	Runella sp. SP2 chromosome, complete genome	blastn	69159	488	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
21888044	21888044	PRJNA1101048_P_NODE_9758_length_210_cov_14.335766_g9702_i0	PRJNA1101048	9758	210	14.335766	30.1051086	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	329	7.6e-86	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g9702	i0	95.61	394.309523809524	205	9	98	0	1	205	217332	217128	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	82805	329	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
23163533	23163533	PRJNA1101048_P_NODE_2479_length_371_cov_3.496644_g2423_i0	PRJNA1101048	2479	371	3.496644	12.97254924	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	525	1.7299999999999995e-144	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g2423	i0	93.056	258.008086253369	360	23	97	2	12	370	217332	216974	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	95721	525	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
24437087	24437087	PRJNA1101048_P_NODE_1100_length_510_cov_1.855835_g1045_i0	PRJNA1101048	1100	510	1.855835	9.4647585	Bacteroidales bacterium	2030927	Bacteria	Bacteria	784	0	NTclustered	gi\|2621785016\|emb\|OY781474.1\|	2030927	g1045	i0	94.369	512.127450980392	515	21	100	6	1	510	526781	527292	MAG: Bacteroidales bacterium isolate d554a065-6b18-4027-98a3-e240c86e67dd genome assembly, chromosome: 1	blastn	261185	784	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales 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);;