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

10 rows where analysis = "blastn", bioproject = "PRJNA1200128" 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
327024	327024	PRJNA1200128_S_NODE_26881_length_185_cov_2.295775_g26772_i0	PRJNA1200128	26881	185	2.295775	4.24718375	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	259	8.67e-65	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g26772	i0	91.892	28.2	185	15	100	0	1	185	1600681	1600497	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	5217	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
1601862	1601862	PRJNA1200128_S_NODE_5742_length_301_cov_2.775194_g5633_i0	PRJNA1200128	5742	301	2.775194	8.35333394	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	490	5.01e-134	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g5633	i0	96.013	160.568106312292	301	12	100	0	1	301	1600052	1599752	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	48331	490	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
7980466	7980466	PRJNA1200128_S_NODE_14747_length_223_cov_2.788889_g14638_i0	PRJNA1200128	14747	223	2.788889	6.21922247	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	375	1.03e-99	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g14638	i0	97.285	45.6816143497758	221	6	99	0	1	221	1599677	1599457	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	10187	375	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
9254953	9254953	PRJNA1200128_S_NODE_11748_length_240_cov_1.979695_g11639_i0	PRJNA1200128	11748	240	1.979695	4.751268	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	272	1.52e-68	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g11639	i0	88.696	456.216666666667	230	17	94	8	10	235	15746	15522	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	109492	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
10530817	10530817	PRJNA1200128_S_NODE_10969_length_245_cov_2.559406_g10860_i0	PRJNA1200128	10969	245	2.559406	6.2705447	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	420	5.26e-113	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g10860	i0	97.551	160.914285714286	245	6	100	0	1	245	1601084	1601328	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	39424	420	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
10530837	10530837	PRJNA1200128_S_NODE_15229_length_221_cov_1.848315_g15120_i0	PRJNA1200128	15229	221	1.848315	4.08477615	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	381	2.2e-101	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g15120	i0	99.061	298.380090497738	213	1	96	1	10	221	1600081	1600293	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	65942	381	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
11805689	11805689	PRJNA1200128_S_NODE_4250_length_335_cov_1.763699_g4141_i0	PRJNA1200128	4250	335	1.763699	5.90839165	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	490	5.65e-134	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g4141	i0	93.155	77.0179104477612	336	20	100	3	1	335	1405303	1404970	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	25801	490	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
14356130	14356130	PRJNA1200128_S_NODE_6312_length_292_cov_1.385542_g6203_i0	PRJNA1200128	6312	292	1.385542	4.04578264	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	198	3.28e-46	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g6203	i0	80.228	1.17808219178082	263	52	90	0	2	264	388424	388686	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	344	198	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
19453120	19453120	PRJNA1200128_S_NODE_25656_length_188_cov_1.751724_g25547_i0	PRJNA1200128	25656	188	1.751724	3.29324112	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	326	8.6e-85	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g25547	i0	97.872	74.4840425531915	188	4	100	0	1	188	1405632	1405819	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	14003	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
19453130	19453130	PRJNA1200128_S_NODE_26636_length_186_cov_1.160839_g26527_i0	PRJNA1200128	26636	186	1.160839	2.15916054	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	193	8.98e-45	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g26527	i0	85.561	363.60752688172	187	24	100	2	1	186	2749580	2749764	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	67631	193	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;