metadata: contig_metadata: 18 rows where bioproject = "PRJNA168635" and tax

18 rows where bioproject = "PRJNA168635" and tax_phylum = "Candidatus Parcubacteria"

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_phylum	tax_species
8017650	8017650	PRJNA168635_P_NODE_13427_length_221_cov_3.802326_g13011_i0	PRJNA168635	13427	221	3.802326	8.40314046	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	209	1.1e-49	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g13011	i0	87.302	96.5294117647059	189	16	84	8	1	186	52529	52346	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	21333	209	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
8017699	8017699	PRJNA168635_P_NODE_15427_length_204_cov_2.470968_g15011_i0	PRJNA168635	15427	204	2.470968	5.04077472	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	134	6.1800000000000006e-27	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g15011	i0	81.176	3.90196078431373	170	28	82	4	33	200	52243	52410	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	796	134	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
9292340	9292340	PRJNA168635_P_NODE_10308_length_257_cov_6.408654_g9893_i0	PRJNA168635	10308	257	6.408654	16.47024078	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	377	3.4e-100	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g9893	i0	93.333	812.120622568093	255	17	99	0	1	255	53081	52827	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	208715	377	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
9292835	9292835	PRJNA168635_P_NODE_7608_length_306_cov_4.435798_g7196_i0	PRJNA168635	7608	306	4.435798	13.57354188	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	374	5.359999999999998e-99	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g7196	i0	92.996	161.313725490196	257	16	84	2	51	306	53947	53692	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	49362	374	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
13118292	13118292	PRJNA168635_P_NODE_22951_length_174_cov_1.624000_g22535_i0	PRJNA168635	22951	174	1.624	2.82576	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	134	5.08e-27	NTclustered	gi\|2874254054\|emb\|OY970378.1\|	2762014	g22535	i0	85.938	24.4712643678161	128	14	95	3	7	132	446840	446965	MAG: Candidatus Parcubacteria bacterium isolate MFD01275.bin.c.8 genome assembly, chromosome: 1	blastn	4258	134	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
14393664	14393664	PRJNA168635_P_NODE_27592_length_166_cov_4.709402_g27176_i0	PRJNA168635	27592	166	4.709402	7.81760732	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	91.6	2.95e-14	NTclustered	gi\|2314736631\|dbj\|AP024682.1\|	2762014	g27176	i0	77.246	6.45180722891566	167	30	98	8	4	166	7755	7593	MAG: Candidatus Parcubacteria bacterium KatS3mg098 DNA, complete genome	blastn	1071	91.6	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
15667139	15667139	PRJNA168635_P_NODE_13333_length_222_cov_1.780347_g12917_i0	PRJNA168635	13333	222	1.780347	3.95237034	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	274	3.86e-69	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g12917	i0	92.632	12.2162162162162	190	14	86	0	1	190	53490	53301	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	2712	274	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
18216190	18216190	PRJNA168635_P_NODE_21915_length_176_cov_4.716535_g21499_i0	PRJNA168635	21915	176	4.716535	8.3011016	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	303	3.71e-78	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g21499	i0	97.727	36.0795454545455	176	4	100	0	1	176	54243	54068	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	6350	303	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
19490544	19490544	PRJNA168635_P_NODE_30396_length_163_cov_3.815789_g29980_i0	PRJNA168635	30396	163	3.815789	6.21973607	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	279	5.73e-71	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g29980	i0	97.546	5.73619631901841	163	4	100	0	1	163	54498	54336	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	935	279	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
26725310	26725310	PRJNA168635_P_NODE_23801_length_172_cov_1.536585_g23385_i0	PRJNA168635	23801	172	1.536585	2.6429262	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	99.4	1.6700000000000001e-22	NR	MEY4731727.1	2762014	g23385	i0	86	0.994186046511628	57	8	99.4	0	1	171	584	640	MEY4731727.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	171	99.4	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
28273916	28273916	PRJNA168635_P_NODE_29166_length_165_cov_0.896552_g28750_i0	PRJNA168635	29166	165	0.896552	1.4793108	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	74.7	6.09e-14	NR	MCG2685873.1	2762014	g28750	i0	63	1.96363636363636	54	20	98.2	0	3	164	152	205	MCG2685873.1 DNA polymerase III subunit gamma/tau [Candidatus Parcubacteria bacterium]	diamond	324	74.7	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
28337226	28337226	PRJNA168635_P_NODE_27746_length_166_cov_1.760684_g27330_i0	PRJNA168635	27746	166	1.760684	2.92273544	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	93.2	9.98e-21	NR	MEA2715371.1	2762014	g27330	i0	77.8	2.85542168674699	54	12	97.6	0	5	166	38	91	MEA2715371.1 cysteinyl-tRNA synthetase [Candidatus Parcubacteria bacterium]	diamond	474	93.2	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
29473587	29473587	PRJNA168635_P_NODE_17850_length_190_cov_1.460993_g17434_i0	PRJNA168635	17850	190	1.460993	2.7758867	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	42.4	0.0249	NR	RJQ33899.1	2762014	g17434	i0	47.1	0.805263157894737	51	27	80.5	0	30	182	551	601	RJQ33899.1 MAG: hypothetical protein C4568_03800 [Candidatus Parcubacteria bacterium]	diamond	153	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
29694566	29694566	PRJNA168635_P_NODE_31910_length_162_cov_0.920354_g31494_i0	PRJNA168635	31910	162	0.920354	1.49097348	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	47.4	1.65e-4	NR	MCK5061739.1	2762014	g31494	i0	44.4	1	54	26	92.6	1	9	158	68	121	MCK5061739.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	162	47.4	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
29820957	29820957	PRJNA168635_P_NODE_34691_length_154_cov_2.590476_g34275_i0	PRJNA168635	34691	154	2.590476	3.98933304	Parcubacteria bacterium C7867-	2762014	Bacteria	Bacteria	70.9	1.28e-12	NR	KND48200.1	1659200	g34275	i0	97.1	0.662337662337662	34	1	66.2	0	1	102	43	76	KND48200.1 MAG: threonine--tRNA ligase [Parcubacteria bacterium C7867-006]	diamond	102	70.9	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium C7867-006
30010881	30010881	PRJNA168635_P_NODE_26531_length_168_cov_0.873950_g26115_i0	PRJNA168635	26531	168	0.87395	1.468236	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	106	4.3e-25	NR	MBX4209607.1	2762014	g26115	i0	78.6	3	56	12	100	0	1	168	47	102	MBX4209607.1 O-antigen ligase family protein [Candidatus Parcubacteria bacterium]	diamond	504	106	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
30990331	30990331	PRJNA168635_P_NODE_26174_length_168_cov_0.873950_g25758_i0	PRJNA168635	26174	168	0.87395	1.468236	Parcubacteria bacterium C7867-	2762014	Bacteria	Bacteria	84.7	2.13e-17	NR	KND48325.1	1659197	g25758	i0	73.6	1.85714285714286	53	14	94.6	0	160	2	2138	2190	KND48325.1 MAG: hypothetical protein AB198_01235, partial [Parcubacteria bacterium C7867-003]	diamond	312	84.7	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium C7867-003
32033810	32033810	PRJNA168635_P_NODE_13818_length_217_cov_7.505952_g13402_i0	PRJNA168635	13818	217	7.505952	16.28791584	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	121	1.04e-32	NR	MEN9412989.1	2762014	g13402	i0	83.1	0.981566820276498	71	12	98.2	0	215	3	12	82	MEN9412989.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	213	121	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria 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);;