metadata: contig_metadata: 9 rows where bioproject = "PRJEB3181", tax_phylum = "Lenarviricota" and tax

9 rows where bioproject = "PRJEB3181", tax_phylum = "Lenarviricota" 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_genus	tax_species
2605981	2605981	PRJEB3181_S_NODE_11923_length_186_cov_107.218543_g11630_i0	PRJEB3181	11923	186	107.218543	199.42648998	Narnavirus sp.	2587225	Viruses	Viruses	69.4	1.58e-7	NTclustered	gi\|2686256125\|emb\|OZ008436.1\|	2587225	g11630	i0	100	20.4247311827957	37	0	20	0	150	186	1074	1110	Apocryptovirus menelaus Segment 2, partial CDS	blastn	3799	69.4	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Narnavirus sp.
3882062	3882062	PRJEB3181_P_NODE_1884_length_494_cov_19.790497_g1708_i0	PRJEB3181	1884	494	19.790497	97.76505518	Chrocagosk virus	3129397	Viruses	Viruses	189	3.5199999999999998e-43	NTclustered	gi\|2717317479\|gb\|PP171845.1\|	3129397	g1708	i0	93.023	23.165991902834	129	9	55	0	1	129	352	224	MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence	blastn	11444	189	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagosk virus
8983226	8983226	PRJEB3181_S_NODE_4628_length_278_cov_26.588477_g4335_i0	PRJEB3181	4628	278	26.588477	73.91596606	Chrocagost virus	3129398	Viruses	Viruses	307	4.95e-79	NTclustered	gi\|2717317482\|gb\|PP171846.1\|	3129398	g4335	i0	88.8	349.856115107914	250	28	90	0	28	277	5862	5613	MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence	blastn	97260	307	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagost virus
10258862	10258862	PRJEB3181_S_NODE_3029_length_323_cov_3.177083_g2736_i0	PRJEB3181	3029	323	3.177083	10.26197809	Ripajed virus	3130769	Viruses	Viruses	73.1	2.33e-8	NTclustered	gi\|2717320728\|gb\|PP173071.1\|	3130769	g2736	i0	84.211	0.445820433436532	76	10	23	2	227	301	132	206	MAG: Ripajed virus isolate KCAP3_k141_11048 genomic sequence	blastn	144	73.1	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripajed virus
12809704	12809704	PRJEB3181_S_NODE_7831_length_224_cov_66.931217_g7538_i0	PRJEB3181	7831	224	66.931217	149.92592608	Narnavirus sp.	2587225	Viruses	Viruses	63.9	9.19e-6	NTclustered	gi\|2686256125\|emb\|OZ008436.1\|	2587225	g7538	i0	100	15.4107142857143	34	0	15	0	1	34	1108	1075	Apocryptovirus menelaus Segment 2, partial CDS	blastn	3452	63.9	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Narnavirus sp.
15358143	15358143	PRJEB3181_P_NODE_7973_length_299_cov_8.317164_g7711_i0	PRJEB3181	7973	299	8.317164	24.86832036	Chrocagosk virus	3129397	Viruses	Viruses	484	2.3099999999999998e-132	NTclustered	gi\|2717317479\|gb\|PP171845.1\|	3129397	g7711	i0	99.623	461.1872909699	265	1	89	0	1	265	265	1	MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence	blastn	137895	484	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagosk virus
17907617	17907617	PRJEB3181_P_NODE_555_length_720_cov_28.647315_g463_i0	PRJEB3181	555	720	28.647315	206.260668	Chrocagosk virus	3129397	Viruses	Viruses	189	5.26e-43	NTclustered	gi\|2717317479\|gb\|PP171845.1\|	3129397	g463	i0	93.023	15.7972222222222	129	9	28	0	592	720	224	352	MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence	blastn	11374	189	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagosk virus
19181576	19181576	PRJEB3181_S_NODE_3536_length_306_cov_7.276753_g3243_i0	PRJEB3181	3536	306	7.276753	22.26686418	Chrocagosk virus	3129397	Viruses	Viruses	483	8.539999999999998e-132	NTclustered	gi\|2717317479\|gb\|PP171845.1\|	3129397	g3243	i0	99.251	35.9967320261438	267	2	87	0	40	306	1	267	MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence	blastn	11015	483	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagosk virus
20456787	20456787	PRJEB3181_P_NODE_4917_length_362_cov_906.084592_g4668_i0	PRJEB3181	4917	362	906.084592	3280.02622304	Chrocagost virus	3129398	Viruses	Viruses	254	8.77e-63	NTclustered	gi\|2717317482\|gb\|PP171846.1\|	3129398	g4668	i0	87.168	62.0552486187845	226	26	62	1	27	252	5640	5862	MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence	blastn	22464	254	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagost 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);;