metadata: contig_metadata: 19 rows where bioproject = "PRJNA630162" and tax

19 rows where bioproject = "PRJNA630162" and tax_phylum = "Abditibacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
602220	602220	PRJNA630162_P_NODE_37041_length_293_cov_12.672131_g35518_i0	PRJNA630162	37041	293	12.672131	37.12934383	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	274	5.33e-69	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g35518	i0	84.266	429.17747440273	286	39	97	6	7	289	2850976	2850694	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	125749	274	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
602511	602511	PRJNA630162_P_NODE_6721_length_737_cov_14.167151_g5520_i0	PRJNA630162	6721	737	14.167151	104.41190287	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	695	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g5520	i0	84.49	96.0502035278155	735	81	99	21	5	733	2851401	2850694	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	70789	695	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
602516	602516	PRJNA630162_P_NODE_6741_length_736_cov_11.186317_g5520_i1	PRJNA630162	6741	736	11.186317	82.33129312	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	701	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g5520	i1	84.605	99.976902173913	734	81	99	21	5	732	2851401	2850694	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	73583	701	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
1877489	1877489	PRJNA630162_P_NODE_103462_length_183_cov_2.970149_g101939_i0	PRJNA630162	103462	183	2.970149	5.43537267	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	316	5.009999999999999e-82	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g101939	i0	98.876	164.918032786885	178	1	97	1	2	178	2853145	2852968	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	30180	316	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
3152317	3152317	PRJNA630162_P_NODE_107143_length_181_cov_2.113636_g105620_i0	PRJNA630162	107143	181	2.113636	3.82568116	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	110	9e-20	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g105620	i0	92.308	0.861878453038674	78	4	43	2	2	78	2851173	2851097	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	156	110	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
3153204	3153204	PRJNA630162_P_NODE_41863_length_274_cov_4.377778_g40340_i0	PRJNA630162	41863	274	4.377778	11.99511172	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	324	4.83e-84	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g40340	i0	87.143	108.171532846715	280	23	98	2	1	268	2853582	2853304	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	29639	324	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
4430208	4430208	PRJNA630162_P_NODE_62584_length_223_cov_4.827586_g61061_i0	PRJNA630162	62584	223	4.827586	10.76551678	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	292	1.07e-74	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g61061	i0	91.204	159.215246636771	216	17	97	2	2	217	2853585	2853372	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	35505	292	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
5704968	5704968	PRJNA630162_P_NODE_10425_length_592_cov_20.064457_g9004_i0	PRJNA630162	10425	592	20.064457	118.78158544	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	771	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g9004	i0	91.161	347.554054054054	577	37	96	13	17	584	2851581	2851010	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	205752	771	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
5706077	5706077	PRJNA630162_P_NODE_56085_length_235_cov_3.263441_g54562_i0	PRJNA630162	56085	235	3.263441	7.66908635	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	257	4.16e-64	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g54562	i0	86.864	3.43404255319149	236	24	99	4	3	235	2851275	2851044	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	807	257	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
5706396	5706396	PRJNA630162_P_NODE_8905_length_643_cov_14.954545_g7545_i0	PRJNA630162	8905	643	14.954545	96.15772435	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	676	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g7545	i0	88.713	202.001555209953	567	47	86	11	82	636	2851647	2852208	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	129887	676	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
9530365	9530365	PRJNA630162_P_NODE_160028_length_162_cov_1.318584_g158505_i0	PRJNA630162	160028	162	1.318584	2.13610608	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	213	5.84e-51	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g158505	i0	91.558	1.90123456790123	154	13	95	0	8	161	2852168	2852321	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	308	213	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
9531006	9531006	PRJNA630162_P_NODE_62168_length_224_cov_2.411429_g60645_i0	PRJNA630162	62168	224	2.411429	5.40160096	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	289	1.39e-73	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g60645	i0	90.09	109.160714285714	222	22	99	0	3	224	2852940	2852719	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	24452	289	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
12081191	12081191	PRJNA630162_P_NODE_150130_length_164_cov_2.069565_g148607_i0	PRJNA630162	150130	164	2.069565	3.3940866	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	167	4.689999999999999e-37	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g148607	i0	85.89	2.23780487804878	163	16	96	6	1	158	2852019	2851859	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	367	167	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
13356326	13356326	PRJNA630162_P_NODE_28031_length_343_cov_4.006803_g26509_i0	PRJNA630162	28031	343	4.006803	13.74333429	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	396	1.3e-105	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g26509	i0	91.468	286.935860058309	293	18	85	4	7	299	2853304	2853589	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	98419	396	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
17180445	17180445	PRJNA630162_P_NODE_56514_length_234_cov_4.513514_g54991_i0	PRJNA630162	56514	234	4.513514	10.56162276	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	226	1.1699999999999999e-54	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g54991	i0	84.783	422.435897435897	230	29	97	6	1	227	2851506	2851280	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	98850	226	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
18453528	18453528	PRJNA630162_P_NODE_124075_length_172_cov_1.983740_g122552_i0	PRJNA630162	124075	172	1.98374	3.4120328	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	215	1.74e-51	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g122552	i0	91.195	265.436046511628	159	13	92	1	1	158	2851451	2851293	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	45655	215	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
22279074	22279074	PRJNA630162_P_NODE_165538_length_158_cov_4.229358_g164015_i0	PRJNA630162	165538	158	4.229358	6.68238564	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	198	1.5899999999999999e-46	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g164015	i0	90.196	94.7721518987342	153	13	96	2	1	152	2853158	2853007	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	14974	198	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
24828876	24828876	PRJNA630162_P_NODE_74320_length_208_cov_5.308176_g72797_i0	PRJNA630162	74320	208	5.308176	11.04100608	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	244	2.8e-60	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g72797	i0	88.406	91.9230769230769	207	19	98	5	3	206	2852384	2852588	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	19120	244	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
31452455	31452455	PRJNA630162_P_NODE_59096_length_229_cov_3.394444_g57573_i0	PRJNA630162	59096	229	3.394444	7.77327676	Abditibacterium	2109263	Bacteria	Bacteria	69.7	6.92e-12	NR	WP_105484113.1	1960156	g57573	i0	84.6	1.53275109170306	39	6	51.1	0	124	8	9	47	WP_105484113.1 porphobilinogen synthase [Abditibacterium utsteinense]	diamond	351	69.7	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense

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