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

15 rows where analysis = "blastn", bioproject = "PRJNA773247" and tax_clade = "Luna-1 subcluster"

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
1206918	1206918	PRJNA773247_P_NODE_13041_length_419_cov_17.447977_g12958_i0	PRJNA773247	13041	419	17.447977	73.10702363	Rhodoluna	529883	Bacteria	Bacteria	228	6.239999999999999e-55	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g12958	i0	77.411	4.81861575178998	394	81	94	6	8	399	1406205	1406592	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	2019	230	0.991304347826087	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
4577149	4577149	PRJNA773247_P_NODE_27484_length_265_cov_2.937500_g27400_i0	PRJNA773247	27484	265	2.9375	7.784375	Rhodoluna limnophila	232537	Bacteria	Bacteria	254	6.19e-63	NTclustered	gi\|1666461688\|gb\|CP040510.1\|	232537	g27400	i0	84.436	95.2452830188679	257	40	97	0	5	261	50766	50510	Rhodoluna limnophila strain 36A-HELLB chromosome, complete genome	blastn	25240	254	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
7127391	7127391	PRJNA773247_P_NODE_10726_length_476_cov_2.744417_g10643_i0	PRJNA773247	10726	476	2.744417	13.06342492	Rhodoluna lacicola	529884	Bacteria	Bacteria	228	7.169999999999997e-55	NTclustered	gi\|2318878936\|dbj\|AP026911.1\|	529884	g10643	i0	78.797	1.44117647058824	349	67	72	6	130	472	1277759	1278106	Rhodoluna lacicola KACHI23 DNA, complete genome	blastn	686	228	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
8401909	8401909	PRJNA773247_P_NODE_14287_length_396_cov_1.900929_g14203_i0	PRJNA773247	14287	396	1.900929	7.52767884	Rhodoluna sp. KAS3	942880	Bacteria	Bacteria	300	1.23e-76	NTclustered	gi\|2318877619\|dbj\|AP026910.1\|	942880	g14203	i0	81.892	2.77272727272727	370	53	92	11	1	363	802037	801675	Rhodoluna sp. KAS3 DNA, complete genome	blastn	1098	300	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp. KAS3
8401948	8401948	PRJNA773247_P_NODE_16667_length_358_cov_15.564912_g16583_i0	PRJNA773247	16667	358	15.564912	55.72238496	Rhodoluna limnophila	232537	Bacteria	Bacteria	183	1.15e-41	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g16583	i0	77.151	5.82960893854749	337	63	94	9	1	336	53910	53587	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	2087	183	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
8402047	8402047	PRJNA773247_P_NODE_23387_length_292_cov_0.945205_g23303_i0	PRJNA773247	23387	292	0.945205	2.7599986	Rhodoluna lacicola	529884	Bacteria	Bacteria	396	1.09e-105	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g23303	i0	91.349	10.3561643835616	289	25	99	0	2	290	914257	914545	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	3024	396	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
10953182	10953182	PRJNA773247_P_NODE_5289_length_768_cov_13.379856_g5210_i0	PRJNA773247	5289	768	13.379856	102.75729408	Rhodoluna lacicola	529884	Bacteria	Bacteria	649	0	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g5210	i0	82.329	0.97265625	747	132	97	0	5	751	1020261	1021007	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	747	649	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
14777498	14777498	PRJNA773247_P_NODE_12532_length_430_cov_14.072829_g12449_i0	PRJNA773247	12532	430	14.072829	60.5131647	Rhodoluna lacicola	529884	Bacteria	Bacteria	507	7.37e-139	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g12449	i0	87.935	3.26976744186046	431	50	100	2	1	430	58945	58516	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	1406	507	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
16051659	16051659	PRJNA773247_P_NODE_5953_length_708_cov_5.321260_g5873_i0	PRJNA773247	5953	708	5.32126	37.6745208	Rhodoluna lacicola	529884	Bacteria	Bacteria	250	2.34e-61	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g5873	i0	81.818	0.795197740112994	297	54	42	0	369	665	332842	333138	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	563	250	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
16509991	16509991	PRJNA773247_P_NODE_33633_length_243_cov_4.917647_g33549_i0	PRJNA773247	33633	243	4.917647	11.94988221	Rhodoluna	529883	Bacteria	Bacteria	219	2.0399999999999998e-52	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g33549	i0	83.83	3.86831275720165	235	32	97	4	9	243	425108	424880	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	940	219	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
17327364	17327364	PRJNA773247_P_NODE_35114_length_240_cov_3.233533_g35030_i0	PRJNA773247	35114	240	3.233533	7.7604792	Rhodoluna lacicola	529884	Bacteria	Bacteria	298	2.51e-76	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g35030	i0	90	3.3625	230	23	96	0	11	240	1405349	1405120	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	807	298	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
17327470	17327470	PRJNA773247_P_NODE_7274_length_615_cov_18.856089_g7191_i0	PRJNA773247	7274	615	18.856089	115.96494735	Rhodoluna lacicola	529884	Bacteria	Bacteria	344	8.979999999999999e-90	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g7191	i0	78.519	1.80813008130081	540	105	86	8	13	543	1403261	1403798	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	1112	344	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
18600402	18600402	PRJNA773247_P_NODE_10135_length_493_cov_3.804762_g10052_i0	PRJNA773247	10135	493	3.804762	18.75747666	Rhodoluna sp. KAS3	942880	Bacteria	Bacteria	479	1.86e-130	NTclustered	gi\|2318877619\|dbj\|AP026910.1\|	942880	g10052	i0	84.476	11.1298174442191	496	66	99	9	5	493	161610	162101	Rhodoluna sp. KAS3 DNA, complete genome	blastn	5487	479	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp. KAS3
18600518	18600518	PRJNA773247_P_NODE_16675_length_358_cov_10.368421_g16591_i0	PRJNA773247	16675	358	10.368421	37.11894718	Rhodoluna lacicola	529884	Bacteria	Bacteria	424	6.24e-114	NTclustered	gi\|2318878936\|dbj\|AP026911.1\|	529884	g16591	i0	87.989	2.39106145251397	358	43	100	0	1	358	431419	431776	Rhodoluna lacicola KACHI23 DNA, complete genome	blastn	856	424	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
22426423	22426423	PRJNA773247_P_NODE_6078_length_698_cov_4.145600_g5997_i0	PRJNA773247	6078	698	4.1456	28.936288	Rhodoluna lacicola	529884	Bacteria	Bacteria	734	0	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g5997	i0	85.859	15.3309455587393	693	95	99	2	2	691	1017942	1017250	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	10701	734	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola

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