metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax_phylum = "Verrucomicrobiota"

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
25581150	25581150	PRJNA737474f_S_NODE_6961_length_787_cov_2.929972_g6399_i0	PRJNA737474	6961	787	2.929972	23.05887964	Pedosphaera parvula Ellin514	320771	Bacteria	Bacteria	758	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g6399	i0	84.774	69.9390088945362	775	97	97	21	24	787	1807	1043	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	55042	758	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
25586652	25586652	PRJNA737474g_S_NODE_326265_length_250_cov_0.949153_g324971_i0	PRJNA737474	326265	250	0.949153	2.3728825	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	195	3.55e-45	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g324971	i0	91.489	4.332	141	12	56	0	108	248	3216162	3216302	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1083	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
25720002	25720002	PRJNA737474g_S_NODE_17682_length_740_cov_1.764618_g16512_i0	PRJNA737474	17682	740	1.764618	13.0581732	Candidatus Xiphinematobacter sp.	1903058	Bacteria	Bacteria	534	6.04e-147	NTclustered	gi\|1966850802\|gb\|CP068472.1\|	1903058	g16512	i0	92.513	0.827027027027027	374	26	50	2	329	701	244070	244442	MAG: Candidatus Xiphinematobacter sp. isolate P3-11 chromosome, complete genome	blastn	612	534	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp.
25987421	25987421	PRJNA737474f_S_NODE_26252_length_413_cov_1.852941_g25575_i0	PRJNA737474	26252	413	1.852941	7.65264633	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	239	2.84e-58	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g25575	i0	80.635	2.76513317191283	315	56	76	5	97	409	55578	55267	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1142	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
25995561	25995561	PRJNA737474g_S_NODE_38404_length_461_cov_1.896907_g37115_i0	PRJNA737474	38404	461	1.896907	8.74474127	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	322	3.09e-83	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g37115	i0	79.437	2.67678958785249	462	89	99	6	1	459	4560252	4559794	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1234	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
25998188	25998188	PRJNA737474g_S_NODE_81428_length_347_cov_4.051095_g80134_i0	PRJNA737474	81428	347	4.051095	14.05729965	Actomonas aquatica	2866162	Bacteria	Bacteria	86.1	3.24e-12	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g80134	i0	97.959	13.9567723342939	49	1	14	0	20	68	2403704	2403656	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	4843	86.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
26118244	26118244	PRJNA737474d_S_NODE_38693_length_247_cov_1.051724_g38099_i0	PRJNA737474	38693	247	1.051724	2.59775828	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g38099	i0	96.875	0.129554655870445	32	1	13	0	54	85	1451984	1452015	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	32	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
26260563	26260563	PRJNA737474f_S_NODE_36470_length_372_cov_1.461538_g35792_i0	PRJNA737474	36470	372	1.461538	5.43692136	Candidatus Xiphinematobacter sp.	1903058	Bacteria	Bacteria	388	2.3699999999999997e-103	NTclustered	gi\|1966850802\|gb\|CP068472.1\|	1903058	g35792	i0	99.531	0.57258064516129	213	1	57	0	160	372	244442	244230	MAG: Candidatus Xiphinematobacter sp. isolate P3-11 chromosome, complete genome	blastn	213	388	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp.

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