metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1159911" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1159911" and tax_clade = "Bacteria candidate phyla"

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_genus	tax_species
2859422	2859422	PRJNA1159911_P_NODE_81283_length_260_cov_1.983957_g80741_i0	PRJNA1159911	81283	260	1.983957	5.1582882	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	211	3.69e-50	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g80741	i0	82.917	18.5461538461538	240	35	91	5	24	260	615794	615558	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	4822	211	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
4135546	4135546	PRJNA1159911_P_NODE_89904_length_249_cov_0.875000_g89362_i0	PRJNA1159911	89904	249	0.875	2.17875	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g89362	i0	100	1	249	0	100	0	1	249	727960	727712	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	249	460	1	Bacteria	Bacteria candidate phyla	Vermiphilus	Vermiphilus pyriformis
4135588	4135588	PRJNA1159911_P_NODE_91624_length_248_cov_0.880000_g91082_i0	PRJNA1159911	91624	248	0.88	2.1824	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	444	3.17e-120	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g91082	i0	99.187	0.991935483870968	246	2	99	0	1	246	56572	56817	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	246	444	1	Bacteria	Bacteria candidate phyla	Vermiphilus	Vermiphilus pyriformis
16884985	16884985	PRJNA1159911_P_NODE_49234_length_350_cov_7.689531_g48692_i0	PRJNA1159911	49234	350	7.689531	26.9133585	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	148	4.1e-31	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g48692	i0	82.54	47.8914285714286	189	13	48	12	172	340	426424	426236	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	16762	148	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
16885788	16885788	PRJNA1159911_P_NODE_88054_length_250_cov_1.463277_g87512_i0	PRJNA1159911	88054	250	1.463277	3.6581925	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g87512	i0	100	7.4	250	0	100	0	1	250	575349	575598	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	1850	462	1	Bacteria	Bacteria candidate phyla	Vermiphilus	Vermiphilus pyriformis
19434886	19434886	PRJNA1159911_P_NODE_97416_length_243_cov_1.811765_g96874_i0	PRJNA1159911	97416	243	1.811765	4.40258895	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g96874	i0	98.354	1	243	4	100	0	1	243	112506	112264	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	243	427	1	Bacteria	Bacteria candidate phyla	Vermiphilus	Vermiphilus pyriformis
21985507	21985507	PRJNA1159911_P_NODE_91018_length_248_cov_0.880000_g90476_i0	PRJNA1159911	91018	248	0.88	2.1824	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	425	1.15e-114	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g90476	i0	97.581	6.14112903225806	248	6	100	0	1	248	55143	54896	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	1523	425	1	Bacteria	Bacteria candidate phyla	Vermiphilus	Vermiphilus pyriformis
24534693	24534693	PRJNA1159911_P_NODE_87980_length_250_cov_1.649718_g87438_i0	PRJNA1159911	87980	250	1.649718	4.124295	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g87438	i0	100	1	250	0	100	0	1	250	520142	520391	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	250	462	1	Bacteria	Bacteria candidate phyla	Vermiphilus	Vermiphilus pyriformis
24534743	24534743	PRJNA1159911_P_NODE_91020_length_248_cov_0.880000_g90478_i0	PRJNA1159911	91020	248	0.88	2.1824	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g90478	i0	100	1.875	248	0	100	0	1	248	1092361	1092608	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	465	459	1	Bacteria	Bacteria candidate phyla	Vermiphilus	Vermiphilus pyriformis

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