metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax

9 rows where analysis = "blastn", 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

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