metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1245487" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1245487" and tax_kingdom = "Orthornavirae"

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_genus	tax_species
350986	350986	PRJNA1245487_P_NODE_20901_length_246_cov_0.901734_g20563_i0	PRJNA1245487	20901	246	0.901734	2.21826564	Hebei scleroulivirus	3371279	Viruses	Viruses	344	3.27e-90	NTclustered	gi\|2819062619\|gb\|PQ150490.1\|	3371279	g20563	i0	91.87	2.99593495934959	246	20	100	0	1	246	675	430	MAG: Hebei scleroulivirus isolate Beijing_119 genomic sequence	blastn	737	344	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Scleroulivirus	Hebei scleroulivirus
1625835	1625835	PRJNA1245487_P_NODE_21482_length_244_cov_0.912281_g21144_i0	PRJNA1245487	21482	244	0.912281	2.22596564	Potexvirus flavitrifolii	3433843	Viruses	Viruses	220	5.699999999999998e-53	NTclustered	gi\|2329659975\|gb\|OK558677.1\|	12177	g21144	i0	83.402	8.95901639344262	241	36	98	3	6	244	554	316	Clover yellow mosaic virus isolate R-046 ORF1, ORF2, ORF3, ORF4, and ORF5 genes, complete cds	blastn	2186	220	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus flavitrifolii
1625902	1625902	PRJNA1245487_P_NODE_6702_length_479_cov_1.839901_g6366_i0	PRJNA1245487	6702	479	1.839901	8.81312579	Periplaneta americana dicistro-like virus	3032225	Viruses	Viruses	494	6.45e-135	NTclustered	gi\|2754804027\|tpg\|BK063169.1\|	3032225	g6366	i0	85.417	1.00208768267223	480	65	99	4	2	479	4482	4006	TPA_asm: Periplaneta americana dicistro-like virus hypothetical protein gene, partial cds	blastn	480	494	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Periplaneta americana dicistro-like virus
2901926	2901926	PRJNA1245487_P_NODE_17183_length_269_cov_1.591837_g16845_i0	PRJNA1245487	17183	269	1.591837	4.28204153	Solenopsis invicta virus 8	2547311	Viruses	Viruses	420	5.86e-113	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g16845	i0	94.796	1	269	14	100	0	1	269	4659	4391	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	269	420	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
8004513	8004513	PRJNA1245487_P_NODE_8207_length_427_cov_1.488701_g7869_i0	PRJNA1245487	8207	427	1.488701	6.35675327	Solenopsis invicta virus 8	2547311	Viruses	Viruses	468	3.45e-127	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g7869	i0	86.698	0.985948477751756	421	56	99	0	6	426	4418	3998	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	421	468	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
18202872	18202872	PRJNA1245487_P_NODE_23175_length_219_cov_7.938356_g22837_i0	PRJNA1245487	23175	219	7.938356	17.38499964	Ripachij virus	3130407	Viruses	Viruses	255	1.38e-63	NTclustered	gi\|2717319663\|gb\|PP172709.1\|	3130407	g22837	i0	87.783	164.771689497717	221	24	100	3	1	219	431	650	MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence	blastn	36085	255	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripachij virus
20177374	20177374	PRJNA1245487_P_NODE_11256_length_351_cov_1.676259_g10918_i0	PRJNA1245487	11256	351	1.676259	5.88366909	Ourmiavirus	186783	Viruses	Viruses	560	4.46e-155	NTclustered	gi\|2819080653\|gb\|PQ150633.1\|	3371276	g10918	i0	95.442	23.7692307692308	351	16	100	0	1	351	1234	884	MAG: Hebei ourmiavirus 2 isolate Beijing_119 genomic sequence	blastn	8343	560	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Ourmiavirus	Hebei ourmiavirus 2
24577499	24577499	PRJNA1245487_P_NODE_6920_length_470_cov_3.551637_g6584_i0	PRJNA1245487	6920	470	3.551637	16.6926939	Sopapen virus	3131614	Viruses	Viruses	183	1.55e-41	NTclustered	gi\|2717322942\|gb\|PP173915.1\|	3131614	g6584	i0	81.092	49.9042553191489	238	37	50	5	1	234	340	573	MAG: Sopapen virus isolate SP1A_k141_131186 genomic sequence	blastn	23455	183	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Sopapen virus

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