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

16 rows where analysis = "blastn", bioproject = "PRJEB7366" and tax_clade = "PVC group"

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
1409818	1409818	PRJEB7366_P_NODE_12502_length_227_cov_2.708333_g12068_i0	PRJEB7366	12502	227	2.708333	6.14791591	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	340	3.8499999999999996e-89	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g12068	i0	94.545	78.1850220264317	220	12	97	0	1	220	1403941	1403722	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	17748	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
1409819	1409819	PRJEB7366_P_NODE_12782_length_224_cov_1.904762_g12348_i0	PRJEB7366	12782	224	1.904762	4.26666688	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	327	2.95e-85	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g12348	i0	92.92	141.946428571429	226	14	100	1	1	224	1405134	1405359	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	31796	327	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
3546110	3546110	PRJEB7366_P_NODE_5723_length_374_cov_2.353982_g5290_i0	PRJEB7366	5723	374	2.353982	8.80389268	Opitutaceae	134623	Bacteria	Bacteria	669	0	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g5290	i0	98.93	196.580213903743	374	4	100	0	1	374	541410	541783	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	73521	675	0.991111111111111	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
3961341	3961341	PRJEB7366_P_NODE_1844_length_722_cov_6.005822_g1493_i1	PRJEB7366	1844	722	6.005822	43.36203484	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	830	0	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g1493	i1	87.432	195.027700831025	740	70	100	18	1	722	7050217	7050951	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	140810	830	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5237805	5237805	PRJEB7366_P_NODE_20385_length_168_cov_2.045113_g19951_i0	PRJEB7366	20385	168	2.045113	3.43578984	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	250	4.66e-62	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g19951	i0	96.104	206.357142857143	154	5	91	1	1	153	1403983	1404136	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	34668	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
7373081	7373081	PRJEB7366_P_NODE_21286_length_164_cov_1.534884_g20852_i0	PRJEB7366	21286	164	1.534884	2.51720976	Verrucomicrobiales	48461	Bacteria	Bacteria	130	6.15e-26	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g20852	i0	81.437	128.90243902439	167	24	99	7	1	163	3411503	3411666	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	21140	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
9062500	9062500	PRJEB7366_P_NODE_11688_length_237_cov_3.366337_g11254_i0	PRJEB7366	11688	237	3.366337	7.97821869	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	348	2.4200000000000006e-91	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g11254	i0	93.939	32.3122362869198	231	13	97	1	1	231	1404909	1405138	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	7658	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
10338291	10338291	PRJEB7366_P_NODE_1829_length_725_cov_5.195652_g1493_i0	PRJEB7366	1829	725	5.195652	37.668477	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	688	0	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g1493	i0	84.384	88.7751724137931	730	83	98	22	1	710	7050951	7050233	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	64362	688	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11613733	11613733	PRJEB7366_P_NODE_11890_length_235_cov_1.305000_g11456_i0	PRJEB7366	11890	235	1.305	3.06675	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	289	1.47e-73	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g11456	i0	89.03	166.042553191489	237	21	100	5	1	235	2809208	2808975	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	39020	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
16711911	16711911	PRJEB7366_P_NODE_14334_length_208_cov_2.080925_g13900_i0	PRJEB7366	14334	208	2.080925	4.328324	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	351	1.6e-92	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g13900	i0	97.115	82.3413461538462	208	6	100	0	1	208	1404306	1404513	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	17127	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
16711936	16711936	PRJEB7366_P_NODE_22274_length_160_cov_0.968000_g21840_i0	PRJEB7366	22274	160	0.968	1.5488	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	278	2.01e-70	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g21840	i0	98.718	186.80625	156	2	98	0	5	160	1249302	1249147	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	29889	278	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
17986827	17986827	PRJEB7366_P_NODE_16675_length_189_cov_4.272727_g16241_i0	PRJEB7366	16675	189	4.272727	8.07545403	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	289	1.14e-73	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g16241	i0	94.18	697.513227513228	189	11	100	0	1	189	7053135	7053323	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	131830	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
17986867	17986867	PRJEB7366_P_NODE_6615_length_342_cov_1.638436_g6181_i0	PRJEB7366	6615	342	1.638436	5.60345112	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	399	1e-106	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g6181	i0	87.941	127.345029239766	340	39	99	2	1	339	3991679	3992017	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	43552	399	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
19260871	19260871	PRJEB7366_P_NODE_7936_length_305_cov_2.088889_g7502_i0	PRJEB7366	7936	305	2.088889	6.37111145	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	558	1.37e-154	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g7502	i0	99.672	97.5967213114754	305	1	100	0	1	305	1404828	1404524	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	29767	558	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
20536134	20536134	PRJEB7366_P_NODE_14457_length_207_cov_1.802326_g14023_i0	PRJEB7366	14457	207	1.802326	3.73081482	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	200	6.109999999999998e-47	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g14023	i0	91.724	178.299516908213	145	11	70	1	61	204	3990067	3990211	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	36908	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
21812057	21812057	PRJEB7366_P_NODE_8378_length_294_cov_1.841699_g7944_i0	PRJEB7366	8378	294	1.841699	5.41459506	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	488	1.7499999999999996e-133	NTclustered	gi\|18029193\|gb\|AF364564.1\|	174324	g7944	i0	96.61	98.9081632653061	295	8	100	2	1	294	492	785	Uncultured Chlamydiales bacterium clone P-4 16S ribosomal RNA gene, partial sequence	blastn	29079	488	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales 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);;