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

18 rows where analysis = "blastn", bioproject = "PRJNA1123436" and tax_clade = "delta/epsilon subdivisions"

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_class	tax_species
1553411	1553411	PRJNA1123436_P_NODE_107142_length_247_cov_1.011494_g105928_i0	PRJNA1123436	107142	247	1.011494	2.49839018	uncultured delta proteobacterium Rifle_16ft_4_minimus_184	1665175	Bacteria	Bacteria	231	2.6699999999999997e-56	NTclustered	gi\|874574271\|gb\|KT006965.1\|	1665175	g105928	i0	83.806	1	247	36	99	4	1	245	36151	35907	Uncultured delta proteobacterium Rifle_16ft_4_minimus_184 genomic sequence	blastn	247	231	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium Rifle_16ft_4_minimus_184
1553437	1553437	PRJNA1123436_P_NODE_108682_length_247_cov_0.885057_g107468_i0	PRJNA1123436	108682	247	0.885057	2.18609079	uncultured delta proteobacterium	34034	Bacteria	Bacteria	318	1.9899999999999998e-82	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g107468	i0	89.879	32.919028340081	247	25	100	0	1	247	932015	932261	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	8131	318	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
1553564	1553564	PRJNA1123436_P_NODE_114882_length_245_cov_0.895349_g113668_i0	PRJNA1123436	114882	245	0.895349	2.19360505	uncultured delta proteobacterium	34034	Bacteria	Bacteria	272	1.56e-68	NTclustered	gi\|2874253674\|emb\|OY969108.1\|	34034	g113668	i0	89.041	0.893877551020408	219	24	89	0	1	219	2798759	2798977	MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1	blastn	219	272	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
1554567	1554567	PRJNA1123436_P_NODE_54242_length_339_cov_0.849624_g53028_i0	PRJNA1123436	54242	339	0.849624	2.88022536	uncultured delta proteobacterium Rifle_16ft_4_minimus_184	1665175	Bacteria	Bacteria	388	2.15e-103	NTclustered	gi\|874574271\|gb\|KT006965.1\|	1665175	g53028	i0	87.316	6.33923303834808	339	43	100	0	1	339	6708	7046	Uncultured delta proteobacterium Rifle_16ft_4_minimus_184 genomic sequence	blastn	2149	388	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium Rifle_16ft_4_minimus_184
4107054	4107054	PRJNA1123436_P_NODE_56804_length_331_cov_1.089147_g55590_i0	PRJNA1123436	56804	331	1.089147	3.60507657	uncultured delta proteobacterium Rifle_16ft_4_minimus_184	1665175	Bacteria	Bacteria	289	2.1799999999999996e-73	NTclustered	gi\|874574271\|gb\|KT006965.1\|	1665175	g55590	i0	83.706	1.03625377643505	313	43	93	6	25	331	23079	23389	Uncultured delta proteobacterium Rifle_16ft_4_minimus_184 genomic sequence	blastn	343	289	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium Rifle_16ft_4_minimus_184
4107139	4107139	PRJNA1123436_P_NODE_61724_length_318_cov_1.191837_g60510_i0	PRJNA1123436	61724	318	1.191837	3.79004166	uncultured delta proteobacterium Rifle_16ft_4_minimus_184	1665175	Bacteria	Bacteria	394	4.3e-105	NTclustered	gi\|874574271\|gb\|KT006965.1\|	1665175	g60510	i0	88.994	8.09119496855346	318	35	100	0	1	318	17649	17966	Uncultured delta proteobacterium Rifle_16ft_4_minimus_184 genomic sequence	blastn	2573	394	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium Rifle_16ft_4_minimus_184
7933623	7933623	PRJNA1123436_P_NODE_88647_length_262_cov_1.222222_g87433_i0	PRJNA1123436	88647	262	1.222222	3.20222164	uncultured delta proteobacterium Rifle_16ft_4_minimus_184	1665175	Bacteria	Bacteria	246	1.02e-60	NTclustered	gi\|874574271\|gb\|KT006965.1\|	1665175	g87433	i0	84.959	0.938931297709924	246	33	93	3	1	244	10317	10560	Uncultured delta proteobacterium Rifle_16ft_4_minimus_184 genomic sequence	blastn	246	246	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium Rifle_16ft_4_minimus_184
9208087	9208087	PRJNA1123436_P_NODE_63348_length_314_cov_0.896266_g62134_i0	PRJNA1123436	63348	314	0.896266	2.81427524	uncultured delta proteobacterium Rifle_16ft_4_minimus_36741	1665180	Bacteria	Bacteria	411	4.209999999999999e-110	NTclustered	gi\|874578314\|gb\|KT007071.1\|	1665180	g62134	i0	90.615	4.28025477707006	309	29	98	0	1	309	4545	4853	Uncultured delta proteobacterium Rifle_16ft_4_minimus_36741 genomic sequence	blastn	1344	411	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium Rifle_16ft_4_minimus_36741
10484028	10484028	PRJNA1123436_P_NODE_82289_length_274_cov_1.134328_g81075_i0	PRJNA1123436	82289	274	1.134328	3.10805872	uncultured delta proteobacterium Rifle_16ft_4_minimus_184	1665175	Bacteria	Bacteria	198	3.0499999999999998e-46	NTclustered	gi\|874574271\|gb\|KT006965.1\|	1665175	g81075	i0	81.022	1	274	31	100	13	1	274	2192	1940	Uncultured delta proteobacterium Rifle_16ft_4_minimus_184 genomic sequence	blastn	274	198	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium Rifle_16ft_4_minimus_184
10484329	10484329	PRJNA1123436_P_NODE_98309_length_250_cov_0.870056_g97095_i0	PRJNA1123436	98309	250	0.870056	2.17514	uncultured delta proteobacterium	34034	Bacteria	Bacteria	324	4.35e-84	NTclustered	gi\|2874253674\|emb\|OY969108.1\|	34034	g97095	i0	90	18.988	250	25	100	0	1	250	2999775	2999526	MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1	blastn	4747	324	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
14308102	14308102	PRJNA1123436_P_NODE_126492_length_241_cov_0.916667_g125278_i0	PRJNA1123436	126492	241	0.916667	2.20916747	uncultured delta proteobacterium Rifle_16ft_4_minimus_184	1665175	Bacteria	Bacteria	329	8.95e-86	NTclustered	gi\|874574271\|gb\|KT006965.1\|	1665175	g125278	i0	91.286	78.50622406639	241	21	100	0	1	241	11292	11532	Uncultured delta proteobacterium Rifle_16ft_4_minimus_184 genomic sequence	blastn	18920	329	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium Rifle_16ft_4_minimus_184
15581532	15581532	PRJNA1123436_P_NODE_101133_length_249_cov_0.875000_g99919_i0	PRJNA1123436	101133	249	0.875	2.17875	uncultured delta proteobacterium	34034	Bacteria	Bacteria	100	7.94e-17	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g99919	i0	89.024	8.16064257028112	82	8	33	1	105	186	300949	300869	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	2032	100	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
16332256	16332256	PRJNA1123436_P_NODE_69373_length_299_cov_1.646018_g68159_i0	PRJNA1123436	69373	299	1.646018	4.92159382	Thermodesulfobacteriota	200940	Bacteria	Bacteria	143	1.5999999999999999e-29	NTclustered	gi\|2874253674\|emb\|OY969108.1\|	34034	g68159	i0	95.556	28.2508361204013	90	2	29	2	93	180	1385927	1385838	MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1	blastn	8447	143	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
19404769	19404769	PRJNA1123436_P_NODE_110016_length_246_cov_1.335260_g108802_i0	PRJNA1123436	110016	246	1.33526	3.2847396	uncultured delta proteobacterium Rifle_16ft_4_minimus_184	1665175	Bacteria	Bacteria	326	1.19e-84	NTclustered	gi\|874574271\|gb\|KT006965.1\|	1665175	g108802	i0	91.25	3.21544715447154	240	20	97	1	8	246	38114	37875	Uncultured delta proteobacterium Rifle_16ft_4_minimus_184 genomic sequence	blastn	791	326	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium Rifle_16ft_4_minimus_184
19406287	19406287	PRJNA1123436_P_NODE_77856_length_282_cov_1.277512_g76642_i0	PRJNA1123436	77856	282	1.277512	3.60258384	uncultured delta proteobacterium Rifle_16ft_4_minimus_184	1665175	Bacteria	Bacteria	344	3.83e-90	NTclustered	gi\|874574271\|gb\|KT006965.1\|	1665175	g76642	i0	88.693	1.00354609929078	283	30	100	2	1	282	36469	36750	Uncultured delta proteobacterium Rifle_16ft_4_minimus_184 genomic sequence	blastn	283	344	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium Rifle_16ft_4_minimus_184
21431569	21431569	PRJNA1123436_P_NODE_52197_length_346_cov_0.714286_g50983_i0	PRJNA1123436	52197	346	0.714286	2.47142956	Bacteria	2	Bacteria	Bacteria	370	7.96e-98	NTclustered	gi\|874574271\|gb\|KT006965.1\|	1665175	g50983	i0	89.189	1.71098265895954	296	32	86	0	1	296	48024	47729	Uncultured delta proteobacterium Rifle_16ft_4_minimus_184 genomic sequence	blastn	592	370	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium Rifle_16ft_4_minimus_184
24505853	24505853	PRJNA1123436_P_NODE_51860_length_347_cov_0.996350_g50646_i0	PRJNA1123436	51860	347	0.99635	3.4573345	uncultured delta proteobacterium Rifle_16ft_4_minimus_36741	1665180	Bacteria	Bacteria	525	1.6099999999999994e-144	NTclustered	gi\|874578314\|gb\|KT007071.1\|	1665180	g50646	i0	93.948	167.884726224784	347	21	100	0	1	347	5139	4793	Uncultured delta proteobacterium Rifle_16ft_4_minimus_36741 genomic sequence	blastn	58256	525	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium Rifle_16ft_4_minimus_36741
24506055	24506055	PRJNA1123436_P_NODE_62320_length_316_cov_1.584362_g61106_i0	PRJNA1123436	62320	316	1.584362	5.00658392	uncultured delta proteobacterium Rifle_16ft_4_minimus_184	1665175	Bacteria	Bacteria	368	2.59e-97	NTclustered	gi\|874574271\|gb\|KT006965.1\|	1665175	g61106	i0	87.697	1.67088607594937	317	37	100	2	1	316	8419	8734	Uncultured delta proteobacterium Rifle_16ft_4_minimus_184 genomic sequence	blastn	528	368	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium Rifle_16ft_4_minimus_184

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