metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJEB81327" and tax

5 rows where analysis = "blastn", bioproject = "PRJEB81327" 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
139751	139751	PRJEB81327_P_NODE_31441_length_276_cov_1.137931_g30833_i0	PRJEB81327	31441	276	1.137931	3.14068956	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	414	2.81e-111	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g30833	i0	94.139	185.31884057971	273	14	99	2	1	272	1315589	1315860	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	51148	414	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
140116	140116	PRJEB81327_P_NODE_58441_length_244_cov_2.514620_g57833_i0	PRJEB81327	58441	244	2.51462	6.1356728	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	278	3.34e-70	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g57833	i0	87.5	0.983606557377049	240	30	98	0	5	244	1057093	1057332	Lacunisphaera limnophila strain IG16b, complete genome	blastn	240	278	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
10343227	10343227	PRJEB81327_P_NODE_69229_length_211_cov_4.181159_g68621_i0	PRJEB81327	69229	211	4.181159	8.82224549	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	291	3.61e-74	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g68621	i0	91.469	1	211	18	100	0	1	211	1015008	1014798	Luteolibacter sp. SL250 chromosome	blastn	211	291	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
11618692	11618692	PRJEB81327_P_NODE_63390_length_242_cov_0.911243_g62782_i0	PRJEB81327	63390	242	0.911243	2.20520806	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	265	2.5699999999999997e-66	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g62782	i0	87.124	2.83057851239669	233	30	96	0	1	233	4165440	4165672	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	685	265	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
14168253	14168253	PRJEB81327_P_NODE_3972_length_754_cov_3.058737_g3426_i0	PRJEB81327	3972	754	3.058737	23.06287698	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	1315	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g3426	i0	98.143	287.013262599469	754	14	100	0	1	754	4717191	4716438	Luteolibacter sp. SL250 chromosome	blastn	216408	1315	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250

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