metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA312899" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4206113	4206113	PRJNA312899_P_NODE_102664_length_161_cov_0.910714_g102222_i0	PRJNA312899	102664	161	0.910714	1.46624954	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	139	9.98e-29	NTclustered	gi\|2621704004\|emb\|OY762959.1\|	2026734	g102222	i0	82.609	73.8509316770186	161	24	99	4	3	161	838883	838725	MAG: Dehalococcoidia bacterium isolate a8fc5444-7059-4be1-bdcb-92646be6befe genome assembly, chromosome: 1	blastn	11890	139	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
7442518	7442518	PRJNA312899_P_NODE_42906_length_270_cov_15.027149_g42464_i0	PRJNA312899	42906	270	15.027149	40.5733023	Bacillati	1783272	Bacteria	Bacteria	115	3.11e-21	NTclustered	gi\|2513924934\|gb\|CP126532.1\|	2306968	g42464	i0	93.506	31.7111111111111	77	5	29	0	61	137	3899518	3899442	MAG: Ktedonobacterales bacterium isolate bin_006 chromosome, complete genome	blastn	8562	115	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
10584265	10584265	PRJNA312899_P_NODE_91689_length_165_cov_0.879310_g91247_i0	PRJNA312899	91689	165	0.87931	1.4508615	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	156	1.02e-33	NTclustered	gi\|2626282194\|emb\|OY839116.1\|	2026734	g91247	i0	83.636	5.33333333333333	165	27	100	0	1	165	425621	425457	MAG: Dehalococcoidia bacterium isolate 44b3abb6-b6b9-4f11-be96-93ee54cc77f6 genome assembly, chromosome: 1	blastn	880	156	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
13132880	13132880	PRJNA312899_P_NODE_20091_length_420_cov_12.760108_g19650_i0	PRJNA312899	20091	420	12.760108	53.5924536	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	370	9.83e-98	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g19650	i0	84.197	11.8880952380952	386	55	91	6	37	418	3495623	3496006	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	4993	370	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
16956834	16956834	PRJNA312899_P_NODE_3554_length_924_cov_56.042286_g3296_i0	PRJNA312899	3554	924	56.042286	517.83072264	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	948	0	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g3296	i0	85.335	157.174242424242	941	111	100	18	1	924	273281	274211	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	145229	948	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
16957282	16957282	PRJNA312899_P_NODE_60694_length_216_cov_2.443114_g60252_i0	PRJNA312899	60694	216	2.443114	5.27712624	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	207	3.84e-49	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g60252	i0	86.294	11.4722222222222	197	20	90	6	1	194	1420	1228	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	2478	207	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
18230576	18230576	PRJNA312899_P_NODE_100515_length_162_cov_0.902655_g100073_i0	PRJNA312899	100515	162	0.902655	1.4623011	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	169	1.28e-37	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g100073	i0	85.625	0.987654320987654	160	23	99	0	3	162	19450	19291	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	160	169	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve

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