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

10 rows where analysis = "blastn", bioproject = "PRJNA1008624" and tax_kingdom = "Shotokuvirae"

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	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1001370	1001370	PRJNA1008624_P_NODE_7361_length_309_cov_2.026923_g7173_i0	PRJNA1008624	7361	309	2.026923	6.26319207	Circovirus	39725	Viruses	Viruses	562	1.08e-155	NTclustered	gi\|2496529047\|gb\|OP564891.1\|	1964372	g7173	i0	99.674	5.34304207119741	307	1	99	3	309	3227	2921	Circovirus sp. strain OBP1/FE1/23/2022, complete genome	blastn	1651	562	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae	Circovirus	Circovirus sp.
2276463	2276463	PRJNA1008624_P_NODE_13682_length_227_cov_1.314607_g13494_i0	PRJNA1008624	13682	227	1.314607	2.98415789	Viruses	10239	Viruses	Viruses	409	1.04e-109	NTclustered	gi\|2089355977\|gb\|MZ364300.1\|	2748378	g13494	i0	99.554	6.66519823788546	224	1	99	1	224	422	199	CRESS virus sp. strain CRESS-2/S10/AUS, complete sequence	blastn	1513	409	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
5257539	5257539	PRJNA1008624_P_NODE_5665_length_354_cov_2.613115_g5477_i0	PRJNA1008624	5665	354	2.613115	9.2504271	Cynopterus sphinx circular DNA virus 2	3064085	Viruses	Viruses	640	5.619999999999999e-179	NTclustered	gi\|2593361784\|gb\|OQ267681.1\|	3064085	g5477	i0	99.432	0.994350282485876	352	2	99	3	354	779	428	MAG: Cynopterus sphinx circular DNA virus 2 isolate 68C2 genomic sequence	blastn	352	640	1	Viruses	Shotokuvirae	Cressdnaviricota					Cynopterus sphinx circular DNA virus 2
6532316	6532316	PRJNA1008624_P_NODE_19286_length_195_cov_0.849315_g19098_i0	PRJNA1008624	19286	195	0.849315	1.65616425	Chegonang virus 3	3063427	Viruses	Viruses	350	5.34e-92	NTclustered	gi\|2626080152\|gb\|OR270642.1\|	3063427	g19098	i0	99.479	2.78461538461538	192	1	98	1	192	386	195	MAG: Chegonang virus 3 isolate GL83, complete genome	blastn	543	350	1	Viruses	Shotokuvirae	Cressdnaviricota					Chegonang virus 3
15029141	15029141	PRJNA1008624_P_NODE_8432_length_288_cov_1.426778_g8244_i0	PRJNA1008624	8432	288	1.426778	4.10912064	Circovirus	39725	Viruses	Viruses	521	1.69e-143	NTclustered	gi\|2496529047\|gb\|OP564891.1\|	1964372	g8244	i0	99.649	4.40277777777778	285	1	99	1	285	2270	2554	Circovirus sp. strain OBP1/FE1/23/2022, complete genome	blastn	1268	521	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae	Circovirus	Circovirus sp.
16731673	16731673	PRJNA1008624_P_NODE_9574_length_270_cov_2.692308_g9386_i0	PRJNA1008624	9574	270	2.692308	7.2692316	Cynopterus sphinx circular DNA virus 7	3064090	Viruses	Viruses	422	1.64e-113	NTclustered	gi\|2593361795\|gb\|OQ267686.1\|	3064090	g9386	i0	99.567	0.855555555555556	231	1	86	40	270	2	232	MAG: Cynopterus sphinx circular DNA virus 7 isolate 68C7 genomic sequence	blastn	231	422	1	Viruses	Shotokuvirae	Cressdnaviricota					Cynopterus sphinx circular DNA virus 7
21831171	21831171	PRJNA1008624_P_NODE_29058_length_168_cov_0.873950_g28870_i0	PRJNA1008624	29058	168	0.87395	1.468236	Cynopterus sphinx circular DNA virus 7	3064090	Viruses	Viruses	302	1.27e-77	NTclustered	gi\|2593361795\|gb\|OQ267686.1\|	3064090	g28870	i0	99.398	0.988095238095238	166	1	99	1	166	667	502	MAG: Cynopterus sphinx circular DNA virus 7 isolate 68C7 genomic sequence	blastn	166	302	1	Viruses	Shotokuvirae	Cressdnaviricota					Cynopterus sphinx circular DNA virus 7
21831317	21831317	PRJNA1008624_P_NODE_37158_length_162_cov_0.876106_g36970_i0	PRJNA1008624	37158	162	0.876106	1.41929172	parvo-like hybrid virus	3367306	Viruses	Viruses	130	6.05e-26	NTclustered	gi\|2814138522\|gb\|PQ313124.1\|	3367306	g36970	i0	88.679	1.30864197530864	106	12	65	1	106	1136	1241	Parvo-like hybrid virus isolate SpinColumn09, partial genome	blastn	212	130	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		parvo-like hybrid virus
22678185	22678185	PRJNA1008624_P_NODE_3958_length_431_cov_2.811518_g3772_i0	PRJNA1008624	3958	431	2.811518	12.11764258	Viruses	10239	Viruses	Viruses	787	0	NTclustered	gi\|2819064707\|gb\|PQ150501.1\|	3042448	g3772	i0	99.767	3.65661252900232	429	1	99	1	429	907	479	MAG: Psittaciform parvoviridae sp. isolate Hebei_059 genomic sequence	blastn	1576	787	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Psittaciform parvoviridae sp.
24380313	24380313	PRJNA1008624_P_NODE_24940_length_175_cov_1.587302_g24752_i0	PRJNA1008624	24940	175	1.587302	2.7777785	Protoparvovirus carnivoran1	3052707	Viruses	Viruses	285	1.3399999999999998e-72	NTclustered	gi\|2471521096\|gb\|OQ198142.1\|	10788	g24752	i0	96.512	8.44	172	6	98	4	175	939	1110	MAG: Canine parvovirus isolate ParvoviridaeDogfe362C6 genomic sequence	blastn	1477	285	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Protoparvovirus	Protoparvovirus carnivoran1

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