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

7 rows where analysis = "blastn", bioproject = "PRJNA741997" 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
8851188	8851188	PRJNA741997_P_NODE_85167_length_244_cov_0.877193_g84047_i0	PRJNA741997	85167	244	0.877193	2.14035092	Chloroflexus	1107	Bacteria	Bacteria	204	5.74e-48	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g84047	i0	82.258	23.077868852459	248	32	100	8	1	244	2918	2679	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	5631	204	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
10126811	10126811	PRJNA741997_P_NODE_5048_length_1227_cov_1.728769_g4426_i0	PRJNA741997	5048	1227	1.728769	21.21199563	Bacteria	2	Bacteria	Bacteria	99	1.59e-15	NTclustered	gi\|2320772474\|gb\|CP075526.1\|	2073117	g4426	i0	75.234	5.28687856560717	214	49	17	4	42	253	1970447	1970236	MAG: Anaerolineales bacterium isolate TGS_CHL3 chromosome	blastn	6487	100	0.99	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
10925384	10925384	PRJNA741997_P_NODE_44729_length_324_cov_1.800797_g43609_i0	PRJNA741997	44729	324	1.800797	5.83458228	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|2531948664\|emb\|OY282448.1\|	166587	g43609	i0	100	0.0864197530864197	28	0	9	0	270	297	1366997	1366970	MAG: uncultured Chloroflexota bacterium genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
17299867	17299867	PRJNA741997_P_NODE_89934_length_241_cov_0.916667_g88814_i0	PRJNA741997	89934	241	0.916667	2.20916747	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	399	6.729999999999998e-107	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g88814	i0	96.68	107.095435684647	241	6	100	2	1	241	669652	669890	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	25810	399	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18573388	18573388	PRJNA741997_P_NODE_76715_length_248_cov_1.760000_g75595_i0	PRJNA741997	76715	248	1.76	4.3648	Thermosporothrix sp. COM3	2490863	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1606557374\|dbj\|AP019376.1\|	2490863	g75595	i0	100	0.112903225806452	28	0	11	0	24	51	1034982	1035009	Thermosporothrix sp. COM3 DNA, nearly complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Thermosporotrichaceae	Thermosporothrix	Thermosporothrix sp. COM3
20324585	20324585	PRJNA741997_P_NODE_79156_length_247_cov_0.885057_g78036_i0	PRJNA741997	79156	247	0.885057	2.18609079	Chloroflexota	200795	Bacteria	Bacteria	204	5.819999999999998e-48	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g78036	i0	82.403	429.797570850202	233	41	94	0	8	240	596040	596272	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	106160	206	0.990291262135922	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
23674744	23674744	PRJNA741997_P_NODE_88439_length_242_cov_0.881657_g87319_i0	PRJNA741997	88439	242	0.881657	2.13360994	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	226	1.2099999999999997e-54	NTclustered	gi\|2874253704\|emb\|OY969431.1\|	1672391	g87319	i0	83.806	1.02066115702479	247	31	100	9	1	242	64336	64578	MAG: uncultured Chloroflexia bacterium isolate MFD02979.bin.c.2 genome assembly, chromosome: 1	blastn	247	226	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);;