metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA390533" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA390533" 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
409814	409814	PRJNA390533_P_NODE_4141_length_932_cov_15.320269_g3578_i0	PRJNA390533	4141	932	15.320269	142.78490708	Anaerolineales bacterium	2073117	Bacteria	Bacteria	638	5.69e-178	NTclustered	gi\|2556899361\|gb\|CP129481.1\|	2073117	g3578	i0	80.401	1.54613733905579	847	158	90	8	24	866	813080	813922	MAG: Anaerolineales bacterium isolate cMAG.15 chromosome, complete genome	blastn	1441	638	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
1684533	1684533	PRJNA390533_P_NODE_24942_length_316_cov_1.267148_g23915_i0	PRJNA390533	24942	316	1.267148	4.00418768	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	106	2.24e-18	NTclustered	gi\|2874253698\|emb\|OY969424.1\|	1672391	g23915	i0	92	0.237341772151899	75	6	24	0	239	313	314948	315022	MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1	blastn	75	106	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
2960189	2960189	PRJNA390533_P_NODE_11183_length_582_cov_9.062615_g10272_i0	PRJNA390533	11183	582	9.062615	52.7444193	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	582	1.65e-161	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g10272	i0	85.663	580.64089347079	558	74	95	5	1	555	2827972	2827418	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	337933	582	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
4236743	4236743	PRJNA390533_P_NODE_2584_length_1123_cov_28.086716_g2191_i0	PRJNA390533	2584	1123	28.086716	315.41382068	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	857	0	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g2191	i0	84.873	487.634906500445	866	113	76	17	242	1096	4992695	4993553	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	547614	857	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
5513287	5513287	PRJNA390533_P_NODE_15445_length_470_cov_6.672854_g14445_i0	PRJNA390533	15445	470	6.672854	31.3624138	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	274	8.96e-69	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g14445	i0	78.444	156.193617021277	450	75	93	16	1	438	2203339	2203778	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	73411	274	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
6181127	6181127	PRJNA390533_P_NODE_23265_length_336_cov_6.976431_g22241_i0	PRJNA390533	23265	336	6.976431	23.44080816	Caldilinea	233191	Bacteria	Bacteria	427	4.51e-115	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g22241	i0	90.491	117.559523809524	326	28	96	3	13	336	2935	2611	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	39500	431	0.990719257540603	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
8062970	8062970	PRJNA390533_P_NODE_25267_length_316_cov_1.083032_g24240_i0	PRJNA390533	25267	316	1.083032	3.42238112	uncultured Caldilineaceae bacterium	543031	Bacteria	Bacteria	60.2	1.77e-4	NTclustered	gi\|2531946084\|emb\|OY282381.1\|	543031	g24240	i0	92.857	0.132911392405063	42	2	13	1	241	281	967448	967407	MAG: uncultured Caldilineaceae bacterium genome assembly, chromosome: 1	blastn	42	60.2	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		uncultured Caldilineaceae bacterium
8063104	8063104	PRJNA390533_P_NODE_37607_length_192_cov_1.915033_g36580_i0	PRJNA390533	37607	192	1.915033	3.67686336	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	124	3.45e-24	NTclustered	gi\|374850026\|dbj\|AP011646.1\|	166587	g36580	i0	85.246	151.53125	122	16	63	2	54	174	2872	2752	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF004_B01	blastn	29094	124	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
10613538	10613538	PRJNA390533_P_NODE_32169_length_230_cov_4.628272_g31142_i0	PRJNA390533	32169	230	4.628272	10.6450256	Anaerolineales bacterium	2073117	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2621701347\|emb\|OY760067.1\|	2073117	g31142	i0	88.889	0.195652173913043	45	2	18	2	22	63	833156	833200	MAG: Anaerolineales bacterium isolate e1712b75-d4f6-4c5e-bc49-bbfdc0d5b476 genome assembly, chromosome: 2	blastn	45	52.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
10613564	10613564	PRJNA390533_P_NODE_34489_length_212_cov_1.421965_g33462_i0	PRJNA390533	34489	212	1.421965	3.0145658	Anaerolineales bacterium	2073117	Bacteria	Bacteria	143	1.08e-29	NTclustered	gi\|2556910457\|gb\|CP129484.1\|	2073117	g33462	i0	80.628	0.900943396226415	191	32	89	5	18	206	1308152	1307965	MAG: Anaerolineales bacterium isolate cMAG.12 chromosome, complete genome	blastn	191	143	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
11281291	11281291	PRJNA390533_P_NODE_29729_length_255_cov_7.851852_g28702_i0	PRJNA390533	29729	255	7.851852	20.0222226	Caldilinea	233191	Bacteria	Bacteria	374	4.3499999999999996e-99	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g28702	i0	96.861	914.039215686274	223	7	87	0	24	246	2346	2568	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	233080	374	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
13163406	13163406	PRJNA390533_P_NODE_25051_length_316_cov_1.198556_g24024_i0	PRJNA390533	25051	316	1.198556	3.78743696	Chloroflexota bacterium	2026724	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2107952176\|gb\|CP070793.1\|	2026724	g24024	i0	96.875	0.10126582278481	32	1	10	0	9	40	1417876	1417907	MAG: Chloroflexi bacterium isolate bin1433 chromosome	blastn	32	54.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
14438566	14438566	PRJNA390533_P_NODE_30172_length_250_cov_8.388626_g29145_i0	PRJNA390533	30172	250	8.388626	20.971565	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	119	2.2e-22	NTclustered	gi\|2893358443\|emb\|OZ220735.1\|	3069543	g29145	i0	87.379	4.364	103	13	41	0	1	103	2878309	2878411	MAG: Phototrophicaceae bacterium isolate 252cb3c6-93c9-4785-98a9-44529c25b936 genome assembly, chromosome: 1	blastn	1091	119	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
14438644	14438644	PRJNA390533_P_NODE_38232_length_189_cov_1.320000_g37205_i0	PRJNA390533	38232	189	1.32	2.4948	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	106	1.23e-18	NTclustered	gi\|2621701267\|emb\|OY759987.1\|	2952883	g37205	i0	89.286	0.444444444444444	84	9	44	0	48	131	408611	408694	MAG: Aggregatilineales bacterium isolate 77605d95-9063-427a-b0a2-1f26f0f1d72f genome assembly, chromosome: 2	blastn	84	106	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
16987124	16987124	PRJNA390533_P_NODE_25434_length_316_cov_0.931408_g24407_i0	PRJNA390533	25434	316	0.931408	2.94324928	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	76.8	1.76e-9	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g24407	i0	97.727	0.89873417721519	44	1	14	0	273	316	1146140	1146097	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	284	76.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18261407	18261407	PRJNA390533_P_NODE_38795_length_186_cov_1.741497_g37768_i0	PRJNA390533	38795	186	1.741497	3.23918442	Anaerolineales bacterium	2073117	Bacteria	Bacteria	117	5.56e-22	NTclustered	gi\|2556910457\|gb\|CP129484.1\|	2073117	g37768	i0	85.217	3.05913978494624	115	16	61	1	73	186	1307823	1307709	MAG: Anaerolineales bacterium isolate cMAG.12 chromosome, complete genome	blastn	569	117	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
22755118	22755118	PRJNA390533_P_NODE_41598_length_174_cov_1.644444_g40571_i0	PRJNA390533	41598	174	1.644444	2.86133256	Chloroflexota	200795	Bacteria	Bacteria	148	1.8099999999999999e-31	NTclustered	gi\|148566298\|gb\|CP000686.1\|	357808	g40571	i0	85.034	6.98275862068965	147	20	84	2	29	174	1799288	1799143	Roseiflexus sp. RS-1, complete genome	blastn	1215	148	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
23361595	23361595	PRJNA390533_P_NODE_11579_length_571_cov_7.154135_g2191_i1	PRJNA390533	11579	571	7.154135	40.85011085	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	399	1.7499999999999995e-106	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g2191	i1	83.011	136.877408056042	465	56	79	21	1	452	2202692	2202238	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	78157	399	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);;