metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1111448" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1111448" 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
1492779	1492779	PRJNA1111448_S_NODE_59082_length_329_cov_2.570312_g58259_i0	PRJNA1111448	59082	329	2.570312	8.45632648	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	407	5.74e-109	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g58259	i0	92.933	74.1063829787234	283	14	85	6	1	280	3832670	3832391	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	24381	407	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2768330	2768330	PRJNA1111448_S_NODE_15243_length_510_cov_4.480549_g14434_i0	PRJNA1111448	15243	510	4.480549	22.8507999	Coraliomargarita sp.	2024828	Bacteria	Bacteria	942	0	NTclustered	gi\|1275509842\|gb\|MG438537.1\|	2024828	g14434	i0	100	92.856862745098	510	0	100	0	1	510	902	393	Coraliomargarita sp. strain BN_1951 16S ribosomal RNA gene, partial sequence	blastn	47357	942	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita sp.
4044669	4044669	PRJNA1111448_S_NODE_25284_length_432_cov_5.005571_g24461_i0	PRJNA1111448	25284	432	5.005571	21.62406672	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	726	0	NTclustered	gi\|2442650069\|gb\|OQ422736.1\|	156588	g24461	i0	96.991	98.3541666666667	432	13	100	0	1	432	826	395	Uncultured Verrucomicrobia bacterium clone KCM_4_1_112 16S ribosomal RNA gene, partial sequence	blastn	42489	726	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
5320592	5320592	PRJNA1111448_S_NODE_24125_length_439_cov_3.595628_g23303_i0	PRJNA1111448	24125	439	3.595628	15.78480692	Pedosphaera parvula	1032527	Bacteria	Bacteria	351	3.74e-92	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g23303	i0	82.311	45.8542141230068	424	57	95	16	23	437	1291	1705	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	20130	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
6595917	6595917	PRJNA1111448_S_NODE_26426_length_426_cov_3.983003_g25603_i0	PRJNA1111448	26426	426	3.983003	16.96759278	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	318	3.67e-82	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g25603	i0	89.453	147.544600938967	256	21	59	5	1	252	1316761	1316508	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	62854	318	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6596284	6596284	PRJNA1111448_S_NODE_63206_length_322_cov_1.156627_g62383_i0	PRJNA1111448	63206	322	1.156627	3.72433894	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	538	1.9e-148	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g62383	i0	96.904	277.801242236025	323	7	100	3	1	322	2217711	2217391	Luteolibacter sp. LG18 DNA, complete genome	blastn	89452	538	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
9145923	9145923	PRJNA1111448_S_NODE_68408_length_313_cov_1.604167_g67585_i0	PRJNA1111448	68408	313	1.604167	5.02104271	Planctomycetes bacterium syqfu	2896527	Bacteria	Bacteria	327	4.339999999999999e-85	NTclustered	gi\|2155219436\|gb\|CP087563.1\|	2896527	g67585	i0	85.804	76.8242811501597	317	35	100	10	1	313	5331450	5331760	Planctomycetes bacterium syqfu chromosome, complete genome	blastn	24046	327	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium syqfu
9146238	9146238	PRJNA1111448_S_NODE_98008_length_274_cov_1.134328_g97185_i0	PRJNA1111448	98008	274	1.134328	3.10805872	Luteolibacter luteus	2728835	Bacteria	Bacteria	451	2.12e-122	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g97185	i0	96.35	72.9343065693431	274	10	100	0	1	274	3804950	3804677	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	19984	451	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
9951154	9951154	PRJNA1111448_S_NODE_8488_length_620_cov_1.524680_g7728_i0	PRJNA1111448	8488	620	1.52468	9.453016	Cerasicoccaceae	3056374	Bacteria	Bacteria	466	1.85e-126	NTclustered	gi\|2080888260\|gb\|CP080649.1\|	2866311	g7728	i0	80.542	149.422580645161	627	104	100	17	1	620	381747	381132	Ruficoccus sp. ZRK36 chromosome, complete genome	blastn	92642	466	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Ruficoccus	Ruficoccus sp. ZRK36
14246617	14246617	PRJNA1111448_S_NODE_142672_length_229_cov_2.314103_g141849_i0	PRJNA1111448	142672	229	2.314103	5.29929587	Luteolibacter sp.	1962973	Bacteria	Bacteria	285	1.85e-72	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g141849	i0	89.083	140.668122270742	229	25	100	0	1	229	1010193	1009965	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	32213	285	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
15520477	15520477	PRJNA1111448_S_NODE_25473_length_431_cov_4.122905_g24650_i0	PRJNA1111448	25473	431	4.122905	17.76972055	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	466	1.25e-126	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g24650	i0	86.456	58.7772621809745	443	39	100	18	1	431	1316666	1316233	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	25333	466	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16794805	16794805	PRJNA1111448_S_NODE_143434_length_226_cov_2.013072_g142611_i0	PRJNA1111448	143434	226	2.013072	4.54954272	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	311	3.01e-80	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g142611	i0	91.556	156.663716814159	225	19	99	0	1	225	2002078	2001854	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	35406	311	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16795258	16795258	PRJNA1111448_S_NODE_61494_length_325_cov_1.242063_g60671_i0	PRJNA1111448	61494	325	1.242063	4.03670475	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	462	1.19e-125	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g60671	i0	92.378	77.3230769230769	328	20	100	5	1	325	5153006	5153331	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	25130	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20618854	20618854	PRJNA1111448_S_NODE_15877_length_503_cov_1.879070_g15066_i0	PRJNA1111448	15877	503	1.87907	9.4517221	Ruficoccus sp. ZRK36	2866311	Bacteria	Bacteria	444	6.94e-120	NTclustered	gi\|2080888260\|gb\|CP080649.1\|	2866311	g15066	i0	83.333	160.290258449304	492	70	97	12	10	495	381973	382458	Ruficoccus sp. ZRK36 chromosome, complete genome	blastn	80626	444	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Ruficoccus	Ruficoccus sp. ZRK36

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