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

10 rows where analysis = "blastn", bioproject = "PRJEB7366" and tax_superkingdom = "Viruses"

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_species
135245	135245	PRJEB7366_P_NODE_14901_length_203_cov_1.904762_g14467_i0	PRJEB7366	14901	203	1.904762	3.86666686	Picornaviridae sp.	1530251	Viruses	Viruses	348	2.0100000000000006e-91	NTclustered	gi\|2780183578\|gb\|PP818844.1\|	1530251	g14467	i0	97.537	1	203	5	100	0	1	203	1937	2139	Picornaviridae sp. polyprotein and capsid protein genes, complete cds	blastn	203	348	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Picornaviridae sp.
135265	135265	PRJEB7366_P_NODE_2201_length_657_cov_2.440514_g1837_i0	PRJEB7366	2201	657	2.440514	16.03417698	Picornaviridae sp.	1530251	Viruses	Viruses	702	0	NTclustered	gi\|2780183578\|gb\|PP818844.1\|	1530251	g1837	i0	85.997	1	657	90	99	2	2	657	3802	3147	Picornaviridae sp. polyprotein and capsid protein genes, complete cds	blastn	657	702	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Picornaviridae sp.
2685307	2685307	PRJEB7366_P_NODE_14403_length_208_cov_1.121387_g13969_i0	PRJEB7366	14403	208	1.121387	2.33248496	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.018	NTclustered	gi\|2057857546\|tpg\|BK050475.1\|	2832643	g13969	i0	100	0.134615384615385	28	0	13	0	136	163	39009	39036	MAG TPA_asm: Caudoviricetes sp. isolate ctWi02, partial genome	blastn	28	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
9062504	9062504	PRJEB7366_P_NODE_12708_length_225_cov_1.631579_g12274_i0	PRJEB7366	12708	225	1.631579	3.67105275	Picornaviridae sp.	1530251	Viruses	Viruses	399	6.199999999999999e-107	NTclustered	gi\|2780183578\|gb\|PP818844.1\|	1530251	g12274	i0	99.099	0.986666666666667	222	2	99	0	4	225	1541	1762	Picornaviridae sp. polyprotein and capsid protein genes, complete cds	blastn	222	399	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Picornaviridae sp.
9923555	9923555	PRJEB7366_P_NODE_12428_length_228_cov_2.253886_g11994_i0	PRJEB7366	12428	228	2.253886	5.13886008	Viruses	10239	Viruses	Viruses	54.7	0.006	NTclustered	gi\|2416386878\|gb\|OP172727.1\|	2968600	g11994	i0	100	0.390350877192982	29	0	13	0	50	78	28287	28315	Bacteroides phage BT681P2, complete genome	blastn	89	54.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Bacteroides phage BT681P2
11613753	11613753	PRJEB7366_P_NODE_18490_length_178_cov_1.398601_g18056_i0	PRJEB7366	18490	178	1.398601	2.48950978	Picornaviridae sp.	1530251	Viruses	Viruses	307	2.91e-79	NTclustered	gi\|2780183578\|gb\|PP818844.1\|	1530251	g18056	i0	97.753	1.15730337078652	178	4	100	0	1	178	574	751	Picornaviridae sp. polyprotein and capsid protein genes, complete cds	blastn	206	307	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Picornaviridae sp.
11613755	11613755	PRJEB7366_P_NODE_190_length_1803_cov_3.829186_g139_i0	PRJEB7366	190	1803	3.829186	69.04022358	Picornaviridae sp.	1530251	Viruses	Viruses	1081	0	NTclustered	gi\|2780183578\|gb\|PP818844.1\|	1530251	g139	i0	77.772	1.01053799223516	1822	361	99	37	1	1801	7734	5936	Picornaviridae sp. polyprotein and capsid protein genes, complete cds	blastn	1822	1081	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Picornaviridae sp.
12888784	12888784	PRJEB7366_P_NODE_10991_length_247_cov_1.816038_g10557_i0	PRJEB7366	10991	247	1.816038	4.48561386	Picornaviridae sp.	1530251	Viruses	Viruses	418	1.9099999999999998e-112	NTclustered	gi\|2780183578\|gb\|PP818844.1\|	1530251	g10557	i0	97.166	1	247	7	100	0	1	247	982	1228	Picornaviridae sp. polyprotein and capsid protein genes, complete cds	blastn	247	418	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Picornaviridae sp.
15437732	15437732	PRJEB7366_P_NODE_17873_length_181_cov_3.390411_g17439_i0	PRJEB7366	17873	181	3.390411	6.13664391	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.015	NTclustered	gi\|2915022265\|gb\|OR222584.1\|	2832643	g17439	i0	100	0.154696132596685	28	0	15	0	112	139	20889	20862	MAG: Caudoviricetes sp. isolate MSP0347 genomic sequence	blastn	28	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
23087083	23087083	PRJEB7366_P_NODE_7539_length_314_cov_3.448029_g7105_i0	PRJEB7366	7539	314	3.448029	10.82681106	Caudoviricetes sp.	2832643	Viruses	Viruses	54.7	0.008	NTclustered	gi\|2059591960\|tpg\|BK036906.1\|	2832643	g7105	i0	100	0.0923566878980892	29	0	9	0	257	285	19234	19262	MAG TPA_asm: Caudoviricetes sp. isolate ctdMI12, partial genome	blastn	29	54.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.

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