metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1022139" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1022139" and tax_clade = "PVC group"

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
1436339	1436339	PRJNA1022139_P_NODE_1622_length_944_cov_2.443169_g1553_i0	PRJNA1022139	1622	944	2.443169	23.06351536	Limnoglobus roseus	2598579	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g1553	i0	100	0.0328389830508475	31	0	3	0	896	926	7374488	7374518	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	31	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
10364953	10364953	PRJNA1022139_P_NODE_43129_length_241_cov_0.916667_g43024_i0	PRJNA1022139	43129	241	0.916667	2.20916747	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g43024	i0	100	0.116182572614108	28	0	12	0	123	150	1047000	1047027	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
11640189	11640189	PRJNA1022139_P_NODE_24870_length_285_cov_1.452830_g24765_i0	PRJNA1022139	24870	285	1.45283	4.1405655	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g24765	i0	100	0.0982456140350877	28	0	10	0	183	210	2034457	2034430	Planctomyces sp. SH-PL62, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
15464267	15464267	PRJNA1022139_P_NODE_13173_length_373_cov_1.540000_g13068_i0	PRJNA1022139	13173	373	1.54	5.7442	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	80.5	1.63e-10	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g13068	i0	81.188	0.270777479892761	101	17	27	2	14	113	1401465	1401366	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	101	80.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
21838513	21838513	PRJNA1022139_P_NODE_31618_length_260_cov_2.775401_g31513_i0	PRJNA1022139	31618	260	2.775401	7.2160426	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g31513	i0	100	0.111538461538462	29	0	11	0	64	92	271048	271020	Planctomyces sp. SH-PL62, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
22680398	22680398	PRJNA1022139_P_NODE_41018_length_243_cov_0.905882_g40913_i0	PRJNA1022139	41018	243	0.905882	2.20129326	PVC group	1783257	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g40913	i0	100	0.460905349794239	28	0	12	0	203	230	4257545	4257572	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	112	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
24387757	24387757	PRJNA1022139_P_NODE_29000_length_270_cov_2.177665_g28895_i0	PRJNA1022139	29000	270	2.177665	5.8796955	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	167	8.47e-37	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g28895	i0	77.941	1.00740740740741	272	56	100	4	1	270	1925638	1925369	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	272	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1

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