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

8 rows where analysis = "blastn", bioproject = "PRJNA788929" and tax_phylum = "Chloroflexota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4597501	4597501	PRJNA788929_P_NODE_23164_length_335_cov_29.683206_g22503_i0	PRJNA788929	23164	335	29.683206	99.4387401	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	189	2.31e-43	NTclustered	gi\|2893358443\|emb\|OZ220735.1\|	3069543	g22503	i0	78.233	121.185074626866	317	53	92	11	22	330	2360761	2360453	MAG: Phototrophicaceae bacterium isolate 252cb3c6-93c9-4785-98a9-44529c25b936 genome assembly, chromosome: 1	blastn	40597	189	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
4597607	4597607	PRJNA788929_P_NODE_30184_length_287_cov_7.663551_g29523_i0	PRJNA788929	30184	287	7.663551	21.99439137	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	307	5.13e-79	NTclustered	gi\|2874253698\|emb\|OY969424.1\|	1672391	g29523	i0	88.889	151.721254355401	252	25	87	3	28	278	971186	971435	MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1	blastn	43544	307	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7147586	7147586	PRJNA788929_P_NODE_12486_length_489_cov_120.685096_g11829_i0	PRJNA788929	12486	489	120.685096	590.15011944	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	383	1.4899999999999994e-101	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g11829	i0	81.612	175.934560327198	484	70	96	12	1	470	2827346	2826868	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	86032	383	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
11418122	11418122	PRJNA788929_P_NODE_19929_length_366_cov_19.027304_g19269_i0	PRJNA788929	19929	366	19.027304	69.63993264	Chloroflexus	1107	Bacteria	Bacteria	270	8.81e-68	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g19269	i0	81.902	3.55464480874317	326	54	88	4	45	366	1337	1661	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	1301	270	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
13523400	13523400	PRJNA788929_P_NODE_49711_length_200_cov_6.425197_g49050_i0	PRJNA788929	49711	200	6.425197	12.850394	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	113	7.860000000000001e-21	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g49050	i0	80.986	1.52	142	27	71	0	19	160	1451891	1452032	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	304	113	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17347309	17347309	PRJNA788929_P_NODE_11014_length_531_cov_43.683406_g10361_i0	PRJNA788929	11014	531	43.683406	231.95888586	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	736	0	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g10361	i0	94.715	114.69868173258	473	25	89	0	36	508	4993626	4994098	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	60905	736	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
17347857	17347857	PRJNA788929_P_NODE_43894_length_234_cov_22.310559_g43233_i0	PRJNA788929	43894	234	22.310559	52.20670806	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	124	4.38e-24	NTclustered	gi\|2621701642\|emb\|OY760398.1\|	2952883	g43233	i0	80.114	4.76495726495726	176	27	73	8	64	234	380999	381171	MAG: Aggregatilineales bacterium isolate 948f1344-b363-40c2-9c6d-9b25e8b84bf3 genome assembly, chromosome: 1	blastn	1115	124	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
24995892	24995892	PRJNA788929_P_NODE_31340_length_280_cov_33.429952_g30679_i0	PRJNA788929	31340	280	33.429952	93.6038656	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	169	2.46e-37	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g30679	i0	80.617	211.132142857143	227	37	80	5	33	257	3521942	3521721	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	59117	169	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia 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);;