metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA488043" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA488043" 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
5553607	5553607	PRJNA488043_S_NODE_985_length_191_cov_19.919753_g974_i0	PRJNA488043	985	191	19.919753	38.04672823	Anaerolineales bacterium	2073117	Bacteria	Bacteria	219	1.5299999999999999e-52	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g974	i0	93.793	262.30890052356	145	9	76	0	6	150	1574962	1575106	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	50101	219	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
8750827	8750827	PRJNA488043_P_NODE_13687_length_249_cov_1.618182_g11445_i0	PRJNA488043	13687	249	1.618182	4.02927318	Caldilinea	233191	Bacteria	Bacteria	106	1.71e-18	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g11445	i0	88.506	22.9718875502008	87	10	35	0	10	96	1347	1261	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	5720	106	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
9377689	9377689	PRJNA488043_P_NODE_18288_length_189_cov_1.725000_g16046_i0	PRJNA488043	18288	189	1.725	3.26025	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2814788335\|emb\|OY760861.2\|	3022862	g16046	i0	96.97	0.174603174603175	33	0	17	1	69	101	1089182	1089213	MAG: Tepidiformaceae bacterium isolate 815c9385-4915-413f-8b4b-d9ebc7d9cf62 genome assembly, chromosome: 1	blastn	33	54.7	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
9377857	9377857	PRJNA488043_S_NODE_328_length_312_cov_4.028269_g317_i0	PRJNA488043	328	312	4.028269	12.56819928	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	204	7.61e-48	NTclustered	gi\|2621706248\|emb\|OY764157.1\|	2952883	g317	i0	81.928	24.3942307692308	249	38	79	7	35	280	142665	142909	MAG: Aggregatilineales bacterium isolate e8f4d38d-de70-4490-8638-1b8803f995b9 genome assembly, chromosome: 1	blastn	7611	204	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
15752701	15752701	PRJNA488043_S_NODE_1273_length_171_cov_19.542254_g1262_i0	PRJNA488043	1273	171	19.542254	33.41725434	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	113	6.480000000000001e-21	NTclustered	gi\|2893356069\|emb\|OZ220492.1\|	2614250	g1262	i0	83.077	22.2397660818713	130	17	75	5	11	138	2776678	2776804	MAG: Caldilineaceae bacterium isolate e886e3b1-96bd-41d4-96ed-8e2f365de7fb genome assembly, chromosome: 1	blastn	3803	113	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
24675805	24675805	PRJNA488043_P_NODE_14000_length_243_cov_2.065421_g11758_i0	PRJNA488043	14000	243	2.065421	5.01897303	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	130	9.84e-26	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g11758	i0	77.328	8.35802469135803	247	39	100	10	1	243	19238	19005	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	2031	130	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);;