metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA849172" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA849172" 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
3387790	3387790	PRJNA849172_P_NODE_68343_length_271_cov_3.540404_g67983_i0	PRJNA849172	68343	271	3.540404	9.59449484	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	93.5	1.46e-14	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g67983	i0	86.207	32.1291512915129	87	10	32	2	186	271	7817752	7817837	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	8707	93.5	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5937790	5937790	PRJNA849172_P_NODE_119305_length_232_cov_4.704403_g118945_i0	PRJNA849172	119305	232	4.704403	10.91421496	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2893358428\|emb\|OZ220720.1\|	2026734	g118945	i0	100	0.125	29	0	13	0	1	29	2828550	2828578	MAG: Dehalococcoidia bacterium isolate c1ccb28d-03af-49da-9b48-84a9185dfe7a genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
8489355	8489355	PRJNA849172_P_NODE_5007_length_986_cov_16.952903_g4727_i0	PRJNA849172	5007	986	16.952903	167.15562358	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	1262	0	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g4727	i0	89.829	176.866125760649	993	87	99	11	2	984	2203616	2202628	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	174390	1262	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
9762140	9762140	PRJNA849172_P_NODE_101588_length_245_cov_3.186047_g101228_i0	PRJNA849172	101588	245	3.186047	7.80581515	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	202	2.08e-47	NTclustered	gi\|2814788335\|emb\|OY760861.2\|	3022862	g101228	i0	82.819	7.55918367346939	227	37	92	2	20	245	2218797	2219022	MAG: Tepidiformaceae bacterium isolate 815c9385-4915-413f-8b4b-d9ebc7d9cf62 genome assembly, chromosome: 1	blastn	1852	202	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
9762577	9762577	PRJNA849172_P_NODE_116988_length_234_cov_4.670807_g116628_i0	PRJNA849172	116988	234	4.670807	10.92968838	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	327	3.11e-85	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g116628	i0	91.88	1	234	19	100	0	1	234	1784891	1784658	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	234	327	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
11038448	11038448	PRJNA849172_P_NODE_123789_length_229_cov_2.474359_g123429_i0	PRJNA849172	123789	229	2.474359	5.66628211	Caldilinea aerophila	133453	Bacteria	Bacteria	324	3.92e-84	NTclustered	gi\|381381223\|dbj\|AP012337.1\|	926550	g123429	i0	92.14	1	229	18	100	0	1	229	2360577	2360349	Caldilinea aerophila DSM 14535 = NBRC 104270 DNA, complete genome	blastn	229	324	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
11039417	11039417	PRJNA849172_P_NODE_23569_length_423_cov_30.648571_g23210_i0	PRJNA849172	23569	423	30.648571	129.64345533	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	241	8.1e-59	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g23210	i0	77.726	171.056737588652	431	70	98	24	1	416	2203745	2203326	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	72357	241	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
11041418	11041418	PRJNA849172_P_NODE_90949_length_251_cov_1.752809_g90589_i0	PRJNA849172	90949	251	1.752809	4.39955059	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	130	1.02e-25	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g90589	i0	82.099	26.0756972111554	162	19	63	8	95	251	3280179	3280335	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	6545	130	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17412365	17412365	PRJNA849172_P_NODE_105034_length_243_cov_6.670588_g104674_i0	PRJNA849172	105034	243	6.670588	16.20952884	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	78.7	3.61e-10	NTclustered	gi\|2531976038\|emb\|OY282376.1\|	2614250	g104674	i0	84.81	0.650205761316872	79	11	33	1	144	222	1382249	1382172	MAG: Caldilineaceae bacterium genome assembly, chromosome: 1	blastn	158	78.7	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
19963539	19963539	PRJNA849172_P_NODE_68996_length_270_cov_12.989848_g68636_i0	PRJNA849172	68996	270	12.989848	35.0725896	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	230	1.0699999999999995e-55	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g68636	i0	83.088	23.1703703703704	272	27	98	13	1	265	2827971	2828230	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	6256	230	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
21237625	21237625	PRJNA849172_P_NODE_18457_length_482_cov_5.545232_g18098_i0	PRJNA849172	18457	482	5.545232	26.72801824	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	54.7	0.013	NTclustered	gi\|2621701266\|emb\|OY759986.1\|	2952883	g18098	i0	100	0.0601659751037344	29	0	6	0	417	445	1221162	1221190	MAG: Aggregatilineales bacterium isolate 77605d95-9063-427a-b0a2-1f26f0f1d72f genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
22514555	22514555	PRJNA849172_P_NODE_91758_length_250_cov_10.971751_g91398_i0	PRJNA849172	91758	250	10.971751	27.4293775	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2513924934\|gb\|CP126532.1\|	2306968	g91398	i0	100	1.248	30	0	12	0	187	216	4223156	4223185	MAG: Ktedonobacterales bacterium isolate bin_006 chromosome, complete genome	blastn	312	56.5	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
23786888	23786888	PRJNA849172_P_NODE_118819_length_233_cov_2.556250_g118459_i0	PRJNA849172	118819	233	2.55625	5.9560625	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	139	1.56e-28	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g118459	i0	82.803	0.67381974248927	157	25	67	2	4	159	2320527	2320372	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	157	139	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
23788190	23788190	PRJNA849172_P_NODE_29719_length_376_cov_4.739274_g29360_i0	PRJNA849172	29719	376	4.739274	17.81967024	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	296	1.5e-75	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g29360	i0	85	189.212765957447	300	35	78	10	59	352	239547	239842	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	71144	296	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
24183791	24183791	PRJNA849172_P_NODE_146359_length_200_cov_7.944882_g145999_i0	PRJNA849172	146359	200	7.944882	15.889764	Bacteria	2	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g145999	i0	100	0.45	28	0	14	0	125	152	2220457	2220430	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	90	52.8	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);;