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

10 rows where analysis = "blastn", bioproject = "PRJNA498309" 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
482333	482333	PRJNA498309_S_NODE_39241_length_217_cov_402.401099_g37073_i0	PRJNA498309	39241	217	402.401099	873.21038483	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	178	3.03e-40	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g37073	i0	85.227	26.3778801843318	176	22	80	4	13	186	2576966	2577139	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	5724	178	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
4309243	4309243	PRJNA498309_S_NODE_3924_length_1562_cov_16.523248_g2725_i0	PRJNA498309	3924	1562	16.523248	258.09313376	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1059	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g2725	i0	79.315	97.8085787451985	1547	292	98	27	23	1553	4130601	4129067	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	152777	1059	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9408895	9408895	PRJNA498309_P_NODE_48128_length_387_cov_1.934286_g45992_i0	PRJNA498309	48128	387	1.934286	7.48568682	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	322	2.55e-83	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g45992	i0	83.286	159.103359173127	353	56	91	3	35	387	1449	1100	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	61573	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
10684141	10684141	PRJNA498309_P_NODE_26689_length_555_cov_10.922780_g24731_i0	PRJNA498309	26689	555	10.92278	60.621429	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	532	1.5999999999999993e-146	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g24731	i0	85.799	254.897297297297	507	66	91	6	22	525	631700	632203	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	141468	532	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
13236433	13236433	PRJNA498309_S_NODE_5231_length_1274_cov_9.265537_g2192_i1	PRJNA498309	5231	1274	9.265537	118.04294138	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	2113	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g2192	i1	96.708	293.061224489796	1276	30	100	11	1	1274	1224	2489	Luteolibacter sp. SL250 chromosome	blastn	373360	2113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
14509666	14509666	PRJNA498309_P_NODE_48932_length_382_cov_4.414493_g46794_i0	PRJNA498309	48932	382	4.414493	16.86336326	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	606	6.199999999999998e-169	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g46794	i0	97.222	269.780104712042	360	7	94	2	23	382	2506	2150	Luteolibacter sp. SL250 chromosome	blastn	103056	606	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
18961125	18961125	PRJNA498309_S_NODE_25715_length_358_cov_3.944272_g23547_i0	PRJNA498309	25715	358	3.9442719999999998	14.12049376	Verrucomicrobiaceae	203557	Bacteria	Bacteria	318	3.03e-82	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g23547	i0	85.806	121.329608938547	310	32	86	8	29	332	631147	631450	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	43436	320	0.99375	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
19608659	19608659	PRJNA498309_S_NODE_7676_length_973_cov_67.288913_g2192_i2	PRJNA498309	7676	973	67.288913	654.72112349	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	1062	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g2192	i2	87.866	191.230215827338	923	89	94	20	1	916	2489	1583	Luteolibacter sp. SL250 chromosome	blastn	186067	1062	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
20884467	20884467	PRJNA498309_S_NODE_43677_length_192_cov_16.031847_g41509_i0	PRJNA498309	43677	192	16.031847	30.781146240000002	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	261	2.52e-65	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g41509	i0	91.146	247.723958333333	192	17	100	0	1	192	2216692	2216883	Luteolibacter sp. LG18 DNA, complete genome	blastn	47563	261	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
23434772	23434772	PRJNA498309_S_NODE_37759_length_228_cov_2.015544_g35591_i0	PRJNA498309	37759	228	2.015544	4.59544032	uncultured Verrucomicrobiaceae bacterium	257470	Bacteria	Bacteria	327	3.02e-85	NTclustered	gi\|672229328\|emb\|HE860821.1\|	257470	g35591	i0	97.895	76.8684210526316	190	3	83	1	24	213	29	217	Uncultured Verrucomicrobiaceae bacterium partial 16S rRNA gene, clone2A_22	blastn	17526	327	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		uncultured Verrucomicrobiaceae 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);;