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

5 rows where analysis = "blastn", bioproject = "PRJEB673" 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
2684951	2684951	PRJEB673_P_NODE_10863_length_168_cov_1.203008_g10514_i0	PRJEB673	10863	168	1.203008	2.02105344	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	255	1e-63	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g10514	i0	94.083	158.380952380952	169	9	100	1	1	168	2003386	2003218	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	26608	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5237506	5237506	PRJEB673_P_NODE_9425_length_197_cov_1.716049_g9076_i0	PRJEB673	9425	197	1.716049	3.38061653	Gemmata massiliana	1210884	Bacteria	Bacteria	303	4.27e-78	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g9076	i0	94.416	34.1269035532995	197	11	100	0	1	197	3634990	3634794	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	6723	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
9062147	9062147	PRJEB673_P_NODE_1228_length_850_cov_8.323926_g1019_i0	PRJEB673	1228	850	8.323926	70.753371	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	1352	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g1019	i0	96.569	279.321176470588	816	28	96	0	1	816	4717234	4716419	Luteolibacter sp. SL250 chromosome	blastn	237423	1352	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
10337986	10337986	PRJEB673_P_NODE_6589_length_338_cov_2.917492_g6240_i0	PRJEB673	6589	338	2.917492	9.86112296	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	508	1.58e-139	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g6240	i0	93.787	102.062130177515	338	21	100	0	1	338	3261715	3261378	Luteolibacter sp. Populi chromosome, complete genome	blastn	34497	508	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
18846973	18846973	PRJEB673_P_NODE_5835_length_364_cov_5.939210_g5486_i0	PRJEB673	5835	364	5.93921	21.6187244	Verrucomicrobiales	48461	Bacteria	Bacteria	468	2.89e-127	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g5486	i0	91.74	392.796703296703	339	24	93	4	1	337	775555	775891	Haloferula helveola CN-1 DNA, complete genome	blastn	142978	470	0.995744680851064	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola

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