metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJEB36940" and tax

8 rows where analysis = "blastn", bioproject = "PRJEB36940" 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
1330980	1330980	PRJEB36940_P_NODE_10802_length_267_cov_6.948454_g10673_i0	PRJEB36940	10802	267	6.948454	18.55237218	Fontisphaera persica	2974023	Bacteria	Bacteria	359	1.29e-94	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g10673	i0	91.078	14.4232209737828	269	18	99	6	1	265	3862996	3863262	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	3851	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
2606661	2606661	PRJEB36940_P_NODE_12883_length_250_cov_4.802260_g12754_i0	PRJEB36940	12883	250	4.80226	12.00565	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	368	1.98e-97	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g12754	i0	93.2	265	250	17	100	0	1	250	17608	17857	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	66250	368	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
6434960	6434960	PRJEB36940_P_NODE_16506_length_224_cov_6.529801_g16377_i0	PRJEB36940	16506	224	6.529801	14.62675424	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	326	1.06e-84	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g16377	i0	92.857	127.758928571429	224	16	100	0	1	224	3991852	3992075	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	28618	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
10259500	10259500	PRJEB36940_P_NODE_169_length_1589_cov_4.757916_g129_i0	PRJEB36940	169	1589	4.757916	75.60328524	Pedosphaera parvula	1032527	Bacteria	Bacteria	1581	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g129	i0	85.041	174.116425424795	1571	215	98	19	21	1583	1559	1	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	276671	1581	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
12810307	12810307	PRJEB36940_P_NODE_3191_length_476_cov_2.734491_g3063_i0	PRJEB36940	3191	476	2.734491	13.01617716	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	577	6.18e-160	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g3063	i0	88.655	299.626050420168	476	51	99	3	2	476	2313	1840	Luteolibacter sp. SL250 chromosome	blastn	142622	577	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
17566818	17566818	PRJEB36940_P_NODE_16134_length_239_cov_2.271084_g16005_i0	PRJEB36940	16134	239	2.271084	5.42789076	Verrucomicrobiaceae	203557	Bacteria	Bacteria	403	5.15e-108	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g16005	i0	97.458	272.782426778243	236	6	99	0	1	236	2412	2647	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	65195	403	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
17908460	17908460	PRJEB36940_P_NODE_675_length_997_cov_2.471861_g578_i0	PRJEB36940	675	997	2.471861	24.64445417	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	730	0	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g578	i0	80.235	69.7753259779338	1022	161	100	38	1	997	2750186	2749181	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	69566	730	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23008765	23008765	PRJEB36940_P_NODE_1299_length_729_cov_2.135671_g1180_i0	PRJEB36940	1299	729	2.135671	15.56904159	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	603	1.6099999999999998e-167	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g1180	i0	82.504	231.772290809328	703	107	95	14	14	707	15550	16245	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	168962	603	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota 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);;