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

10 rows where analysis = "blastn", bioproject = "PRJEB39269" 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
3883184	3883184	PRJEB39269_P_NODE_48184_length_197_cov_4.537975_g47779_i0	PRJEB39269	48184	197	4.537975	8.93981075	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	244	2.62e-60	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g47779	i0	89.109	364.142131979695	202	14	100	8	1	197	3893718	3893520	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	71736	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5159374	5159374	PRJEB39269_P_NODE_26205_length_272_cov_2.828326_g25800_i0	PRJEB39269	26205	272	2.828326	7.69304672	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	472	1.62e-128	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g25800	i0	98.864	103.330882352941	264	3	97	0	7	270	2497158	2497421	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	28106	472	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
6435273	6435273	PRJEB39269_P_NODE_58286_length_180_cov_5.007092_g57881_i0	PRJEB39269	58286	180	5.007092	9.0127656	Chthoniobacter flavus	191863	Bacteria	Bacteria	302	1.37e-77	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g57881	i0	97.714	230.138888888889	175	4	97	0	4	178	2090	1916	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	41425	302	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
7709420	7709420	PRJEB39269_P_NODE_20727_length_308_cov_2.185874_g20322_i0	PRJEB39269	20727	308	2.185874	6.73249192	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	375	1.5e-99	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g20322	i0	88.71	241.853896103896	310	31	100	3	1	308	2036	2343	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	74491	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
9917425	9917425	PRJEB39269_P_NODE_55688_length_184_cov_2.262069_g55283_i0	PRJEB39269	55688	184	2.262069	4.16220696	Verrucomicrobiota	74201	Bacteria	Bacteria	340	2.99e-89	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g55283	i0	100	45.7065217391304	184	0	100	0	1	184	3347	3164	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	8410	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
15359289	15359289	PRJEB39269_P_NODE_90493_length_151_cov_1.044643_g90088_i0	PRJEB39269	90493	151	1.044643	1.57741093	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	222	8.879999999999998e-54	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g90088	i0	95.035	41.0529801324503	141	7	93	0	11	151	2577522	2577382	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	6199	222	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
16633912	16633912	PRJEB39269_P_NODE_51354_length_191_cov_6.743421_g50949_i0	PRJEB39269	51354	191	6.743421	12.87993411	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	281	1.92e-71	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g50949	i0	93.194	39.8429319371728	191	13	100	0	1	191	2557675	2557485	Lacunisphaera limnophila strain IG16b, complete genome	blastn	7610	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
16633923	16633923	PRJEB39269_P_NODE_64654_length_172_cov_1.518797_g64249_i0	PRJEB39269	64654	172	1.518797	2.61233084	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	213	6.25e-51	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g64249	i0	94.891	12.3720930232558	137	6	79	1	32	167	3832125	3832261	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	2128	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16633937	16633937	PRJEB39269_P_NODE_74934_length_163_cov_1.112903_g74529_i0	PRJEB39269	74934	163	1.112903	1.81403189	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	274	2.66e-69	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g74529	i0	96.933	158.104294478528	163	5	100	0	1	163	3412685	3412523	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	25771	274	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
21391374	21391374	PRJEB39269_P_NODE_88957_length_152_cov_1.088496_g88552_i0	PRJEB39269	88957	152	1.088496	1.65451392	Verrucomicrobiales	48461	Bacteria	Bacteria	158	2.56e-34	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g88552	i0	89.516	14.3355263157895	124	13	82	0	11	134	3412204	3412327	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	2179	158	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae 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);;