metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA666695" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA666695" 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
630982	630982	PRJNA666695_S_NODE_149561_length_178_cov_1.343066_g148467_i0	PRJNA666695	149561	178	1.343066	2.39065748	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	100	5.3e-17	NTclustered	gi\|2108353487\|gb\|CP070655.1\|	2035772	g148467	i0	81.746	0.707865168539326	126	17	69	6	20	142	686699	686821	MAG: Candidatus Omnitrophota bacterium isolate bin81 chromosome	blastn	126	100	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
3714251	3714251	PRJNA666695_S_NODE_135383_length_188_cov_2.129252_g134289_i0	PRJNA666695	135383	188	2.129252	4.00299376	Planctomycetia	203683	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g134289	i0	100	0.446808510638298	28	0	15	0	35	62	7487899	7487926	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	84	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
4461377	4461377	PRJNA666695_S_NODE_88344_length_232_cov_3.497382_g87250_i0	PRJNA666695	88344	232	3.497382	8.11392624	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2621705864\|emb\|OY763926.1\|	2813034	g87250	i0	100	0.120689655172414	28	0	12	0	85	112	271248	271275	MAG: Sedimentisphaerales bacterium isolate 7f5c64f7-1a0d-4936-834e-775057159072 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
6266680	6266680	PRJNA666695_S_NODE_184465_length_156_cov_1.982609_g183371_i0	PRJNA666695	184465	156	1.982609	3.09287004	Opitutaceae	134623	Bacteria	Bacteria	254	3.28e-63	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g183371	i0	96.711	41.8397435897436	152	5	97	0	3	154	1903699	1903548	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	6527	255	0.996078431372549	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
10835987	10835987	PRJNA666695_S_NODE_22069_length_399_cov_716.106145_g20976_i0	PRJNA666695	22069	399	716.106145	2857.26351855	uncultured Ruficoccus sp.	2175960	Bacteria	Bacteria	379	1.54e-100	NTclustered	gi\|2907625921\|emb\|OZ223481.1\|	2175960	g20976	i0	84.478	298.100250626566	393	52	97	8	12	399	741226	740838	MAG: uncultured Ruficoccus sp. isolate b2a3d85c-2e17-47e2-9e32-7ac6437316b9 genome assembly, chromosome: 10	blastn	118942	379	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Ruficoccus	uncultured Ruficoccus sp.
15932858	15932858	PRJNA666695_S_NODE_103213_length_216_cov_2.931429_g102119_i0	PRJNA666695	103213	216	2.931429	6.33188664	Aquisphaera giovannonii	406548	Bacteria	Bacteria	283	6.21e-72	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g102119	i0	90.455	55.1666666666667	220	14	100	7	1	216	5180414	5180198	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	11916	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
18482792	18482792	PRJNA666695_S_NODE_122555_length_198_cov_2.968153_g121461_i0	PRJNA666695	122555	198	2.968153	5.87694294	Urbifossiella limnaea	2528023	Bacteria	Bacteria	278	2.6e-70	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g121461	i0	93.617	135.257575757576	188	9	94	3	12	198	4212472	4212287	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	26781	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
19014090	19014090	PRJNA666695_S_NODE_130555_length_192_cov_1.523179_g129461_i0	PRJNA666695	130555	192	1.523179	2.92450368	Coraliomargarita	442430	Bacteria	Bacteria	126	9.6e-25	NTclustered	gi\|470486190\|ref\|NR_076741.1\|	395922	g129461	i0	87.85	140.359375	107	13	56	0	13	119	1324	1430	Coraliomargarita akajimensis strain 04OKA010-24 23S ribosomal RNA gene, complete sequence	blastn	26949	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita akajimensis
19758885	19758885	PRJNA666695_S_NODE_25816_length_377_cov_1.642857_g24723_i0	PRJNA666695	25816	377	1.642857	6.19357089	Opitutales bacterium	2026772	Bacteria	Bacteria	411	5.139999999999999e-110	NTclustered	gi\|2891482117\|emb\|OZ219851.1\|	2026772	g24723	i0	86.458	129.519893899204	384	41	100	11	1	377	1410399	1410020	MAG: Opitutales bacterium isolate e4292735-b3b5-42df-bce3-ad3ef7a88f44 genome assembly, chromosome: 10	blastn	48829	411	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
24857105	24857105	PRJNA666695_S_NODE_145660_length_180_cov_5.294964_g144566_i0	PRJNA666695	145660	180	5.294964	9.5309352	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	233	5.08e-57	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g144566	i0	90.11	59.0777777777778	182	15	100	3	1	180	3893393	3893573	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	10634	233	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;