metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA971676" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA971676" 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
4772946	4772946	PRJNA971676_P_NODE_17704_length_247_cov_0.885057_g17615_i0	PRJNA971676	17704	247	0.885057	2.18609079	Hepacivirus hominis	3052230	Viruses	Viruses	52.8	0.022	NTclustered	gi\|338830580\|gb\|HQ618277.1\|	3052230	g17615	i0	100	1.1336032388664	28	0	11	0	7	34	50	23	Hepatitis C virus isolate ET1365 polyprotein gene, partial cds	blastn	280	52.8	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Hepacivirus	Hepacivirus hominis
11148342	11148342	PRJNA971676_P_NODE_2769_length_467_cov_2.050761_g2680_i0	PRJNA971676	2769	467	2.050761	9.57705387	Locusta migratoria associated flavi-like virus	3142496	Viruses	Viruses	342	2.3999999999999998e-89	NTclustered	gi\|2755703735\|tpg\|BK067811.1\|	3142496	g2680	i0	99.471	0.404710920770878	189	0	40	1	267	454	189	1	TPA_asm: Locusta migratoria associated flavi-like virus isolate MYMM genomic sequence	blastn	189	342	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae		Locusta migratoria associated flavi-like virus
13698265	13698265	PRJNA971676_P_NODE_16531_length_248_cov_1.320000_g16442_i0	PRJNA971676	16531	248	1.32	3.2736	Plotvirus plot	2170099	Viruses	Viruses	62.1	3.73e-5	NTclustered	gi\|1720702708\|gb\|MN119378.1\|	2596982	g16442	i0	91.489	0.854838709677419	47	1	18	2	67	110	45867	45913	Mycobacterium phage Penelope2018, complete genome	blastn	212	62.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Plotvirus	Plotvirus plot
16247522	16247522	PRJNA971676_P_NODE_21593_length_243_cov_0.905882_g21504_i0	PRJNA971676	21593	243	0.905882	2.20129326	uncultured marine virus	186617	Viruses	Viruses	335	1.9399999999999993e-87	NTclustered	gi\|2033874520\|dbj\|LC629455.1\|	186617	g21504	i0	92.05	0.983539094650206	239	18	98	1	6	243	238657	238895	MAG: Uncultured marine virus CM1_5m.V1 DNA, nearly complete genome	blastn	239	335	1	Viruses							uncultured marine virus
20392723	20392723	PRJNA971676_P_NODE_18516_length_246_cov_0.890173_g18427_i0	PRJNA971676	18516	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	449	6.74e-122	NTclustered	gi\|1879635015\|gb\|MN737436.1\|	10533	g18427	i0	99.593	99.9878048780488	246	1	100	0	1	246	841	596	Human adenovirus 1 strain QH-1665/2018, complete genome	blastn	24597	449	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari

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