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

5 rows where analysis = "blastn", bioproject = "PRJNA498309" 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
1755614	1755614	PRJNA498309_P_NODE_32482_length_496_cov_5.943355_g30461_i0	PRJNA498309	32482	496	5.943355	29.4790408	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	231	5.799999999999999e-56	NTclustered	gi\|2893358443\|emb\|OZ220735.1\|	3069543	g30461	i0	76.065	118.064516129032	493	91	95	25	1	473	2360443	2360928	MAG: Phototrophicaceae bacterium isolate 252cb3c6-93c9-4785-98a9-44529c25b936 genome assembly, chromosome: 1	blastn	58560	231	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
1755772	1755772	PRJNA498309_P_NODE_42082_length_423_cov_2.924870_g39967_i0	PRJNA498309	42082	423	2.92487	12.3722001	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	250	1.35e-61	NTclustered	gi\|2893358456\|emb\|OZ220748.1\|	2026734	g39967	i0	79.885	5.31205673758865	348	64	82	6	73	417	1146695	1147039	MAG: Dehalococcoidia bacterium isolate 6c7b36c8-b3ab-4b4c-a352-7e98d29eb5d7 genome assembly, chromosome: 1	blastn	2247	250	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
9408343	9408343	PRJNA498309_P_NODE_16728_length_718_cov_3.549192_g15024_i0	PRJNA498309	16728	718	3.549192	25.48319856	Anaerolinea thermophila	167964	Bacteria	Bacteria	1254	0	NTclustered	gi\|319993263\|dbj\|AP012029.1\|	926569	g15024	i0	98.192	1.00139275766017	719	12	100	1	1	718	411450	410732	Anaerolinea thermophila UNI-1 DNA, complete genome	blastn	719	1254	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea thermophila
10684592	10684592	PRJNA498309_P_NODE_50749_length_372_cov_5.226866_g48603_i0	PRJNA498309	50749	372	5.226866	19.44394152	uncultured Anaerolineaceae bacterium	310067	Bacteria	Bacteria	520	8.069999999999999e-143	NTclustered	gi\|633869141\|gb\|KJ128030.1\|	310067	g48603	i0	95.666	79.744623655914	323	14	87	0	50	372	1	323	Uncultured Anaerolineaceae bacterium clone NJFU_SLX-S190 16S ribosomal RNA gene, partial sequence	blastn	29665	520	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		uncultured Anaerolineaceae bacterium
22158571	22158571	PRJNA498309_S_NODE_18478_length_491_cov_29.333333_g16407_i0	PRJNA498309	18478	491	29.333333	144.02666503	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	213	2.08e-50	NTclustered	gi\|2893358443\|emb\|OZ220735.1\|	3069543	g16407	i0	75.519	87.4562118126273	482	93	94	23	6	468	2878317	2878792	MAG: Phototrophicaceae bacterium isolate 252cb3c6-93c9-4785-98a9-44529c25b936 genome assembly, chromosome: 1	blastn	42941	213	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae 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);;