metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1092581" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1092581" 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
197003	197003	PRJNA1092581_P_NODE_44701_length_406_cov_1.474474_g44168_i0	PRJNA1092581	44701	406	1.474474	5.98636444	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	523	6.869999999999998e-144	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g44168	i0	91.003	48.3177339901478	389	33	95	1	20	406	1858812	1859200	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	19617	523	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
1017937	1017937	PRJNA1092581_P_NODE_17861_length_657_cov_11.541096_g17346_i0	PRJNA1092581	17861	657	11.541096	75.82500072	Chloroflexus	1107	Bacteria	Bacteria	525	3.209999999999999e-144	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g17346	i0	82.205	758.595129375951	635	90	95	22	20	645	826	1446	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	498397	525	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
2746351	2746351	PRJNA1092581_P_NODE_105363_length_246_cov_1.658960_g104830_i0	PRJNA1092581	105363	246	1.65896	4.0810416	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	154	5.9200000000000005e-33	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g104830	i0	79.911	114.886178861789	224	34	89	8	27	246	8	224	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	28262	154	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
4024527	4024527	PRJNA1092581_P_NODE_80304_length_288_cov_5.432558_g79771_i0	PRJNA1092581	80304	288	5.432558	15.64576704	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	113	1.2e-20	NTclustered	gi\|2621701266\|emb\|OY759986.1\|	2952883	g79771	i0	78.889	97.7986111111111	180	29	74	8	2	176	53414	53589	MAG: Aggregatilineales bacterium isolate 77605d95-9063-427a-b0a2-1f26f0f1d72f genome assembly, chromosome: 1	blastn	28166	113	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
12496636	12496636	PRJNA1092581_P_NODE_111210_length_238_cov_3.096970_g110677_i0	PRJNA1092581	111210	238	3.09697	7.3707886	Chloroflexus	1107	Bacteria	Bacteria	132	2.67e-26	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g110677	i0	78.922	8.03361344537815	204	35	84	8	14	213	1660	1461	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	1912	132	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
13771222	13771222	PRJNA1092581_P_NODE_115191_length_231_cov_5.316456_g114658_i0	PRJNA1092581	115191	231	5.316456	12.28101336	Chloroflexota	200795	Bacteria	Bacteria	222	1.4899999999999999e-53	NTclustered	gi\|2621701642\|emb\|OY760398.1\|	2952883	g114658	i0	87.065	11.7575757575758	201	20	86	6	21	218	381901	382098	MAG: Aggregatilineales bacterium isolate 948f1344-b363-40c2-9c6d-9b25e8b84bf3 genome assembly, chromosome: 1	blastn	2716	224	0.991071428571429	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
14226922	14226922	PRJNA1092581_P_NODE_93592_length_263_cov_3.010526_g93059_i0	PRJNA1092581	93592	263	3.010526	7.91768338	Anaerolineales bacterium	2073117	Bacteria	Bacteria	58.4	5.16e-4	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g93059	i0	94.737	0.144486692015209	38	1	14	1	114	151	1307982	1308018	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	38	58.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
15498412	15498412	PRJNA1092581_P_NODE_113333_length_234_cov_6.838509_g112800_i0	PRJNA1092581	113333	234	6.838509	16.00211106	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	215	2.53e-51	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g112800	i0	85.308	72.8376068376068	211	27	89	4	25	233	4992916	4992708	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	17044	215	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
16772579	16772579	PRJNA1092581_P_NODE_102154_length_250_cov_1.694915_g101621_i0	PRJNA1092581	102154	250	1.694915	4.2372875	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	169	2.15e-37	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g101621	i0	80.172	151.804	232	40	91	6	23	250	274545	274774	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	37951	169	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
16773704	16773704	PRJNA1092581_P_NODE_31034_length_496_cov_23.366430_g30502_i0	PRJNA1092581	31034	496	23.36643	115.8974928	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	497	5.18e-136	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g30502	i0	86.58	181.372983870968	462	49	92	13	15	468	2828272	2827816	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	89961	497	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
18047278	18047278	PRJNA1092581_P_NODE_103615_length_248_cov_2.148571_g103082_i0	PRJNA1092581	103615	248	2.148571	5.32845608	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	235	2.08e-57	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g103082	i0	84.746	1.18951612903226	236	34	95	2	14	248	1052026	1051792	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	295	235	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21874111	21874111	PRJNA1092581_P_NODE_56598_length_354_cov_2.558719_g56065_i0	PRJNA1092581	56598	354	2.558719	9.05786526	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	331	3.84e-86	NTclustered	gi\|374850026\|dbj\|AP011646.1\|	166587	g56065	i0	85.03	41.2062146892655	334	40	93	10	27	354	2750	2421	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF004_B01	blastn	14587	331	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
23970537	23970537	PRJNA1092581_P_NODE_2919_length_1331_cov_28.542925_g2705_i0	PRJNA1092581	2919	1331	28.542925	379.90633175	Chloroflexus	1107	Bacteria	Bacteria	1208	0	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g2705	i0	83.483	318.800901577761	1338	179	99	37	3	1318	427	1744	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	424324	1214	0.99505766062603	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
24423317	24423317	PRJNA1092581_P_NODE_62720_length_334_cov_2.076628_g62187_i0	PRJNA1092581	62720	334	2.076628	6.93593752	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	497	3.36e-136	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g62187	i0	94.969	17.3473053892216	318	14	95	1	17	334	1858996	1859311	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	5794	497	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
25244657	25244657	PRJNA1092581_P_NODE_43940_length_410_cov_1.997033_g43407_i0	PRJNA1092581	43940	410	1.997033	8.1878353	Chloroflexota	200795	Bacteria	Bacteria	340	7.5e-89	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g43407	i0	82.075	524.880487804878	424	52	99	17	4	410	239856	240272	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	215201	342	0.994152046783626	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
25244873	25244873	PRJNA1092581_P_NODE_63400_length_331_cov_11.255814_g62867_i0	PRJNA1092581	63400	331	11.255814	37.25674434	Caldilinea	233191	Bacteria	Bacteria	329	1.29e-85	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g62867	i0	86.842	110.679758308157	304	28	90	11	24	321	1154	1451	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	36635	329	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila

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