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

14 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax_phylum = "Verrucomicrobiota"

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
1299698	1299698	PRJEB28062_P_NODE_75242_length_393_cov_2.325000_g72880_i0	PRJEB28062	75242	393	2.325	9.13725	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	542	1.8299999999999999e-149	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g72880	i0	95.562	1.52162849872774	338	15	86	0	36	373	4082521	4082858	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	598	542	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
1299968	1299968	PRJEB28062_P_NODE_88562_length_349_cov_10.699275_g86200_i0	PRJEB28062	88562	349	10.699275	37.34046975	Chthoniobacter flavus	191863	Bacteria	Bacteria	375	1.7199999999999998e-99	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g86200	i0	87.654	166.143266475645	324	38	93	2	1	324	498	177	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	57984	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
5126724	5126724	PRJEB28062_P_NODE_22545_length_787_cov_4.952381_g20381_i0	PRJEB28062	22545	787	4.952381	38.97523847	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	444	1.1099999999999995e-119	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g20381	i0	84.564	0.567979669631512	447	69	57	0	96	542	3173010	3172564	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	447	444	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
5128042	5128042	PRJEB28062_P_NODE_86905_length_355_cov_2.177305_g84543_i0	PRJEB28062	86905	355	2.177305	7.72943275	Akkermansia muciniphila	239935	Bacteria	Bacteria	625	1.5799999999999994e-174	NTclustered	gi\|2566450153\|gb\|CP114596.1\|	239935	g84543	i0	99.419	93.0253521126761	344	2	97	0	12	355	1337019	1336676	Akkermansia muciniphila strain MmAkk2 chromosome, complete genome	blastn	33024	625	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
6402006	6402006	PRJEB28062_P_NODE_124446_length_250_cov_19.118644_g122082_i0	PRJEB28062	124446	250	19.118644	47.79661	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	340	4.31e-89	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g122082	i0	95.775	42.34	213	5	84	4	1	211	3557836	3558046	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	10585	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
7677345	7677345	PRJEB28062_P_NODE_58587_length_458_cov_28.332468_g56228_i0	PRJEB28062	58587	458	28.332468	129.76270344	Prosthecobacter debontii	48467	Bacteria	Bacteria	494	6.14e-135	NTclustered	gi\|164510703\|emb\|AJ966882.1\|	48467	g56228	i0	87.385	412.2903930131	436	47	94	6	4	435	3572	3141	Prosthecobacter debontii 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ala gene, tRNA-Ile gene and ITS1, strain DSM 14044	blastn	188829	494	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
10227985	10227985	PRJEB28062_P_NODE_64309_length_433_cov_9.852778_g61948_i0	PRJEB28062	64309	433	9.852778	42.66252874	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	468	3.5e-127	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g61948	i0	88.235	0.903002309468822	391	46	90	0	24	414	1925218	1924828	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	391	468	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
11190924	11190924	PRJEB28062_P_NODE_54589_length_478_cov_16.202469_g52236_i0	PRJEB28062	54589	478	16.202469	77.44780182	Chthoniobacter	295577	Bacteria	Bacteria	475	2.3299999999999994e-129	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g52236	i0	87.799	161.353556485356	418	35	86	14	18	428	733	325	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	77127	475	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
11502078	11502078	PRJEB28062_P_NODE_133410_length_231_cov_5.493671_g131046_i0	PRJEB28062	133410	231	5.493671	12.69038001	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	270	5.2299999999999984e-68	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g131046	i0	90.732	31.5670995670996	205	15	89	4	27	231	1315511	1315711	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	7292	270	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14053541	14053541	PRJEB28062_P_NODE_71892_length_404_cov_24.395770_g69531_i0	PRJEB28062	71892	404	24.39577	98.5589108	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	339	2.66e-88	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g69531	i0	85.802	0.801980198019802	324	40	79	5	64	384	4768072	4768392	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	324	339	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
17876273	17876273	PRJEB28062_P_NODE_37315_length_598_cov_13.801905_g34988_i0	PRJEB28062	37315	598	13.801905	82.5353919	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	959	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g34988	i0	96.87	232.120401337793	575	14	95	3	12	582	164	738	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	138808	959	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
17877331	17877331	PRJEB28062_P_NODE_88615_length_349_cov_6.387681_g86253_i0	PRJEB28062	88615	349	6.387681	22.29300669	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	411	4.719999999999999e-110	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g86253	i0	93.19	0.908309455587393	279	19	80	0	17	295	2711561	2711283	Luteolibacter sp. SL250 chromosome	blastn	317	411	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
20424504	20424504	PRJEB28062_P_NODE_119597_length_261_cov_5.712766_g117234_i0	PRJEB28062	119597	261	5.712766	14.91031926	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	189	1.7399999999999999e-43	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g117234	i0	81.25	2.11111111111111	256	28	92	12	23	261	940229	939977	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	551	189	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
22977119	22977119	PRJEB28062_P_NODE_58039_length_461_cov_4.265464_g55681_i0	PRJEB28062	58039	461	4.265464	19.66378904	Akkermansia muciniphila	239935	Bacteria	Bacteria	745	0	NTclustered	gi\|2051370031\|gb\|CP072028.1\|	239935	g55681	i0	98.126	90.3796095444686	427	8	93	0	11	437	1284649	1285075	Akkermansia muciniphila strain Akk1756 chromosome, complete genome	blastn	41665	745	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila

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